简单的实现excel导出

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;
    }