1、封装实体
Dao接口:
public Sysuser selectUser(Sysuser u);
Xml映射文件:
<!-- ${实体类的属性名} -->
<select id="selectUser" parameterType="sysuser" resultType="sysuser">
select * from sysuser where uname=#{uname} and uphone=#{uphone}
</select>
2、封装map
Dao接口:
public Sysuser selectUser2(Map<String,Object> m);
Xml映射文件:
<!-- #{map的key} -->
<select id="selectUser2" parameterType="map" resultType="sysuser">
select * from sysuser where uname=#{uname} and uphone=#{uphone}
</select>
3、@Param注解
Dao接口:
public Sysuser selectUserByNameAndPhone(@Param("un")String uname,@Param("up")String uphone);
Xml映射文件:
<!-- #{Param注解的value值} -->
<select id="selectUserByNameAndPhone" resultType="Sysuser">
select * from sysuser where uname=#{un} and uphone=#{up}
</select>