list( String searchkey, String searchValue, String order)
public Page list(int pageNO, int pageSize,int disabled, String searchkey,
String searchValue, String order) {
StringBuffer sql = new StringBuffer("select * from order where disabled=? ");
if(!StringUtil.isEmpty(searchkey) && !StringUtil.isEmpty(searchValue) ){
sql.append(" and ");
sql.append(searchkey);
sql.append("=?");
}
order = StringUtil.isEmpty(order)?"order_id desc":order;
sql.append(" order by "+ order);
Page page =null;
if(!StringUtil.isEmpty(searchkey) && !StringUtil.isEmpty(searchValue) ){
page = this.baseDaoSupport.queryForPage(sql.toString(), pageNO, pageSize, Order.class,disabled, searchValue);
}else{
page = this.baseDaoSupport.queryForPage(sql.toString(), pageNO, pageSize, Order.class,disabled);
}
return page;
}
阿里云国内75折 回扣 微信号:monov8 |
阿里云国际,腾讯云国际,低至75折。AWS 93折 免费开户实名账号 代冲值 优惠多多 微信号:monov8 飞机:@monov6 |