Mybatis 复杂对象映射配置ResultMap的association

最新推荐文章于 2024-05-14 13:56:01 发布

爱卿呀

最新推荐文章于 2024-05-14 13:56:01 发布

阅读量646

点赞数

分类专栏： spring boot 文章标签： springboot

本文链接：https://blog.csdn.net/weixin_43432438/article/details/124247761

版权

spring boot 专栏收录该内容

66 篇文章 0 订阅

订阅专栏

association: 映射到POJO的某个复杂类型属性，比如订单order对象里面包含 user对象

代码：

VideoMapper.java

public interface VideoOrderMapper {
    /**
     * 查询全部订单，关联用户
     * @return
     */
    List<VideoOrder> queryVideoOrderList();
}

VideoMapper.xml

<mapper namespace="work.yspan.online_class.dao.VideoOrderMapper">

    <resultMap id="VideoOrderResultMap" type="VideoOrder">
        <id column="id" property="id"/>
        <result column="user_id" property="userId"/>
        <result column="out_trade_no" property="outTradeNo"/>
        <result column="create_time" property="createTime"/>
        <result column="total_fee" property="totalFee"/>
        <result column="video_id" property="videoId"/>
        <result column="video_title" property="videoTitle"/>
        <result column="video_img" property="videoImg"/>
		<!--
 		association 配置属性一对一
 		property 对应videoOrder⾥⾯的user属性名
 		javaType 这个属性的类型
 		-->
        <association property="user" javaType="User">
            <id column="user_id" property="id"/>
            <result column="name" property="name"/>
            <result column="head_img" property="headImg"/>
            <result column="phone" property="phone"/>
            <result column="create_timeu" property="createTime"/>
        </association>
    </resultMap>
	<!--一对一管理查询订单， 订单内部包含用户属性-->
    <select id="queryVideoOrderList" resultMap="VideoOrderResultMap">
        select
        o.id ,
        o.user_id,
        o.out_trade_no,
        o.create_time,
        o.total_fee,
        o.video_id,
        o.video_title,
        o.video_img,
        u.name,
        u.head_img,
        u.phone,
        u.create_time create_timeu
        from video_order o left join user u on o.user_id = u.id
    </select>

</mapper>

运行代码：

public class SqlSessionDemo {
    public static void main(String [] args) throws IOException {

        //读取配置文件
        String resouce="config/mybatis-config.xml";
        InputStream inputStream= Resources.getResourceAsStream(resouce);

        //构建Session工厂
        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
        //获取Session
        try(SqlSession sqlSession=sqlSessionFactory.openSession()){
            VideoOrderMapper videoOrderMapper=sqlSession.getMapper(VideoOrderMapper.class);
 			/**
             * resultMap association关联查询
             */
            List<VideoOrder> list=videoOrderMapper.queryVideoOrderList();
            System.out.println(list.toString());