mybatis xml中常见配置demo

新增:

<insert id="insertSelective" parameterType="map" >
    insert into BS_CHNGROUP_DICT
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="groupName != null" >
        GROUP_NAME,
      </if>
      <if test="hasChild != null" >
        HAS_CHILD,
      </if>
      <if test="queryIndex != null" >
        QUERY_INDEX,
      </if>
      <if test="activeTime != null" >
        ACTIVE_TIME,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="groupName != null" >
        #{groupName,jdbcType=VARCHAR},
      </if>
      <if test="hasChild != null" >
        #{hasChild,jdbcType=CHAR},
      </if>
      <if test="queryIndex != null" >
        #{queryIndex,jdbcType=DECIMAL},
      </if>
      <if test="activeTime != null" >
        #{activeTime,jdbcType=TIMESTAMP},
      </if>
    </trim>
  </insert>

 

修改:

  1.

 <update id="updateByPrimaryKeySelective" parameterType="map" >
    update BS_STAFF_STATUS
    <set >
      <if test="status != null" >
        STATUS = #{status,jdbcType=VARCHAR},
      </if>
      <if test="enterTime != null" >
        ENTER_TIME = #{enterTime,jdbcType=TIMESTAMP},
      </if>
      <if test="insertTime != null" >
        INSERT_TIME = #{insertTime,jdbcType=TIMESTAMP},
      </if>
      <if test="deptId != null" >
        DEPT_ID = #{deptId,jdbcType=VARCHAR},
      </if>
      <if test="phoneNo != null" >
        PHONE_NO = #{phoneNo,jdbcType=VARCHAR},
      </if>
    </set>
    where STAFF_ID = #{staffId,jdbcType=VARCHAR}
  </update>

 查询

  1.

  

<select id="selectSelective" resultType="map" parameterType="map" >
    select 
    <include refid="Base_Column_List" />
    from BS_QUESTION_TRACE_INFO a
    <trim prefix="WHERE" prefixOverrides="AND |OR ">  
        <if test="questionId != null" >
            and QUESTION_ID = #{questionId,jdbcType=CHAR} 
          </if>
          <if test="preStatus != null">  
            and PRE_STATUS = #{preStatus,jdbcType=CHAR}  
        </if>
        <if test="curStatus != null">  
            and CUR_STATUS = #{curStatus,jdbcType=CHAR}  
        </if>
        <if test="oprType != null">  
            and OPR_TYPE = #{oprType,jdbcType=CHAR}  
        </if>
        <if test="questionOwnerId != null">
            and QUESTION_OWNER_ID = #{questionOwnerId,jdbcType=CHAR}  
        </if>
    </trim> 
  </select>

 

  

posted @ 2015-08-08 11:06  勿妄  阅读(310)  评论(0编辑  收藏