How to Insert image and data both together in database in JSP/Servlet ?

//form.jsp

<%@ page language="java" %>
<HTML>
<HEAD><TITLE>Display file upload form to the user</TITLE></HEAD>
<BODY> 

<FORM ENCTYPE="multipart/form-data" ACTION="NewAdmission2011_12.jsp" METHOD="POST">
<br><br><br>
<center>
<table border="0" bgcolor=#ccFDDEE>

Name:<input type=text name="name">
City:<input type=text name="city">

<tr>
<center>
<td colspan="2" align="center"><B>UPLOAD THE FILE</B><center></td>
</tr>
<tr>
<td colspan="2" align="center"> </td>
</tr>
<tr>
<td><b>Choose the file To Upload:</b></td>
<td><INPUT NAME="file" TYPE="file"></td>
</tr>
<tr>
<td colspan="2" align="center"> </td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" value="Send File"> </td>
</tr>
<table>
</center>
</FORM>
</BODY>
</HTML>



//NewAdd.jsp

<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%



String saveFile="";
String contentType = request.getContentType();
if((contentType != null)&&(contentType.indexOf("multipart/form-data") >= 0))
{
    DataInputStream in = new DataInputStream(request.getInputStream());
    int formDataLength = request.getContentLength();
    byte dataBytes[] = new byte[formDataLength];
    int byteRead = 0;
    int totalBytesRead = 0;


    while(totalBytesRead < formDataLength)
    {
        byteRead = in.read(dataBytes, totalBytesRead,formDataLength);
        totalBytesRead += byteRead;
    }

    String file = new String(dataBytes);
    saveFile = file.substring(file.indexOf("filename=\"") + 10);
    saveFile = saveFile.substring(0, saveFile.indexOf("\n"));
    saveFile = saveFile.substring(saveFile.lastIndexOf("\\") + 1,saveFile.indexOf("\""));
    int lastIndex = contentType.lastIndexOf("=");
    String boundary = contentType.substring(lastIndex + 1,contentType.length());
    int pos;
    pos = file.indexOf("filename=\"");
    pos = file.indexOf("\n", pos) + 1;
    pos = file.indexOf("\n", pos) + 1;
    pos = file.indexOf("\n", pos) + 1;
    int boundaryLocation = file.indexOf(boundary, pos) - 4;
    int startPos = ((file.substring(0, pos)).getBytes()).length;
    int endPos = ((file.substring(0, boundaryLocation)).getBytes()).length;
    File ff = new File(saveFile);
    FileOutputStream fileOut = new FileOutputStream(ff);
    fileOut.write(dataBytes, startPos, (endPos - startPos));
    fileOut.flush();
    fileOut.close();
%>

    <Br><table border="2"><tr><td><b>You have successfully upload the file:</b>
<%
    out.println(saveFile);
%>
    </td></tr></table>
<%

    Connection connection = null;
    String connectionURL = "jdbc:mysql://localhost:3306/test";
    ResultSet rs = null;


    PreparedStatement psmnt = null;
    FileInputStream fis;

    try
    {

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

connection=DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/student.mdb");


        String nn=request.getParameter("name");
            String cc=request.getParameter("city");

        File f = new File(saveFile);
        psmnt = connection.prepareStatement("insert into data(Name,City,Img) values('"+nn+"','"+cc+"',?)");
        fis = new FileInputStream(f);
        psmnt.setBinaryStream(1, (InputStream)fis, (int)(f.length()));
        int s = psmnt.executeUpdate();

        if(s>0)
        {
            System.out.println("Uploaded successfully !");
        }
        else
        {
            System.out.println("Error!");
        }
    }
    catch(Exception e)
    {
            System.out.println(e.getMessage());
    }
}
%>



//if i remove below lines then it insert image
String nn=request.getParameter("name");
String cc=request.getParameter("city");

and when i insert these lines then nothing insert 
plz help me
View Answers
How to Insert image and data both together in database in JSP/Servlet ?

Questions by Category
