mybatis自动生成主键

下面就是将主键id自动生成，累加1的实现方法

<selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" >            select get_seq_next('Engine_Line_Stock') from dual</selectKey>

这个需要你建一个名字叫做ENGINE_LINE_STOCK_SEQ的序列

    <insert id="insertEngineLineStock" parameterType="cn.evun.srm.psc.mes.model.EngineLineStock" >        <selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" >            select get_seq_next('Engine_Line_Stock') from dual        </selectKey>        insert into Engine_Line_Stock        <trim prefix="(" suffix=")" suffixOverrides="," >              ID,            FC_CODE,            MT_CODE,            CURR_STOCK,            UPLOAD_TIME        </trim>        <trim prefix="values (" suffix=")" suffixOverrides="," >                      #{id,jdbcType=INTEGER},                      #{fcCode,jdbcType=VARCHAR},                     #{mtCode,jdbcType=VARCHAR},                      #{currStock,jdbcType=VARCHAR},                        #{uploadTime,jdbcType=VARCHAR}                  </trim>  </insert>