开发采用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
SELECT COUNT(*) FROM RYDM ry where 1=1
分页模型通用类
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);
}e