-------取值-------
取页面input_kh参数值,并去首尾空格
String ls_kh=getPara("input_kh").trim()
取页面日期并转换成无符号格式
String ls_a17s=base.fn_dataformat(getPara("sdate").trim());
取SQL返回值,并返回到list中
List<Record> retlist = Db.find(ls_sql);
取List行记录
Record map = (Record)retlist.get(i);
数据转换字符
Record map = (Record)retlist.get(i);
Object ob = map.get("a25");//先将数据转成
str_a25=ob.toString();
循环取行记录,并增加一个list明细
for(int i=0;i<retlist.size();i++){
Record map = (Record)retlist.get(i);
Object ob = map.get("a25");//先将数据转成
str_a25=ob.toString();
String ls_sql2="select a27,a28,sum(a13)a13 from gkkc where a13>0 and a25="+str_a25+" group by a27,a28";
List<Record> retlist2 = Db.find(ls_sql2);
//增加一个list明细
map.set("listmx", retlist2);
}
-------返回-------
返回字符串
setAttr("retlist","ok");
返回list,并返回页面
setAttr("retlist",retlist);
render("/wxbb/r1.jsp");
返回json格式
renderJson();
-------页面接收--------
jfinal例子
<ul class="mui-table-view mui-table-view-striped mui-table-view-condensed">
<li class="mui-table-view-cell">
<c:choose>
<c:when test="${retlist== null || fn:length(retlist) == 0}">
无数据
</c:when>
<c:otherwise>
<c:forEach items="${retlist}" var="retlist">
<div class="mui-table">
<div class="mui-table-cell mui-col-xs-10">
<h4 class="mui-ellipsis">${retlist.a2} / ${retlist.a9}</h4>
<h5>生产企业:${retlist.a8}</h5>
<p class="mui-h6 mui-ellipsis">数量:${retlist.a5}
单价:<fmt:formatNumber type="number" value="${retlist.a6}" pattern="0.00" maxFractionDigits="2"/>
金额:<fmt:formatNumber type="number" value="${retlist.a7}" pattern="0.00" maxFractionDigits="2"/>
</p>
<p class="mui-h6 mui-ellipsis">批号:${retlist.a27} 效期:${retlist.a28}</p>
<p class="mui-h6 mui-ellipsis">客户名称:${retlist.kh_name}</p>
</div>
<div class="mui-table-cell mui-col-xs-2 mui-text-right">
<span class="mui-h5"></span>
</div>
</div>
</c:forEach>
</c:otherwise>
</c:choose>
</li>
</ul>
<div style='text-align:center'>
<br/>无数据
</div>
ajax接收例子
$.ajax({
url:ls_fnstr, --地址格式 ls_apppath+方法+'?'+参数
type:'post',
success: function(data)
{
document.getElementById('data3').innerHTML=data.retlist;
}
});
转载于:https://my.oschina.net/need/blog/1083254