Mybatis的获取参数的方式

方式1：${} 字符串拼接

方式2：#{} 占位符

1. Mapper接口参数为单个参数

<delete id="delUserById" parameterType="int">

delete from user where id = #{id}

</delete>

<delete id="delUserById" parameterType="int">

delete from user where id = ${id}

</delete>

2.Mapper接口参数是多个参数的获取

mybatis在处理多个参数时,会将多个参数保存到map集合中会 以 agr0 ，agr1或param1 param2为键 以参数位置进行存储

User selectUserByUserNameAndPassword(String username,String password);

<select id="selectUserByUserNameAndPassword" resultType="user">

select * from user where user_name = #{arg0} and password = #{arg1}

</select>

4.将参数设为map集合进行数据的传递

User selectUserByMap(Map map);

<select id="selectUserByMap" resultType="cn.kgc.mybatis.entity.User">

select * from user where user_name = #{username} and password = #{password}

</select>

5.通过注解@param("键名")设置参数的获取名字

int insertUser(User user);

<insert id="insertUser" parameterType="user" useGeneratedKeys="true" keyProperty="id" >

insert into user values ( #{id},#{userName},#{password})

</insert>