this is my action class but i am getting error at FileInputStream myInput = new FileInputStream(filename); in following code as FILENOTFOUNDEXception..help me
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception
{
String target="";
FileForm myForm=(FileForm)form;
FormFile myFile = myForm.getTheFile();
StoreExcel storeExcel=new StoreExcel();
File file = new File(myFile.getFileName());
// String fileNamee="C:\\Book1.xls";
System.out.println("file name ----"+fileNamee);
String fileName=myFile.getFileName();
/
Vector dataHolder=read(fileName);
saveToDatabase(dataHolder);
return mapping.findForward("success");
}
public Vector read(String fileName)
{
Vector cellVectorHolder = new Vector();
try{
FileInputStream myInput = new FileInputStream(filename);// giving error at this line...filenotfound exception can anybody help me
POIFSFileSystem myFileSystem = new POIFSFileSystem(myInput);
HSSFWorkbook myWorkBook = new HSSFWorkbook(myFileSystem);
HSSFSheet mySheet = myWorkBook.getSheetAt(0);
Iterator rowIter = mySheet.rowIterator();
while(rowIter.hasNext()){
HSSFRow myRow = (HSSFRow) rowIter.next();
Iterator cellIter = myRow.cellIterator();
Vector cellStoreVector=new Vector();
while(cellIter.hasNext()){
HSSFCell myCell = (HSSFCell) cellIter.next();
cellStoreVector.addElement(myCell);
}
cellVectorHolder.addElement(cellStoreVector);
}
}catch (Exception e){e.printStackTrace(); }
return cellVectorHolder;
}
private void saveToDatabase(Vector dataHolder) {
String username="";
String password="";
for (int i=0;i<dataHolder.size(); i++){
Vector cellStoreVector=(Vector)dataHolder.elementAt(i);
for (int j=0; j < cellStoreVector.size();j++){
HSSFCell myCell = (HSSFCell)cellStoreVector.elementAt(j);
String st = myCell.toString();
username=st.substring(0,1);
password=st.substring(0);
}
try{
BaseDao dao=new BaseDao();
Connection conn=(Connection) dao.getConnection();
Statement stat=(Statement) conn.createStatement();
int k=stat.executeUpdate("insert into USER_TABLE(username,password) value('"+username+"','"+password+"')");
System.out.println("Data is inserted");
stat.close();
conn.close();
}
catch(Exception e){}
}
}
}