欢迎进入Java社区论坛,与200万技术人员互动交流 >>进入
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet();
createTag(coloumItems, sheet);// 写表格的列名
createValue(rs, sheet);// 获取数据集,然后获得数据,写文件
workbook.write(fileOutputStream);
fileOutputStream.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
if (fileOutputStream != null) {
try {
fileOutputStream.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
DB.close(ps);
DB.close(conn);
}
/**
* 创建表格表头
*
* @param tags
* @param s
*/
private static void createTag(String[] tags, HSSFSheet s) {
HSSFRow row = s.createRow(0);
HSSFCell cell = null;
for (int i = 0; i < tags.length; i++) {
cell = row.createCell(i);
cell.setCellValue(tags[i]);
}
}
/**
* 设置表格内容
*
* @param res
* @param s
*/
private static void createValue(java.sql.ResultSet res, HSSFSheet s) {
try {
int flag = 1;
int count = res.getMetaData()。getColumnCount();
HSSFRow row = null;
HSSFCell cell = null;
while (res.next()) {
row = s.createRow(flag);
for (int i = 1; i <= count; i++) {
cell = row.createCell(i – 1);
Object obj = res.getObject(i);
cell.setCellValue(obj + “”);
}
flag++;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
二、数据库操作封装
package com.otdrmsys.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DB {
public static Connection createConn() {
Connection conn = null;
try {
Class.forName(”com.mysql.jdbc.Driver”);
conn = DriverManager.getConnection
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
[1][2][3]
在向山靠近一点,才发现这座山,好象一位诗人遥望远方,