ligerui做分页显示数据

现在前台技术用到的是ligerui，一直想写一个有关ligerui的显示，利用加班的今天偷点闲复制一下下，当自己的一些小资料吧，不会的时候，还可以来看看............稍微有点多，毕竟是从前后台一起写的，后台技术用到spring、mybatis。全部全部过程！

 html：

<div id="grid"></div>

 

js:

var grid;//
var columns;
$(function(){
     grid = $("#grid").ligerGrid({
                columns: columns,
                url: '/MCS/loanappro/getLoanApproveCommWithPagingList.do?openType='+openType,
                sortName: 'bill_code', // 排序列名
                sortOrder: 'asc', // 排序方式
                rownumbers: true,
                allowUnSelectRow: true,
                usePager: true,
                width: '100%',
                height: '100%',
                heightDiff: -4,
                parms: {
                    _filterParms: -1
                }
            });
});

var columns=[
         display: '单据编号',
                name: 'bill_code',
                width: 110,
                minWidth: 110,
                //添加超链接的东西
                render: function (rowdata, rowindex, value) { 
                    return '<a href="javascript:creditInfo('+rowdata.mcs_cre_credit_head_id+');" style="color:#056AFF;text-decoration: none;">'+value+'</a>';
                },
            },{
            display: '申请时间',
                name: 'create_timestamp',
                width: 150,
                minWidth: 150

},{
        display: '贷款种类', 
              name:'loan_types',
              isSort: false, 
              width:100,
              render: function (rowdata, rowindex, value){
                  var h = "";
                  if (!rowdata._editing){
                      h += "抵押<input type='checkbox' style='width:20px;'/>";
                      h += "信用<input type='checkbox'  style='width:20px;'/> "; 
                  }else{
                      h += "抵押<input type='checkbox'  style='width:20px;'/>";
                      h += "信用<input type='checkbox'  style='width:20px;'/> "; 
                  }
                  return h;
              }

}

];

前台我就简写了三列，可根据情况自己添写字段。

下面介绍到后台

Controller：

package com.goldcow.emanage.loanappro.web;
@Controller
public class McsCreCreditApproController
{
    /**
     * 查询列表分页
     * @param queryInfo
     * @return
     */
    @RequestMapping(value="/loanappro/getLoanApproveCommWithPagingList.do",method={RequestMethod.GET,RequestMethod.POST})
    @ResponseBody
    public Map<String,Object> getLoanApproveCommWithPagingList(McsCreApproSearchBean queryInfo,HttpServletRequest request, String openType){
        //获取当前登录人
        HttpSession session = request.getSession();
        UserBean user =(UserBean)session.getAttribute(GlobalVal.USER_SESSION);
        return mcscrecreditapproService.getLoanApproveCommWithPagingList(queryInfo,user,openType);
    }
}

service就不写了，直接写serviceImpl的内容：

package com.goldcow.emanage.loanappro.service.impl;
@Service("mcscrecreditapproService")
public class McsCreCreditApproServiceImpl implements IMcsCreCreditApproService
{ 
    @Override
    public Map<String, Object> getLoanApproveCommWithPagingList(
            McsCreApproSearchBean queryInfo, UserBean user, String openType) {
    Map<String,Object> paramMap=new HashMap<String,Object>();
     paramMap.put("sortname", queryInfo.getSortname());
        paramMap.put("sortorder", queryInfo.getSortorder());
        paramMap.put("offset", queryInfo.getOffset());
        paramMap.put("pagesize", queryInfo.getPagesize());
        List<Map<String,Object>> list=mcscrecreditapproDao.getLoanApproveCommWithPagingList(paramMap);//查询search
        GridDataBean<Map<String,Object>> bean =new GridDataBean<Map<String,Object>>(queryInfo.getPage(),mcscrecreditapproDao.getLoanApproveCommCount(paramMap),list);//getPage():第几页  getLoanApproveCommCount():查询共有条数据  list:查询
        return bean.getGridData();

}
}

接下来就是dao了：

package com.goldcow.emanage.loanappro.persist;
@MyBatisRepository
public interface McsCreCreditApproDao{
       List<Map<String,Object>> getLoanApproveCommWithPagingList(Map<String,Object> paramMap);

    int getLoanApproveCommCount(Map<String,Object> paramMap);
}

xml：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- namespace必须指向Dao接口 -->
<mapper namespace="com.goldcow.emanage.loanappro.persist.McsCreCreditApproDao">
   <select id="getLoanApproveCommCount" parameterType="map"  resultType="int">
    select count(

mcs_cre_credit_experience_points_main_id

) as count from mcs_cre_credit_head 

</select> 

<select id="getLoanApproveCommWithPagingList" parameterType="map" resultType="java.util.HashMap"> 
　　select 
　　mcs_cre_credit_head_id,
 　　bill_code, 
　　credit_purpose, 
max_repayment_limit_per_month,
 credit_limit
 from mcs_cre_credit_head
 <if test="sortname!=null and sortorder!=null">
 order by ${sortname} ${sortorder} 
</if>
 <if test="offset!=null and pagesize!=null">
 limit ${offset},${pagesize} 
</if> 
</select> 

</mapper>

缺少一个bean

package com.goldcow.emanage.util.gen.entity;
/**
 * 个人银行贷款
 * @author xuxiaohua
 *
 */
public class McsCreApproSearchBean extends GridParamBean implements BaseEntity{
    private Integer mcs_cre_credit_head_id;
    
    private String bill_code;
    
    private String credit_purpose;
    
    private Double max_repayment_limit_per_month;
    
    private Double credit_limit;
    
    private Integer max_repayment_time_limit;
        //封装好这些私有字段之后
       
        /**
    * default val cols name array
    */    
    private static String[] defaultValColArr = {
    };
    
    /**
    * pk cols name array
    */    
    private static String[] pkColArr = {
          "mcs_cre_credit_head_id"
    };
    
         private static String[] columnNameArr = {
        "mcs_cre_credit_head_id",
        "bill_code",
        "credit_purpose",
        "max_repayment_limit_per_month",
        "credit_limit",
        "max_repayment_time_limit"
             }

              /**
    * put all columns into a map
    */
    public void putInMap(Map<String, Object> paramMap) {
        paramMap.put("mcs_cre_credit_head_id", this.mcs_cre_credit_head_id);
        paramMap.put("bill_code", this.bill_code);
        paramMap.put("credit_purpose", this.credit_purpose);
        paramMap.put("max_repayment_limit_per_month", this.max_repayment_limit_per_month);
        paramMap.put("credit_limit", this.credit_limit);
        paramMap.put("max_repayment_time_limit", this.max_repayment_time_limit);
             }
              
     /**
    * return the columns map
    */
    public Map<String, Object> getInfoMap() {
        Map<String, Object> paramMap = new HashMap<String, Object>();
        this.putInMap(paramMap);
        return paramMap;
    }
    
    /**
    * remove default value and pk if it is null
    */
    private Map<String, Object> dealWithMap(Map<String, Object> paramMap) {
        Set<String> set = new HashSet<String>();
        for (String colName : defaultValColArr) {
            set.add(colName);
        }
        for (String colName : pkColArr) {
            set.add(colName);
        }
        Iterator<String> iterator = set.iterator();
        while (iterator.hasNext()) {
            String colName = iterator.next();
            if(paramMap.get(colName) == null) {
                paramMap.remove(colName);
            }
        }
        return paramMap;
    }
}

 

好像已经写完了，啊，格式有点乱，凑合看吧！这个摁tab键也不好用啊。

有时间弄一份easyui的.

我觉得应该写一份有关mybatis的增删改查