ibatis查询oracle分页

ibtais配置分页模糊查询

Java代码










                     bmzdm LIKE '%$objCondition.bmzdm$%'


                    AND rymc LIKE '%$objCondition.rymc$%'






分页模型通用类

Java代码
public class Page implements java.io.Serializable{

    public void setPageProperty(Page page) {
        if(page.getStart()>0){
        // 设置取数据的区间
        int endPage=page.getStart()+page.getLimit();
        int stratPage=page.getStart();
        this.setStart(stratPage);
        this.setLimit(endPage);
        }else{
            this.setLimit(page.getLimit());
            this.setStart(0);
        }
    }


    private int totalProperty;


    private List root;


    private int start;


    private int limit;


    private boolean success;


    private Object objCondition;
实体类
Java代码
public class Rydm implements Serializable{

    private String rydm;

    private String rymc;

    private String bmzdm;

服务层调用
Java代码
public class RydmServiceImpl extends SqlMapClientDaoSupport implements
        RydmService {

public Page findByPageRydm(Page page) throws BusinessException {
        page.setTotalProperty((Integer) getSqlMapClientTemplate()
                .queryForObject("RYDM.findByCount", page));
        page.setPageProperty(page);
        page.setRoot(getSqlMapClientTemplate().queryForList(
                "RYDM.findByPage", page));
        return page;
    }

action设置分页属性
Java代码
public class UsersAction extends ActionSupport implements ServletRequestAware,
SessionAware{
    public String message;
    public String conditions;
    protected Map session;//会话对象
    protected HttpServletRequest request;//请求对象

    public String listUser() {
        Rydm user=new   Rydm();
        user.setBmzdm(request.getParameter("bmzdm").toString());
        user.setRymc(request.getParameter("rymc").toString());
        int start =0;
        int Limit=10;
        Page page = new Page();
       try {
        start = Integer.valueOf(getRequest().getParameter("start"));
        Limit = Integer.valueOf(getRequest().getParameter("limit"));
        }catch (NumberFormatException e) {
        }
        page.setStart(start);
        page.setLimit(Limit);
        //使用对象作为查询参数传入ibtais
        page.setObjCondition(user);
        page = userService.findByPage(page);
        } catch (BusinessException e) {
            log.warn("UsersAction.class查询用户信息出现异常"+e.getMessage(), e);
        }
        return SUCCESS;
    }
}
返回配置我是使用了ext 所以转换json 显示到客户端
Java代码




                page
                limit,start,objCondition



extjs 参数查询
Js代码
var rydm_store = new Ext.data.Store({
    proxy : new Ext.data.HttpProxy({
        url : "/extDemo/admin/userList.action",
        method:"post"
    }),
    reader : new Ext.data.JsonReader({
        totalProperty : 'totalProperty',
        root : 'root',
        fields : [ {
            name : 'bmzdm',
            type : 'string'
        } , {
            name : 'bmmc',
            type : 'string'
        }]
    })
});

var btn_search_rydm = new Ext.Button({
    text : '查询',
    iconCls : 'icon-search',
    handler : queryRydm
});

var queryRydm = function() {
    rydm_store.baseParams.bmzdm= bmzdm_search_rydn.getValue();
    rydm_store.baseParams.rymc =text_search_rydm.getValue();
    rydm_store.load({params : {start : 0,limit : 15}});

}

ITPub博客

ibatis查询oracle分页