开发采用spring+struts+ibatis+extjs，数据库用oracle
ibtais配置分页 模糊查询
Java代码
bmzdm LIKE '%$objCondition.bmzdm$%'
AND rymc LIKE '%$objCondition.rymc$%'
resultClass="abatorgenerated_RydmResult">
SELECT * FROM (SELECT row_.*, rownum rownum_ FROM
(select ry.* from RYDM ry
where 1=1
)row_ WHERE rownum <= $limit$)row_ WHERE rownum_ >$start$
ORDER BY rydm
分页模型通用类
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 boolean success;
/** 查询条件 */
private Object objCondition;
实体类
Java代码
public class Rydm implements Serializable{
/**
* This field was generated by Abator for iBATIS.
* This field corresponds to the database column RYDM.RYDM
*
* @abatorgenerated Sat Aug 06 16:55:26 CST 2011
*/
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.cl