用poi生成EXCEL

package hz;

import java.io.FileOutputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class Make{

public static void main(String []args){
  String path="f:/info.xls";
  Make mk = new Make();
  mk.abc(path);
}

public  void abc(String path){
  HSSFWorkbook wb = new HSSFWorkbook(); // 建立新HSSFWorkbook对象

  HSSFSheet sheet = wb.createSheet();
  // wb.setSheetName(0, "", HSSFWorkbook.ENCODING_UTF_16);
  sheet.setDefaultColumnWidth((short) 15);
  //HashMap hm = new HashMap();
  //String cj02005 = (String)hm.get("CJ02005");
  //System.out.println(cj02005);
  // 样式2 宋体 写正文时用
  HSSFFont font2 = wb.createFont();
  font2.setColor(HSSFFont.COLOR_NORMAL);
  font2.setFontName("宋体");
  font2.setFontHeightInPoints((short) 12);
  HSSFCellStyle normal = wb.createCellStyle();
  normal.setFont(font2);
  normal.setAlignment(HSSFCellStyle.ALIGN_LEFT); // 水平居中
  normal.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP); // 垂直居中
  normal.setDataFormat(HSSFDataFormat.getBuiltinFormat("@"));
  HSSFRow row = null;
  HSSFCell cell = null;
  HSSFCell csCell = null;

  // 行
  int i = 0;

  row = sheet.createRow((short) i);
  cell = row.createCell((short) (0)); // 建立新cell
  cell.setCellStyle(normal);
  cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
  cell.setCellValue("姓名"); // 设置中西文结合字符串
 
  row = sheet.createRow((short) i);
  cell = row.createCell((short) (1)); // 建立新cell
  cell.setCellStyle(normal);
  cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
  cell.setCellValue("性别"); // 设置中西文结合字符串

  row = sheet.createRow((short) i);
  cell = row.createCell((short) (2)); // 建立新cell
  cell.setCellStyle(normal);
  cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
  cell.setCellValue("民族"); // 设置中西文结合字符串

  row = sheet.createRow((short) i);
  cell = row.createCell((short) (3)); // 建立新cell
  cell.setCellStyle(normal);
  cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
  cell.setCellValue("卡号"); // 设置中西文结合字符串

  row = sheet.createRow((short) i);
  cell = row.createCell((short) (4)); // 建立新cell
  cell.setCellStyle(normal);
  cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
  cell.setCellValue("身份证号"); // 设置中西文结合字符串
 
  row = sheet.createRow((short) i);
  cell = row.createCell((short) (5)); // 建立新cell
  cell.setCellStyle(normal);
  cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
  cell.setCellValue("银行行号"); // 设置中西文结合字符串
 
  row = sheet.createRow((short) i);
  cell = row.createCell((short) (6)); // 建立新cell
  cell.setCellStyle(normal);
  cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
  cell.setCellValue("银行卡号"); // 设置中西文结合字符串
 
  String sql = "SELECT CJ02005,CJ02006,CJ02007,CJ02029,CJ02004,CJ02027,CJ02028 FROM T_CJ02";
  ResultSet rs = this.sel(sql);
  try {
   while(rs.next()){
    row = sheet.createRow((short) i + 1);
    cell = row.createCell((short) (0)); // 建立新cell
    cell.setCellStyle(normal);
    cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
    cell.setCellValue(rs.getString("CJ02005")); // 设置中西文结合字符串
    System.out.println(rs.getString("CJ02005"));
   
    cell = row.createCell((short) (1)); // 建立新cell
    cell.setCellStyle(normal);
    cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
    cell.setCellValue(rs.getString("CJ02006")); // 设置中西文结合字符串

    cell = row.createCell((short) (2)); // 建立新cell
    cell.setCellStyle(normal);
    cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
    cell.setCellValue(rs.getString("CJ02007")); // 设置中西文结合字符串

    cell = row.createCell((short) (3)); // 建立新cell
    cell.setCellStyle(normal);
    cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
    cell.setCellValue(rs.getString("CJ02029")); // 设置中西文结合字符串
   
    cell = row.createCell((short) (4)); // 建立新cell
    cell.setCellStyle(normal);
    cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
    cell.setCellValue(rs.getString("CJ02004")); // 设置中西文结合字符串

    cell = row.createCell((short) (5)); // 建立新cell
    cell.setCellStyle(normal);
    cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
    cell.setCellValue(rs.getString("CJ02027")); // 设置中西文结合字符串

    cell = row.createCell((short) (6)); // 建立新cell
    cell.setCellStyle(normal);
    cell.setEncoding(HSSFCell.ENCODING_UTF_16); // 设置cell编码解决中文高位字节截断
    cell.setCellValue(rs.getString("CJ02028")); // 设置中西文结合字符串
   
    i++;
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }
  try {
   FileOutputStream fileOut = new FileOutputStream(path);
   wb.write(fileOut);
   fileOut.close();
   System.out.println("====动态模板文件excel文件生成成功：========" + path);
  } catch (Exception e1) {
   e1.printStackTrace();
  }
}
public ResultSet sel(String sql){
  Connection con = null;
  ResultSet rs = null;
  //String sql = "SELECT CJ02005,CJ02006,CJ02007,CJ02029,CJ02004,CJ02027,CJ02028 FROM T_CJ02";
  try{
   con = DataConnection.getConnection();
   Statement stt = con.createStatement();
   rs = stt.executeQuery(sql);
  
  }catch(Exception e){
   e.printStackTrace();
  }
  return rs;
}
}