jsp:
action:上传文件的文件如果为uploadFile,那么文件名一定要为uploadFileFileName,也就是在文件后加入FileName,不然不能识别
[color=red]1:导入导出jar包的区别‘
2: private File uploadFile=null;
private String uploadFileFileName=null;
为什么不加“=null”值就传不进来
3:String directory="/upload/role";
String targetDirectory=
ServletActionContext.getServletContext().getRealPath(directory);
--》targetDirectory = D:\lxq\zhuanyi\jar+js\apache-tomcat-5.5.23\webapps\TinyBee\upload\role
[/color]
<s:form action="import.action" method="post" enctype="multipart/form-data" theme="simple">
<table border="1">
<tr>
<td>文件上传</td>
</tr>
<tr>
<td>
<s:file name="uploadFile" label="文件位置" size="80"/>
</td>
</tr>
<tr><td>
<s:submit value="submit"></s:submit>
<s:reset value="reset"></s:reset>
</td></tr>
</table>
</s:form>
action:上传文件的文件如果为uploadFile,那么文件名一定要为uploadFileFileName,也就是在文件后加入FileName,不然不能识别
package excl;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import org.apache.commons.io.FileUtils;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.struts2.ServletActionContext;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;
import test.BaseAction;
import test.User;
public class Import extends BaseAction{
private static final String SUCCESS = "success";
private File uploadFile=null;
private String uploadFileFileName=null;
public String loadRoleFile() {
String directory="/upload/role";
String targetDirectory=
ServletActionContext.getServletContext().getRealPath(directory);
String file=targetDirectory+"\\"+uploadFileFileName;
//生成上传的文件对象
File target = new File(file);
//如果文件已经存在,则删除源文件
if(target.exists()){
target.delete();
}
System.out.println(uploadFile);
System.out.println(uploadFileFileName);
//复制file对象,实现上传
try {
FileUtils.copyFile(uploadFile,target);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
List roleList = new ArrayList();
try {
FileInputStream fi = new FileInputStream(target);
Workbook wb = new HSSFWorkbook(fi);
Sheet sheet = wb.getSheetAt(0);
int rowNum = sheet.getLastRowNum()+1;
for(int i=1;i<rowNum;i++){
User user = new User();
Row row = sheet.getRow(i);
int cellNum = row.getLastCellNum();
for(int j=0;j<cellNum;j++){
Cell cell = row.getCell(j);
String cellValue=null;
switch(cell.getCellType()){
//判断 excel单元格内容的格式,并对其进行转换,以便插入数据库
case 0:cellValue=String .valueOf((int)cell.getNumericCellValue());break;
case 1 : cellValue = cell.getStringCellValue(); break;
case 2 : cellValue = String.valueOf(cell.getDateCellValue()); break;
case 3 : cellValue = ""; break;
case 4 : cellValue = String.valueOf(cell.getBooleanCellValue()); break;
case 5 : cellValue = String.valueOf(cell.getErrorCellValue()); break;
}
switch(j){//通过列数来判断对应插如的字段
case 0 : user.setId(Integer.parseInt(cellValue));break;
case 1 : user.setPassword(cellValue);break;
case 2 : user.setUsername(cellValue);break;
}
}
roleList.add(user);
}
} catch (IOException e) {
e.printStackTrace();
}
Session session = this.getHibernateTemplate().getSessionFactory().openSession();
Transaction tx = null;
try {
tx=null;
tx=session.beginTransaction();
if(roleList.size()>0){
int roleNum=roleList.size();
for(int i=0;i<roleNum;i++){
session.save(roleList.get(i));
}
tx.commit();
}
} catch (HibernateException e) {
tx.rollback();
e.printStackTrace();
}finally{
session.close();
}
return SUCCESS;
}
public String getUploadFileFileName() {
return uploadFileFileName;
}
public void setUploadFileFileName(String uploadFileFileName) {
this.uploadFileFileName = uploadFileFileName;
}
public File getUploadFile() {
return uploadFile;
}
public void setUploadFile(File uploadFile) {
this.uploadFile = uploadFile;
}
}
[color=red]1:导入导出jar包的区别‘
2: private File uploadFile=null;
private String uploadFileFileName=null;
为什么不加“=null”值就传不进来
3:String directory="/upload/role";
String targetDirectory=
ServletActionContext.getServletContext().getRealPath(directory);
--》targetDirectory = D:\lxq\zhuanyi\jar+js\apache-tomcat-5.5.23\webapps\TinyBee\upload\role
[/color]