Dao层定义如下:
public interface CompanyMemberRelReadDao {
CompanyMemberRel getCompanyMemberRel(Integer companyId, Integer memberId);
}这样子的话,sql的配置如下:
<mapper namespace="com.tsb.dao.read.CompanyMemberRelReadDao">
<resultMap id="companyMemberRelResult" type="CompanyMemberRel">
</resultMap>
<select id="getCompanyMemberRel" resultMap="companyMemberRelResult">
select * from company_member_rel where companyId = #{companyId}
and memberId = #{memberId}
</select>
</ mapper>这样mybaits是找不到 companyId,也就是识别不了 #{companyId}
写成如下才可以
<mapper namespace="com.tsb.dao.read.CompanyMemberRelReadDao">
<resultMap id="companyMemberRelResult" type="CompanyMemberRel">
</resultMap>
<select id="getCompanyMemberRel" resultMap="companyMemberRelResult">
select * from company_member_rel where companyId = #{0}
and memberId = #{1}
</select>
</ mapper>
如果要写成第一种形式,那么dao层需要增加@Param
public interface CompanyMemberRelReadDao {
CompanyMemberRel getCompanyMemberRel(@Param("companyId") Integer companyId, @Param("memberId") Integer memberId);
}