Forum:

Image Uploading in database through JSP

Ranch Hand

Posts: 30

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hey.
We are trying to uplaod an image to our database though the web page. the codes are as follows.
1) This is the form though which we are sending all the info. to be inserted into the database.

<%-- 
    Document   : apply_voter
    Created on : Apr 25, 2011, 1:09:34 PM
    Author     : Ricerca4
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Apply for VoterID</title>
    <link rel="stylesheet" type="text/css" href="stylesheet.css"/>
    <script language="javascript" type="text/javascript">    
    
    function dropdownlist(listindex)
{

document.formname.District.options.length = 0;
switch (listindex)
{

case "Uttar Pradesh" :
document.formname.District.options[0]=new Option("Select District","");
document.formname.District.options[1]=new Option("Gautam Buddh Nagar","Gautambuddh Nagar");
document.formname.District.options[2]=new Option("Varanasi","Varanasi");
document.formname.District.options[3]=new Option("Barabanki","Barabanki");
document.formname.District.options[4]=new Option("Jhansi","Jhansi");

break;

case "Delhi" :
document.formname.District.options[0]=new Option("Select District","");
document.formname.District.options[1]=new Option("East Delhi","East Delhi");
document.formname.District.options[2]=new Option("Central Delhi","Central Delhi");
document.formname.District.options[3]=new Option("North Delhi","North Delhi");
document.formname.District.options[4]=new Option("South Delhi","South Delhi");
document.formname.District.options[5]=new Option("West Delhi","West Delhi");

break;

case "Rajasthan" :
document.formname.District.options[0]=new Option("Select District","");
document.formname.District.options[1]=new Option("Jaipur","Jaipur");
document.formname.District.options[2]=new Option("Jodhpur","Jodhpur");
document.formname.District.options[3]=new Option("Ajmer","Ajmer");
document.formname.District.options[4]=new Option("Jaisalmer","Jaisalmer");
document.formname.District.options[5]=new Option("Alwar","Alwar");

break;

}
return true;
}

</script>

</head>
    <body>
    
    <div class="top">
      <p ><font face="times" size="5" >RASHTRIYA MATTDAN</font> </p>  
       
    </div>
    <br>
    <div class="linktab"  >
        <a href="home.jsp" >Home</a>  
        
       <a href="KnowConstituency.jsp" >KnowYourConstituency</a> 
      <a href="KnowCandidate.jsp" >KnowCandidates</a> 
        <a href="" >Results</a>
        <%HttpSession session1=request.getSession(false);
        if(session1.isNew())
            {%><a href="login.html">Login</a><%}
         else
              {String login1=(String)session1.getAttribute("logged-in");
               System.out.println(login1);
            if(login1!=null){if(login1.equals("true"))
                {%><a href="logout.jsp">Logout</a><%}
                else
                {%><a href="login.html">Login</a><%}}}
    %>
        
        
        <%if(session1.isNew())
        {%><a href="apply.html">Apply/Register</a><%}
                else{
                    String log1=(String)session1.getAttribute("logged-in");
                if(log1!=null){
         if(log1.equals("true"))
            {%><a href="prevote.jsp">Vote</a>
            <%}
         }}%>
           
        <a href="feedback.jsp" >Feedback</a> 
        <a href="sitemap.html" >Sitemap</a>
    </div>
    <div class="content">
        <centre>
        <fieldset><legend>
            <form id="formname" name="formname" method="post" action="application processing.jsp" >
            <p align=right >Passport Size Picture
                  <input type="file" name="file" size="20" /></p>
            <table width="50%" border="0" cellspacing="2" cellpadding="2" >
            
            <tr>
                <td align="right" valign="middle">Name</td>
                <td align="right" valign="middle"><input type="text" size="40" name ="voter_name" /></td>
              </tr>
              <tr>
                  <td align="right" valign="middle">Father's/Husband's Name</td>
                <td align="right" valign="middle"><input type="text" size="40" name="fath_hus_name" /></td>
                  
              </tr>
              <tr>
                  <td align="right" valign="middle">Date Of Birth</td>
                <td align="right" valign="middle"><input type="text" size="10" name="date_of_birth" /></td>
                  
              </tr>
                <tr>
                  <td align="right" valign="middle">Gender</td>
                <td align="right" valign="middle"><input type="radio" name="gender" value="M" />Male
                                                  <input type="radio" name="gender" value="F" />Female</td>
                  
              </tr>
            
             
              <tr>
                <td align="right" valign="middle">Permanent_Address</td>
                <td align="right" valign="middle"><textarea rows=4 cols=30 name="per_add"></textarea></td>
            </tr>
      
              <tr>
                  <td align="right" valign="middle">Tehsil</td>
                <td align="right" valign="middle"><input type="text" size="40" name="tehsil" /></td>
                  
              </tr>
               <tr>
                  <td align="right" valign="middle">Constituency Code:</td>
                <td align="right" valign="middle"><input type="text" size="10" name="const_id" /></td>
                  
              </tr>
              <tr>
                  <td align="right" valign="middle">State</td>
                <td align="right" valign="middle">><select name="State" id="State" onchange="javascript: dropdownlist(this.options[this.selectedIndex].value);">
                    <option value="">Select State</option>
                    <option value="Uttar Pradesh">Uttar Pradesh</option>
                    <option value="Delhi">Delhi</option>
                    <option value="Rajasthan">Rajasthan</option>
                    </select></td>
                  
              </tr>
              <tr>
                  <td align="right" valign="middle">District</td>
                <td align="right" valign="middle"><script type="text/javascript" language="JavaScript">
                    document.write('<select name="District"><option value="">Select District</option></select>')
                    </script>
                    <noscript><select name="District" id="District" >
                    <option value="">Select District</option>
                    </select>
                    </noscript></td>
                  
              </tr>
              <tr>
                  <td align="right" valign="middle">Mobile No.</td>
                <td align="right" valign="middle"><input type="text" size="12" name="mobil_no" /></td>
                  
              </tr>
              <tr>
                  <td align="right" valign="middle">Telephone No.</td>
                <td align="right" valign="middle"><input type="text" size="11" name="tele_no" /></td>
                  
              </tr>
            
              <tr>
                  <td align="right" valign="middle">Religion</td>
                <td align="right" valign="middle"><input type="text" size="15" name="religion" /></td>
                  
              </tr>
              <tr>
                <td align="right" valign="middle"> <input type="submit" value="submit"/></td>
   
            </tr>
            
        </table>
        
                  
                
                  
              
    </form>
   
   
            
        </legend>
    </fieldset>
    </centre>
    </div>
    
    </body>
