Spring boot 多表连接 增删改查代码简便*
MYSQL当中的数据
在实体类当中,连接表
package com.demo12.demo.Ertity;
import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import javax.persistence.*;
@Table
@Entity(name="student")
public class Student {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int sid;
private String Sname;
private String Sage;
private String Ssex;
private int Sdid;
@ManyToOne(targetEntity = Classes.class) 连接表
@JoinColumn(name="Sdid",referencedColumnName = "cid",insertable = false,updatable = false)主表的外键对应着另一个表的主键
private Classes classes;//实例化另一个表的名 同时写Get()Set()方法
public Classes getClasses() {
return classes;
}
public void setClasses(Classes classes) {
this.classes = classes;
}
public int getSid() {
return sid;
}
public void setSid(int sid) {
this.sid = sid;
}
public String getSname() {
return Sname;
}
public void setSname(String sname) {
Sname = sname;
}
public String getSage() {
return Sage;
}
public void setSage(String sage) {
Sage = sage;
}
public String getSsex() {
return Ssex;
}
public void setSsex(String ssex) {
Ssex = ssex;
}
public int getSdid() {
return Sdid;
}
public void setSdid(int sdid) {
Sdid = sdid;
}
}
另一个表,链接,也得写实体类,Dao Service 可以不用写控制器 带式在主表控制器当中,得写上
@Autowired
ClassesService classesService;
在这里插入代码片
写完实例化后,就创建Dao Service Controller
在Dao模式中,就写一个修改查询主键的值,其他的查询全部,删除,直接调用Dao模式自带的方法
Dao代码如下
package com.demo12.demo.Dao;
import com.demo12.demo.Ertity.Student;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org