<resultMap id="BaseResultMap" type="com.transcore.common.dal.model.PaymentDO">
<id column="ID" property="id"/>
<result column="BUSINESS_CHANNEL" property="businessChannel"/>
<result column="CURRENCY_CODE" property="currencyCode"/>
<result column="PAYMENT_MODE" property="paymentMode"/>
<result column="TRANS_ID" property="transId"/>
<result column="OPERATOR_IP" property="operatorIp"/>
<result column="OPERATOR_ID" property="operatorId"/>
<result column="AMOUNT" property="amount"/>
<result column="STATUS" property="status"/>
<result column="CREATE_TIME" property="createTime"/>
<result column="MODIFY_TIME" property="modifyTime"/>
</resultMap>
<resultMap id="detailPaymentMap" type="com.transcore.common.dal.model.PaymentDO"
extends="BaseResultMap">
<collection property="paymentDetailList" column="PAYMENT_ID"
ofType="com.transcore.common.dal.model.PaymentDetailDO">
<id column="PD_ID" property="id"/>
<result column="PAYMENT_ID" property="paymentId"/>
<result column="PAYMENT_TYPE" property="paymentType"/>
<result column="CREDENTIAL_ID" property="credentialId"/>
<result column="CREDENTIAL_NAME" property="credentialName"/>
<result column="CURRENCY_CODE" property="currencyCode"/>
<result column="PD_AMOUNT" property="amount"/>
<result column="PD_CREATE_TIME" property="createTime"/>
<result column="PD_MODIFY_TIME" property="modifyTime"/>
<result column="EXTERNAL_FIELDS" property="externalFields"/>
<result column="SUB_PAY_TYPE" property="subPayType"/>
<result column="FOREIGN_AMOUNT" property="foreignAmt"/>
<result column="FOREIGN_CURRENCY" property="foreignCcy"/>
<result column="EXCHANGE_RATE" property="exchangeRate"/>
</collection>
</resultMap>
<sql id="Base_Column_List">
ID, BUSINESS_CHANNEL, CURRENCY_CODE, PAYMENT_MODE, TRANS_ID,
OPERATOR_IP, OPERATOR_ID, AMOUNT, STATUS, CREATE_TIME, MODIFY_TIME
</sql>
<select id="queryPaymentDetailByPage"
resultMap="detailPaymentMap" parameterType="map">
select
p.ID, p.BUSINESS_CHANNEL, p.CURRENCY_CODE, p.PAYMENT_MODE, p.TRANS_ID,
p.OPERATOR_IP, p.OPERATOR_ID, p.AMOUNT, p.STATUS, p.CREATE_TIME, p.MODIFY_TIME,
pd.ID AS PD_ID, pd.PAYMENT_ID, pd.PAYMENT_TYPE, pd.CREDENTIAL_ID, pd.CREDENTIAL_NAME,
pd.CURRENCY_CODE, pd.AMOUNT AS PD_AMOUNT, pd.CREATE_TIME AS PD_CREATE_TIME
, pd.MODIFY_TIME AS PD_MODIFY_TIME,pd.EXTERNAL_FIELDS AS EXTERNAL_FIELDS,
pd.SUB_PAY_TYPE as SUB_PAY_TYPE,
pd.FOREIGN_AMOUNT as FOREIGN_AMOUNT,
pd.FOREIGN_CURRENCY as FOREIGN_CURRENCY,
pd.EXCHANGE_RATE as EXCHANGE_RATE
from T_TRANSCORE_PAYMENT p INNER JOIN T_TRANSCORE_PAYMENT_DETAIL pd
ON p.ID = pd.PAYMENT_ID
where p.TRANS_ID = #{id}
<if test="status != null">AND p.STATUS = #{status}</if>
<if test="payType != null">AND pd.PAYMENT_TYPE = #{payType}</if>
<if test="paymentId != null">AND p.ID = #{paymentId}</if>
order by p.CREATE_TIME desc
</select>
分享到:
相关推荐
springmvc+mybaits配置示例
mybatis3.1.1和spring3.0.5整合时,applicationContext的配置,整合时使用mybatis-spring-1.1.1.jar
例子中对MyBatis的配置做了很多的注释,简单易懂
springboot 整和 mybaits 里边包括 一对一,一对多,多对多的多表联查 环境搭建请参考 https://blog.csdn.net/Insist___/article/details/104219471
NULL 博文链接:https://qerooy.iteye.com/blog/2086405
springboot 集成mybits mysql和freemark模板引擎demo,本demo在mybaits中sql用到springboot默认注解sql以及spring的mapping映射*.xml 两种方式,而且配置操作日志(sql打印)
文档中主要说明:(1)多表联合查询步骤,快捷便利;(2)数据批量插入,以及相关的案例,节省运行资源。
Mybaits 技术文档 可以有效说明mybaits的开发
此源码包含mybaits的增删改,springmvc的页面跳转,mybaits配置详细注解 试用Oracle数据库
mybaits反向工程mybaits反向工程mybaits反向工程mybaits反向工程mybaits反向工程mybaits反向工程mybaits反向工程
springmvc+mybaits 做的一个查询列表 以及分页功能 带数据库
mybaits的使用和配置,具体的参数结构和配置相关的信息,导入可以看具体的信息
手写mybaits框架代码手写mybaits框架代码手写mybaits框架代码手写mybaits框架代码手写mybaits框架代码手写mybaits框架代码手写mybaits框架代码手写mybaits框架代码手写mybaits框架代码手写mybaits框架代码手写...
主要介绍了Mybaits配置文件之动态SQL配置备忘录的相关资料,需要的朋友可以参考下
1、基于yml 配置方式 ,实现springBoot+sharding-jdbc+mybatis-plus 实现分库分表,读写分离,以及全局表,子表的配置。 2、实现mybatis-plus 整合到springboot 详细使用请看 测试用例
mybaits通过maven构建的最新jar包文件
mybaits逆向工程....................................................................................
SpringMvC+Mybaits 有点乱
最简单mybaits实例项目,入门级者,可以很快掌握的
Spring 配置多数据源的方式可以分成两大类情况:表级上的跨数据库和非表级上的跨数据库。表级上的跨数据库是指不同的数据库却有相同的表(表名和表结构完全相同),而非表级上的跨数据库是指多个数据源不存在相同的...