mybatis的一个奇怪问题!!
第一种写法:取出数据为2条。对的。<resultMap id="accountResult" type="account"><association property="addressList" column="userid" select="selectAddress"/>
</resultMap>
<select id="getAccountByUserid" parameterType="int" resultMap="accountResult">
SELECT * FROM ACCOUNT WHERE USERID = #{userid}
</select>
<select id="selectAddress" parameterType="int" resultType="address">
SELECT * FROM ADDRESS WHERE USERID = #{userid}
</select>
第二种写法:取出数据为3条。错了。<resultMap id="accountResult" type="account">
<result property="userid" column="userid" />
<result property="username" column="username"/>
<result property="password" column="password"/>
<result property="createtime" column="createtime"/>
<result property="description" column="description"/>
<result property="release" column="release"/>
<collection property="addressList"
column="userid"
resultMap="addressResult"
ofType = "example.scz.usually.dto.Address"
select="selectAddress"/>
</resultMap>
<resultMap id="addressResult" type="address">
<result property="id" column="id" />
<result property="userid" column="userid"/>
<result property="address" column="address"/>
<result property="name" column="name"/>
</resultMap>
<select id="getAccountByUserid" parameterType="int" resultMap="accountResult">
SELECT * FROM ACCOUNT WHERE USERID = #{userid}
</select>
<select id="selectAddress" parameterType="int" resultType="address">
SELECT * FROM ADDRESS WHERE USERID = #{userid}
</select>
我想知道第二种写法错在哪里了,为什么?希望高人能帮我指点迷津,先谢谢了! --------------------编程问答-------------------- 没人回答,沉底了,现在csdn这么没有人气啊! --------------------编程问答-------------------- 自己顶!找有缘人
补充:Java , Web 开发