I am uploading a file.but i get an error.please correct the code. i get an error where check2 is not being printed.plz correct
package sercls; import java.lang.Class; import java.lang.String; import java.lang.Exception;
import java.io.PrintWriter; import java.io.IOException; import java.io.BufferedReader; import java.io.InputStreamReader;
import java.sql.Types; import java.sql.ResultSet; import java.sql.Statement; import java.sql.Connection; import java.sql.DriverManager;
import java.util.List; import java.util.Iterator;
import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpSession; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;
import org.apache.commons.fileupload.FileItem; import org.apache.commons.fileupload.DiskFileUpload; import org.apache.commons.fileupload.FileUploadException;
public class saveserv extends HttpServlet {
@Override protected void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { Connection connection = null; Statement statement = null;
String driver = null;
String url = null;
String userid = null;
String pass = null;
String query = null;
String error_message = null;
boolean error_occured = false;
boolean tableCreated = false;
DiskFileUpload upload = null;
BufferedReader queries = null;
List items = null;
HttpSession session = req.getSession(false);
driver = session.getAttribute("driver").toString();
url = session.getAttribute("url").toString();
userid = session.getAttribute("userid").toString();
pass = session.getAttribute("pass").toString();
PrintWriter out=res.getWriter();
out.println("sdfsfd");
out.println(driver+url);
try {
out.println("check");
upload = new DiskFileUpload();
out.println("check1"+upload+"***************"+items);
items = upload.parseRequest(req);
out.println("check2");
Iterator iter = items.iterator();
out.println("items--------"+items);
while (iter.hasNext()) {
FileItem item = (FileItem) iter.next();
if(!item.isFormField()) {
queries = new BufferedReader(new InputStreamReader(item.getInputStream()));
out.println("queries----------"+queries);
}
}
}
catch(Exception e) {
error_occured = true;
error_message = e.toString();
}
/*if(!error_occured) {
try {
Class.forName(driver);
connection = DriverManager.getConnection(url,userid,pass);
statement = connection.createStatement();
}
catch(Exception e) {
error_occured = true;
error_message = e.toString();
}
}
if(error_occured)
res.sendRedirect("error occured");
else {
try {
while(true) {
query = queries.readLine();
if(query == null) break;
else {
statement.execute(query);
if(query.toUpperCase().startsWith("CREATE")) tableCreated = true;
}
}
}
catch(Exception e) {
error_occured = true;
error_message = e.toString();
}
}
*/ out.println("checkfinal"); }
}
1)page.jsp:
<%@ page language="java" %> <HTML> <FORM ENCTYPE="multipart/form-data" ACTION="../UploadServlet" METHOD=POST> <center> <table border="0" bgcolor=#ccFDDEE> <tr> <center><td colspan="2" align="center"><B>UPLOAD THE FILE</B><center></td> </tr> <tr><td colspan="2" align="center"> </td></tr> <tr><td><b>Choose the file To Upload:</b></td> <td><INPUT NAME="file" TYPE="file"></td> </tr> <tr><td colspan="2" align="center"> </td></tr> <tr><td colspan="2" align="center"><input type="submit" value="Send File"> </td></tr> <table> </center> </FORM> </HTML>
2)UploadServlet.java:
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class UploadServlet extends HttpServlet{
public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
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();
out.println("You have successfully upload the file:"+saveFile);
Connection connection = null;
String connectionURL = "jdbc:mysql://localhost:3306/test";
ResultSet rs = null;
PreparedStatement psmnt = null;
FileInputStream fis;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "root", "root");
File f = new File(saveFile);
psmnt = connection.prepareStatement("insert into file(file_data) values(?)");
fis = new FileInputStream(f);
psmnt.setBinaryStream(1, (InputStream)fis, (int)(f.length()));
int s = psmnt.executeUpdate();
if(s>0){
System.out.println("Uploaded successfully !");
}
else{
System.out.println("Error!");
}
}
catch(Exception e){
e.printStackTrace();
}
}
}
}