<%@ page import="java.sql.*,java.io.*,java.util.*" %>
<HTML>
<table border="1" bgcolor="olive" align="center" width=250">
<tr><th>Name</th><th>Address</th><th>Image</th><th>Logo</th></tr>
<%
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","ims");
Statement stmt=con.createStatement();
String strQuery = "select * from photoinfo";
ResultSet rs = stmt.executeQuery(strQuery);
while(rs.next())
{
%>
<tr>
<td bgcolor="silver"><%=rs.getString("name")%></td>
<td bgcolor="silver"><%=rs.getString("address")%></td>
<td align="center" bgcolor="silver">
<img src="image.jsp?imgid=<%=rs.getInt(1)%>" width="100" height="50">
</td>
<td>
<img src="image1.jsp?id=<%=rs.getInt(6)%>" width="100" height="50">
</td>
</tr>
<%
}
rs.close();
con.close();
stmt.close();
}
catch(Exception e)
{
e.getMessage();
}
%>
</table>
</HTML>
Image.jsp
<%@ page import="java.sql.*,java.io.*,java.util.*" %>
<%
int id = Integer.parseInt(request.getParameter("imgid"));
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","ims");
Statement st=con.createStatement();
String strQuery = "select photo from photoinfo where id="+id;
ResultSet rs = st.executeQuery(strQuery);
String imgLen="";
while(rs.next()){
imgLen = rs.getString(1);
}
rs = st.executeQuery(strQuery);
if(rs.next()){
int len = imgLen.length();
byte [] rb = new byte[len];
response.setContentType("image/png");
InputStream readImg = rs.getBinaryStream(1);
//InputStream readImg1 = rs.getBinaryStream(2);
int index=readImg.read(rb, 0, len);
st.close();
response.reset();
response.getOutputStream().write(rb,0,len);
response.getOutputStream().flush();
}
}
catch (Exception e){
e.printStackTrace();
}
%>AryanTechindia pvt.ltd
No comments:
Post a Comment