用apache poi导出数据到Excel
public class ExPortExcel {private ResultSet rs;
private String strSql;
public ExPortExcel() {
}
public ExPortExcel(ResultSet rs, String strSql) {
this.rs=rs;
this.strSql=strSql;
}
/**
* @return
*/
public ResultSet getRs() {
return rs;
}
/**
* @return
*/
public String getStrSql() {
return strSql;
}
/**
* @param set
*/
public void setRs(ResultSet set) {
rs = set;
}
/**
* @param string
*/
public void setStrSql(String string) {
strSql = string;
}
//导出数据到Excel
public void getExcel(HttpServletRequest req, HttpServletResponse res,
ExPortExcel excel) {
//HSSFRichTextString title = new HSSFRichTextString("用户信息");
DataDAO db = new DataDAO();
ResultSet rs = db.getData(excel.strSql);
// 创建Excel 文件
HSSFWorkbook workbook = new HSSFWorkbook();
// 创建工作区
HSSFSheet sheet = workbook.createSheet();
// 创建行对象
HSSFRow row_title = sheet.createRow(0);
// 创建标题的字体
//HSSFFont title_font = workbook.createFont();
//// 设置标题字体属性
//title_font.setFontHeightInPoints((short) 8);
//// 设置标题字体属性
//title_font.setFontHeight((short) HSSFFont.BOLDWEIGHT_NORMAL);
//// 设置标题字体的颜色
//title_font.setColor((short) HSSFFont.BOLDWEIGHT_NORMAL);
//// 创建样式
//HSSFCellStyle title_style = workbook.createCellStyle();
//// 设置标题样式属性
//title_style.setFont(title_font);
//// 创建单元格对象
//HSSFCell cell_title = row_title.createCell((short) 1);
//// 设置单元格样式
//cell_title.setCellStyle(title_style);
//// 将标题写到Excel表格中
//cell_title.setCellValue(title);
ArrayList list = new ArrayList();
try {
// 得到元数据
ResultSetMetaData rsmd = rs.getMetaData();
for (int j = 1; j
页:
[1]