mybatis 一对多装载入string集合

我在广州为it添砖java

已于 2024-08-19 13:48:30 修改

阅读量62

点赞数 1

文章标签： mybatis sql 数据库

于 2024-08-14 15:56:11 首次发布

本文链接：https://blog.csdn.net/weixin_52536654/article/details/141193198

版权

很久没写mapper.xml,忘记一对多怎么写了

    <resultMap id="StoresMentionTaskVoMap" type="cn.gzfuture.verification.manage.vo.StoresMentionTaskVo">
        <id column="task_id" property="task_id"></id>
        <result column="task_name" property="task_name"></result>
        <result column="task_range" property="task_range"></result>
        <result column="task_description" property="task_description"></result>
        <result column="task_endtime" property="task_endtime"></result>
        <result column="mt_feedbacktime" property="mt_feedbacktime"></result>

        //映射字符串集合
        <collection property="mt_mentionIds" ofType="String" >
            <id  column="mt_mentionId"/>
        </collection>

        //映射对象集合
        <association property="user" javaType="user">
            <id column="uid" property="id"></id>
            <result column="username" property="username"></result>
            <result column="password" property="password"></result>
            <result column="birthday" property="birthday"></result>
        </association>
    </resultMap>

    <select id="getTaskFeedback"  resultMap="StoresMentionTaskVoMap">
        xxx-xxxx
    </select>