freemarker模板引擎

Bertha 。 2022-05-14 02:15 275阅读 0赞

一、创建模板

<div class="detail-module">
    	<div class="first-line">
    		<div class="right-box">
    			<div class="overview-item">
    				<div class= 'detail-item'>
    					<div class="handle-line">
    						<p><span class="font-weight">来客姓名:</span> <span class="float-left">${informationMap.VISITOR_NAME}</span></p>
    						<p><span class="font-weight">到访时间:</span> <span class="float-left">${informationMap.ARRIVEVISIT_TIME}</span></p>
    						<p><span class="font-weight">同行人数:</span> <span class="float-left">${informationMap.PEER_NUMBER}</span></p>
    						<p><span class="font-weight">来客职务:</span> <span class="float-left">${informationMap.DUTY_NAME}</span></p>
    						<p><span class="font-weight">行政级别:</span> <span class="float-left">${informationMap.ADMINISTRATIVE_LEVEL_LABEL}</span></p>
    						<p><span class="font-weight">联系人:</span> <span class="float-left">${informationMap.CONTACTS}</span></p>
    						<p><span class="font-weight">联系电话:</span> <span class="float-left">${informationMap.CONTACTS_TEL}</span></p>
    					</div>
    				</div>
    			 </div>
    		</div>
    	</div> 	                        
    </div>
    <h3>任务内容</h3>
    <div class="handle-detail">
       <div class="first-line">
           <div class="right-box">
               <div class="overview-item">
                   <div class= 'detail-item'>
                       <div class="handle-line">
                           <p><span class="font-weight">任务内容:</span> <span class="float-left">${taskMap.TASK_CONTENT_LABEL}</span></p>
                           <p><span class="font-weight">到站方式:</span> <span class="float-left">${taskMap.ARRIVE_STATION_LABEL}</span></p>
                           <p><span class="font-weight">交通工具:</span> <span class="float-left">${taskMap.ARRIVE_INFORMATION1}，${taskMap.ARRIVE_INFORMATION2}，${taskMap.ARRIVE_INFORMATION3}</span></p>
                           <p><span class="font-weight">出发地:</span> <span class="float-left">${taskMap.ARRIVE_PLACE}</span></p>
                           <p><span class="font-weight">离站方式:</span> <span class="float-left">${taskMap.LEAVE_STATION_LABEL}</span></p>
                           <p><span class="font-weight">交通工具:</span> <span class="float-left">${taskMap.LEAVE_INFORMATION1}，${taskMap.LEAVE_INFORMATION2}，${taskMap.LEAVE_INFORMATION3}</span></p>
                           <p><span class="font-weight">目的地:</span> <span class="float-left">${taskMap.LEAVE_PLACE}</span></p>
                       </div>
                   </div>
               </div>
           </div>
    	</div>
    </div>
    <h3>上传下达</h3>
    <div class="handle-detail">
        <div class="first-line">
            <div class="right-box">
                <div class="overview-item">
                    <div class= 'detail-item'>
                        <div class="handle-line">
                            <p><span class="font-weight">执行部门/人:</span> <span class="float-left">${signMap.IMPLEMENT_ORG_USER}</span></p>
                            <p><span class="font-weight">执行领导:</span> <span class="float-left">${signMap.IMPLEMENT_LEADER}</span></p>
                            <p><span class="font-weight">周知部门/人:</span> <span class="float-left">${signMap.KNOWN_ORG_USER}</span></p>
                            <p><span class="font-weight">贵宾室:</span> <span class="float-left">${signMap.POSTDUTY_PLACE}</span></p>
                            <p><span class="font-weight">接待人员:</span> <span class="float-left">${signMap.RECEPTION_USER}</span></p>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

二、java

在执行保存功能时，把模板保存到数据库

//更新模板
    VisitorImportant visitorImportant = baseInfoService.getObjectById(VisitorImportant.class, id);
    //进行保存模板操作
    createVisitorImportantDetail(visitorImportant, "visitorImportantPC.ftl");

