Untitled

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

<html>
    <%
        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);
            String saveFile = file.substring(file.indexOf("filename=\"") + 10);
            System.out.println("saveFile=" + saveFile);
            saveFile = saveFile.substring(saveFile.lastIndexOf("\\") + 1, saveFile.indexOf("\""));
            System.out.println("saveFile" + saveFile);
            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;

            FileOutputStream fileOut = new FileOutputStream(saveFile);
            fileOut.write(dataBytes, startPos, (endPos - startPos));

    %>
    <b>File <% out.println(saveFile);%> has been uploaded and inserted into Database.</b>
    <%


            String bestandsNaam = saveFile;
            String rij;

            FileInputStream fis = new FileInputStream(bestandsNaam);
            DataInputStream myInput = new DataInputStream(fis);


            while ((rij = myInput.readLine()) != null) {
                String kolom[] = rij.split(",");

                CMI_SQL sql = new CMI_SQL("jdbc:mysql://mysql.cmi-hro.nl:3306/bla", "bla", "bla");


                String query1 = "INSERT INTO KLANT VALUES(" + kolom[0] + "," + kolom[1] + ")";
                String query2 = "INSERT INTO KLANT_GEGEVENS VALUES(" + kolom[0] + "," + kolom[2] + "," + kolom[3] + "," + kolom[4] + "," + kolom[5] + ");";
                String query3 = "INSERT INTO REIS_GEGEVENS VALUES(" + kolom[0] + "," + kolom[6] + "," + kolom[7] + ");";
                sql.updateQuery(query1);
                sql.updateQuery(query2);
                sql.updateQuery(query3);


            }


        }


    %>
</html>