81,091
社区成员
发帖
与我相关
我的任务
分享
<typeAlias="studentBean" type="XXXXXX.studentbean">
<resultMap class="studentBean" id="studentBeanMap">
<result property="id" column="id" nullValue="0" />
<result property="name" column="name" nullValue="" />
<result property="booknames" column="id" select="getBookNameInfo" />
<result property="grades" column="id" select="getGradesInfo" />
</resultMap>
<!--你的主查询 -->
<select id="getStudentInfo" parameterClass="" resultMap="studentBeanMap">
select id, name ,age form student
</select>
<!-- 查询book info -->
<select id="getBookNameInfo" parameterClass="long" resultMap="bookBeanMap">
select * from bookinfo where studentid=#id#
</select>
好啦。。这样就可以了,,楼主看看吧...