how to upload pdf files to My sql with java

[P Arunkumar]

Hi

I need to save file to mysql database.

I tried through java, compilation no error, while running time iam getting errors please help me to solve the problem.

My inserting file code is:

import java.sql.*;
import java.io.*;
class SaveImageToDatabase {
    public static void main(String[] args) throws SQLException {
        // declare a connection by using Connection interface 
        Connection connection = null;
        /* Create string of connection url within specified format with machine 
           name, port number and database name. Here machine name id localhost 
           and database name. */
        String connectionURL = "jdbc:mysql://localhost:3306/file_upload";
        /*declare a resultSet that works as a table resulted by execute a specified 
           sql query. */
        ResultSet rs = null;
        // Declare prepare statement.
        PreparedStatement psmnt = null;
        // declare FileInputStream object to store binary stream of given image.
        FileInputStream fis;
        try {
            // Load JDBC driver "com.mysql.jdbc.Driver"
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            /* Create a connection by using getConnection() method that takes 
               parameters of string type connection url, user name and password to 
               connect to database. */
            connection = DriverManager.getConnection(connectionURL, "root", "root");
            // create a file object for image by specifying full path of image as parameter.
            File image = new File("C:\\hello.pdf");
            /* prepareStatement() is used for create statement object that is 
               used for sending sql statements to the specified database. */
            psmnt = connection.prepareStatement("insert into save_file(name, city, image, Phone) "+ "values(?,?,?,?)");
            psmnt.setString(1,"mahendra");
            psmnt.setString(2,"Delhi");
            psmnt.setString(4,"123456");
            fis = new FileInputStream(image);
            psmnt.setBinaryStream(3, (InputStream)fis, (int)(image.length()));
            /* executeUpdate() method execute specified sql query. Here this query 
               insert data and image from specified address. */ 
            int s = psmnt.executeUpdate();
            if(s>0) {
                System.out.println("Uploaded successfully !");
            }
            else {
                System.out.println("unsucessfull to upload image.");
            }
        }
        // catch if found any exception during rum time.
        catch (Exception ex) {
            System.out.println("Found some error : "+ex);
        }
        finally {
            // close all the connections.
            connection.close();
            psmnt.close();
        }
    }
}

My Sql Database is:
SQL> create database file_upload; sql> create table save_file( name varchar(25) not null, city varchar(25) not null, image mediumblob, phone varchar(15) );
Compilation: javac SaveImageToDatabase.java
No error
Run : java SaveImageToDatabase
Error
In thread "main: java.lang.NoClassDefFoundError: SaveImageToDatabase
caused by: java.lang.ClassNotFoundException:SaveImageToDatabase
at java.net.URLClassLoader$1.run(URLCLassLoader.java:202)
at java.security.AccessController.doPrivileges(Native Method)
at java.net.URLClassLoader.findClass(URLCLassLoader.java:190)
at java.lang.ClassLoader.LoadClass(CLassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
Could not find the main class:SaveImageToDatabase.

[Rob Spoor]

Please UseCodeTags. Don't forget to keep your indentation. I've added both for you this time.

You have a class path issue. You've probably set the class path and forgot to include the current directory (.).

I also see two quick improvements:
1) You don't need to cast fis to InputStream. It's a FileInputStream and therefore already an InputStream.
2) You should close the connection after closing the statement. Once the connection is closed its statements are already invalid.

[P Arunkumar]

Hi

Thanks for guide i have solved the class path issue, i run the program its showing Uploaded successfully !. but if i went and saw in MySQL Workbench in image column its blank and its showing blob only the datatype.

I tried to retrieve the fie its showing java.Lang.NullPointerException.

try
{
rs=st.executeQuery("select images from image where name=' '");
if(rs.next()){
byte[] bytearray = new byte[1048576];
int size=0;
sImage = rs.getBinaryStream(1);
response.reset();
response.setContentType("image/jpeg");
while((size=sImage.read(bytearray))!= -1 )
{
response.getOutputStream().write(bytearray,0,size);
}
}
}
// catch if found any exception during rum time.
catch (Exception ex) {
System.out.println("Found some error : "+ex);
}

Please help to solve my problem.

[Wendy L Gibbons]

first point, don't always trust mysql workbench, I spent about 2 hours pulling my hair out because my update wasn't working. I closed the workbench, opened it again, and WOW my update HAD worked.

