分类:
2008-10-17 13:50:28
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 _to_Excel {
ResultSet rs=null;
public void serch(){
//Conn 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();
}
}