gpt-3.5-turbo-0301· OpenAI
WildChat-4.8M (AI2)
基于以下数据表生成java类设计映射表 -…
- 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)
- 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; }}