second point, which line had the null pointer exception

[P Arunkumar]

Thank you
This is my full code:

<%@page import="java.sql.*,java.io.*"%>
<%
InputStream sImage;
Connection connection = null;
Statement st=null;
/* Create string of connection url within specified format with machine 
name, port number and database name. Here machine name id localhost 
and database name is mahendra. */
String connectionURL = "jdbc:mysql://localhost:3306/file_upload";
/*declare a resultSet that works as a table resulted by execute a specified 
sql query. */
ResultSet rs = null;
// Declare prepare statement.
PreparedStatement psmnt = null;
// declare FileInputStream object to store binary stream of given image.
FileInputStream fis;
try {
// Load JDBC driver "com.mysql.jdbc.Driver"
Class.forName("com.mysql.jdbc.Driver").newInstance();
/* Create a connection by using getConnection() method that takes 
parameters of string type connection url, user name and password to 
connect to database. */
connection = DriverManager.getConnection(connectionURL, "root", "root");
// create a file object for image by specifying full path of image as parameter.
File image = new File("C:\\Documents and Settings\\manjusha\\Desktop\\h.jpg");
/* prepareStatement() is used for create statement object that is 
used for sending sql statements to the specified database. */
psmnt = connection.prepareStatement
("insert into save_image(name, city, image, Phone) "+ "values(?,?,?,?)");
psmnt.setString(1,"hai");
psmnt.setString(2,"Delhi");
psmnt.setString(4,"123456");
fis = new FileInputStream(image);
psmnt.setBinaryStream(3, (InputStream)fis, (int)(image.length()));
/* executeUpdate() method execute specified sql query. Here this query 
insert data and image from specified address. */ 
int s = psmnt.executeUpdate();
if(s>0) {
System.out.println("Uploaded successfully !");
}
psmnt.close();
rs=st.executeQuery("select images from image where name='hai'");
if(rs.next()){
byte[] bytearray = new byte[1048576];
int size=0;
sImage = rs.getBinaryStream(1);
response.reset();
response.setContentType("image/jpeg");
while((size=sImage.read(bytearray))!= -1 )
{
response.getOutputStream().write(bytearray,0,size);
}
}
}
// catch if found any exception during rum time.
catch (Exception ex) {
System.out.println("Found some error : "+ex);
}
finally {
// close all the connections.
connection.close();
psmnt.close();
}
%>

After running this code its shows:

Uploaded successfully !
Found some error : java.lang.NullPointerException

what are the data i have given its uploaded, i need to check that my file is uploaded sucessfully or not. and i need to see my file as output.

i need to see my image as output after uploading.

Iam new to developing field, if i did any mistakes please guide me.

Thanks in advance.

[Wendy L Gibbons]

sorry to be a pain, but is this in a .jsp file, as your first post was in a class?

at least for this stage I would put it back in a class, you will get much better errors out whilst testing it (like you did in the first post.)

Then once it is in a class read this thread https://coderanch.com/t/565873/JSP/java/connect-database-display-query-vqlus
it is about seperating your jsp from your pretty stuff on screen

[Wendy L Gibbons]

and read this page, examples of your exact question:
http://www.mkyong.com/java/how-to-download-file-from-website-java-jsp/

[P Arunkumar]

Hi

I have find out how to upload and download a file through java. now i need to get the upload path from jsp page and then the path want to store in variable, by using variable the file wants to save in MySQL database. iam using Eclipse and i created one jsp page and one class file for java, by using request.getParameter()
Iam getting the values from jsp page. but iam getting error. My java program separately running successfully, but i need to connect with jsp.

Please Help Me, iam new to developing field, please Guide me.

My MySql Creation:

Mysql> create database blob_test;
Mysql > use blob_test;
Mysql > create table pictures (id varchar (100), name varchar (100), photo longblob);

My JSP Code :

<%@ page language="java" %>
<Html>
<HEAD><TITLE>Display file upload form to the user</TITLE></HEAD>  
<% //  for uploading the file we used Encrypt type of multipart/form-data and input of file type to browse and submit the file %>
  <BODY> <FORM  ENCTYPE="multipart/form-data" ACTION= "BlobSample2" METHOD=POST>
                <br><br><br>
          <center><table border="2" >
                    <tr><center><td colspan="2"><p align=
