DEBUG [main] - ==>  Preparing: SELECT * FROM users u LEFT JOIN ordersitem o ON u.id=o.user_id INNER JOIN `order` od ON o.order_id=od.id; 
DEBUG [main] - ==> Parameters: 
DEBUG [main] - <==      Total: 10
User{id=5, username='zhangjiaying', password='123123', email='zjy@qq.com', birthday='2000-11-04', roleList=[Role{user_id=5, order_id=1}, Role{user_id=5, order_id=2}, Role{user_id=5, order_id=3}, Role{user_id=5, order_id=4}]}
User{id=4, username='guoqiqi', password='123321', email='1611284116@qq.com', birthday='2000-02-07', roleList=[Role{user_id=4, order_id=1}, Role{user_id=4, order_id=2}, Role{user_id=4, order_id=3}, Role{user_id=4, order_id=4}, Role{user_id=4, order_id=5}]}
User{id=2, username='lisi', password='123456', email='lisi@sina,com', birthday='1981-12-01', roleList=[Role{user_id=2, order_id=5}]}

Process finished with exit code 0

# Global logging configuration
log4j.rootLogger=ERROR, stdout
# MyBatis logging configuration...
log4j.logger.com.soft=DEBUG
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/jdbc
    jdbc.username=root
    jdbc.password=123456

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-config.dtd">


<configuration>
    <!--properties引用另一个配置文件-->
    <properties resource="jdbc.properties"/>

    <!--&lt;!&ndash;给类起别名   &ndash;&gt;-->
    <!--<typeAliases>-->
        <!--&lt;!&ndash;属性type,要起别名的类,alias:新的名字&ndash;&gt;-->
......................

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">


<!-- namespace表示命名空间 -->
<mapper namespace="com.soft.mapper.PersonMapper">

<!--属性type是最后生成的对象类型-->
<resultMap id="orderMap" type="com.soft.model.Order">
<!--属性id就是特殊的result-->
<id property="id" column="id"/>
......................

package com.soft;

import com.soft.Util.MybatisUtils;
import com.soft.model.Order;
import com.soft.model.Role;
import org.apache.ibatis.session.SqlSession;

import java.util.List;

public class Test {
    public static void main(String[] args) {
        SqlSession sqlSession = MybatisUtils.getSqlSession();
......................

package com.soft.model;

import java.util.List;

public class User {
    private int id;
    private  String username;
    private String password;
    private String  email;
    private String birthday;
    private List<Role> roleList;
    public List<Role> getRoleList() {
......................

package com.soft.model;

import java.util.List;

public class Role {
    private int user_id;
    private int order_id;


    public int getUser_id() {
        return user_id;
    }
......................

package com.soft.Util;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

//工具类
public final class MybatisUtils {
......................

package com.soft.model;

import java.util.Date;
import java.util.List;

//订单类
public class Order {
    private int id;
    private String  commodity;//商品
    private double total;//金额
    private List<Order> roleList;

......................