excel.java

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

package com.gs.util;

/**
 * @(#)cexcel.java 1.0 04/04/02
 * Title:
 * Description:
 * Copyright:    Copyright (c) 2003
 * Company:
 * @author lxh
 */

import java.io.*;
import java.sql.*;
import com.gs.util.Common;
//import com.javaTNT.excel.*;
import jxl.*;
import jxl.write.*;

public class excel{

    /*========================================================
     === 函数功能:生成excel文件
     === 参    数
     ===     title：字段名称
     ===     sql： sql字符串
     ===     path：文件生成路径
     ==========================================================*/

    public void createEXCEL(String[] title,String sql,String path) throws AppException{

        int i = 0;
        int j = 0;

        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;

        try{
            //建立与数据库的连接
            conn = Common.getConnection();
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);

            //构建Workbook对象, 只读Workbook对象
            //：创建可写入的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();
            //关闭Excel工作薄对象
            wwb.close();
            rs.close();
            stmt.close();
            conn.close();
        } catch(Exception e){
            System.out.println(e.toString());
        }
    }
}