java代码如下：
@SuppressWarnings({ "rawtypes", "unchecked" })
@RequestMapping(value = "/xungeng.jspx",method = RequestMethod.GET)
protected String pollingQuery(HttpServletRequest request,HttpServletResponse response, ModelMap model) throws Exception {
CmsSite site = CmsUtils.getSite(request);
String op = request.getParameter("op");
//获取查询日期
// Map<List> resultMap = new HashMap<List>();
Map<String, List> resultMap = new HashMap<String, List>();
String str = request.getParameter("op").trim().toString();
try {
String conStr = request.getRealPath("/")+"WEB-INF/config/jdbc.properties";
conStr = conStr.replace("\\", "/");
con =this.init(conStr);
String sql1 = "select id, pollingAddrssName ,pollingAddressId from jc_pollingAddress";
ps = con.prepareStatement(sql1);
rsCard = ps.executeQuery();
while(rsCard.next()){
// System.out.println(rsCard.getString("id")+"--" + rsCard.getString("pollingAddrssName")+"--" + rsCard.getString("pollingAddressId"));
//获取某一日期str(2012-07-03)的晚上八点到2012-07-04早上八点的所有巡查记录数据
String sql2="select * from " +
"(select personCard,personName,pollingTime,addressCard,addressName,eventNum,machineNum,lineNum,jc_pollingAddress.id,pollingAddrssName,pollingAddressId from jc_importExl_copy ,jc_pollingAddress where pollingTime < (select date_add('"+str+" 20:00:00', interval 12 hour)) and pollingTime >= (select date_add('"+str+" 20:00:00', interval 0 hour))) newResult " +
"where addressCard = '"+rsCard.getString("pollingAddressId")+"' and pollingAddressId = '"+rsCard.getString("pollingAddressId")+"' order by pollingAddrssName, pollingTime;";
// System.out.println(sql2);
ps = con.prepareStatement(sql2);
rsResult = ps.executeQuery();
List resultList = new ArrayList();
while(rsResult.next()){
resultList.add(rsResult.getString("personCard"));
resultList.add(rsResult.getString("personName"));
resultList.add(rsResult.getString("pollingTime"));
resultList.add(rsResult.getString("addressCard"));
resultList.add(rsResult.getString("addressName"));
resultList.add(rsResult.getString("eventNum"));
resultList.add(rsResult.getString("machineNum"));
resultList.add(rsResult.getString("lineNum"));
resultList.add(rsResult.getString("pollingAddrssName"));
resultList.add(rsResult.getString("pollingAddressId"));
model.put("map"+rsCard.getString("pollingAddressId").toString(), resultList);
// 将request中所有参数保存至model中。
model.putAll(RequestUtils.getQueryParams(request));
FrontUtils.frontData(request, model, site);
FrontUtils.frontPageData(request, model);
}
}
} catch (Exception e) {
e.printStackTrace();
}
return FrontUtils.getTplPath(request, site.getSolutionPath(),
TPLDIR_SPECIAL, XUNGENG_INDEX);
}
html页面输出值代码如下：
<#list map0012 as c >
${c.pollingTime}
</#list>
但是报错：
Expected hash. c evaluated instead to freemarker.template.SimpleScalar on line 130, column 11 in WEB-INF/t/cms/www/red/special/电子巡更.html. The problematic instruction: ---------- ==> ${c.pollingTime} [on line 130, column 9 in WEB-INF/t/cms/www/red/special/电子巡更.html]
各位，有什么问题，帮帮忙看看把 ~~~ 在线等~~ |
|
