Jxls导出excel的若干方式总结（八）-- 导出一条查询记录到多个sheet

最新推荐文章于 2024-06-27 08:00:00 发布

南山隐者

最新推荐文章于 2024-06-27 08:00:00 发布

阅读量252

点赞数

文章标签：数据库人工智能

注意：suplyArea后跟的是其对应数据库表的列名称。

Sheet1中的模板信息（模板）

Sheet2中的模板信息（模板）

代码：
List supplyAreaList = saBiz.getSupplyAreaById(supplyAreaId);
	SupplyArea sa = (SupplyArea) supplyAreaList.get(0);
	Long id = sa.getSupplyAreaId();
	String templateDir = "D:/excel/template/SupplyAreaRecordsInSheet.xls";
	String targetDir="D:/excel/export/testRecordsInSheet.xls";			
	Map beans = new HashMap();
	Class.forName("oracle.jdbc.driver.OracleDriver").getInterfaces();
	Connection con = DriverManager.getConnection("jdbc:oracle:thin:@168.9.202.49:1521:GIS", "JMJL","JMJL" );
	Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
	String query = "select SUPPLYAREA_ID,EDITUSER,SUPPLYAREA_NAME,X,Y," +
	        		"REMARKS,STARTDATE,ENDDATE,LIFECYCLE,DATAGUID " +
	        		"from HSY_T_SUPPLYAREA where SUPPLYAREA_ID ="+id;
	ResultSet rs = stmt.executeQuery(query);
	RowSetDynaClass rsc = new RowSetDynaClass(rs,false);
	beans.put("suplyArea",rsc.getRows());
	XLSTransformer transformer = new XLSTransformer();
	transformer.transformXLS(templateDir, beans, targetDir);