/**
    	 * 
    	 * @Description 保存重要来客可查看信息的模板
    	 * @param visitorImportant
    	 * @param templatesName
    	 * @return ReturnDatas
    	 * @throws Exception
    	 *
    	 */
    	@Override
    	@Transactional(propagation = Propagation.REQUIRED)
    	public VisitorImportantDetail createVisitorImportantDetail(VisitorImportant visitorImportant,String templatesName) throws Exception {
    		ReturnDatas returnDatas = new ReturnDatas();
    		String id_visitor_important = visitorImportant.getId();
    		VisitorImportantDetail visitorImportantDetail = visitorImportantDetailService.getVisitorImportantDetailByInstId(id_visitor_important);
    		String informationSql = "select  " +
        			"t.id as id , " + //主键id
    				"t.visitor_name as visitor_name," + //来客姓名
        			"t.arrivevisit_time as arrivevisit_time, " + //到访时间
        			"t.peer_number as peer_number, " + //同行人数
        			"t.duty_name as duty_name, " + //来客职务
        			"t.administrative_level_label as administrative_level_label, " + //行政级别
        			"t.contacts as contacts ,"+ //联系人
        			"t.contacts_tel as contacts_tel " + //联系电话
        			" from v_visitor_important t  " + 
        			" where t.id = '"+id_visitor_important+"'";
    		List<Map<String, Object>> informationMap = baseInfoService.listMapQueryBySql(informationSql);
    		LinkedHashMap<String,Object> linkMap = new LinkedHashMap<String,Object>();
    		VisitorImportantDetailPo visitorImportantDetailPo = new VisitorImportantDetailPo();
        	if(informationMap!=null && informationMap.size()>0) {
        		Map<String, Object> map = informationMap.get(0);
        		//替换jsonArray中的值
        		for(String key : map.keySet()) {
        			linkMap.put(key, map.get(key));
        		}
        		visitorImportantDetailPo.setInformationMap(linkMap);
        	}
        	
        	String hql = "select u from VisitorImportant u where id = '"+id_visitor_important+"'";
        	VisitorImportant v = (VisitorImportant) baseInfoService.getObjectByHql(hql);
        	String arriveType = v.getDict_arrive_station();
        	String arrive_information1 = "t.arrive_station_transportation";
        	String arrive_information2 = "t.arrive_station_contact";
        	String arrive_information3 = "t.arrive_station_othertime";
        	String arrive_place = arrive_information2;
        	if("0".equals(arriveType)) {
        		arrive_information1 = "t.arrive_station_train";
        		arrive_information2 = "t.arrive_station_seat";
        		arrive_information3 = "t.arrive_station_place";
        		arrive_place = arrive_information3;
    		}else if("1".equals(arriveType)) {
    			arrive_information1 = "t.arrive_station_car";
        		arrive_information2 = "t.arrive_station_park";
        		arrive_information3 = "t.arrive_station_cartime";
        		arrive_place = arrive_information2;
    		}
        	String leaveType = v.getDict_leave_station();
        	String leave_information1 = "t.leave_station_transportation";
        	String leave_information2 = "t.leave_station_contact";
        	String leave_information3 = "t.leave_station_othertime";
        	String leave_place = leave_information2;
        	if("0".equals(leaveType)) {
        		leave_information1 = "t.leave_station_train";
        		leave_information2 = "t.leave_station_seat";
        		leave_information3 = "t.leave_station_place";
        		leave_place = leave_information3;
    		}else if("1".equals(leaveType)) {
    			leave_information1 = "t.leave_station_car";
        		leave_information2 = "t.leave_station_park";
        		leave_information3 = "t.leave_station_cartime";
        		leave_place = leave_information2;
    		}
        	String taskSql = "select  " +
        			"t.id as id, " + //主键id
    				"t.task_content_label as task_content_label," + //任务内容
        			"t.arrive_station_label as arrive_station_label, " + //到站方式
        			arrive_information1+" as arrive_information1, " + //交通工具
        			arrive_information2+" as arrive_information2, " + //交通工具
        			arrive_information3+" as arrive_information3, " + //交通工具
        			arrive_place+" as arrive_place, " + //出发地
        			"t.leave_station_label as leave_station_label, " + //离站方式
        			leave_information1+" as leave_information1, " + //交通工具
        			leave_information2+" as leave_information2, " + //交通工具
        			leave_information3+" as leave_information3, " + //交通工具
        			leave_place+" as leave_place " + //目的地
        			" from v_visitor_important t  " + 
        			" where t.id = '"+id_visitor_important+"'";
    		List<Map<String, Object>> taskMap = baseInfoService.listMapQueryBySql(taskSql);
    		LinkedHashMap<String,Object> taskLinkMap = new LinkedHashMap<String,Object>();
        	if(taskMap!=null && taskMap.size()>0) {
        		Map<String, Object> map = taskMap.get(0);
        		//替换jsonArray中的值
        		for(String key : map.keySet()) {
        			taskLinkMap.put(key, map.get(key));
        		}
        		visitorImportantDetailPo.setTaskMap(taskLinkMap);
        	}
        	
        	String signSql = "select  " +
        			"t.id as id , " + //主键id
    				"t.implement_org_user as implement_org_user," + //执行部门/人
        			"t.implement_leader as implement_leader, " + //执行领导
        			"t.known_org_user as known_org_user, " + //周知部门/人
        			"t.known_leader as known_leader, " + //周知领导
        			"t.postduty_place as postduty_place, " + //贵宾室
        			"t.reception_user as reception_user " + //接待人员
        			" from v_visitor_important t  " + 
        			" where t.id = '"+id_visitor_important+"'";
    		List<Map<String, Object>> signMap = baseInfoService.listMapQueryBySql(signSql);
    		LinkedHashMap<String,Object> signLinkMap = new LinkedHashMap<String,Object>();
        	if(signMap!=null && signMap.size()>0) {
        		Map<String, Object> map = signMap.get(0);
        		//替换jsonArray中的值
        		for(String key : map.keySet()) {
        			signLinkMap.put(key, map.get(key));
        		}
        		visitorImportantDetailPo.setSignMap(signLinkMap);
        	}
        	
        	//字符流
            StringWriter stringWriterPC = new StringWriter();
            //StringWriter stringWriterAPP = new StringWriter();
            try {
    			//Map<String, Object> map = JSON.parseObject(detailStr);
    			//创建配置实例 
    			Configuration configuration = new Configuration(Configuration.VERSION_2_3_23);
    			//设置编码
    			configuration.setDefaultEncoding("UTF-8");
    			//空值
    			configuration.setClassicCompatible(true);
    			//ftl模板文件
    			configuration.setClassForTemplateLoading(VisitorImportantServiceImpl.class, "/templates/");
    			String tempPc = "visitorImportantPC.ftl";
    			//String tempApp = "taskApp.ftl";
    			//获取PC模板 
    			Template templatePC = configuration.getTemplate(tempPc);
    			//替换
    			templatePC.process(visitorImportantDetailPo, stringWriterPC);
    		} catch (Exception e) {
    			LogUtil.error(e.getMessage(),e);
                returnDatas.setStatus(ReturnDatas.ERROR);
                returnDatas.setMessage("freeMarker替换模板出错");
    		}
            
            System.out.println(stringWriterPC.toString());
        	//转化为JSON
        	String detailStr = JSON.toJSONString(visitorImportantDetailPo);
        	
        	String contentPC = stringWriterPC.toString();
         	String contentAPP = "";
         
        	//封装emergencyInsyDetail对象
         	visitorImportantDetail.setId_visitor_important(id_visitor_important);
         	visitorImportantDetail.setInst_content(detailStr);
         	visitorImportantDetail.setInst_content_pc(contentPC);
         	visitorImportantDetail.setInst_content_app(contentAPP);
            //保存静态Html对象
         	visitorImportantDetail = visitorImportantDetailService.saveVisitorImportantDetail(visitorImportantDetail);

三、VisitorImportantDetailPo实体类

public class VisitorImportantDetailPo{
    
    	private LinkedHashMap<String,Object> informationMap;
    	private LinkedHashMap<String,Object> taskMap;
    	private LinkedHashMap<String,Object> signMap;
    	public LinkedHashMap<String, Object> getInformationMap() {
    		return informationMap;
    	}
    	public void setInformationMap(LinkedHashMap<String, Object> informationMap) {
    		this.informationMap = informationMap;
    	}
    	public LinkedHashMap<String, Object> getTaskMap() {
    		return taskMap;
    	}
    	public void setTaskMap(LinkedHashMap<String, Object> taskMap) {
    		this.taskMap = taskMap;
    	}
    	public LinkedHashMap<String, Object> getSignMap() {
    		return signMap;
    	}
    	public void setSignMap(LinkedHashMap<String, Object> signMap) {
    		this.signMap = signMap;
    	}
    	
    }

四、数据库效果如下

![70][]

![70 1][]

从数据库读取到数据后替换页面即可

[70]: /images/20220514/5663b456b3a24d488dcf1a4a4aadff19.png
[70 1]: /images/20220514/933753bbdf9c4aa68a37bd5a5a3d664e.png