Mybatis传参数

一、多个参数

 

DAO层的函数方法

Public User selectUser(String name,String area);

 

对应的Mapper.xml

<select id="selectUser" resultMap="BaseResultMap">
    select  *  from user_user_t   where user_name = #{0} and user_area=#{1}
</select>

 二、Map方式

 

DAO层的函数方法

Public User selectUser(Map paramMap);

 

对应的Mapper.xml

<select id=" selectUser" resultMap="BaseResultMap">
   select  *  from user_user_t   where user_name = #{userName，jdbcType=VARCHAR} 
   and user_area=#{userArea,jdbcType=VARCHAR}
</select>

 

Service层调用

Private User xxxSelectUser(){
  Map paramMap=new hashMap();
  paramMap.put(“userName”,”对应具体的参数值”);
  paramMap.put(“userArea”,”对应具体的参数值”);
  User user=xxx. selectUser(paramMap);
}

 三、注解@param

 

Dao层的函数方法

User selectUser(@param("userName")Stringname,@param("userArea")String area);

 

对应的Mapper.xml

<select id=" selectUser" resultMap="BaseResultMap">
   select  *  from user_user_t   where user_name = #{userName，jdbcType=VARCHAR} 
    and user_area=#{userArea,jdbcType=VARCHAR}
</select> 

 四、java实体对象

 

Service层调用

Teacher queryTeacher=new Teacher();  
queryTeacher.setId(2);  
List<Teacher> tList = teacherMapper.selectTeacher(queryTeacher);

 

对应的Mapper.xml

<select id="selectTeacher" parameterType="com.myapp.domain.Teacher" 
    resultType="com.myapp.domain.Teacher">  
    select * from Teacher where c_id=#{id}  
</select>