一.动态填充数据库中的数据到文档中(以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"); //此行必须