一个vue页面实现Mysql数据表（三表）的增删改查、分页、表连接

最新推荐文章于 2024-02-21 18:07:28 发布

万幸得以相识_

最新推荐文章于 2024-02-21 18:07:28 发布

阅读量1.7k

点赞数 1

分类专栏： Javascript

本文链接：https://blog.csdn.net/L_888888/article/details/107027442

版权

实体类

Student.java

package com.sdbairui.demo.Entity;


import com.fasterxml.jackson.annotation.JsonFormat;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.*;
import java.util.Date;
import java.util.Set;


@Table
@Entity(name="student")
public class Student {
   
    @Id            //主键
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int sid;
    private String sname;
    private int sex;
    @DateTimeFormat(pattern="yyyy-MM-dd")     //转换日期格式   将前台日期字符串转换成Date格式
    @JsonFormat(pattern="yyyy-MM-dd",timezone="GMT+8")    //将服务器端Date日期转换成指定字符串格式
    private Date birth;
    private String classes;

    @OneToMany                       //一对多关系
    @JoinColumn(name="sid",referencedColumnName = "sid",insertable = false,updatable = false)
    private Set<Score> score;

    public Set<Score> getScore(){
   
        return score;
    }

    public void setScore(Set<Score> score){
   
        this.score=score;
    }

    public void setSid(int sid){
   
        this.sid=sid;
    }
    public int getSid(){
   
        return this.sid;
    }
    public void setSname(String sname){
   
        this.sname=sname;
    }
    public String getSname(){
   
        return this.sname;
    }
    public void setSex(int sex){
   
        this.sex=sex;
    }
    public int getSex(){
   
        return this.sex;
    }
    public void setBirth(Date birth) {
   
        this.birth = birth;
    }
    public Date getBirth(){
   
        return this.birth;
    }
    public void setClasses(String classes){
   
        this.classes=classes;
    }
    public String getClasses(){
   
        return this.classes;
    }

}

Score.java

package com.sdbairui.demo.Entity;

import javax.persistence.*;
import javax.persistence.Table;

@Table
@Entity(name="Score")
public class Score {
   
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int scid;
    private int sid;
    private int coid;
    private float grade;

    @OneToOne               //一对一关系
    @JoinColumn(name="coid",referencedColumnName = "coid",insertable = false,updatable = false)
    private Course course;

    public Course getCourse() {
   
        return course;
    }

    public void setCourse(Course course) {
   
        this.course = course;
    }

    public void setScid(int scid){
   
        this.scid=scid;
    }
    public int getScid(){
   
        return this.scid;
    }
    public void setSid(int sid){
   
        this.sid=sid;
    }
    public int getSid(){
   
        return this.sid;
    }
    public void setCoid(int coid){
   
        this.coid=coid;
    }
    public int getCoid(){
   
        return this.coid;
    }
    public void setGrade(float grade){
   
        this.grade=grade;
    }
    public float getGrade(){
   
        return this.grade;
    }
}

Course.java

package com.sdbairui.demo.Entity;

import javax.persistence.*;
import javax.persistence.Table;

@Table
@Entity(name="Score")
public class Score {
   
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int scid;
    private int sid;
    private int coid;
    private float grade;

    @OneToOne
    @JoinColumn(name="coid",referencedColumnName = "coid",insertable = false,updatable = false)
    private Course course;

    public Course getCourse() {
   
        return course;
    }

    public void setCourse(Course course) {
   
        this.course = course;
    }

    public void setScid(int scid){
   
        this.scid=scid;
    }
    public int getScid(){
   
        return this.scid;
    }
    public void setSid(int sid){
   
        this.sid=sid;
    }
    public int getSid(){
   
        return this.sid;
    }
    public void setCoid(int coid){
   
        this.coid=coid;
    }
    public int getCoid(){
   
        return this.coid;
    }
    public void setGrade(float grade){
   
        this.grade=grade;
    }
    public float getGrade(){
   
        return this.grade;
    }
}

Controller 控制器层 StudentController.java

package com.sdbairui.demo.Controller;

import com.sdbairui.demo.Dao.StudentDao;
import com.sdbairui.demo.Entity.Student;
import com.sdbairui.demo.Service.StudentService;
import com.sdbairui.demo.Utils.JsonResult;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data