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>   www.zzzyk.com
   <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>

补充：软件开发 , Java ,

上一个：各操作系统启动java程序的脚本
下一个：java正则表达式处理类