简单的实现excel导出

xiaoxiao2021-03-26 29

public String export()throws Exception{ HttpServletResponse response = ServletActionContext.getResponse(); //创建数据库连接 String dbUrl="jdbc:mysql://localhost:3306/excel"; String dbUserName="root"; String dbPassword="123"; String jdbcName="com.mysql.jdbc.Driver"; Class.forName(jdbcName); Connection con=DriverManager.getConnection(dbUrl,dbUserName,dbPassword); con=dbUtil.getCon(); //创建工作薄 Workbook wb=new HSSFWorkbook(); String headers[]={"编号","姓名","电话","Email","QQ"}; //数据库返回查询的数据 ResultSet rs=userDao.userList(con, null); //向工作薄中写入数据 int rowIndex=0; Sheet sheet=wb.createSheet(); Row row=sheet.createRow(rowIndex++); for(int i=0;i<headers.length;i++){ row.createCell(i).setCellValue(headers[i]); } while(rs.next()){ row=sheet.createRow(rowIndex++); for(int i=0;i<headers.length;i++){ row.createCell(i).setCellValue(rs.getObject(i+1).toString()); } } //下载数据 response.setHeader("Content-Disposition", "attachment;filename="+URLEncoder.encode("导出数据.xls", "UTF-8")); response.setContentType("application/ynd.ms-excel;charset=UTF-8"); OutputStream out=response.getOutputStream(); wb.write(out); out.flush(); out.close(); con.close(); return null; }

转载请注明原文地址: https://ju.6miu.com/read-664384.html

技术

最新回复(0)