到处excel表格

导出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();
		}