数据库的转excel测试

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();
  }
     
    }
 
 public static void main(String[] args) {
  Oracle_to_Excel oratoex=new Oracle_to_Excel();
  oratoex.serch();
 }

}