Servlet Code to Display Image from Database

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class DisplayImage extends HttpServlet{
public void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException{
String connectionURL = "jdbc:odbc:test";
java.sql.Connection con=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
con=DriverManager.getConnection(connectionURL);
Statement st1=con.createStatement();
ResultSet rs1 = st1.executeQuery("select image1 from table1 where ID=8");

String imgLen="";

if(rs1.next())
{
imgLen = rs1.getString(1);

}
rs1 = st1.executeQuery("select image1 from table1 where ID=8");

if(rs1.next()){
int len = imgLen.length();
byte [] rb = new byte[len];
InputStream readImg = rs1.getBinaryStream(1);
int index=readImg.read(rb, 0, len);
st1.close();
response.reset();
response.setContentType("image/jpg");
response.getOutputStream().write(rb,0,len);
response.getOutputStream().flush();
}
}
catch (Exception e){
pw.print("<h1>"+e+"</h1>");
}
}
}

Comments

Popular posts from this blog

Edit/Modify existing PDF using Java(iText)

Verify Digital Signature in PDF using Java(iText) and cacerts

Steps to create SOAP Web service using Eclipse