How to insert and retrive image in database use JSP ..

Question

Image Upload i want to insert photo in database and retrive image in table ../////...... can u help me ....

ashok k · Answer

sir u r using mysql but i want oracle

ashok k · Answer

thank u sir it is very helpful to me

ashok k · Answer

thank u sir it is very helpful to me

rahul jaiswal · Answer

Sir i want to store path in database and retirve data in table thats my question and thanks to reply me.//.

Akkiraju Ivaturi · Answer

Check if the following works for you: try{ InputStream sImage; Class.forName(com.mysql.jdbc.Driver); Connection con = DriverManager.getConnection(jdbc:mysql://localhost:3306/test root root); File imgfile = new File(C:/flower3.jpg); FileInputStream fin = new FileInputStream(imgfile); PreparedStatement pre = con.prepareStatement(insert into image(images) values(?)); pre.setBinaryStream(1fin(int)imgfile.length()); pre.executeUpdate(); System.out.println(Inserting Successfully!); pre.close(); Statement st=con.createStatement(); ResultSet rs=st.executeQuery(select images from image 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(bytearray0size); } } rs.close(); st.close(); con.close(); } catch(Exception ex){ out.println(error :+ex); } %>