<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的时候  就直接跳到这里  下图
是本人哪点配置错了吗