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