分页 联接查询
分页 连接查询
public PageObject bookList(PageParameter req, Map args) {
String sql = " select BID as ID,BNAME,BREMARK,BCOVER,USERNAME as CREATEDID,
TO_CHAR(CREATEDTIME,'YYYY-MM-DD HH24:MI:SS') as CREATEDTIME
from tbbook b, tbuser u where b.CREATEDID = u.userid ";
if (args.get("bname") != null
&& ObjectUtils.toString(args.get("bname")).length() != 0) {
sql += " and bname=:bname ";
}
sql += " order by b.createdtime asc ";
return queryForSQLList(sql, req, args);
}