67,549
社区成员
发帖
与我相关
我的任务
分享mybatis 三表联查
<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的时候 就直接跳到这里 下图
是我哪点配置错了吗
<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的时候 就直接跳到这里 下图
是我哪点配置错了吗
...全文
请发表友善的回复…
发表回复
键圣 2016-05-27
- 打赏
- 举报
是不是你打断点或者debug进去的，如果有错，控制台会有错误信息，你把那个信息贴出来
wu3431214 2016-05-27
- 打赏
- 举报
你自己定了已resultMap中包含了另外的resultMap，但是实体类中没有get、set方法
fh_su 2016-05-27
- 打赏
- 举报
就是 上面 第一个图 找不到引用源 是缺少jar包么
fh_su 2016-05-27
- 打赏
- 举报
上面的问题 已经好了 是由于在配置文件注入的时候 property 里面的是大写
还有 现在就是 debug的时候 进不去 方法 我ctrl 能点进去 这是为什么
_叶轻舟 2016-05-27
- 打赏
- 举报
仔细看看xml的属性名和class com.travelsky.model.Emd_ticket_info里的是否一样，区分大小写
拘谨的小人 2016-05-27
- 打赏
- 举报
每次看到 resultMap 都感觉 
fh_su 2016-05-27
- 打赏
- 举报
有的 public Emd_info getEmd_info() {
return emd_info;
}
public void setEmd_info(Emd_info emd_info) {
this.emd_info = emd_info;
}
尼古拉斯-全蛋 2016-05-27
- 打赏
- 举报
There is no getter for property named 'Emd_info' in 'class com.travelsky.model.Emd_ticket_info'
看起来像是没写get、set方法
fh_su 2016-05-27
- 打赏
- 举报
Caused by: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'Emd_info' in 'class com.travelsky.model.Emd_ticket_info'
at org.apache.ibatis.reflection.Reflector.getGetInvoker(Reflector.java:372)
at org.apache.ibatis.reflection.MetaClass.getGetInvoker(MetaClass.java:167)
at org.apache.ibatis.reflection.wrapper.BeanWrapper.getBeanProperty(BeanWrapper.java:149)
at org.apache.ibatis.reflection.wrapper.BeanWrapper.get(BeanWrapper.java:45)
at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:113)
at org.apache.ibatis.executor.resultset.NestedResultSetHandler.instantiateCollectionPropertyIfAppropriate(NestedResultSetHandler.java:196)
at org.apache.ibatis.executor.resultset.NestedResultSetHandler.applyNestedResultMappings(NestedResultSetHandler.java:148)
at org.apache.ibatis.executor.resultset.NestedResultSetHandler.getRowValue(NestedResultSetHandler.java:118)
at org.apache.ibatis.executor.resultset.NestedResultSetHandler.handleRowValues(NestedResultSetHandler.java:89)
at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSet(FastResultSetHandler.java:193)
at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSets(FastResultSetHandler.java:159)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:57)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
这是 这个sql的错误 <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>
