mybatis 三表联查

fh_su 2016-05-27 11:11:41
<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的时候 就直接跳到这里 下图


是我哪点配置错了吗
...全文
3104 9 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
9 条回复
切换为时间正序
请发表友善的回复…
发表回复
键圣 2016-05-27
  • 打赏
  • 举报
回复
是不是你打断点或者debug进去的,如果有错,控制台会有错误信息,你把那个信息贴出来
wu3431214 2016-05-27
  • 打赏
  • 举报
回复
你自己定了已resultMap中包含了另外的resultMap,但是实体类中没有get、set方法
fh_su 2016-05-27
  • 打赏
  • 举报
回复
引用 6 楼 study_zhao 的回复:
仔细看看xml的属性名和class com.travelsky.model.Emd_ticket_info里的是否一样,区分大小写
就是 上面 第一个图 找不到引用源 是缺少jar包么
fh_su 2016-05-27
  • 打赏
  • 举报
回复
引用 6 楼 study_zhao 的回复:
仔细看看xml的属性名和class com.travelsky.model.Emd_ticket_info里的是否一样,区分大小写
上面的问题 已经好了 是由于在配置文件注入的时候 property 里面的是大写 还有 现在就是 debug的时候 进不去 方法 我ctrl 能点进去 这是为什么
_叶轻舟 2016-05-27
  • 打赏
  • 举报
回复
仔细看看xml的属性名和class com.travelsky.model.Emd_ticket_info里的是否一样,区分大小写
拘谨的小人 2016-05-27
  • 打赏
  • 举报
回复
每次看到 resultMap 都感觉
fh_su 2016-05-27
  • 打赏
  • 举报
回复
引用 3 楼 qnmdcsdn 的回复:
There is no getter for property named 'Emd_info' in 'class com.travelsky.model.Emd_ticket_info' 看起来像是没写get、set方法
有的 public Emd_info getEmd_info() { return emd_info; } public void setEmd_info(Emd_info emd_info) { this.emd_info = emd_info; }
  • 打赏
  • 举报
回复
There is no getter for property named 'Emd_info' in 'class com.travelsky.model.Emd_ticket_info' 看起来像是没写get、set方法
fh_su 2016-05-27
  • 打赏
  • 举报
回复
引用 1 楼 jiaotuwoaini 的回复:
是不是你打断点或者debug进去的,如果有错,控制台会有错误信息,你把那个信息贴出来
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>

67,550

社区成员

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器,保护我们的业务核心组件(中间件),以延续它的生命力,而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