Mapper.class中有个接口方法
public User getUserByIdandName(Integer id,String name);
Mapper.xml
<select id="getUserByIdandName" resultType="user">
select * from user where id=#{param0} and name=#{param1}
</select>
接下来展示@Param的功效
Mapper.class中有个接口方法
public User getUserByIdandName(@Param("id")Integer id,@Param("name")String name);
Mapper.xml
<select id="getUserByIdandName" resultType="user">
select * from user where id=#{id} and name=#{name}
</select>