- <%@ page contentType="text/html; charset=GBK" errorPage="/error.jsp" %>
- <jsp:useBean id="idmServer" scope="application" class="com.***.idm.IdentityServer" />
- <%--//checks.jsp包括登录校验、idmServer/loginUrl/checkUserName变量声明、服务器是否启动、登录用户是否有超级管理员权限--%>
- <%@ page import="java.util.List" %>
- <%@ page import="com.***.idm.model.service.UIService" %>
- <%@ page import="com.***.idm.data.bo.User" %>
- <%@ page import="org.apache.poi.hssf.usermodel.*" %>
- <%@ page import="com.***.idm.data.service.SearchFilter" %>
- <%@ page import="java.io.*" %>
- <%@ page import="java.util.Date" %>
- <%
- String _total = request.getParameter("total"); //取得记录总数
- int int_total = Integer.parseInt(_total);
- try {
- HSSFWorkbook hssfworkbook = new HSSFWorkbook();
- HSSFSheet hssfsheet = hssfworkbook.createSheet(); //创建sheet页
- hssfworkbook.setSheetName(0,"用户列表",HSSFWorkbook.ENCODING_UTF_16); //sheet名称乱码处理
- HSSFRow hssfrow = hssfsheet.createRow(0); //创建表头
- HSSFCell hssfcell_title_0 = hssfrow.createCell((short)0); //创建第一个单元格
- hssfcell_title_0.setEncoding(HSSFWorkbook.ENCODING_UTF_16); //处理乱码
- hssfcell_title_0.setCellValue("用户名"); //对第一个单元格赋值
- HSSFCell hssfcell_title_1 = hssfrow.createCell((short)1); //创建第二个单元格子
- hssfcell_title_1.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_title_1.setCellValue("昵称");
- HSSFCell hssfcell_title_2 = hssfrow.createCell((short)2);
- hssfcell_title_2.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_title_2.setCellValue("真名");
- HSSFCell hssfcell_title_3 = hssfrow.createCell((short)3);
- hssfcell_title_3.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_title_3.setCellValue("电子邮件");
- HSSFCell hssfcell_title_4 = hssfrow.createCell((short)4);
- hssfcell_title_4.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_title_4.setCellValue("身份证号");
- HSSFCell hssfcell_title_5 = hssfrow.createCell((short)5);
- hssfcell_title_5.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_title_5.setCellValue("所属组织");
- HSSFCell hssfcell_title_6 = hssfrow.createCell((short)6);
- hssfcell_title_6.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_title_6.setCellValue("是否开通");
- HSSFCell hssfcell_title_7 = hssfrow.createCell((short)7);
- hssfcell_title_7.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_title_7.setCellValue("电话");
- HSSFCell hssfcell_title_8 = hssfrow.createCell((short)8);
- hssfcell_title_8.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_title_8.setCellValue("手机");
- HSSFCell hssfcell_title_9 = hssfrow.createCell((short)9);
- hssfcell_title_9.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_title_9.setCellValue("说明");
- boolean cdn = false;
- SearchFilter sf = new SearchFilter();
- if (true){
- sf.addCondition("''", "''", "''"); //查询条件(全部查出)
- cdn = true;
- }
- List users = null;
- if (cdn == true){
- try{
- users = idmServer.getModelService().getUserManager().findByFilter(sf); //取得全部记录
- }catch(Exception e){
- e.printStackTrace();
- }
- }
- System.out.println("已导出数据 " + users.size() + " 条!");
- //if (users != null && users.size()>0){
- // out.print("true");
- //} else {
- // out.print("false");
- //}
- for(int i=1; i<=int_total; i++) {
- User user = (User) users.get(i-1);
- //创建sheet新行
- HSSFRow hssfrow_Name = hssfsheet.createRow(i);
- //依次创建单元格,写入数据
- HSSFCell hssfcell_0 = hssfrow_Name.createCell((short)0);
- hssfcell_0.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_0.setCellValue(user.getUserName());
- HSSFCell hssfcell_1 = hssfrow_Name.createCell((short)1);
- hssfcell_1.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_1.setCellValue(user.getNickName());
- HSSFCell hssfcell_2 = hssfrow_Name.createCell((short)2);
- hssfcell_2.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_2.setCellValue(user.getTrueName());
- HSSFCell hssfcell_3 = hssfrow_Name.createCell((short)3);
- hssfcell_3.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_3.setCellValue(user.getEmail());
- HSSFCell hssfcell_4 = hssfrow_Name.createCell((short)4);
- hssfcell_4.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_4.setCellValue(user.getCreditID());
- HSSFCell hssfcell_5 = hssfrow_Name.createCell((short)5);
- hssfcell_5.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_5.setCellValue(user.getGroupName());
- HSSFCell hssfcell_6 = hssfrow_Name.createCell((short)6);
- hssfcell_6.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_6.setCellValue(user.isActived());
- HSSFCell hssfcell_7 = hssfrow_Name.createCell((short)7);
- hssfcell_7.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_7.setCellValue(user.getTel());
- HSSFCell hssfcell_8 = hssfrow_Name.createCell((short)8);
- hssfcell_8.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_8.setCellValue(user.getMobile());
- HSSFCell hssfcell_9 = hssfrow_Name.createCell((short)9);
- hssfcell_9.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- hssfcell_9.setCellValue(user.getDesc());
- }
- //HSSFCellStyle hssfcellstyle = hssfworkbook.createCellStyle();//日期单元格格式处理
- //hssfcellstyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy"));//m/d/yy h:mm
- FileOutputStream fileoutputstream = new FileOutputStream("D://用户数据//用户列表.xls");
- hssfworkbook.write(fileoutputstream);
- fileoutputstream.close();
- } catch (IOException e) {
- e.printStackTrace();
- } catch (Exception e) {
- e.printStackTrace();
- }
- %>
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
- <html>
- <head>
- <title>***身份服务器 ***IDS</title>
- <link href="../style/style.css" type="text/css" rel=stylesheet>
- <link href="../style/listStyle.css" type="text/css" rel=stylesheet>
- <style type=text/css>body {
- margin: 5px
- }
- </style>
- <meta http-equiv="pragma" content="no-cache">
- <meta http-equiv="cache-control" content="no-cache">
- <meta http-equiv="expires" content="0">
- <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
- <meta http-equiv="description" content="This is my page">
- <!--
- <link rel="stylesheet" type="text/css" href="styles.css">
- -->
- </head>
- <body>
- <br>
- 数据已全部导出! <br>
- 存放路径:D:/用户数据/用户列表.xls<br>
- <input type="button" value="返回" onClick="history.go(-1);">
- </body>
- </html>
IDS export.jsp
最新推荐文章于 2024-09-13 16:01:42 发布