<sqlMap namespace="USER">
<resultMap id="get-user-result" class="org.peak.ibatis.entity.SysUser">
<result property="usrId" column="usr_id" />
<result property="usrName" column="usr_name" />
<result property="usrPassword" column="usr_password" />
<result property="usrFlag" column="usr_flag" />我看见有的配置文件里都没有resultMap 那什么时候用他呢 谢谢各位大侠啦
<resultMap id="get-user-result" class="org.peak.ibatis.entity.SysUser">
<result property="usrId" column="usr_id" />
<result property="usrName" column="usr_name" />
<result property="usrPassword" column="usr_password" />
<result property="usrFlag" column="usr_flag" />我看见有的配置文件里都没有resultMap 那什么时候用他呢 谢谢各位大侠啦
例如
<select id="selectUser" parameterType="int" resultMap="get-user-result">
但是如这个Bean里有集合类,或者属性是另一个类的对象,这时需要自己定义ResultMap
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="CUSTOMER">
<typeAlias alias="customer" type="org.peak.ibatis.entity.CstCustomer" />
<select id="staCustomer" resultClass="HashMap" parameterClass="String">
SELECT
$condition$ ,COUNT(*) AS cstCount
FROM
cst_customer t1 left JOIN bas_dict t2 ON t2.dict_value=t1.cust_level
WHERE
t2.dict_type='客户等级'
group by
$condition$
</select>
<select id="staService" resultClass="HashMap" parameterClass="String">
SELECT
svr_type as serviceType,COUNT(svr_id) as svrCount
FROM
cst_service
WHERE
svr_create_date LIKE '%$year$%'
GROUP BY
svr_type
</select>
</sqlMap>他的这个是怎么回事
resultClass="HashMap"