How to retrieve and insert image from jsp page

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*,java.io.*"%>
<% try{ InputStream sImage; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:kkk", "", ""); /* File imgfile = new File("C:/flower3.jpg"); FileInputStream fin = new FileInputStream(imgfile); PreparedStatement pre = con.prepareStatement("insert into image(images) values(?)"); pre.setBinaryStream(1,fin,(int)imgfile.length()); pre.executeUpdate(); System.out.println("Inserting Successfully!"); pre.close(); * */ Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select [file] from DBFiles where id=1"); if(rs.next()){ byte[] bytearray = new byte[1048576]; int size=0; sImage = rs.getBinaryStream(1); response.reset(); response.setContentType("image/jpeg"); while((size=sImage.read(bytearray))!= -1 ){ response.getOutputStream().write(bytearray,0,size); } } rs.close(); st.close(); con.close(); } catch(Exception ex){ out.println("error :"+ex); } %>

Comments

Popular Posts