Mybatis实现订单案例的五表联合操作

Mybatis实现订单案例的五表联合操作
上一个笔记中已经完成了五表的设计，本案例使用mybatis来完成相应的查询功能
pom文件添加junit，mysql， mybatis（3.4.4）

设置mybatis的配置文件

<?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">

<!--
    引入db的配置文件信息，后面用到的四个连接字符串就可以直接使用 ${}的方式来动态引入
-->
<properties resource="db.properties" />

<!--
    给当前mybatis项目添加日志功能，该STDOUT_LOGGING值的好处是不用添加第三方jar包就可以有日志的输出
-->
<settings>
    <setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>

<environments default="development">
    <environment id="development">
        <transactionManager type="JDBC"/>
        <dataSource type="POOLED">
            <property name="driver" value="${driver}"/>
            <property name="url" value="${url}"/>
            <property name="username" value="${user}"/>
            <property name="password" value="${pass}"/>
        </dataSource>
    </environment>
</environments>
<mappers>
    <mapper resource="com/qfedu/mapper/OrderMapper.xml"/>
    <mapper resource="com/qfedu/mapper/UserMapper.xml"/>
    <mapper resource="com/qfedu/mapper/DetailMapper.xml"/>
    <mapper resource="com/qfedu/mapper/ProductMapper.xml"/>
    <mapper resource="com/qfedu/mapper/TypeMapper.xml"/>
</mappers>

</configuration>

db.properties数据库的配置文件

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mall
user=root
pass=123456

设计pojo类

User.java

package com.qfedu.pojo;

public class User {
private int uid;
private String name;
private String pass;
private String phone;

@Override
public String toString() {
    return "User{" +
            "uid=" + uid +
            ", name='" + name + '\'' +
            ", pass='" + pass + '\'' +
            ", phone='" + phone + '\'' +
            '}';
}

public int getUid() {
    return uid;
}

public void setUid(int uid) {
    this.uid = uid;
}

public String getName() {
    return name;
}

public void setName(String name) {
    this.name = name;
}

public String getPass() {
    return pass;
}

public void setPass(String pass) {
    this.pass = pass;
}

public String getPhone() {
    return phone;
}

public void setPhone(String phone) {
    this.phone = phone;
}

}

Type.java

package com.qfedu.pojo;

public class Types {

private String tid;
private String name;

@Override
public String toString() {
    return "Types{" +
            "tid=" + tid +
            ", name='" + name + '\'' +
            '}';
}

public String getTid() {
    return tid;
}

public void setTid(String tid) {
    this.tid = tid;
}

public String getName() {
    return name;
}

public void setName(String name) {
    this.name = name;
}

}

Product.java

package com.qfedu.pojo;

public class Product {

private String pid;
private String name;
private String img;
private double price;
private Types t;

@Override
public String toString() {
    return "Product{" +
            "pid='" + pid + '\'' +
            ", name='" + name + '\'' +
            ", img='" + img + '\'' +
            ", price=" + price +
            ", t=" + t +
            '}';
}

public String getPid() {
    return pid;
}

public void setPid(String pid) {
    this.pid = pid;
}

public String getName() {
    return name;
}

public void setName(String name) {
    this.name = name;
}

public String getImg() {
    return img;
}

public void setImg(String img) {
    this.img = img;
}

public double getPrice() {
    return price;
}

public void setPrice(double price) {
    this.price = price;
}

public Types getT() {
    return t;
}

public void setT(Types t) {
    this.t = t;
}

}

Detail.java

package com.qfedu.pojo;

public class Detail {

private String did;
private int count;
private Product pro;

@Override
public String toString() {
    return "Detail{" +
            "did='" + did + '\'' +
            ", count=" + count +
            ", pro=" + pro +
            '}';
}

public String getDid() {
    return did;
}

public void setDid(String did) {
    this.did = did;
}

public int getCount() {
    return count;
}

public void setCount(int count) {
    this.count = count;
}

public Product getPro() {
    return pro;
}

public void setPro(Product pro) {
    this.pro = pro;
}

}

Order.java

package com.qfedu.pojo;

import java.util.List;

public class Order {

private String oid;
private double price;
private String addr;
private String payType;
private User u;
private List<Detail> details;

@Override
public String toString() {
    return "Order{" +
            "oid='" + oid + '\'' +
            ", price=" + price +
            ", addr='" + addr + '\'' +
            ", payType='" + payType + '\'' +
            ", u=" + u +
            ", details=" + details +
            '}';
}

public String getOid() {
    return oid;
}

public void setOid(String oid) {
    this.oid = oid;
}

public double getPrice() {
    return price;
}

public void setPrice(double price) {
    this.price = price;
}

public String getAddr() {
    return addr;
}

public void setAddr(String addr) {
    this.addr = addr;
}

public String getPayType() {
    return payType;
}

public void setPayType(String payType) {
    this.payType = payType;
}

public User getU() {
    return u;
}

public void setU(User u) {
    this.u = u;
}

public List<Detail> getDetails() {
    return details;
}

public void setDetails(List<Detail> details) {
    this.details = details;
}

}

设置映射文件mapper

OrderMapper.xml