import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Iterator;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.commons.fileupload.*;
 
 
public class Upload extends HttpServlet {
 
    /** 
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        PreparedStatement pst = null;
        ResultSet rs = null;
        Statement stmt = null;
        Connection conn = null;
        try {
 
            Class.forName("org.gjt.mm.mysql.Driver").newInstance();
 
            conn = DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=dba$");
            stmt = conn.createStatement();
 
            FileUpload fup = new FileUpload();
            DiskFileUpload upload = new DiskFileUpload();
            List items = upload.parseRequest(request);
            Iterator iter = items.iterator();
 
            int count = 0;
            while (iter.hasNext()) {
                count++;
                FileItem item = (FileItem) iter.next();
                File cfile = new File(item.getName());
                File tosave = new File(getServletContext().getRealPath("/temp/"), cfile.getName());
                //item.write(tosave);
                // String file_name = item.getName(); 
                FileInputStream fis = new FileInputStream(tosave);
                int len = (int) tosave.length();
                pst = conn.prepareStatement("INSERT INTO images (image_data)values(?)");
                //image_data column holds LONGBLOB data type
 
                pst.setBinaryStream(1, fis, len);
                int rows = pst.executeUpdate();
            }
 
        } catch (Exception e) {
            System.out.println(e.toString());
        }
 
    }
}