"center"><B>PROGRAM FOR UPLOADING THE FILE</B><center></td></tr>
                    <tr><td><b>Choose the file To Upload:</b>
</td>
                    <td><INPUT NAME="F1" TYPE="file"></td></tr>
                                        <tr><td colspan="2">
<p align="right"><INPUT TYPE="submit" VALUE="Send File" ></p></td></tr>
             <table>
     </center>      
     </FORM>
</BODY>
</HTML>

My Java Code :

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class BlobSample2 {
    public static void main(String[] args) throws Exception, IOException, SQLException {
    [b][size=18][color=red]	String path = request.getParameter("F1");[/color][/size][/b]
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/blob_test", "root", "root");
        String INSERT_PICTURE = "insert into pictures(id, name, photo) values (?, ?, ?)";       

        FileInputStream fis = null;
        PreparedStatement ps = null;
        try {
            //save file as blob
            conn.setAutoCommit(false);
            File file = new File(path);
            fis = new FileInputStream(file);
            ps = conn.prepareStatement(INSERT_PICTURE);
            ps.setString(1, "004");
            ps.setString(2, "mahentesh");
            ps.setBinaryStream(3, fis, (int) file.length());
            ps.executeUpdate();
            conn.commit();


            //read back
            String SELECT_PICTURE = "select id, name, photo from pictures";
            ps = conn.prepareStatement(SELECT_PICTURE);
            ResultSet rs =  ps.executeQuery();
            while (rs.next()) {
                //save blob as an image
                FileOutputStream fos = new FileOutputStream("c:\\elsoft.pdf");
                //String id = rs.getString(1);
                //String name = rs.getString(2);
                InputStream is  = rs.getBinaryStream(3);
                byte[] buf = new byte[3000];
                int read = 0;
                while ((read = is.read(buf))>0) {
                    fos.write(buf, 0, read);
                }
                fos.close();
                is.close();
            }

        } finally {
            ps.close();
            fis.close();
        }
    }
}

I have coded perfectly or not i don't know please check my code and help me.


Thanks in advance

[Rob Spoor]

Please PostRealCode. That's not your real code, as HTML pages cannot call Java applications through form actions. You need a servlet instead, with the right URL mapping and all.

[P Arunkumar]

Thank you for your Guide

I have change my code into servlet please help me iam getting error. iam using Eclipse for development.


My jsp page:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<Html>
<HEAD><TITLE>Display file upload form to the user</TITLE></HEAD>  
<% //  for uploading the file we used Encrypt type of multipart/form-data and input of file type to browse and submit the file %>
  <BODY> <FORM  ENCTYPE="multipart/form-data" ACTION= "BlobSample" METHOD=POST>
                <br><br><br>
          <center><table border="2" >
                    <tr><center><td colspan="2"><p align=
"center"><B>PROGRAM FOR UPLOADING THE FILE</B><center></td></tr>
                    <tr><td><b>Choose the file To Upload:</b>
</td>
                    <td><INPUT NAME="F1" TYPE="file"></td></tr>
                                        <tr><td colspan="2">
<p align="right"><INPUT TYPE="submit" VALUE="Send File" ></p></td></tr>
             <table>
     </center>      
     </FORM>
</BODY>
</HTML>

My servlet Code

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
 
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class BlobSample extends HttpServlet {
 

public void init(ServletConfig config) throws ServletException {
super.init(config);
}
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
	{
		PrintWriter out = response.getWriter();
		String connectionURL = "jdbc:mysql://localhost:3306/blob_test";
		// Load the database driver
		
		// Get a Connection to the database

		
		ResultSet rs;
		String Name = request.getParameter("F1");
		response.setContentType("text/html");
		FileInputStream fis = null;
		PreparedStatement ps = null;
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			Connection conn = null;
			conn = DriverManager.getConnection(connectionURL, "root", "root");
			//save file as blob
			conn.setAutoCommit(false);
			File file = new File(Name);
			fis = new FileInputStream(file);
			String INSERT_PICTURE = "insert into pictures(id, name, photo) values (?, ?, ?)";
			ps = conn.prepareStatement(INSERT_PICTURE);
			ps.setString(1, "005");
			ps.setString(2, "hai");
			ps.setBinaryStream(3, fis, (int)file.length());
			ps.executeUpdate();
			//read back
            String SELECT_PICTURE = "select id, name, photo from pictures";
            ps = conn.prepareStatement(SELECT_PICTURE);
             rs =  ps.executeQuery();
            while (rs.next()) {
                //save blob as an image
                FileOutputStream fos = new FileOutputStream("c:\\elsoft.pdf");
                //String id = rs.getString(1);
                //String name = rs.getString(2);
                InputStream is  = rs.getBinaryStream(3);
                byte[] buf = new byte[3000];
                int read = 0;
                while ((read = is.read(buf))>0) {
                    fos.write(buf, 0, read);
                }
                fos.close();
                is.close();

		
            }			
			
		}
		catch(SQLException e)
		{
		out.println();	
			
		}
		catch(ClassNotFoundException cx)
		{
	
		out.println(cx);
		}


	}
 
