MyBatis: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
(→Key) |
||
| Line 22: | Line 22: | ||
<insert id="createDataType"> | <insert id="createDataType"> | ||
<selectKey keyProperty="id" resultType="int" order="BEFORE"> | <selectKey keyProperty="id" resultType="int" order="BEFORE"> | ||
SELECT | |||
nvl(MAX(id),0) + 1 id | |||
FROM | |||
M00TM00X00 | |||
</selectKey> | </selectKey> | ||
INSERT INTO M00TM00X00( | INSERT INTO M00TM00X00( | ||
| Line 37: | Line 37: | ||
#{id}, | #{id}, | ||
#{dataTypeCode}, | #{dataTypeCode}, | ||
#{dataTypeName}, | #{dataTypeName,}, | ||
SYSDATE, | SYSDATE, | ||
'SELF' | 'SELF' | ||
| Line 43: | Line 43: | ||
</insert> | </insert> | ||
</source> | </source> | ||
==References== | ==References== | ||
* [https://mybatis.org/mybatis-3/sqlmap-xml.html Mapper XML Files] | * [https://mybatis.org/mybatis-3/sqlmap-xml.html Mapper XML Files] | ||
* [https://mybatis.org MyBatis] | * [https://mybatis.org MyBatis] | ||
* [https://ibatis.apache.org iBATIS] | * [https://ibatis.apache.org iBATIS] | ||
Revision as of 20:36, 4 November 2019
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>