@SuppressWarnings("deprecation")
@Override
public boolean excelUserInfoToExcel(HttpServletRequest request,
HttpServletResponse response) {
// 文件名称
String fileName = "用户信息";
String tempPath = request.getRealPath("/");
String className = "com.***.ExcelUser";
// 表格名称
String tableName = "用户信息";
/**
* // 字段名称 String[] columns = new String[16]; columns[0] = "姓名";
* columns[1] = "所属软件用户组"; columns[2] = "所属岗位"; columns[3] = "登陆账号";
* columns[4] = "员工ID"; columns[5] = "手机号码1"; columns[6] = "手机号码2";
* columns[7] = "办公电话"; columns[8] = "家庭电话"; columns[9] = "办公地址";
* columns[10] = "家庭地址"; columns[11] = "紧急联系人"; columns[12] = "联系人电话";
* columns[13] = "工作Email"; columns[14] = "私人Email"; columns[15] = "备注";
*
* // 字段类型 String[] types = new String[16]; types[0] = types[1] =
* types[2] = types[3] = types[4] = types[5] = types[6] = types[7] =
* types[8] = types[9] = types[10] = types[11] = types[12] = types[13] =
* types[14] = types[15] = "String"; // 数据 ArrayList<String[]> rows =
* new ArrayList<String[]>(); List<User> users =
* this.userDao.exportUsers(); for (User user:users) { String roleInfos
* = getGroupInfoByUser(user); String stationInfos =
* getStationInfoByUser(user); // 封装数据 String[] row = new String[16];
* row[0] = String.valueOf(user.getFullName()); row[1] =
* String.valueOf(roleInfos); row[2] = String.valueOf(stationInfos);
* row[3] = String.valueOf(user.getUsername()); row[4] =
* String.valueOf(user.getEmployeeId()); row[5] =
* String.valueOf(user.getMobilePhone1()); row[6] =
* String.valueOf(user.getMobilePhone2()); row[7] =
* String.valueOf(user.getOfficePhone()); row[8] =
* String.valueOf(user.getHomePhone()); if(user.getAddress()!=null){
* row[9] = String.valueOf(user.getAddress().getOfficeAddress());
* row[10] = String.valueOf(user.getAddress().getHomeAddress()); }else{
* row[9] = String.valueOf(""); row[10] = String.valueOf(""); } row[11]
* = String.valueOf(user.getEmergencyUsername()); row[12] =
* String.valueOf(user.getEmergencyPhone()); row[13] =
* String.valueOf(user.getOfficeEmail()); row[14] =
* String.valueOf(user.getPrivateEmail()); row[15] =
* String.valueOf(user.getDescription()); // 放入相关rows rows.add(row); }
*/
// 数据
ArrayList<ExcelUser> rows = new ArrayList<ExcelUser>();
List<User> users = this.userDao.exportUsers();
for (User user : users) {
ExcelUser excelUser = new ExcelUser();
String roleInfos = getGroupInfoByUser(user);
String stationInfos = getStationInfoByUser(user);
excelUser.setFirstName(String.valueOf(user.getFullName()));
excelUser.setRoleInfos(String.valueOf(roleInfos));
excelUser.setStationInfos(String.valueOf(stationInfos));
excelUser.setUsername(String.valueOf(user.getUsername()));
excelUser.setEmployeeId(String.valueOf(user.getEmployeeId()));
excelUser.setMobilePhone1(String.valueOf(user.getMobilePhone1()));
excelUser.setMobilePhone2(String.valueOf(user.getMobilePhone2()));
excelUser.setOfficePhone(String.valueOf(user.getOfficePhone()));
excelUser.setHomePhone(String.valueOf(user.getHomePhone()));
if (user.getAddress() != null) {
excelUser.setOfficeAddress(String.valueOf(user.getAddress()
.getOfficeAddress()));
excelUser.setHomeAddress(String.valueOf(user.getAddress()
.getHomeAddress()));
} else {
excelUser.setOfficeAddress(String.valueOf(""));
excelUser.setHomeAddress(String.valueOf(""));
}
excelUser.setEmergencyUsername(String.valueOf(user
.getEmergencyUsername()));
excelUser
.setEmergencyPhone(String.valueOf(user.getEmergencyPhone()));
excelUser.setOfficeEmail(String.valueOf(user.getOfficeEmail()));
excelUser.setPrivateEmail(String.valueOf(user.getPrivateEmail()));
excelUser.setDescription(String.valueOf(user.getDescription()));
// 放入相关rows
rows.add(excelUser);
}
// 导出到excel
try {
// CommonExcel.getCommonExcel().exportExcel(fileName, tableName,
// columns,types, rows, response, tempPath);
boolean result = ExcelExport.createExcel(rows, className, tempPath,fileName, tableName);
if (result) {
return true;
} else {
return false;
}
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
代码备份
最新推荐文章于 2024-07-23 10:00:35 发布