public void destroy() {
 
}
}

My code is for i need to upload one file its wants to save in MySQL and and the copy of the file wants to download as C:\\ filename it is working in java perfect if i gave the path as manually,but i need to upload a file path by using jsp page

My web.xml code :

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
	<display-name>Upload_data</display-name>
	<servlet>
		<servlet-name>BlobSample</servlet-name>
		<servlet-class>BlobSample</servlet-class>
	</servlet>
	<servlet-mapping>
		<servlet-name>BlobSample</servlet-name>
		<url-pattern>/BlobSample</url-pattern>
	</servlet-mapping>
	</web-app>

MySQL Database:

Mysql> create database blob_test;
Mysql > use blob_test;
Mysql > create table pictures (id varchar (100), name varchar (100), photo longblob);

I have copy and pasted the class file in class folder and the jar files are commons-fileupload-1.2.2.jar,commons-io-1.3.2.jar, mysql-connector-java-3.0.17-ga-bin.jar,servlet-api.jar in lib folder.

while iam running the program iam getting error as

HTTP Status 500 - 

--------------------------------------------------------------------------------

type Exception report

message 

description The server encountered an internal error () that prevented it from fulfilling this request.

exception 

java.lang.NullPointerException
	java.io.File.<init>(File.java:222)
	BlobSample.doPost(BlobSample.java:51)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)


note The full stack trace of the root cause is available in the Apache Tomcat/6.0.33 logs.

Please help me to solve the problem.

Thanks in advance.

[Wendy L Gibbons]

it is handy you are using eclipse, then you can debug the server, the line that must be going wrong is:

String Name = request.getParameter("F1");  

I always found it handy to get all of the parameters and loop through printing them out, as looking at the variables in the debug/variables tab is horrible.
but from experience it is usually the passing form, isn't doing what you expect.

[P Arunkumar]

I can't understand what your are coming to tell me. please tell clearly and give any guide to solve this.

[Rob Spoor]

Files are not treated the same as other parameters. See https://coderanch.com/how-to/java/FileUpload for more information.

[P Arunkumar]

I solved my problem it will store the the file into mysql

jpage.jsp:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<Html>
<HEAD><TITLE>Display file upload form to the user</TITLE></HEAD>  
<% //  for uploading the file we used Encrypt type of multipart/form-data and input of file type to browse and submit the file %>
  <BODY> <FORM  ENCTYPE="multipart/form-data" ACTION= "upload.jsp" METHOD=POST>
                <br><br><br>
          <center><table border="2" >
                    <tr><center><td colspan="2"><p align=
"center"><B>PROGRAM FOR UPLOADING THE FILE</B><center></td></tr>
                    <tr><td><b>Choose the file To Upload:</b>
</td>
                    <td><INPUT NAME="F1" TYPE="file"></td></tr>
                                        <tr><td colspan="2">
<p align="right"><INPUT TYPE="submit" VALUE="Send File" ></p></td></tr>
             <table>
     </center>      
     </FORM>
</BODY>
</HTML>

upload.jsp:

<%@ page import="java.io.*,java.util.*, javax.servlet.*,java.sql.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="org.apache.commons.fileupload.*" %>
<%@ page import="org.apache.commons.fileupload.disk.*" %>
<%@ page import="org.apache.commons.fileupload.servlet.*" %>
<%@ page import="org.apache.commons.io.output.*" %>


