Mybatis添加oracle语句自增

Mybatis打印sql语句

在spring-mybatis中加载sqlmapconfig.xml

sqlmapconfig.xml中的代码

<configuration>
    <settings>
        <!-- 控制台打印sql语句 -->
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
</configuration>

   <insert id="insert" parameterType="com.water.entity.Syemp" useGeneratedKeys="true" keyProperty="id">
        <selectKey resultType="java.lang.Integer" order="BEFORE" keyProperty="id">
        SELECT example_sequence.Nextval as ID from DUAL
        </selectKey>

        INSERT INTO SYEMP (
        <include refid="Syeemp_filed" />
        ) VALUES (
        <include refid="Syeemp_insert" />
        )
    </insert>