java中实现将页面数据导入Excel中

package com.tang.dao; import java.sql.*; import java.util.*; import com.tang.entity.User; import java.io.*; import jxl.*; import jxl.write.*; import jxl.write.Number; public class UserDao extends BaseDao{ Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; //得到所有数据 @SuppressWarnings("unchecked") public List getAllUser() { String sql=" select * from users "; List list = new ArrayList (); conn = this.getConn(); try { ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while(rs.next()) { User u = new User(); u.setId(rs.getInt(1)); u.setUserName(rs.getString(2)); u.setPassword(rs.getString(3)); u.setSex(rs.getString(4)); u.setAge(rs.getInt(5)); u.setAddress(rs.getString(6)); list.add(u); } } catch(Exception ex) { ex.printStackTrace(); }finally { this.closeAll(); } return list; } //登录方法 public User checkLogin(String name,String pwd) { User u = null; String sql=" select * from users where username='"+name+"' and password='"+pwd+"'"; conn = this.getConn(); try { ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while(rs.next()) { u = new User(); u.setId(rs.getInt(1)); u.setUserName(rs.getString(2)); u.setPassword(rs.getString(3)); u.setSex(rs.getString(4)); u.setAge(rs.getInt(5)); u.setAddress(rs.getString(6)); } } catch(Exception ex) { ex.printStackTrace(); }finally { this.closeAll(); } return u; } //导出数据方法 @SuppressWarnings("unchecked") public void exec () { try { //方法一 : 直接生成本地文件 // jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File("f:/1.execl")); //方法二 : 将Excel对象直接写入到输出流 // OutputStream os = new FileOutputStream("f://1.xls"); //利用已经创建的Excel工作薄创建新的可写入的Excel工作薄 jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File("f://1.xls")); //获取第一张Sheet表 WritableSheet sheet = wwb.createSheet("用户信息记录", 0); List list = this.getAllUser(); //表头 Label label0 = new Label(0, 0, "编号"); sheet.addCell(label0); Label label1 = new Label(1, 0, "用户名"); sheet.addCell(label1); Label label2 = new Label(2, 0, "密码"); sheet.addCell(label2); Label label3 = new Label(3, 0, "性别"); sheet.addCell(label3); Label label4 = new Label(4, 0, "年龄"); sheet.addCell(label4); Label label5 = new Label(5, 0, "地址"); sheet.addCell(label5); //循环表中的数据 for(int i=0;i<list.size();i++) { User u = (User) list.get(i); //取得ID,int型的 Number labid = new Number(0,i+1,u.getId()); sheet.addCell(labid); //取得姓名 Label lblname = new Label(1, i+1,u.getUserName()); sheet.addCell(lblname); //取得密码 Label lblpwd = new Label(2, i+1, u.getPassword()); sheet.addCell(lblpwd); //取得性别 Label lblsex = new Label(3, i+1,u.getSex()); sheet.addCell(lblsex); //取得年龄,int型的 Number lblage = new Number(4, i+1,u.getAge()); sheet.addCell(lblage); //取得地址 Label lbladd = new Label(5, i+1,u.getAddress()); sheet.addCell(lbladd); } //写入工作表 wwb.write(); //关闭Execl工作表 wwb.close(); } catch(Exception ex) { ex.printStackTrace(); } } //测试数据 public static void main(String[] args) { UserDao ud = new UserDao(); User u = ud.checkLogin("jim","111"); System.out.println(u.getAddress()); } }