mybatis input 类型

renyanping

mybatis input支持string,map,javaBean


ERMMember ermLogin(Map map);



<resultMap id="ERMMemberResult" type="com.jje.membercenter.domain.ERMMember">
<id property="id" column="id" />
<id property="agreementCode" column="agreement_code" />
</resultMap>
<select id="ermLogin" parameterType="map" resultMap="ERMMemberResult">
select l.id, a.agreement_code
from erm_login l, erm_ecagreement a
where l.enterprise_no = a.enterprise_no
and l.login_name = #{loginName} and l.pwd = #{sha1}
</select>