Question

帮忙看下mybatis查出的数据为什么是一条

若以下回答无法解决问题，邀请你更新回答

Answer 1

<resultMap id="articleResultMap" type="Article">
<id property="id" column="id" />
<result property="title" column="title" />
<result property="content" column="content" />
</resultMap>

<resultMap id="articleResultMap" type="Article">
<id property="id" column="id" />
<result property="username" column="userName" />
<result property="useraddress" column="userAddress" />
<collection property="articles" column="ID" javaType="ArrayList" ofType="java.lang.Object" select="select-articles-user" />
</resultMap>

<select id="getUserArticles" parameterType="int" resultMap="resultUserArticleList">
select u.id,u.username,u.useraddress from test_user u where u.id=#{id}
</select>

<select id="select-articles-user" parameterType="int" resultMap="articleResultMap">
select id,title,content from test_article where id = #{ID}
</select>