MyBatis

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>

References

• Mapper XML Files
• SmartSql
• MyBatis
• iBATIS