ibatis动态字段配置

一、《增加》时有返回影响行数配置：

<insert id="insertDd" parameterClass="java.util.Map">
  INSERT INTO [USEDD]([DDCODE], [DDTCODE], [DDTYPE], [DDNAME],
  [DDINDEX])
  VALUES(#ddCode#,#ddTCode#,#ddType#,#ddName#,$ddIndex$)
  <selectKey resultClass="java.lang.Integer"
   keyProperty="DDCODE">
   <![CDATA[SELECT count(1) FROM [USEDD] WHERE [DDCODE]=#ddCode#]]>
  </selectKey>
 </insert>

 

二、《修改》时字段配置：

<update id="updateUser" parameterClass="user">
     update user
      <dynamic prepend="set">
          <isNotNull prepend="," property="username">
               username=#username#
           </isNotNull>
          <isNotNull prepend="," property="password">
               password=#password#
           </isNotNull>
      </dynamic>
     where id=#id#
</update>

 

 

三、《查询》时动态条件：

<select id="findDdByParams" resultClass="java.util.HashMap"
  parameterClass="java.util.Map">
  SELECT [DDCODE], [DDTCODE], [DDTYPE], [DDNAME], [DDINDEX] FROM
  [USEDD] WHERE 1=1
  <isNotNull prepend="AND" property="ddCode">
   [DDCODE]=#ddCode#
  </isNotNull>
 </select>