Untitled

<html>
    <head>
        <title>TODO supply a title</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    </head>
    <body>
        <form id="f1" enctype="multipart/form-data" action="xlsUpload_01.jsp" method="post">
            <table align="center" border="1">
                <tr>
                    <td>Enter File name</td>
                    <td><input type="text" name="id"></td>

                </tr>
                <tr>
                    <td>Select File</td>
                     <td><input type="file"  name="xlsfile" />
                </tr>

            </table>
            <p>
            <center>
                <input align="center" type="submit" value="Upload File" name="btnsubmit"/>
            </center>

            </p>
        </form>
    </body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
     <%@page import="java.sql.*" %>
    <%@page import ="java.util.Date" %>
    <%@page import ="java.io.*" %>
    <%@page import ="java.io.FileNotFoundException" %>
    <%@page import ="java.io.IOException" %>
    <%@page import ="java.util.Iterator" %>
    <%@page import ="java.util.ArrayList" %>
    <%@page import="org.apache.poi.hssf.usermodel.*" %>
    <%@page import ="org.apache.poi.hssf.usermodel.HSSFCell" %>
    <%@page import ="org.apache.poi.hssf.usermodel.HSSFRow" %>
    <%@page import ="org.apache.poi.hssf.usermodel.HSSFSheet" %>
    <%@page import ="org.apache.poi.hssf.usermodel.HSSFWorkbook" %>
    <%@page import ="org.apache.poi.poifs.filesystem.POIFSFileSystem" %>
    <%@page import="org.apache.poi.ss.usermodel.Cell" %>
    <%@page import ="org.apache.poi.ss.usermodel.Row"%>
    <%@page import="org.apache.poi.ss.usermodel.Sheet" %>
    <%@page import="org.apache.poi.ss.usermodel.Workbook" %>
    <%@page import="com.oreilly.servlet.MultipartRequest" %>
    <%@page import="org.apache.poi.xssf.usermodel.*"%>
    <%@page import="org.apache.poi.xssf.usermodel.XSSFWorkbook"%>

     <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
  <%

 ArrayList CellArrayListHolder=new ArrayList();
 Class.forName("oracle.jdbc.driver.OracleDriver");
        Connection con=DriverManager.getConnection("jdbc:oracle:thin:@172.18.114.213:1821:xe","se","Spacess");
        //String Path="upload";
        String absolutepath=getServletContext().getRealPath("/");

        MultipartRequest mr=new MultipartRequest(request,absolutepath);
        String filename=mr.getOriginalFileName("filename");
        FileInputStream myinput=new FileInputStream(new File(absolutepath+"/"+filename));


       Workbook workbook=new XSSFWorkbook(myinput);

Sheet firstSheet=workbook.getSheetAt(0);
Iterator<Row> iterator=firstSheet.iterator();
int count=0;
while(iterator.hasNext())
{
    XSSFRow nextrow=(XSSFRow)iterator.next();
    ArrayList rowarraylist=new ArrayList();
    Iterator<Cell> cellIterator=nextrow.cellIterator();

    while(cellIterator.hasNext())
    {
        XSSFCell cell=(XSSFCell)cellIterator.next();
        rowarraylist.add(cell);
    }
    CellArrayListHolder.add(rowarraylist);
}
       out.println(CellArrayListHolder);
       ArrayList rowarraylist=null;
       PreparedStatement st=con.prepareStatement("insert into DYNAMIC_INSERT values(?)");

for(int i=1;i<CellArrayListHolder.size();i++)
{
    rowarraylist=(ArrayList)CellArrayListHolder.get(i);
    st.setString(1, rowarraylist.get(0).toString());
    //st.executeUpdate();
    count=st.executeUpdate();

}
if(count>0)
{
       out.println("<script type="text/javascript">");
   out.println("alert('File added');");
   out.println("</script>");
}


  %>
    </body>
</html>