jfinal 常用方法

-------取值-------
取页面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}&nbsp;/&nbsp;${retlist.a9}</h4>
                   <h5>生产企业：${retlist.a8}</h5>
                   <p class="mui-h6 mui-ellipsis">数量：${retlist.a5}&nbsp;&nbsp;
                    单价:<fmt:formatNumber type="number" value="${retlist.a6}" pattern="0.00" maxFractionDigits="2"/>&nbsp;&nbsp;
                    金额:<fmt:formatNumber type="number" value="${retlist.a7}" pattern="0.00" maxFractionDigits="2"/>
                   </p>
                   <p class="mui-h6 mui-ellipsis">批号：${retlist.a27}&nbsp;&nbsp;效期：${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;
}
});