有两张表,一张为GUEST代表旅客,一张为PREORDER代表订单,现在我想要用户输入GUEST旅客的名字GNAME就能查询到PREORDER订单,如何做到?
PREORDER中有一个字段GID作为外键关联到GUEST中的主键GID,但是旅客的名字GNAME却什么都不是,只是GUEST中的普通字段而已
我觉得我已经描述的很清楚了吧,代码还需要贴嘛? 求大神解惑呀..
/p>
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
select p.*,g.gname,r.rt_name from preOrder p left join guest g on p.gid=g.gid left join roomtype r on p.rt_id=r.rt_id where po_id=#{po_id}
and poCreateTime between #{beginDate} and #{endDate}
order by
po_id
poCreateTime
ASC
DESC
select * from
(select row_number() over(
= #{pageno} and rn <= #{pagesize} ]]>
useCache="true" flushCache="false">
) rn,p.* from preOrder p
select count(po_id) from preOrder