Mybatis实现订单案例的五表联合操作实现订单案例的五表联合操作
Mybatis实现订单案例的五表联合操作实现订单案例的五表联合操作
上一个笔记中已经完成了五表的设计,本案例使用上一个笔记中已经完成了五表的设计,本案例使用mybatis来完成相应的查询功能来完成相应的查询功能
pom文件添加junit,mysql, mybatis(3.4.4)
设置mybatis的配置文件
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;