PageOffice动态填充数据库数据

一.动态填充数据库中的数据到文档中(以JAVA语言，Word文档,Sqlite数据库为例).

PageOfficeCtrl poCtrl1 = new  PageOfficeCtrl(request);       poCtrl1.setServerPage(request.getContextPath()+"/poserver.zz"); //此行必须         //连接数据库并获得数据库中的字段值    Class.forName("org.sqlite.JDBC");    String strUrl = "jdbc:sqlite:"             + this.getServletContext().getRealPath("demodata/" + "\\demo.db";    Connection conn = DriverManager.getConnection(strUrl);    Statement stmt = conn.createStatement();    ResultSet rs = stmt.executeQuery("select * from user where id =1");    if (rs.next()) {        String name=rs.getString(“name”);        String deptNum=rs.getString(“deptNum”);    }    rs.close();    conn.close();   //将获取的数据填充到word文档只读的数据区域中    WordDocument doc = new WordDocument();   //打开数据区域    DataRegion dataRegion1 = doc.openDataRegion("PO_userName");    //给数据区域填充获取的字段值赋值    dataRegion1.setValue(name);    DataRegion dataRegion2 = doc.openDataRegion("PO_deptName");    dataRegion2.setValue(deptNum);    poCtrl1.setWriter(doc);    poCtrl1.webOpen("doc/test.doc", OpenModeType.docNormalEdit, "张三");    poCtrl1.setTagId("PageOfficeCtrl1"); //此行必须