Ads

Unable to upload a file to mysql database using struts1

Hi,

Below are my classes

1.upload.jsp

<%@ taglib uri="/tags/struts-html" prefix="html" %>

<html:html>
<body>
<html:form action="upload" enctype="multipart/form-data">
Select a File :<html:file property="file"/>
<html:submit/>
</html:form>
</body>
</html:html>

2.UploadForm.java

import javax.servlet.http.HttpServletRequest;

import org.apache.struts.action.*;
import org.apache.struts.upload.FormFile;

public class UploadForm extends ActionForm{
private FormFile file;

public FormFile getFile(){
return this.file;
}

public void setFile(FormFile file){
this.file=file;
}
}

3.UploadAction.java

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.FileInputStream;
import java.sql.*;
import org.apache.struts.action.*;
import org.apache.struts.upload.FormFile;

public class UploadAction extends Action{
public ActionForward execute(ActionMapping mapping,ActionForm form,HttpServletRequest       request,HttpServletResponse response) throws Exception{
UploadForm uploadForm=(UploadForm)form;
System.out.print("Executed");
FormFile formFile=uploadForm.getFile();
System.out.print("Executed1");
String fileName=formFile.getFileName();
System.out.print(fileName);
File file=new File(fileName);
System.out.print(">>>>");
FileInputStream fin=new FileInputStream(file);
System.out.print("*****");
Integer fileSize=formFile.getFileSize();
int insert=0;
try{
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Driver Loaded.");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/test","root","");
System.out.println("Connection Opened.");
PreparedStatement pst=con.prepareStatement("insert into upload values(?)");
pst.setBinaryStream(1,fin,fileSize);
insert=pst.executeUpdate();
System.out.print("File Uploaded.");
}
catch(Exception e){System.out.println(e);}
if(insert!=0){
return mapping.findForward("success");
}
else{
return mapping.findForward("error");
}
}
}

I am getting error in this line * FileInputStream fin=new FileInputStream(file);* in the above action class i.e UploadAction.java

And below is the error I am getting in tomcat ...

exception

java.io.FileNotFoundException: ZensarCVFormat.doc (The system cannot find the file specified) java.io.FileInputStream.open(Native Method) java.io.FileInputStream.(Unknown Source) UploadAction.execute(UploadAction.java:19) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) javax.servlet.http.HttpServlet.service(HttpServlet.java:710) javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

Please Help me how to resolve this issue... Kindly reply back ASAP...

Thanks in advance...

View Answers

Ads