</html>

2)This is the jsp file which is intercating with the database:

<%-- 
    Document   : application processing
    Created on : Apr 25, 2011, 3:05:29 PM
    Author     : Ricerca4
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Processing Appliation</title>
    <link rel="stylesheet" type="text/css" href="stylesheet.css"/>
    
    </head>
    <body>
    
    <div class="top">
      <p ><font face="times" size="5" >RASHTRIYA MATTDAN</font> </p>  
       
    </div>
    <br>
    <div class="linktab"  >
        <a href="home.jsp" >Home</a>  
        
       <a href="KnowConstituency.jsp" >KnowYourConstituency</a> 
      <a href="KnowCandidate.jsp" >KnowCandidates</a> 
        <a href="" >Results</a>
        <%HttpSession session1=request.getSession(false);
        if(session1.isNew())
            {%><a href="login.html">Login</a><%}
         else
              {String login1=(String)session1.getAttribute("logged-in");
               System.out.println(login1);
           if(login1!=null){ if(login1.equals("true"))
                {%><a href="logout.jsp">Logout</a><%}
                else
                {%><a href="login.html">Login</a><%}}}
    %>
        
        
        <%if(session1.isNew())
        {%><a href="apply.html">Apply/Register</a><%}
                else{
                    String log1=(String)session1.getAttribute("logged-in");
                if(log1!=null){
         if(log1.equals("true"))
            {%><a href="prevote.jsp">Vote</a>
            <%}
         }}%>
           
        <a href="feedback.jsp" >Feedback</a> 
        <a href="sitemap.html" >Sitemap</a>
    </div>
    <div class="content">
    <   
   
    
    <%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.zip.*"%>
            <%
        String const_id=request.getParameter("const_id");
        String voter_name=request.getParameter("voter_name");
        String fath_hus_name=request.getParameter("fath_hus_name");        
        String mobil_no=request.getParameter("mobil_no");
        String tele_no=request.getParameter("tele_no");        
        String tehsil=request.getParameter("tehsil");
        String district=request.getParameter("District");
        String state_name=request.getParameter("State");
        String per_add=request.getParameter("per_add");
        String date_of_birth=request.getParameter("date_of_birth");
        String gender=request.getParameter("gender");
        String religion=request.getParameter("religion");
        String pic=request.getParameter("cand_pic");
        String userName="root";
        String password="root";
        String msg=null;
        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();

Connection conn = null;
    String url = "jdbc:mysql://localhost:3306/";
    String dbName = "project_demo";
    String driver = "com.mysql.jdbc.Driver";
    ResultSet rs = null;
    PreparedStatement psmnt = null;
    FileInputStream fis;

try {
      Class.forName(driver).newInstance();
      conn = DriverManager.getConnection(url+dbName,userName,password);
      File f = new File(saveFile);

String sql = "INSERT temp_voter values('"+const_id+"','"+voter_name+"','"+fath_hus_name+"','"+mobil_no+"','"+tele_no+"','"+tehsil+"','"+district+"','"+state_name+"','"+per_add+"',?,'"+date_of_birth+"','"+gender+"','"+religion+"')" ;
     psmnt=conn.prepareStatement(sql);
     fis = new FileInputStream(f);
    psmnt.setBinaryStream(1, (InputStream)fis, (int)(f.length()));
    int s = psmnt.executeUpdate();

if(s>0){
        
}
else{
System.out.println("Error!");
}
}
catch(Exception e){e.printStackTrace();}
}
%>   
  
    
</div>
</body>
</html>

3) and this is the error which is coming:

Apr 27, 2011 5:06:28 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
        at org.apache.jsp.KnowConstituency_jsp._jspService(KnowConstituency_jsp.java:134)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)

When we are not trying to insert any image then the code is working fine but as soon as we try to insert an image it gives NullPointer error.

Please help.

For my next trick, I'll need the help of a tiny ad ...

a bit of art, as a gift, the permaculture playing cards

https://gardener-gift.com