Date entranceTime, String photo, String classes, List
this.studentID = studentID;
this.studentName = studentName; this.password = password; this.sex = sex;
this.birth = birth; this.phone = phone; this.qq = qq;
this.homeAddr = homeAddr;
this.entranceTime = entranceTime; this.photo = photo;
this.classes = classes; this.grades = grades; }
public String getStudentID() { return studentID; }
public void setStudentID(String studentID) { this.studentID = studentID; }
public String getStudentName() { return studentName; }
public void setStudentName(String studentName) { this.studentName = studentName; }
public String getSex() { return sex; }
public void setSex(String sex) { this.sex = sex; }
public Date getBirth() { return birth; }
public void setBirth(Date birth) { this.birth = birth; }
public String getPhone() { return phone; }
public void setPhone(String phone) { this.phone = phone; }
public String getQq() { return qq; }
public void setQq(String qq) { this.qq = qq; }
public String getHomeAddr() { return homeAddr; }
public void setHomeAddr(String homeAddr) { this.homeAddr = homeAddr; }
public Date getEntranceTime() { return entranceTime; }
public void setEntranceTime(Date entranceTime) { this.entranceTime = entranceTime; }
public List
public void setGrades(List
}
public String getPassword() { return password; }
public void setPassword(String password) { this.password = password; }
public String getPhoto() { return photo; }
public void setPhoto(String photo) { this.photo = photo; }
public String getClasses() { return classes; }
public void setClasses(String classes) { this.classes = classes; }
com.ccniit.student.Grade类
说明: 此类是成绩模型类,提供了成绩的属性和get、set方法和几个构造方法,便于GradeManage来操作。
package com.ccniit.student;
public class Grade {
private String studentID; private String courseName; private int semester; private int schoolYear; private double grade;
public Grade() {}
public Grade(String studentID, String courseName) { this.studentID = studentID;
this.courseName = courseName; }
public Grade(String studentID, String courseName, int semester, int schoolYear, double grade) { this.studentID = studentID; this.courseName = courseName; this.semester = semester;
this.schoolYear = schoolYear; this.grade = grade; }
public String getStudentID() { return studentID; }
public void setStudentID(String studentID) { this.studentID = studentID; }
public String getCourseName() { return courseName; }
public void setCourseName(String courseName) { this.courseName = courseName; }
public int getSemester() { return semester; }
public void setSemester(int semester) { this.semester = semester; }
public int getSchoolYear() { return schoolYear; }
public void setSchoolYear(int schoolYear) { this.schoolYear = schoolYear; }
}
public double getGrade() { return grade; }
public void setGrade(double grade) { this.grade = grade; }
com.ccniit.student.util.DBConnection类
说明:这个类的功能是与底层数据库创建连接给逻辑处理层,还有关闭连接的相关功能。
package com.ccniit.student.util;
import java.sql.Connection; import java.sql.DriverManager;
import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;
//管理与数据库的连接
public class DBConnection { static { try {
Class.forName(\); } catch (ClassNotFoundException e) { e.printStackTrace(); } }
private DBConnection() { }
public static Connection getConn() throws SQLException { Connection conn = DriverManager.getConnection(
\studentManage\,
\, \); return conn; }