MyBatis: Difference between revisions
Jump to navigation
Jump to search
| Line 45: | Line 45: | ||
==References== | ==References== | ||
* [https://github.com/mybatis/spring-boot-starter/tree/master/mybatis-spring-boot-samples/mybatis-spring-boot-sample-xml MyBatis Spring Boot Sample] | |||
* [https://mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/ MyBatis Spring Boot Starter] | |||
* [https://mybatis.org/mybatis-3/sqlmap-xml.html Mapper XML Files] | * [https://mybatis.org/mybatis-3/sqlmap-xml.html Mapper XML Files] | ||
* [[SmartSql]] | * [[SmartSql]] | ||
* [https://mybatis.org MyBatis] | * [https://mybatis.org MyBatis] | ||
* [https://ibatis.apache.org iBATIS] | * [https://ibatis.apache.org iBATIS] | ||
Revision as of 02:51, 11 March 2020
Sql
<sql id="userColumns">
${alias}.id,
${alias}.entered,
${alias}.enterer,
${alias}.amended,
${alias}.amender
</sql>
<select id="selectUsers" resultType="map">
SELECT
<include refid="userColumns"><property name="alias" value="t1"/></include>,
<include refid="userColumns"><property name="alias" value="t2"/></include>
FROM
M00TM00X00 t1
LEFT join M00TM00X00 t2 on t1.id = t2.id
</select>
Key
<insert id="createDataType">
<selectKey keyProperty="id" resultType="int" order="BEFORE">
SELECT
nvl(MAX(id),0) + 1 id
FROM
M00TM00X00
</selectKey>
INSERT INTO M00TM00X00 (
id,
data_type_code,
data_type_name,
entered,
enterer
)
VALUES (
#{id},
#{dataTypeCode},
#{dataTypeName},
SYSDATE,
'SELF'
)
</insert>