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 SinghPosted Jul 24, 2015, 8:40 PM
Manish kumarPosted Nov 29, 2016, 10:04 AM
2-2-11/11/2016-40
3-3-11/11/2016-30
<%@page import="java.sql.*"%>
<%@ page import="java.util.Calendar" %>
<%
//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 <= OrderID)'Running_Total' from CustomerOrders";
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());
}
%>