(J2EE)Struts+Spring+MyBatis整合实现分页分页查询(三)
return_date,
return_flag,
rownum rn
FROM bm_borrow)
where rn <= #{endRow} )
where rn > #{startRow}
]]>
select count(*) from bm_borrow
实体层
[java]
package com.qianyan.bm.rack.po;
import java.util.Date;
public class Borrow{
private int id;
private int managerId;
private int borrowerId;
private int bookId;
private Date borrowDate;
private Date returnDate;
private String returnFlag;
private Book book;
public Borrow(){
}
省略Set和Get方法
}
展示层
[java]