Jxls导出excel的若干方式总结（四）-- jdbc方式(RowSetDynaClass)+ jx标签库

来源：互联网发布：java 用户管理框架编辑：程序博客网时间：2024/04/30 23:44

在excel中利用el表达式。注意：suplyArea后跟的是其对应数据库表的列名称。

List supply realist = saBiz.getSupplyAreaById(supplyAreaId);SupplyArea sa = (SupplyArea) supplyAreaList.get(0);Long id = sa.getSupplyAreaId();String templateDir = "D:/excel/template/SupplyAreaIf.xls";String targetDir="D:/excel/export/testIf.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 ";        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);