mybatis-实现多关联查询

一、一对多的关联

1.1、提出需求

根据id查询球星的信息

1.2、创建表和数据

创建user表

– Table structure for
tb_user

–

DROP TABLE IF EXISTS
tb_user;

CREATE TABLE tb_user (

id int(32) NOT NULL AUTO_INCREMENT,

username varchar(32) DEFAULT NULL,

address varchar(256) DEFAULT NULL,

PRIMARY KEY (id)

) ENGINE=InnoDB
AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

–

– Records of tb_user

–

INSERT INTO tb_user VALUES
(‘1’, ‘詹姆斯’, ‘克利夫兰’);

INSERT INTO tb_user VALUES
(‘2’, ‘热火’, ‘太阳’);

INSERT INTO tb_user VALUES
(‘3’, ‘保罗’, ‘洛杉矶’);

创建订单表

DROP TABLE IF EXISTS
tb_orders;

CREATE TABLE tb_orders (

id int(32) NOT NULL AUTO_INCREMENT,

number varchar(32) NOT NULL,

user_id int(32) NOT NULL,

PRIMARY KEY (id),

KEY user_id (user_id),

CONSTRAINT tb_orders_ibfk_1 FOREIGN KEY
(user_id) REFERENCES tb_user (id)

) ENGINE=InnoDB
AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

–

– Records of tb_orders

–

INSERT INTO tb_orders VALUES
(‘1’, ‘1000011’, ‘1’);

INSERT INTO tb_orders
VALUES (‘2’, ‘1000012’, ‘1’);

INSERT INTO tb_orders
VALUES (‘3’, ‘1000013’, ‘2’);

1.3、定义实体类

1.Orders实体类

/**

• 订单持久化类
  /
  public class Orders {
  //与数据库的 tb_orders的表中的字段一一对应
  private Integer id; //订单id
  private String number;//订单编号
  /*

  • 这个GetterSetter方法
  • @return
    */
    public Integer getId() {
    return id;
    }
    public void setId(Integer id) {
    this.id = id;
    }
    public String getNumber() {
    return number;
    }
    public void setNumber(String number) {