<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的时候 就直接跳到这里 下图![mybatis 三表联查 mybatis 三表联查](https://www.codebye.com/wp-content/uploads/2016/07/-14191692785513756.jpg)
是本人哪点配置错了吗
<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的时候 就直接跳到这里 下图
![mybatis 三表联查 mybatis 三表联查](https://www.codebye.com/wp-content/uploads/2016/07/-14191692785513756.jpg)
是本人哪点配置错了吗
解决方案
20
There is no getter for property named “Emd_info” in “class com.travelsky.model.Emd_ticket_info”
看起来像是没写get、set方法
看起来像是没写get、set方法
30
仔细看看xml的属性名和class com.travelsky.model.Emd_ticket_info里的能否一样,区分大小写