会员
周边
众包
新闻
博问
闪存
赞助商
所有博客
当前博客
我的博客
我的园子
账号设置
简洁模式
...
退出登录
注册
登录
网站开发与移动开发
博客园
首页
新随笔
管理
公告
代码备份
@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; } }
posted on
2012-04-07 00:48
txf2004
阅读(
170
) 评论(
0
)
编辑
收藏
举报
会员力量,点亮园子希望
刷新页面
返回顶部
Powered by:
博客园
Copyright © 2024 txf2004
Powered by .NET 8.0 on Kubernetes