JFinal

登录 注册

Db.paginate分页出错

String sql=" FROM shop_food_order o,shop_restaurant r ,security_user u where o.sEmpCode=r.id and u.user_info_id=o.memberId  and sn like '%'".concat("?").concat("%'");

            //sb.append(" and sn like '%").append(sn).append("%'");

    list = Db.paginate(pageNumber, PAGE_SIZE,"SELECT o.*,r.name as rname,u.realname ",sql,sn);

带条件查询出不来

list = Db.paginate(pageNumber, PAGE_SIZE,"SELECT o.*,r.name as rname,u.realname "," FROM shop_food_order o,shop_restaurant r ,security_user u where o.sEmpCode=r.id and u.user_info_id=o.memberId ");

没有条件的没报错,求指点

评论

  • 01-10 18:07
    sn like '%"多了一个单引号,
  • 01-10 18:16
    这篇文档中有关于 like 的使用:
    https://www.jfinal.com/doc/5-13
  • 01-11 09:35
    @JFinal ,示例中的all.sql文件是放在webapp根目录下吗
  • 01-11 09:39
    @JFinal 已解决
  • 01-11 10:08
    @JFinal #sql("findorder")
    SELECT o.*,r.name as rname,u.realname FROM shop_food_order o,shop_restaurant r ,security_user u where o.sEmpCode=r.id and u.user_info_id=o.memberId and o.sn like concat('%', #para(0), '%')
    #end
    SqlPara sqlPara = Db.getSqlPara("findorder", sn);
    list =Db.paginate(pageNumber, PAGE_SIZE, sqlPara);
    System.out.print(list);
    结果
    pageNumber : 1
    pageSize : 20
    totalPage : 1
    totalRow : 3 为什么结果还是出不来呢
  • 01-11 10:12
    @JFinal 应该说是页面上还是显示所有的记录而不是查询出来的3条
  • 01-11 10:15
    @JFinal 已解决是别的错误,不好意思
  • 发送