自己项目里面的aos 查询数据的语法

最新推荐文章于 2022-02-18 21:20:56 发布

李乾坤lqk

最新推荐文章于 2022-02-18 21:20:56 发布

阅读量432

点赞数

本文链接：https://blog.csdn.net/u012960049/article/details/78328287

版权

StringBuffer sb = new StringBuffer("select * from"

               + " (select a.id ,a.name ,a.vendor_id , nvl(h.id,0) viwe ,v.vendor_name from app   a "
               + "left join hot h on a.id = h.app_id "
               + "left join vendor v on a.vendor_id = v.id "
               + "where a.state=0 and $like(a.name,app_name) and $equal(a.id,app_id)) x "

+ " order by viwe desc");

       /*sb.append(" and $like(NAME,app_name)");

       sb.append(" and $equal(A.ID,app_id)");*/


       return db.getListResultByPage(bus, new SqlInfo(String.valueOf(sb)));