<%
   File file ;
   int maxFileSize = 5000 * 2492013;
   int maxMemSize = 5000 * 2492013;
   ServletContext context = pageContext.getServletContext();
   String filePath = context.getInitParameter("file-upload");

   // Verify the content type
   String contentType = request.getContentType();
   if ((contentType.indexOf("multipart/form-data") >= 0)) {

      DiskFileItemFactory factory = new DiskFileItemFactory();
      // maximum size that will be stored in memory
      factory.setSizeThreshold(maxMemSize);
      // Location to save data that is larger than maxMemSize.
      factory.setRepository(new File("c:\\temp"));

      // Create a new file upload handler
      ServletFileUpload upload = new ServletFileUpload(factory);
      // maximum file size to be uploaded.
      upload.setSizeMax( maxFileSize );
      new File("C:\\Diry1").mkdir();
      try{ 
         // Parse the request to get file items.
         List fileItems = upload.parseRequest(request);

         // Process the uploaded file items
         Iterator i = fileItems.iterator();

         out.println("<html>");
         out.println("<head>");
         out.println("<title>JSP File upload</title>");  
         out.println("</head>");
         out.println("<body>");
         while ( i.hasNext () ) 
         {
            FileItem fi = (FileItem)i.next();
            if ( !fi.isFormField () )	
            {
            // Get the uploaded file parameters
            String fieldName = fi.getFieldName();
            String fileName = fi.getName();
            boolean isInMemory = fi.isInMemory();
            long sizeInBytes = fi.getSize();
            // Write the file
            if( fileName.lastIndexOf("\\") >= 0 ){
            file = new File( filePath + 
            fileName.substring( fileName.lastIndexOf("\\"))) ;
            }else{
            file = new File( filePath + 
            fileName.substring(fileName.lastIndexOf("\\")+1)) ;
            }
            fi.write( file ) ;
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/blob_test", "root", "root");
            String INSERT_PICTURE = "insert into pictures(id, name, photo, File_name, Date,Time) values (?, ?, ?, ?, CURDATE(), CURTIME())";       
            
            String file_name = file.getName();
            FileInputStream fis = null;
            PreparedStatement ps = null;
            conn.setAutoCommit(false);
            fis = new FileInputStream(file);
            ps = conn.prepareStatement(INSERT_PICTURE);
            ps.setString(1, "026");
            ps.setString(2, "hai");
            ps.setBinaryStream(3, fis, (int) file.length());
            ps.setString(4, file_name);
            ps.executeUpdate();
            conn.commit();


            //read back
            String SELECT_PICTURE = "select id, name, photo from pictures";
            ps = conn.prepareStatement(SELECT_PICTURE);
            ResultSet rs =  ps.executeQuery();
            out.println("Uploaded Filename: " + 
            fileName + "<br>");
            file.delete();
       
            out.println("filename :"+file_name);
            
            }
         }
         out.println("</body>");
         out.println("</html>");
      }catch(Exception ex) {
         System.out.println(ex);
      }
   }else{
      out.println("<html>");
      out.println("<head>");
      out.println("<title>Servlet upload</title>");  
      out.println("</head>");
      out.println("<body>");
      out.println("<p>No file uploaded</p>"); 
      out.println("</body>");
      out.println("</html>");
   }
%>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
	<display-name>upload_mon</display-name>
	<context-param> 
    <description>Location to store uploaded file</description> 
    <param-name>file-upload</param-name> 
    <param-value>
         C:\Dir1
     </param-value> 
</context-param>
</web-app>

then we need servlet-api jar file, mysql-connector-java-3.0.17-ga-bin jar file, commons-fileupload-1.2.2 jar file, commons-io-1.3.2 jar file.


My program is running sucessfully and the file is loading to the server with file name and current date and time.

[P Arunkumar]

I solved my problem it will store the the file into mysql

jpage.jsp:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<Html>
<HEAD><TITLE>Display file upload form to the user</TITLE></HEAD>  
<% //  for uploading the file we used Encrypt type of multipart/form-data and input of file type to browse and submit the file %>
  <BODY> <FORM  ENCTYPE="multipart/form-data" ACTION= "upload.jsp" METHOD=POST>
                <br><br><br>
          <center><table border="2" >
                    <tr><center><td colspan="2"><p align=
"center"><B>PROGRAM FOR UPLOADING THE FILE</B><center></td></tr>
                    <tr><td><b>Choose the file To Upload:</b>
</td>
                    <td><INPUT NAME="F1" TYPE="file"></td></tr>
                                        <tr><td colspan="2">
