Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0301· OpenAIAi2 WildChat-4.8M (AI2)

基于以下数据表生成java类设计映射表 -…

  1. User

    基于以下数据表生成java类设计映射表 - 学生表(student):存储学生信息,包括学生编号(s_id)、姓名(s_name)、性别(s_sex)、年龄(s_age)、班级(s_class),专业(s_major)

    • 课程表(course):存储课程信息,包括课程编号(c_id)、课程名称(c_name)、授课教师(c_teacherId)、学分(c_credit)
    • 教师表(teacher):存储教师信息,包括教师编号(t_id)、姓名(t_name)、性别(t_sex)、部门(t_department)
    • 选课表(course_selection):存储学生选课信息,包括学生编号(s_id)、课程编号(c_id)
    • 成绩表(grade):存储学生成绩信息,包括学生编号(s_id)、课程编号(c_id)、成绩(s_grade)
  2. Assistant

    以下为对应的Java类设计:

    学生类(Student.java):

    public class Student { private int sId; private String sName; private String sSex; private int sAge; private String sClass; private String sMajor;

    // 构造方法
    public Student(int sId, String sName, String sSex, int sAge, String sClass, String sMajor) {
        this.sId = sId;
        this.sName = sName;
        this.sSex = sSex;
        this.sAge = sAge;
        this.sClass = sClass;
        this.sMajor = sMajor;
    }
    
    // getter和setter方法
    public int getSid() {
        return this.sId;
    }
    public void setSid(int sId) {
        this.sId = sId;
    }
    public String getSname() {
        return this.sName;
    }
    public void setSname(String sName) {
        this.sName = sName;
    }
    public String getSsex() {
        return this.sSex;
    }
    public void setSsex(String sSex) {
        this.sSex = sSex;
    }
    public int getSage() {
        return this.sAge;
    }
    public void setSage(int sAge) {
        this.sAge = sAge;
    }
    public String getSclass() {
        return this.sClass;
    }
    public void setSclass(String sClass) {
        this.sClass = sClass;
    }
    public String getSmajor() {
        return this.sMajor;
    }
    public void setSmajor(String sMajor) {
        this.sMajor = sMajor;
    }
    

    }

    课程类(Course.java):

    public class Course { private int cId; private String cName; private int cTeacherId; private int cCredit;

    // 构造方法
    public Course(int cId, String cName, int cTeacherId, int cCredit) {
        this.cId = cId;
        this.cName = cName;
        this.cTeacherId = cTeacherId;
        this.cCredit = cCredit;
    }
    
    // getter和setter方法
    public int getCid() {
        return this.cId;
    }
    public void setCid(int cId) {
        this.cId = cId;
    }
    public String getCname() {
        return this.cName;
    }
    public void setCname(String cName) {
        this.cName = cName;
    }
    public int getCteacherId() {
        return this.cTeacherId;
    }
    public void setCteacherId(int cTeacherId) {
        this.cTeacherId = cTeacherId;
    }
    public int getCcredit() {
        return this.cCredit;
    }
    public void setCcredit(int cCredit) {
        this.cCredit = cCredit;
    }
    

    }

    教师类(Teacher.java):

    public class Teacher { private int tId; private String tName; private String tSex; private String tDepartment;

    // 构造方法
    public Teacher(int tId, String tName, String tSex, String tDepartment) {
        this.tId = tId;
        this.tName = tName;
        this.tSex = tSex;
        this.tDepartment = tDepartment;
    }
    
    // getter和setter方法
    public int getTid() {
        return this.tId;
    }
    public void setTid(int tId) {
        this.tId = tId;
    }
    public String getTname() {
        return this.tName;
    }
    public void setTname(String tName) {
        this.tName = tName;
    }
    public String getTsex() {
        return this.tSex;
    }
    public void setTsex(String tSex) {
        this.tSex = tSex;
    }
    public String getTdepartment() {
        return this.tDepartment;
    }
    public void setTdepartment(String tDepartment) {
        this.tDepartment = tDepartment;
    }
    

    }

    选课类(CourseSelection.java):

    public class CourseSelection { private int sId; private int cId;

    // 构造方法
    public CourseSelection(int sId, int cId) {
        this.sId = sId;
        this.cId = cId;
    }
    
    // getter和setter方法
    public int getSid() {
        return this.sId;
    }
    public void setSid(int sId) {
        this.sId = sId;
    }
    public int getCid() {
        return this.cId;
    }
    public void setCid(int cId) {
        this.cId = cId;
    }
    

    }

    成绩类(Grade.java):

    public class Grade { private int sId; private int cId; private int sGrade;

    // 构造方法
    public Grade(int sId, int cId, int sGrade) {
        this.sId = sId;
        this.cId = cId;
        this.sGrade = sGrade;
    }
    
    // getter和setter方法
    public int getSid() {
        return this.sId;
    }
    public void setSid(int sId) {
        this.sId = sId;
    }
    public int getCid() {
        return this.cId;
    }
    public void setCid(int cId) {
        this.cId = cId;
    }
    public int getSgrade() {
        return this.sGrade;
    }
    public void setSgrade(int sGrade) {
        this.sGrade = sGrade;
    }
    

    }