从数据库中查出数据，填入word模板，并生成word和pdf文档

justepcjl · 发表于 2015-7-30 15:24:37

本帖最后由 justepcjl 于 2015-7-30 16:35 编辑

转自：使用X5生成复杂的word合同模板（）
http://bbs.wex5.com/forum.php?mod=viewthread&tid=71710

第一部：首先要有制作word模板；首先将word转换为.xml文件（word2003），然后，在转换为.ftl文件。（要注意编码格式，乱码有时候清一下缓存，等                等）这个ftl文件中最重要的是下面蓝色的，${xx},其中xx为map数据中的key。这个可以在.xml文件写好，在转换为.ftl文件。                                                                               <w:r wsp:rsidRPr="003A7488">
                                                      <w:rPr>
                                                            <w:rFonts w:ascii="仿宋_GB2312" w:fareast="仿宋_GB2312" w:hint="fareast"/>
                                                            <wx:font wx:val="仿宋_GB2312"/>
                                                            <w:sz w:val="30"/>
                                                            <w:sz-cs w:val="30"/>
                                                      </w:rPr>
                                                      <w:t>联系电话</w:t>
                                             </w:r>
                                             <w:r>
                                                      <w:rPr>
                                                            <w:rFonts w:ascii="仿宋_GB2312" w:fareast="仿宋_GB2312" w:hint="fareast"/>
                                                            <wx:font wx:val="仿宋_GB2312"/>
                                                            <w:sz w:val="30"/>
                                                            <w:sz-cs w:val="30"/>
                                                            <w:u w:val="single"/>
                                                      </w:rPr>
                                                      <w:t> </w:t>
                                             </w:r>
                                             <w:r>
                                                      <w:rPr>
                                                            <w:rFonts w:ascii="仿宋_GB2312" w:fareast="仿宋_GB2312" w:hint="fareast"/>
                                                            <wx:font wx:val="仿宋_GB2312"/>
                                                            <w:color w:val="000000"/>
                                                            <w:kern w:val="0"/>
                                                            <w:sz w:val="24"/>
                                                      </w:rPr>
                                                      <w:t>${fLXDH}</w:t>
                                             </w:r>

