第一种方法:
mapper中的方法
public User selectUser(String name,String area);
对应的xml文件:
<select id="selectUser"resultMap="BaseResultMap">
select * from user where user_name = #{0} and user_area=#{1}
</select>
第二种方法:利用@param注解:
public User selectUser(@param(“username”) string username,@param(“area”) string area)
对应的xml文件:
<select id="selectUser"resultMap="BaseResultMap">
select * from user where user_name = #{username} and user_area=#{area}
</select>
第三种方法:Map
public User selectUser(Map<String, Object> params);
对应的xml文件:
<select id="selectUser"resultMap="BaseResultMap">
select * from user where user_name = #{username} and user_area=#{area}
</select>
此时传入的map的key需要对应xml文件中的#{}中的内容
像这样:
Map<String,Object> parameter= new HashMap<String, Object>();
parameter.put("username", username)
parameter.put("area", area)
selectUser(parameter)