package domain;
public class Employee {
    private Integer id;
    private String loginname;
    private String password;
    private String name;
    private String sex;
    private Integer age;
    private String phone;
    private double sal;
    private String state;
    // 构造方法
    public Employee()
    {
        super();
    }
    // 此处省略getter和setter方法,请自己补上
    @Override
    public String toString()
    {
        return "Employee [id=" + id + ", loginname=" + loginname + ", password=" + password
                + ", name=" + name + ", sex=" + sex + ", age=" + age + ", phone=" + phone + ", sal="
                + sal + ", state=" + state + "]";
    }
}

package mapper;
public interface EmployeeMapper {
}

public class User
    implements Serializable
{
    private static final long serialVersionUID = 1L;
    private Integer id;  // 用户id，主键
    private String username;  // 用户名
    private String loginname; // 登录名
    private String password;  // 密码
    private String phone;    // 联系电话
    private String address;  // 收货地址
    // 用户和订单是一对多的关系，即一个用户可以有多个订单
    private List<Order> orders;
    public User()
    {
        super();
        // TODO Auto-generated constructor stub
    }
    public User(String username, String loginname, String password, String phone, String address)
    {
        super();
        this.username = username;
        this.loginname = loginname;
        this.password = password;
        this.phone = phone;
        this.address = address;
    }
    // 此处省略getter和setter方法,请自己补上
    @Override
    public String toString()
    {
        return "User [id=" + id + ", username=" + username + ", loginname=" + loginname
                + ", password=" + password + ", phone=" + phone + ", address=" + address + "]";
    }
}

public class Order
    implements Serializable
{
    private static final long serialVersionUID = 1L;
    private Integer id;  // 订单id，主键
    private String code;  // 订单编号
    private Double total; // 订单总金额
    // 订单和用户是多对一的关系，即一个订单只属于一个用户
    private User user;
    // 订单和商品是多对多的关系，即一个订单可以包含多种商品
    private List<Article> articles;
    public Order()
    {
        super();
        // TODO Auto-generated constructor stub
    }
    public Order(String code, Double total)
    {
        super();
        this.code = code;
        this.total = total;
    }
    // 此处省略getter和setter方法,请自己补上
    @Override
    public String toString()
    {
        return "Order [id=" + id + ", code=" + code + ", total=" + total + "]";
    }
}

public class Article
    implements Serializable
{
    private static final long serialVersionUID = 1L;
    private Integer id;        // 商品id，主键
    private String name;    // 商品名称
    private Double price;    // 商品价格
    private String remark;    // 商品描述
    // 商品和订单是多对多的关系，即一种商品可以包含在多个订单中
    private List<Order> orders;
    public Article()
    {
        super();
        // TODO Auto-generated constructor stub
    }
    public Article(String name, Double price, String remark)
    {
        super();
        this.name = name;
        this.price = price;
        this.remark = remark;
    }
    // 此处省略getter和setter方法,请自己补上
    @Override
    public String toString()
    {
        return "Article [id=" + id + ", name=" + name + ", price=" + price + ", remark=" + remark
                + "]";
    }
}

public interface UserMapper {
    User selectUserById(int id);
}

public interface OrderMapper {
    Order selectOrderById(int id);
}

public class ManyToManyTest {
    public static void main(String[] args)
    {
        // 定义SqlSession变量
        SqlSession sqlSession = null;
        try
        {
            // 创建SqlSession实例
            sqlSession = FKSqlSessionFactory.getSqlSession();
            ManyToManyTest t = new ManyToManyTest();
            // 根据用户id查询用户，测试一对多
            // t.testSelectUserById(sqlSession);
            // 根据订单id查询订单，测试多对多
            t.testSelectOrderById(sqlSession);
            // 提交事务
            sqlSession.commit();
        } catch (Exception e)
        {
            // 回滚事务
            sqlSession.rollback();
            e.printStackTrace();
        } finally
        {
            // 关闭SqlSession
            if (sqlSession != null)
                sqlSession.close();
        }
    }
    // 测试一对多，查询班级User（一）的时候级联查询订单Order（多）
    public void testSelectUserById(SqlSession sqlSession)
    {
        // 获得UserMapper接口的代理对象
        UserMapper um = sqlSession.getMapper(UserMapper.class);
        // 调用selectUserById方法
        User user = um.selectUserById(1);
        // 查看查询到的user对象信息
        System.out.println(user.getId() + " " + user.getUsername());
        // 查看user对象关联的订单信息
        List<Order> orders = user.getOrders();
        orders.forEach(order -> System.out.println(order));
    }
    // 测试多对多，查询订单Order（多）的时候级联查询订单的商品Article（多）
    public void testSelectOrderById(SqlSession sqlSession)
    {
        // 获得OrderMapper接口的代理对象
        OrderMapper om = sqlSession.getMapper(OrderMapper.class);
        // 调用selectOrderById方法
        Order order = om.selectOrderById(2);
        // 查看查询到的order对象信息
        System.out.println(order.getId() + " " + order.getCode() + " " + order.getTotal());
        // 查看order对象关联的用户信息
        User user = order.getUser();
        System.out.println(user);
//        // 查看order对象关联的商品信息
//        List<Article> articles = order.getArticles();
//        articles.forEach(article -> System.out.println(article));
    }
}

