Retrieve image from the database using JSP.

<%@ page import="java.sql.*" %>

<%@ page import="java.io.*" %>

<%



try{

Class.forName("com.mysql.jdbc.Driver").newInstance();

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root", "root");

Statement st=con.createStatement();

ResultSet rs = st.executeQuery("select image from image where id=1");

if(rs.next()){

String imgLen = rs.getString(1);

int len = imgLen.length();

byte [] rb = new byte[len];

InputStream is = rs.getBinaryStream(1);

int index=is.read(rb, 0, len);

response.reset();

response.setContentType("image/jpg");

response.getOutputStream().write(rb,0,len);

response.getOutputStream().flush();

}

}

catch (Exception e){

e.printStackTrace();

}



%>