Mybatis - Mapper文件简练

<!-- 插入一条语句，根据类中存在的数据进行动态解析生成SQL -->
 <select id="select" resultMap="BaseResultMap" parameterType="com.metarnet.Execution.DAO.Model.CeicsExecution">
  select 
    <include refid="Base_Column_List" />
    from CEICS_EXECUTION
    <trim prefix="WHERE" prefixOverrides="AND">
   <if  test="executionId != null">
   AND EXECUTION_ID=#{executionId,jdbcType=DECIMAL}
   </if>
   <if test="executionName != null" >
   AND EXECUTION_NAME like #{executionName,jdbcType=VARCHAR}
   </if>
   <if test="executionActive != null" >
        AND EXECUTION_ACTIVE like #{executionActive,jdbcType=DECIMAL}
      </if>
      <if test="regDate != null" >
       AND REG_DATE=#{regDate,jdbcType=TIMESTAMP}
      </if>
</trim>
  </select>


<!-- 自动主键（此时的自动主键可在JAVA中获取到） -->
<insert id="insert" parameterType="com.metarnet.Execution.DAO.Model.CeicsExecution" >
  <selectKey keyProperty="executionId"  resultType="java.math.BigDecimal" order="BEFORE" >
  SELECT nvl(max(EXECUTION_ID),0)+1 as executionId FROM CEICS_EXECUTION
  </selectKey>
    insert into CEICS_EXECUTION (EXECUTION_ID, EXECUTION_NAME, EXECUTION_ACTIVE, 
      REG_DATE)
    values (#{executionId,jdbcType=DECIMAL}, #{executionName,jdbcType=VARCHAR}, #{executionActive,jdbcType=DECIMAL}, 
      #{regDate,jdbcType=TIMESTAMP})

  </insert>

-----------------------------------程序员 闫帆原创---------------------------------------

转载请注明原创人信息  程序员 闫帆yanfanvip