package org.fkit.domain;
import java.io.Serializable;

public class Student implements Serializable
{
    private static final long serialVersionUID = -8985198663152992443L;
    private Integer id; // 学生id，主键
    private String name; // 姓名
    private String sex;  // 性别
    private Integer age; // 年龄
    // 学生和班级是多对一的关系，即一个学生只属于一个班级
    private Clazz clazz;
    // 省略构造方法
    // 此处省略getter和setter方法,请自己补上
    // 省略toString()方法
}

package org.fkit.domain;
import java.io.Serializable;
import java.util.ArrayList;
public class Clazz implements Serializable
{
    private static final long serialVersionUID = 7120329740548835778L;
    private Integer id; // 班级id，主键
    private String code; // 班级编号
    private String name; // 班级名称
    // 班级和学生是一对多的关系，即一个班级可以有多个学生
    private ArrayList<Student> students;
    // 省略构造方法
    // 省略getter和setter方法
    // 省略toString方法
}

public interface ClazzMapper {
    // 根据id查询班级信息
    Clazz selectClazzById(Integer id);
}

public interface StudentMapper {
    /**
     * 根据id查询学生信息
     * @param id
     * @return Student对象。
     */
    Student selectStudentById(Integer id);
}

package org.fkit.test;

import java.util.List;
import org.apache.ibatis.session.SqlSession;
import org.fkit.domain.Clazz;
import org.fkit.domain.Student;
import org.fkit.factory.FKSqlSessionFactory;
import org.fkit.mapper.ClazzMapper;
import org.fkit.mapper.StudentMapper;

public class OneToManyTest
{
    public static void main(String[] args)
    {
        // 1.定义SqlSession变量
        SqlSession sqlSession = null;
        try
        {
            // 2.创建SqlSession实例
            sqlSession = FKSqlSessionFactory.getSqlSession();
            OneToManyTest t = new OneToManyTest();
            t.testSelectClazzById(sqlSession);
            // t.testSelectStudentById(sqlSession);
            // 提交事务
            sqlSession.commit();
        } catch (Exception e)
        {
            // 回滚事务
            sqlSession.rollback();
            e.printStackTrace();
        } finally
        {
            // 关闭SqlSession
            if (sqlSession != null)
                sqlSession.close();
        }
    }

    // 测试一对多，查询班级Clazz（一）的时候级联查询学生Student（多）
    public void testSelectClazzById(SqlSession sqlSession)
    {
        // 1.获得ClazzMapper接口的代理对象
        ClazzMapper cm = sqlSession.getMapper(ClazzMapper.class);
        // 2.调用接口的代理对象的selectClazzById方法
        Clazz clazz = cm.selectClazzById(1);
        // 查看查询到的clazz对象信息
        System.out.println(clazz.getId() + " " + clazz.getCode() + " " + clazz.getName());
        // 查看clazz对象关联的学生信息
        List<Student> students = clazz.getStudents();
        students.forEach(stu -> System.out.println("    " + stu));
    }

    // 测试多对一，查询学生Student（多）的时候级联查询 班级Clazz（一）
    public void testSelectStudentById(SqlSession sqlSession)
    {
        // 获得StudentMapper接口的代理对象
        StudentMapper sm = sqlSession.getMapper(StudentMapper.class);
        // 调用selectStudentById方法
        Student stu = sm.selectStudentById(1);
        // 查看查询到的Student对象信息
        System.out.println(stu);
        // 查看Student对象关联的班级信息
        System.out.println(stu.getClazz());
    }

}

package org.fkit.domain;
import java.io.Serializable;
public class Card implements Serializable
{
    private static final long serialVersionUID = 1164164518527094243L;
    private Integer id;  // 主键id
    private String code; // 身份证编号
    public Card() {
        super();
        // TODO Auto-generated constructor stub
    }
    // 此处省略getter和setter方法,请自己补上
    @Override
    public String toString()
    {
        return "Card [id=" + id + ", code=" + code + "]";
    }
}