第二部：前端页面js:
   第一部分js:其中fid是要查询的数据的主键，根据他查询出数据，放进map，然后填充到word模板。
   mainActivity.trigger6Click = function(event){
      var dataMain = justep.xbl("dataMain");
      var fid = dataMain.getCurrentID();  //得到该条数据记录，就是要打印的调解协议书.
      if(!fid) {
            return;
               }
      createDoc(fid, "_xys", "农村土地承包经营权纠纷调解协议书");
      };

      第二部分js: createDoc其实就是一个ajax访问CreateDoc(action方法），第四部中讲的就是这个action.后面那个setURL就是打开windowsDialog.
      ,其中子页面就是第三部中要讲的。
      function createDoc(fid, type, name) {
            var actionParam = new justep.Request.ActionParam();
            actionParam.setString("fid", fid);
            actionParam.setString("type", type);
            justep.Request.sendBizRequest2({
                        dataType : "application/json",
                        action : "CreateDoc",
                        parameters : actionParam,
                     callback : function(result) {
                              if (result.state) {
                                    var res = result.response;
                                    getURL(res,name);
                              } else {
                                       throw new Error("调用失败！|" + result.response.message);
                              }
                     }
            });
      }

      function getURL(res,name) {
               var runner = justep.xbl("windowRunner1");       //这儿是一个windowDilog.
               runner.setURL("/UI/LandManagerSys/LandQueriesMgr/process/CBHTQuery/docView.w");
               runner.setTitle(name);
               runner.open({
                     res:res,
                     name:name
                  });
      }

第三部分：
      其中有两个按钮，一个div,div的id问pdf，就是第一个function中，也就是windowsReceive事件中最后在pdf div中，添加了pdf对象。
      另外有两个按钮。这个需要引用js文件：

pdfobject.zip (1.04 KB, 下载次数: 1132)

2015-7-30 16:25 上传

点击文件名下载附件
pdf对象

docView图片

ar res = '';
var name = '';
docView.windowReceiver1Receive = function(event){
res = event.data.res;//文件名
name = event.data.name;
var a = res.split(".");
var url = window.location.protocol+"//"+ window.location.host + "/x5/UI/LandManagerSys/doc/" + a[0] + ".pdf";
var success = new PDFObject({url:url}).embed("pdf");
};
docView.trigger4Click = function(event){
justep.xbl("windowReceiver1").windowCancel();
};
//文档另存
docView.trigger3Click = function(event){
var url = justep.Request
.convertURL("/UI/LandManagerSys/PublicClass/servlet/DownDoc.j?res="
+ encodeURI(res) + '&Filename=' + encodeURI(name + ".doc"));
url = justep.Request.setBizParams(url);
$("#file").attr("src", url);
};

复制代码

第四部分：createDoc action 你自己看。

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.io.UnsupportedEncodingException;
import java.io.Writer;
import java.math.*;
import java.sql.*;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.Date;
import org.dom4j.*;
import org.dom4j.io.SAXReader;
import com.justep.common.SystemUtils;
import com.justep.filesystem.FileSystem;
import com.justep.filesystem.FileSystemWrapper;
import com.justep.system.context.ContextHelper;
import com.justep.system.data.*;
import com.justep.system.util.BizUtils;
import freemarker.template.Configuration;
import freemarker.template.Template;
import freemarker.template.TemplateException;
public class LandQueriesMgr {
private static Configuration configuration = null;
private static WordToPDF wordToPDF = null;
// 生成承包合同模板
public static String CreateDoc(String fid, String type) {
return getDoc(fid, type);
}
// 生成模板
public static String getDoc(String fid, String type) {
configuration = new Configuration();
configuration.setDefaultEncoding("utf-8");
configuration.setClassicCompatible(true);
// 要填入模本的数据文件
if(type.equals("_xys")){ //乡村调解协议书
getData_Xys(fid,dataMap);
}
else {
getData(fid, dataMap);
}
FileSystem fileSystem = FileSystemWrapper.instance();
String real = fileSystem.getRealPath("/LandManagerSys/template");
File file = new File(real);
try {
configuration.setDirectoryForTemplateLoading(file);
} catch (IOException e2) {
e2.printStackTrace();
}
Template t = null;
try {
// test.ftl为要装载的模板
t = configuration.getTemplate(type + ".ftl");
} catch (IOException e) {
e.printStackTrace();
}
// 输出文档路径及名称
// FileSystem fil = FileSystemWrapper.instance();
// String reals = fil.getRealPath("/LandManagerSys/doc/" + fid + type +
// ".doc");
String ul = getHome() + "/model/UI/LandManagerSys/doc/" + fid + type
+ ".doc";
System.out.println(ul);
File outFile = new File(ul);
if (outFile.exists()) {
outFile.delete();
}
Writer out = null;
try {
out = new BufferedWriter(new OutputStreamWriter(
new FileOutputStream(outFile)));
} catch (FileNotFoundException e1) {
e1.printStackTrace();
}
try {
t.process(dataMap, out);
} catch (TemplateException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
try {
out.flush();
out.close();
} catch (IOException e) {
e.printStackTrace();
}
}
wordToPDF = new WordToPDF();
String pdfUrl = getHome() + "/model/UI/LandManagerSys/doc/" + fid
+ type + ".pdf";
wordToPDF.wordToPDF(ul, pdfUrl);
return outFile.getName();
}
/**
* 生成合同、登记薄、经营权证
*
* @param fid
* @param dataMap
*/
private static void getData(String fid, Map<String, Object> dataMap) {
String ksql = "SELECT CBHT.*, CBJYQQDFS.MC AS CBFSMC, CBF.*,ZJLX.MC AS ZJLXMC, FBF.*, XZQ.name AS SHI, X.name as XIANG, C.name as CUN FROM CBHT CBHT optional JOIN CBJYQQDFS CBJYQQDFS ON CBHT.CBFS = CBJYQQDFS.DM optional JOIN CBF CBF ON CBHT.CBFBM = CBF.CBFBM optional JOIN FBF FBF ON CBHT.FBFBM = FBF.FBFBM optional JOIN XZQ XZQ ON substring(CBHT.CBHTBM, 0, 7) = XZQ optional JOIN XZQ X ON substring(CBHT.CBHTBM, 0, 10) = X optional JOIN XZQ C ON substring(CBHT.CBHTBM, 0, 13) = C optional JOIN ZJLX ZJLX ON CBF.CBFZJLX = ZJLX.DM";
if (!"".equals(fid)) {
ksql += " WHERE CBHT.CBHTBM='" + fid + "'";
}
Table table = KSQL.select(ksql, null,
"/LandManagerSys/LandInfoMgr/data", null);
Iterator<Row> rows = table.iterator();
Collection<String> list = table.getColumnNames();
String[] strArray1 = (String[]) list.toArray(new String[0]);
String fCBHTBH = "";// 合同编号
String fCBFBM = "";// 承包方编码
while (rows.hasNext()) {
Row row = rows.next();
fCBHTBH = row.getString("CBHTBM");
fCBFBM = row.getString("CBFBM");
Date sdate = row.getDate("CBQXQ");
Date edate = row.getDate("CBQXZ");
long quot = edate.getTime() - sdate.getTime();
quot = quot / 1000 / 60 / 60 / 24 / 365;
dataMap.put("CBNX", quot);
for (int i = 0; i < table.getColumnCount(); i++) {
dataMap.put(strArray1[i], row.getValue(strArray1[i]));
}
}
Calendar now = Calendar.getInstance();
SimpleDateFormat formatter = new SimpleDateFormat("yyyy");
String time = formatter.format(now.getTime());
dataMap.put("NIAN", time);
dataMap.put("YUE", (now.get(Calendar.MONTH) + 1));
dataMap.put("RI", now.get(Calendar.DAY_OF_MONTH));
// 生成宗地
String ksql_zd = "SELECT CBDKXX.*,CBJYQQDFS.MC AS CBFSMC, DK.*, DKLB.MC AS DKLBMC, TDYT.MC AS TDYTMC, DLDJ.MC AS DLDJMC, SF.MC AS SFJBNTMC FROM CBDKXX CBDKXX optional JOIN CBJYQQDFS CBJYQQDFS ON CBDKXX.CBJYQQDFS = CBJYQQDFS.DM optional JOIN DK DK ON CBDKXX.DKBM = DK.DKBM optional JOIN DKLB DKLB ON DK.DKLB = DKLB.DM optional JOIN TDYT TDYT ON DK.TDYT = TDYT.DM optional JOIN DLDJ DLDJ ON DK.DLDJ = DLDJ.DM optional JOIN SF SF ON DK.SFJBNT = SF.DM";
if (!"".equals(fCBHTBH) && fCBHTBH != null) {
ksql_zd += " WHERE CBDKXX.CBHTBM='" + fCBHTBH + "'";
}
Table table_zd = KSQL.select(ksql_zd, null,
"/LandManagerSys/LandInfoMgr/data", null);
Iterator<Row> rows_zd = table_zd.iterator();
List<ZD> table2 = new ArrayList<ZD>();
while (rows_zd.hasNext()) {
ZD zd = new ZD();
Row row = rows_zd.next();
Float a = row.getFloatObject("SCMJ");
a = a==null?(float)0:a;
Double b = new Double(new DecimalFormat(".00").format(a * 0.0015));
Float htmj = row.getFloatObject("HTMJ");
if (htmj == null) {
htmj = (float) 0;
} else {
htmj = (float) htmj;
}
Double c = new Double(new DecimalFormat(".00").format(htmj * 0.0015));
zd.setDkmc(row.getString("DKMC"));
zd.setDkbm(row.getString("DKBM"));
zd.setScmj(String.valueOf(b));
zd.setJbnt(row.getString("SFJBNTMC"));
zd.setDz(row.getString("DKDZ"));
zd.setXz(row.getString("DKXZ"));
zd.setNz(row.getString("DKNZ"));
zd.setBz(row.getString("DKBZ"));
zd.setDj(row.getString("DLDJMC"));
zd.setLx(row.getString("DKLBMC"));
zd.setHtmj(String.valueOf(c));
zd.setTddj(row.getString("TDYTMC"));
zd.setTdyt(row.getString("DLDJMC"));
table2.add(zd);
}
dataMap.put("table2", table2);
// 生成共有人
String sql_gyr = "SELECT CBF_JTCY.*, ZJLX.MC AS ZJLXMC, XB.MC AS XBMC, CYBZD.MC AS CYBZMC, SF.MC AS SFMC,YH.MC as YHZGXMC FROM CBF_JTCY CBF_JTCY optional JOIN ZJLX ZJLX ON CBF_JTCY.CYZJLX = ZJLX.DM optional JOIN XB XB ON CBF_JTCY.CYXB = XB.DM optional JOIN CYBZ CYBZD ON CBF_JTCY.CYBZ = CYBZD.DM optional JOIN SF SF ON CBF_JTCY.SFGYR = SF.DM optional join YHZGX YH on CBF_JTCY.YHZGX = YH.DM";
if (!"".equals(fid) && !"".equals(fCBFBM)) {
sql_gyr += " WHERE CBF_JTCY.CBFBM='" + fCBFBM + "'";
}
Table table_gyr = KSQL.select(sql_gyr, null,
"/LandManagerSys/LandInfoMgr/data", null);
Iterator<Row> rows_gyr = table_gyr.iterator();
List<GYR> table3 = new ArrayList<GYR>();
while (rows_gyr.hasNext()) {
GYR gyr = new GYR();
Row row = rows_gyr.next();
gyr.setXm(row.getString("CYXM"));
gyr.setGx(row.getString("YHZGXMC"));
gyr.setSfz(row.getString("CYZJHM"));
gyr.setBz(row.getString("CYBZMC"));
table3.add(gyr);
}
dataMap.put("table3", table3);
// 获取序列号
int a = BizUtils.getNextSequence("");
dataMap.put("fBSM", a);
// --------------------------------------------------
// for (String key : dataMap.keySet()) {
// System.out.println(key+"----"+dataMap.get(key));
//
// }
}
/*
* 乡村调解协议书生成数据
*
* @param fid
* @param dataMap
*/
public static void getData_Xys(String fid, Map<String, Object> dataMap){
String oracle = "SELECT LA_XCTJ.* ";
String mssql = "SELECT LA_XCTJ.* ";
String mysql = "SELECT LA_XCTJ.* ";
if (!"".equals(fid)) {
oracle += " FROM LA_XCTJ WHERE LA_XCTJ.FID='" + fid + "'";
mssql += " FROM LA_XCTJ WHERE LA_XCTJ.FID='" + fid + "'";
mysql += " FROM LA_XCTJ WHERE LA_XCTJ.FID='" + fid + "'";
}
System.out.println(mysql);
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(SQL.DEFAULT_DB_NAME, mssql);
sqlMap.put(DatabaseProduct.ORACLE.name(), oracle);
sqlMap.put(DatabaseProduct.MSSQL.name(), mssql);
sqlMap.put(DatabaseProduct.KINGBASE.name(), oracle);
sqlMap.put(DatabaseProduct.SYBASE.name(), mssql);
sqlMap.put(DatabaseProduct.DB2.name(), oracle);
sqlMap.put(DatabaseProduct.MYSQL.name(), mysql);
Table table = SQL.select(sqlMap, null, "/LandManagerSys/LandDAM/data");
Iterator<Row> rows = table.iterator();
Collection<String> list = table.getColumnNames();
String[] strArray1 = (String[]) list.toArray(new String[0]);
while (rows.hasNext()) {
Row row = rows.next();
for (int i = 0; i < table.getColumnCount(); i++) {
dataMap.put(strArray1[i], row.getValue(strArray1[i]));
System.out.println(strArray1[i]+":"+row.getValue(strArray1[i]));
}
}
}
// 获取服务端安装地址
public static String getHome() {
String home = System.getenv("JUSTEP_HOME");
if (home == null) {
File fl = new File(ContextHelper.getSessionContext().getSession()
.getServletContext().getRealPath("/WEB-INF/justep.xml"));
if (fl.exists()) {
try {
SAXReader reader = new SAXReader();
Document doc = reader.read(fl);
Element e = doc.getRootElement().element("JUSTEP_HOME");
if (e != null) {
home = e.getText().trim();
} else {
home = fl.getParent() + "/../../..";
}
} catch (DocumentException e) {
e.printStackTrace();
throw new UnsupportedOperationException(fl.getPath()
+ "不是标准的XML!", e);
}
} else {
throw new UnsupportedOperationException("没有找到" + fl.getPath());
}
}
try {
File f = new File(home);
home = f.getCanonicalPath();
} catch (IOException e) {
throw new RuntimeException("JUSTEP_HOME: “" + home + "“不存在！");
}
return home;
}
// 另存文档
public static Object downloadFile(String fileName)
throws UnsupportedEncodingException {
FileSystem fileSystem = FileSystemWrapper.instance();
String real = fileSystem.getRealPath("/LandManagerSys/doc/");
FileInputStream fis = null;
String s = java.net.URLDecoder.decode(real + fileName, "UTF-8");
File file = new File(s);
if (file.getAbsolutePath().startsWith(file.getAbsolutePath())) {
try {
fis = new FileInputStream(file);
} catch (FileNotFoundException e) {
throw new RuntimeException("获取文件失败！", e);
}
} else
throw new RuntimeException("获取文件失败，超出获取文件权限范围！");
return fis;
}
public static Table hcxx_z(String fid) {
String hcxx_z = "select CBHT.CBHTBM as CBHTBM,FBF.FBFMC as FBFMC,CBHT.CBDKZS as CBDKZS, CBHT.CBHTZMJ as CBHTMJ," +
"CBF.CBFMC as CBFMC,CBF.CBFBM as CBFBM,CBF.CBFZJHM as CBFZJHM ," +
"CBJYQQDFS.MC AS CBFSMC,CBF.CBFDZ as CBFDZ,CBF.YZBM as YZBM," +
"CBF.LXDH as LXDH,datediff(YEAR,CBHT.CBQXQ,CBHT.CBQXZ)+1 as CBQX " +
"from CBHT,FBF,CBF,CBJYQQDFS " +
"where CBHT.CBHTBM = '"+fid+"' " +
"and FBF.FBFBM = CBHT.FBFBM " +
"and CBF.CBFBM = CBHT.CBFBM " +
"and CBJYQQDFS.DM = cbht.CBFS";
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(SQL.DEFAULT_DB_NAME, hcxx_z);
sqlMap.put(DatabaseProduct.MSSQL.name(), hcxx_z);
sqlMap.put(DatabaseProduct.SYBASE.name(), hcxx_z);
return SQL.select(sqlMap, null, "/LandManagerSys/LandInfoMgr/data");
}
public static Table hcxx_gyr(String fid) {
String hcxx_gyr = "select CBF_JTCY.CYXM as CYXM,YH.MC as YHZGXMC,CBF_JTCY.CBFBM as CBFBM,CBF_JTCY.CYZJHM as CYZJHM,"
+ "CYBZD.MC AS CYBZMC "
+ "FROM CBF_JTCY CBF_JTCY left JOIN CYBZ CYBZD ON CBF_JTCY.CYBZ = CYBZD.DM "
+ "left join YHZGX YH on CBF_JTCY.YHZGX = YH.DM "
+ "where CBF_JTCY.CBFBM =(select CBFBM from CBHT where CBHT.CBHTBM = '"
+ fid + "')";
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(SQL.DEFAULT_DB_NAME, hcxx_gyr);
sqlMap.put(DatabaseProduct.MSSQL.name(), hcxx_gyr);
sqlMap.put(DatabaseProduct.SYBASE.name(), hcxx_gyr);
return SQL.select(sqlMap, null, "/LandManagerSys/LandInfoMgr/data");
}
public static Table hcxx_zd(String fid) {
String hcxx_zd = "SELECT DK.DKMC as DKMC,CBDKXX.DKBM as DKBM,SF.MC AS SFJBNTMC,CBDKXX.CBHTBM as CBHTBM," +
"Convert(decimal(10,2),(CBDKXX.HTMJ*0.0015)) as HTMJ," +
"Convert(decimal(10,2),(DK.SCMJ*0.0015)) as SCMJ," +
"DK.DKDZ as DKDZ,DK.DKNZ as DKNZ,DK.DKXZ as DKXZ," +
"DK.DKBZ as DKBZ " +
"FROM CBDKXX CBDKXX left JOIN DK DK ON CBDKXX.DKBM = DK.DKBM " +
"left JOIN SF SF ON DK.SFJBNT = SF.DM " +
"where CBDKXX.CBHTBM = '"+fid+"'";
System.out.println(hcxx_zd);
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(SQL.DEFAULT_DB_NAME, hcxx_zd);
sqlMap.put(DatabaseProduct.MSSQL.name(), hcxx_zd);
sqlMap.put(DatabaseProduct.SYBASE.name(), hcxx_zd);
return SQL.select(sqlMap, null, "/LandManagerSys/LandInfoMgr/data");
}
}

复制代码

阿拉伯梳子 · 发表于 2016-9-29 11:59:37

楼主你好，问一下flt文件是什么格式文件啊？怎么生成的

哟哟哟 · 发表于 2016-10-13 17:12:35

大良哥，给力啊

Adol · 发表于 2019-7-31 16:27:16

里面有很多报错的引用最新的jacob.jar和freemarker.jar不起作用

lyc_0809 · 发表于 2019-8-5 08:22:27

学习学习

		自动登录	找回密码
密码			注册

[分享] 从数据库中查出数据，填入word模板，并生成word和pdf文档