Retriving image from database

Question

I have inserted in image in database using mysql with data type blob. Now i want to retrive it in form in jsp. I have created an jsp application form and i want to display the image of applicant. Please some one give me the code for it in jsp . I will be thankfull for that.

Krishna Rajput Singh · Answer

here is helpful for you http://www.aspdotnet-suresh.com/2014/11/retrieve-images-from-path-stored-in-database-in-aspnet.html

Manish kumar · Answer

can any body resolve my problem mention below jsp Running_Total is not working in MS ACCESS Databasecan suggest us real jsp sql code for Running_Total? ID-OrderID-OrderDate-Amount-Running_Total 1-1-11/11/2016-120 2-2-11/11/2016-40 3-3-11/11/2016-30 4-4-11/11/2016-80 //java Code 25/11/2016 try { String date = (new java.util.Date()).toString(); String OrderDate=request.getParameter(OrderDate); int OrderID = Integer.parseInt(request.getParameter(OrderID)); int Amount = Integer.parseInt(request.getParameter(Amount)); int Running_Total=Integer.parseInt(request.getParameter(Running_Total)); String sql_debit=select OrderIDOrderDateAmount(select sum(Amount) from CustomerOrders where OrderID String s=jdbc:odbc:Database2; Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection conn=DriverManager.getConnection(s); Statement pstmt=conn.createStatement(); Calendar calendar = Calendar.getInstance(); java.sql.Date startDate = new java.sql.Date(calendar.getTime().getTime()); ResultSet result = pstmt.executeQuery(sql_debit); //int count = 0; while (result.next()) { //result.getInt(Running_Total); Running_Total = result.getInt(1); //result.getInt(1); String output = User #%d: %s ; System.out.println(String.format(output Running_Total)); } conn.close(); } catch(Exception ex) { System.err.println(ex.getMessage()); } %>

Manoj Bhoir · Answer

Hi Please check these links : http://stackoverflow.com/questions/2340406/how-to-retrieve-and-display-images-from-a-database-in-a-jsp-page http://stackoverflow.com/questions/2150265/retrieve-an-image-stored-as-blob-on-a-mysql-db