package org.fkit.domain;
import java.io.Serializable;
//# 创建tb_person表
//DROP TABLE IF EXISTS `tb_person`;
//CREATE TABLE `tb_person` (
//  `id` int(11) NOT NULL AUTO_INCREMENT,
//  `name` varchar(18) NOT NULL,
//  `sex` varchar(18) NOT NULL,
//  `age` int(11) DEFAULT NULL,
//  `card_id` int(11) DEFAULT NULL,
//  PRIMARY KEY (`id`),
//  UNIQUE KEY `card_id` (`card_id`),
//  CONSTRAINT `tb_person_ibfk_1` FOREIGN KEY (`card_id`)
//    REFERENCES `tb_card` (`id`)
//) ENGINE=InnoDB DEFAULT CHARSET=utf8;
//# 插入一条数据
//INSERT INTO `tb_person` VALUES ('1', '小明', '男', '22', '1');
public class Person implements Serializable
{
    private static final long serialVersionUID = -6685680170973264712L;
    private Integer id;  // 主键id
    private String name; // 姓名
    private String sex;  // 性别
    private Integer age; // 年龄
    // 人和身份证是一对一的关系，即一个人只有一个身份证
    private Card card;
    public Person() {
        super();
        // TODO Auto-generated constructor stub
    }
    // 此处省略getter和setter方法,请自己补上
    @Override
    public String toString()
    {
        return "Person [id=" + id + ", name=" + name + ", sex=" + sex + ", age=" + age + "]";
    }
}

package org.fkit.mapper;

import org.fkit.domain.Person;

public interface PersonMapper
{
    /**
     * 方法名称要和select元素的id属性一致,参数名必须和select元素的parameterType属性一致.
     * @param id
     * @return Person对象
     */
    Person selectPersonById(Integer id);
}

package org.fkit.test;

import org.apache.ibatis.session.SqlSession;
import org.fkit.domain.Person;
import org.fkit.factory.FKSqlSessionFactory;
import org.fkit.mapper.PersonMapper;

public class OneToOneTest {

    public static void main(String[] args)
    {
        // 定义SqlSession变量
        SqlSession sqlSession = null;
        try
        {
            // 1.创建SqlSession实例
            sqlSession = FKSqlSessionFactory.getSqlSession();
            // 2.获得mapper接口的代理对象
            PersonMapper pm = sqlSession.getMapper(PersonMapper.class);
            // 3.直接调用接口的方法，查询id为1的Peson数据
            Person p = pm.selectPersonById(1);
            // 4.1打印Peson对象
            System.out.println(p);
            // 4.2打印Person对象关联的Card对象
            System.out.println(p.getCard());
            // 5.提交事务
            sqlSession.commit();
        } catch (Exception e)
        {
            // 6.回滚事务
            sqlSession.rollback();
            e.printStackTrace();
        } finally
        {
            // 7.关闭SqlSession
            if (sqlSession != null)
                sqlSession.close();
        }
    }

}

package org.fkit.test;

import org.apache.ibatis.session.SqlSession;
import org.fkit.domain.Person;
import org.fkit.factory.FKSqlSessionFactory;

public class OneToOneTest2
{
    public static void main(String[] args)
    {
        // 创建SQLSession实例
        SqlSession sqlSession = FKSqlSessionFactory.getSqlSession();
        try
        {
            Person p = sqlSession.selectOne("org.fkit.mapper.PersonMapper.selectPersonById", 1);
            System.out.println(p);
            System.out.println(p.getCard());
            // 提交事务
            sqlSession.commit();
        } catch (Exception e)
        {
            e.printStackTrace();
            sqlSession.rollback();
        } finally
        {
            sqlSession.close();
        }
    }

}

<select id="selectUser" resultType="map">
    select * from tb_user
</select>

package org.fkit.test;

import java.util.List;
import java.util.Map;
import org.apache.ibatis.session.SqlSession;
import org.fkit.factory.FKSqlSessionFactory;

public class SelectMapTest
{

    public static void main(String[] args)
    {
        // 1.定义SqlSession变量
        SqlSession sqlSession = null;
        try
        {
            // 2.创建SqlSession实例
            sqlSession = FKSqlSessionFactory.getSqlSession();
            // 3.查询TB_USER表所有记录,每一条记录都封装Map,
            // 该记录的属性作为key,属性值作为value
            List<Map<String, Object>> list = sqlSession.selectList("org.fkit.mapper.UserMapper.selectUser");
            // 遍历List集合，打印每一个Map对象
            list.forEach(row -> System.out.println(row));
            // 4.提交事务
            sqlSession.commit();
        } catch (Exception e)
        {
            // 5.回滚事务
            sqlSession.rollback();
            e.printStackTrace();
        } finally
        {
            // 关闭SqlSession
            if (sqlSession != null)
                sqlSession.close();
        }
    }
}

public class User
    implements Serializable
{
    private static final long serialVersionUID = 1L;
    private Integer id;
    private String name;
    private String sex;
    private Integer age;
    public User()
    {
        super();
        // TODO Auto-generated constructor stub
    }
    public User(String name, String sex, Integer age)
    {
        super();
        this.name = name;
        this.sex = sex;
        this.age = age;
    }
    // 此处省略getter和setter方法,请自己补上
    @Override
    public String toString()
    {
        return "User [id=" + id + ", name=" + name + ", sex=" + sex + ", age=" + age + "]";
    }
}