MyBatis3 传递参数种类

第一种：单个参数[基本类型]：

# Mapper 接口定义
T selectByPrimaryKey(String sid);

# Mapper 映射文件
 <select id="selectByPrimaryKey" parameterType="java.lang.String" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from ***
    where sid = #{sid,jdbcType=VARCHAR}
  </select>

第二种：多个参数

# Mapper 接口定义
public List<T> getList(String sid, String code);

# Mapper 映射文件
<select id="getList" resultType="T">
　　select * from ** where sid = #{0} and code= #{1}  
</select>   

第三种：Map参数

# Mapper 接口定义
List<T> selectAll(Map<String,Object> parame);

# Mapper 映射文件
<select id="selectAll" parameterType="map" resultMap="BaseResultMap">
  	select 
    <include refid="Base_Column_List" />
    from cm
    where 1 = 1
       <if test="id != null">
            and  cm.id = #{id,jdbcType=DECIMAL}
        </if>
        <if test="carDeptName != null">
            and  cm.car_dept_name = #{carDeptName,jdbcType=VARCHAR}
        </if>
        <if test="carMakerName != null">
            and  cm.car_maker_name = #{carMakerName,jdbcType=VARCHAR}
        </if>
        <if test="hotType != null" >
           and  cm.hot_type = #{hotType,jdbcType=BIGINT}
        </if>

  </select>

第四种：类参数

 <update id="updateByPrimaryKeySelective" parameterType="com.system.model.User" >
    update user
    <set >
      <if test="carDeptName != null" >
        car_dept_name = #{carDeptName,jdbcType=VARCHAR},
      </if>
      <if test="carMakerName != null" >
        car_maker_name = #{carMakerName,jdbcType=VARCHAR},
      </if>
      <if test="icon != null" >
        icon = #{icon,jdbcType=VARCHAR},
      </if>
      <if test="carMakerPy != null" >
            car_maker_py = #{carMakerPy,jdbcType=VARCHAR},
      </if>
      <if test="hotType != null" >
            hot_type = #{hotType,jdbcType=BIGINT},
      </if>
    </set>
    where id = #{id,jdbcType=BIGINT}
  </update>

第五种：List参数

  <delete id="batchdelete" parameterType="java.util.List">
  	delete from user_relation_role where SID in 
  	<foreach item="sid" collection="list" open="(" separator="," close=")">
    	#{sid}
    </foreach>
  </delete>

第七种：@Param参数

# Mapper 接口定义
List<String> selectIdBySortTime(@Param(value="startdate")String startDate);

# Mapper 映射文件
 <select id="selectIdBySortTime" resultType="java.lang.String" parameterType="java.lang.String">
  	select distinct *** from *** where sorttime >= to_date(#{startdate,jdbcType=VARCHAR},'YYYY-MM-DD') and created_date=updated_date 
  	and keyvalue in (select  distinct companyname from *** where isupdate='0')
   </select>