数据库的转excel测试

来源：作者：佚名出处：巧巧读书 2008-05-06 进入讨论组

关键词：
oracle
excel
java
数据库

    package dbToxml;
    /**
     * @author Alex
     * @msg 把数据库转化为excel
     */
    import java.io.File;

    import java.io.IOException;
    import java.sql.ResultSet;
    import java.sql.SQLException;

    import jxl.Cell;
    import jxl.Workbook;
    import jxl.write.Label;
    import jxl.write.WritableSheet;
    import jxl.write.WritableWorkbook;
    import jxl.write.WriteException;
    import jxl.write.biff.RowsExceededException;

    public class Oracle_to_Excel {
    ResultSet rs=null;
    public void serch(){
         //ConnOracle oracle=new ConnOracle();
         String sql="select * from purchase_info";
         //ResultSet rs=oracle.query(sql);
         WritableWorkbook book=null;
         WritableSheet sheet=null;
         try
         {
         //Excel获得文件
         Workbook wb=Workbook.getWorkbook(new File("e:\\测试.xls")); //打开一个文件的副本，并且指定数据写回到原文件
         book= Workbook.createWorkbook(new File("e:\\测试.xls"),wb); //添加一个工作表
         sheet=book.createSheet("第五页",4);
         //sheet.addCell(new Label(0,0,"第二页的测试数据"));
         //jxl.write.Number c=new jxl.write.Number(1,0,10);
         //sheet.addCell(c);
         //book.write();
         //book.close();
         }catch(Exception e)
         {
         System.out.println(e);
         }
         int j=0;
         try {
       while(rs.next()){
        int i=0;
        sheet.addCell(new jxl.write.Number(i,j,rs.getInt(1)));
        sheet.addCell(new Label(++i,j,rs.getString("pur_name")));
        sheet.addCell(new Label(++i,j,rs.getString("pur_address")));
        sheet.addCell(new Label(++i,j,rs.getString("pur_mail")));
        //String date=rs.getDate("pur_date").toString();
        //sheet.addCell(new Label(i,++j,date));
        j++;
       }
      } catch (RowsExceededException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
      } catch (WriteException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
      } catch (SQLException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
      }
         try {
       book.write();
       book.close();
      } catch (WriteException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
      } catch (IOException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
      }