前排提示:代码手打,可能有拼写错误
核心代码
把表中的列名存在呢一个list中
Connection conn=......
String sql="select * from test"
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
ResultSetMetaData metaData = rs.getMetaData();
int cilum =metaData.getColumnCount();
List<String> columnNameList=new ArrayList();
for(int i=1;i<=column;i++){
String columnName=metaData.getColumnName(i);
columnNameList.add(columnName);
}
创建excel
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
HSSFSheet hssfSheet = workbook.createSheet("信息表");
HSSFRow row = hssfSheet.createRow(0);
for(int i=0;i<columnNameList.size();i++){
HSSFCell cell=row.createCell(i);
HSSFRichTextString text=new HSSFRichTextString(columnNameList.get(i));
cell.setCellValue(text);
}
int rowNum=1;
while(rs.next()){
HSSFRow row1=hssfSheet.createRow(rowNum);
for(int i=0;i<columNameList.size();i++)
{
row1.createCell(i).setCellValue(rs.getString(columnNameList.get(i)));
}
rowNum++
}