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

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

Manish kumar · Answer

can any body resolve my problem ,mention below jsp Running_Total is not working in MS ACCESS Database,can 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 OrderID,OrderDate,Amount,(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()); } %>

Retriving image from database

Answers (3)