<%@page contentType="text/html" pageEncoding="UTF-8" import="java.sql.*,dbmodel.DBConnection,model.ExceptionLogger,java.io.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%
try
{
String seproname = request.getParameter("proname");
String seblocknm = request.getParameter("block");
String valfloor=request.getParameter("floorno");
Connection con=new DBConnection().getDBConnection();
PreparedStatement pst=con.prepareStatement("select floor_pic from tbl_floor_picture where pro_name=? and block_name =? and floorno =?");
pst.setString(1, seproname.trim());
pst.setString(2, seblocknm.trim());
pst.setString(3, valfloor.trim());
ResultSet rs = pst.executeQuery();
if(rs.next())
{
int len =10485760;
byte [] rb = new byte[len];
InputStream readImg = rs.getBinaryStream(1);
int index=readImg.read(rb);
response.reset();
response.setContentType("image/jpg");
response.setHeader("Content-disposition","attachment; filename=img");
response.getOutputStream().write(rb,0,rb.length);
response.getOutputStream().flush();
out.write("image");
}
rs.close();
pst.close();
con.close();
}
catch(Exception e)
{
ExceptionLogger.writeToDB(this.getClass().getName()+": "+e);
//session.setAttribute("resmsg", "Sorry! Some Exception Occurred");
//response.sendRedirect("floor_pic_Upload.jsp");
}
%>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment