查询出单个记录可以任意布局。
模板中beans对象suplyArea后跟的是数据库表中的列名称。
List supplyAreaList = saBiz.getSupplyAreaById(supplyAreaId); SupplyArea sa = (SupplyArea) supplyAreaList.get(0); Long id = sa.getSupplyAreaId(); String templateDir = "D:/excel/template/SupplyAreaJDBC.xls"; String targetDir="D:/excel/export/testJDBC.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);