导出excel表格
Connection connection = null;
try {
connection = new DBDao().getConn();
String sql="select * from t_cno";
PreparedStatement pStatement = connection.prepareStatement(sql);
ResultSet rs=pStatement.executeQuery();
WritableWorkbook book=Workbook.createWorkbook(new File("C:/Users/maorenwei/Desktop/bx.xls"));
WritableSheet sheet = book.createSheet("第一页", 0);
int i=0;
int j=0;
for(int k=0;k<rs.getMetaData().getColumnCount();k++){
sheet.addCell(new jxl.write.Label(k, 0, rs.getMetaData().getColumnName(k+1)));
}
while(rs.next()){
for(int k=0;k<rs.getMetaData().getColumnCount();k++){
sheet.addCell(new jxl.write.Label(k, j+i+1, rs.getString(k+1)));
}
i++;
}
book.write();
book.close();
rs.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}