excel 写入 oracle,oracle 写入excel

//下面这段代码是将内容写入一个excel文档//----------------------------------------------------------------------package Print;import java.util.StringTokenizer;import jxl.*;import jxl.write.*;import jxl.format.*;import java.io.*;import java.sql.*;import conn.*;import TypeChare.*;public class writeexcel{  WritableSheet sheet;  File tempFile;  WritableWorkbook workbook; WritableFont headerFont;  WritableFont titleFont; WritableFont detFont; WritableCellFormat titleFormat;  WritableCellFormat headerFormat; WritableCellFormat detFormat; WritableCellFormat priceFormat;  WritableCellFormat dateFormat;  Label l=null; jxl.write.Number n=null; jxl.write.DateTime d=null;   int column=0;//================== 打开EXCEL文件 ============================= public writeexcel(String OutFile){   try{ tempFile=new File(OutFile); workbook = Workbook.createWorkbook(tempFile); sheet = workbook.createSheet("用户", 0);    headerFont = new WritableFont(WritableFont.ARIAL, 12, WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK); headerFormat = new WritableCellFormat (headerFont); titleFont = new WritableFont(WritableFont.ARIAL, 10, WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK); titleFormat = new WritableCellFormat (titleFont); detFont = new WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK); detFormat = new WritableCellFormat (detFont); NumberFormat nf=new NumberFormat("0.00"); //用于Number的格式 priceFormat = new WritableCellFormat (detFont, nf); DateFormat df=new DateFormat("yyyy-MM-dd");//用于日期的 dateFormat = new WritableCellFormat (detFont, df);    //合并第一列第一行到第六列第一行的所有单元格   sheet.mergeCells(0,0,5,0);    //单元格边框设置   headerFormat.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.MEDIUM);   titleFormat.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN);   detFormat.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN);   priceFormat.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN);   dateFormat.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN);   //单元格文字位置设置   headerFormat.setAlignment(jxl.format.Alignment.CENTRE);  }  catch(Exception e) { System.out.println("error0:"+e.getMessage()); } }//======================= 显示表头 ================================public boolean setColumTitle(String Columtitle)  { //表头  try{ l=new Label(0, 0, Columtitle, headerFormat); sheet.addCell(l); }  catch(Exception e) { System.out.println("error1:"+e.getMessage()); }    return true;  }//======================= 显示表内容 =============================public boolean DisplayDetail(String sql)  {   try{   int h=0;   conn conn= new conn(); ResultSet Rs=conn.executeQuery(sql);   column=0; for (int i=1; i<=Rs.getMetaData().getColumnCount(); i++){ l=new Label(column++, 2, Rs.getMetaData().getColumnName(i), titleFormat); //sheet.setColumnView(column,Rs.getString(i).length());   //System.out.println(Rs.getMetaData().getColumnDisplaySize(i)); sheet.addCell(l);} while (Rs.next()){     column=0; for (int j=1; j<=Rs.getMetaData().getColumnCount(); j++){       if (Rs.getMetaData().getColumnTypeName(j).compareTo("VARCHAR2")==0) l=new Label(column++, h+3, Rs.getString(j),detFormat);       if (Rs.getMetaData().getColumnTypeName(j).compareTo("NUMBER")==0) l=new Label(column++, h+3, Rs.getString(j),priceFormat);       if (Rs.getMetaData().getColumnTypeName(j).compareTo("DATE")==0) l=new Label(column++, h+3, Rs.getString(j),dateFormat);       sheet.addCell(l);     }      h++;   } Rs=null; conn.close();   //设置列的宽度 //column=0; //sheet.setColumnView(column++, 10); //sheet.setColumnView(column++, 10); //sheet.setColumnView(column++, 10); //sheet.setColumnView(column++, 10); workbook.write(); workbook.close();   }   catch(Exception e) { System.out.println("error1:"+e.getMessage()); }    return true;  } public static void main(String args[]) { // new writeexcel("d:/Print.xls"); } }