package bookmanage;
import java.io.*;
import java.sql.*;
import jxl.*;
import jxl.write.*;

public class Excel {
  DBManager db=null;
  //構(gòu)造函數(shù)
  public Excel(){
    db=new DBManager();
  }
  /*========================================================
   === 函數(shù)功能:生成excel文件
   === 參    數(shù)
   ===     title：字段名稱
   ===     sql： sql字符串
   ===     path：文件生成路徑
  === 返 回 值:
   === 開 發(fā) 者:曾文秋
   === 開發(fā)時間：2006-12-16
   === 修改紀(jì)錄:
   ==========================================================*/

  public void createEXCEL(String[]title,String sql,String path){
    int i=0;
    int j=0;
    ResultSet rs=null;
    try {
     rs=db.getResult(sql);
     //構(gòu)建Workbook對象, 只讀Workbook對象
     //：創(chuàng)建可寫入的Excel工作薄
     WritableWorkbook wwb = Workbook.createWorkbook(new FileOutputStream(path));
     WritableSheet ws = wwb.createSheet("sheet1", 0);

     for( i=0;i<title.length;i++){
       WritableFont wf = new WritableFont(WritableFont.TIMES, 12, WritableFont.BOLD, false);
       WritableCellFormat wcfF = new WritableCellFormat(wf);
       Label labelCF = new Label(i, 0, title[i],wcfF);
       ws.addCell(labelCF);
     }
     i=1;
     while (rs.next()) {
      for(j=1;j<=title.length;j++)
      {
        Label labelC = new Label(j-1,i, rs.getString(j));
        ws.addCell(labelC);
      }
      i++;
    }
    //寫入Exel工作表
    wwb.write();
    wwb.close();
    rs.close();
    db.close();
  }
  catch (Exception e) {
    System.out.println(e.toString());
  }
}

}