Mybatis传参数

最新推荐文章于 2024-10-09 23:23:03 发布

xxpjjpf

最新推荐文章于 2024-10-09 23:23:03 发布

阅读量100

点赞数

文章标签： java

本文链接：https://blog.csdn.net/xxpjjpf/article/details/84795180

版权

一、多个参数

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>