-
BaseDAO
通过书籍名字模糊查询数据,并且具备分页的功能
-
原生sql
hql实现不了的功能,可以考虑使用原生sql1、配置关系麻烦
2、复杂sql查询需求:统计订单表中的订单对应的所有订单项中,某一书籍的销量。
select oi.selfNo,t.bname from t_hibernate_book b,t_hibernate_Oerder o,t_hibernate_Oerder_item oi
where o.orderid = oi.oid and b.bid = oi.product_idsql->hql
from Book
-
视图映射
select oi.selfNo,t.bname from t_hibernate_book b,t_hibernate_Oerder o,t_hibernate_Oerder_item oifunca(){ select oi.selfNo,t.bname from t_hibernate_book b,t_hibernate_Oerder o,t_hibernate_Oerder_item oi where bname like '%?%' } funca(){ select oi.selfNo,t.bname from t_hibernate_book b,t_hibernate_Oerder o,t_hibernate_Oerder_item oi where order_no > 343 } funca(){ select oi.selfNo,t.bname from t_hibernate_book b,t_hibernate_Oerder o,t_hibernate_Oerder_item oi where product_id = 1213 } funca(){ slect * from DDD,(select oi.selfNo,t.bname from t_hibernate_book b,t_hibernate_Oerder o,t_hibernate_Oerder_item oi) }
两张表 hql
三张以上 原生sql、视图、存储过程
SELECT @rowno:=@rowno + 1 AS rowno,a.* FROM tableName a,(SELECT @rowno:=0) b