<p align="right"><INPUT TYPE="submit" VALUE="Send File" ></p></td></tr>
             <table>
     </center>      
     </FORM>
</BODY>
</HTML>

upload.jsp:

<%@ page import="java.io.*,java.util.*, javax.servlet.*,java.sql.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="org.apache.commons.fileupload.*" %>
<%@ page import="org.apache.commons.fileupload.disk.*" %>
<%@ page import="org.apache.commons.fileupload.servlet.*" %>
<%@ page import="org.apache.commons.io.output.*" %>


<%
   File file ;
   int maxFileSize = 5000 * 2492013;
   int maxMemSize = 5000 * 2492013;
   ServletContext context = pageContext.getServletContext();
   String filePath = context.getInitParameter("file-upload");

   // Verify the content type
   String contentType = request.getContentType();
   if ((contentType.indexOf("multipart/form-data") >= 0)) {

      DiskFileItemFactory factory = new DiskFileItemFactory();
      // maximum size that will be stored in memory
      factory.setSizeThreshold(maxMemSize);
      // Location to save data that is larger than maxMemSize.
      factory.setRepository(new File("c:\\temp"));

      // Create a new file upload handler
      ServletFileUpload upload = new ServletFileUpload(factory);
      // maximum file size to be uploaded.
      upload.setSizeMax( maxFileSize );
      new File("C:\\Diry1").mkdir();
      try{ 
         // Parse the request to get file items.
         List fileItems = upload.parseRequest(request);

         // Process the uploaded file items
         Iterator i = fileItems.iterator();

         out.println("<html>");
         out.println("<head>");
         out.println("<title>JSP File upload</title>");  
         out.println("</head>");
         out.println("<body>");
         while ( i.hasNext () ) 
         {
            FileItem fi = (FileItem)i.next();
            if ( !fi.isFormField () )	
            {
            // Get the uploaded file parameters
            String fieldName = fi.getFieldName();
            String fileName = fi.getName();
            boolean isInMemory = fi.isInMemory();
            long sizeInBytes = fi.getSize();
            // Write the file
            if( fileName.lastIndexOf("\\") >= 0 ){
            file = new File( filePath + 
            fileName.substring( fileName.lastIndexOf("\\"))) ;
            }else{
            file = new File( filePath + 
            fileName.substring(fileName.lastIndexOf("\\")+1)) ;
            }
            fi.write( file ) ;
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/blob_test", "root", "root");
            String INSERT_PICTURE = "insert into pictures(id, name, photo, File_name, Date,Time) values (?, ?, ?, ?, CURDATE(), CURTIME())";       
            
            String file_name = file.getName();
            FileInputStream fis = null;
            PreparedStatement ps = null;
            conn.setAutoCommit(false);
            fis = new FileInputStream(file);
            ps = conn.prepareStatement(INSERT_PICTURE);
            ps.setString(1, "026");
            ps.setString(2, "hai");
            ps.setBinaryStream(3, fis, (int) file.length());
            ps.setString(4, file_name);
            ps.executeUpdate();
            conn.commit();


            //read back
            String SELECT_PICTURE = "select id, name, photo from pictures";
            ps = conn.prepareStatement(SELECT_PICTURE);
            ResultSet rs =  ps.executeQuery();
            out.println("Uploaded Filename: " + 
            fileName + "<br>");
            file.delete();
       
            out.println("filename :"+file_name);
            
            }
         }
         out.println("</body>");
         out.println("</html>");
      }catch(Exception ex) {
         System.out.println(ex);
      }
   }else{
      out.println("<html>");
      out.println("<head>");
      out.println("<title>Servlet upload</title>");  
      out.println("</head>");
      out.println("<body>");
      out.println("<p>No file uploaded</p>"); 
      out.println("</body>");
      out.println("</html>");
   }
%>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
	<display-name>upload_mon</display-name>
	<context-param> 
    <description>Location to store uploaded file</description> 
    <param-name>file-upload</param-name> 
    <param-value>
         C:\Dir1
     </param-value> 
</context-param>
</web-app>

then we need servlet-api jar file, mysql-connector-java-3.0.17-ga-bin jar file, commons-fileupload-1.2.2 jar file, commons-io-1.3.2 jar file.


My program is running sucessfully and the file is loading to the server with file name and current date and time.