mybatis 三表联查

fh_su fh_su 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
<mapper namespace="com.travelsky.mapper.Emd_ticket_infoMapper">


<resultMap type="Emd_ticket_info" id="Emd_ticket_info">
<result property="id" column="id"/>
<result property="ticketNo" column="ticketNo"/>
<result property="carrFlightNo" column="carrFlightNo"/>
<result property="departDate" column="departDate"/>
<result property="departCityCode" column="departCityCode"/>
<result property="arriCityCode" column="arriCityCode"/>
<result property="classType" column="classType"/>
<result property="trvlName" column="trvlName"/>
<result property="trvlPhone" column="trvlPhone"/>
<result property="trvlEmail" column="trvlEmail"/>
<result property="PNR" column="PNR"/>
<result property="remark" column="remark"/>
<collection property="Emd_info" javaType="Emd_info" resultMap="Emd_info"/>
</resultMap>

<resultMap type="Emd_info" id="Emd_info">
<result property="id" column="id"/>
<result property="ticketNo" column="ticketNo"/>
<result property="carrFlightNo" column="carrFlightNo"/>
<result property="orderID" column="orderID"/>
<result property="emdTicketNo" column="emdTicketNo"/>
<result property="paymentStatus" column="paymentStatus"/>
<result property="currCode" column="currCode"/>
<result property="total" column="total"/>
<result property="Status" column="Status"/>
<result property="SeatLocation" column="SeatLocation"/>
<result property="seatType" column="seatType"/>
<result property="packNum" column="packNum"/>
<result property="fcMethod" column="fcMethod"/>
<result property="seatvaluelevel" column="seatvaluelevel"/>
<result property="packWeight" column="packWeight"/>
<result property="remark" column="remark"/>
<collection property="Emd_operating_info" javaType="Emd_operating_info" resultMap="Emd_operating_info"/>
</resultMap>
<resultMap type="Emd_operating_info" id="Emd_operating_info">
<result property="id" column="id"/>
<result property="orderId" column="orderId"/>
<result property="login_user" column="login_user"/>
<result property="operationTime" column="operationTime"/>
<result property="Opr_status" column="Opr_status"/>
<result property="Opr_flag" column="Opr_flag"/>
<result property="ErrorType" column="ErrorType"/>
<result property="ErrorCode" column="ErrorCode"/>
<result property="ErrorText" column="ErrorText"/>
<result property="remark" column="remark"/>
</resultMap>


<select id="QueryNotPayOrder" parameterType="String" resultMap="Emd_ticket_info">
SELECT c.departDate,c.departCityCode,c.arriCityCode,c.classType,a.ticketNo,a.carrFlightNo,a.orderID,
a.emdTicketNo,
a.SeatLocation,a.seatType,b.operationTime FROM emd_ticket_info c,emd_info a,emd_operating_info b
WHERE a.Status = b.Opr_status AND a.orderID = b.orderId AND c.ticketNo = a.ticketNo AND
a.carrFlightNo = c.carrFlightNo AND b.Opr_status = '0'
</select>



调用这个sql的时候 就直接跳到这里 下图


是我哪点配置错了吗
...全文
评论 9
收藏 已收藏
分享
返回顶部
fh_su
Java EE 67,535 成员 225,843 内容