设备资源管理系统-jxl报表
设备资源管理系统-jxl报表
- 引入导入的模板
- 部分代码
1、引入使用jxl报表技术的jar包
2、导入java文件GenerateSqlFromExcel.java
3、导入jsp文件userImport.jsp文件，用于导入excel的文件页面
4、在userIndex.jsp中添加：
<td class="ta_01" align="right">
<input style="font-size:12px; color:black; height=20;width=80" id="BT_Import" type="button" value="EXCEL导入" name="BT_Import"
onclick="openWindow('system/elecUserAction_importpage.do','700','400')">
</td>
5、在userList.jsp中添加：
<td class="ta_01" align="right">
<input style="font-size:12px; color:black; height=20;width=80" id="BT_Import" type="button" value="EXCEL导入" name="BT_Import"
onclick="openWindow('system/elecUserAction_importpage.do','700','400')">
</td>
6、在struts.xml的配置文件中，添加：
<!-- 2011-12-12，从excel文件中读取数据，存入数据库中 -->
<result name="importpage">
/WEB-INF/page/system/userImport.jsp
</result>
<result name="importdata">
/WEB-INF/page/system/userImport.jsp
</result>
7、在ElecUserForm中添加file属性：
private File file;
public File getFile() {
return file;
}
public void setFile(File file) {
this.file = file;
}
8、在ElecUserAction中添加2个方法
public String importpage(){
return "importpage";
}
public String importdata(){
elecUserService.importExcelData(elecUserForm);
return "importdata";
}
9、在ElecUserServiceImpl中添加方法：
@Transactional(isolation=Isolation.DEFAULT,propagation=Propagation.REQUIRED,readOnly=false)
public void importExcelData(ElecUserForm elecUserForm) {
try {
File file = elecUserForm.getFile();
GenerateSqlFromExcel fromExcel = new GenerateSqlFromExcel();
ArrayList<String[]> list = fromExcel.generateStationBugSql(file);
MD5keyBean bean = new MD5keyBean();
for(int i=0;list!=null && i<list.size();i++){
String [] data = list.get(i);
ElecUser elecUser = new ElecUser();
elecUser.setLogonName(data[0].toString());
elecUser.setLogonPwd(bean.getkeyBeanofStr(data[1].toString()));
elecUser.setUserName(data[2].toString());
elecUser.setSexID(data[3].toString());
elecUser.setJctID(data[4].toString());
elecUser.setAddress(data[5].toString());
elecUser.setIsDuty(data[6].toString());
elecUser.setBirthday(StringHelper.stringConvertDate(data[7].toString()));
elecUserDao.save(elecUser);
}
} catch (Exception e) {
throw new RuntimeException("从excel文件中读取数据，导入到数据库有误！");
}
}
