student.java

一个基于Java开发的学生管理系统。 很好用地！

package informationsystem.information;

import informationsystem.database.DBHandler;
import java.sql.*;

public class Student {
  private String studentNo;
  private String name;
  private String department;
  private String belong_class;

  private DBHandler db = new DBHandler();

  public Student(String number) {
    ResultSet rs = db.getStudent(number);
    try {
      while (rs.next()) {
        this.studentNo = number;
        this.name = rs.getString("name");
        this.department = rs.getString("department");
        this.belong_class = rs.getString("theclass");
      }
    }
    catch (SQLException ex) {
      ex.printStackTrace();
    }
    finally {
      try {
        rs.close();
      }
      catch (SQLException ex) {
        ex.printStackTrace();
      }
    }
  }

  public Student(String number, String name, String department, String belong) {
    this.studentNo = number;
    this.name = name;
    this.department = department;
    this.belong_class = belong;
  }

  /**
   *
   * 以下四个方法用来获取学生的基本信息。
   */

  public String getNo() {
    return this.studentNo;
  }

  public String getName() {
    return this.name;
  }

  public String getDepartment() {
    return this.department;
  }

  public String getBelongClass() {
    return this.belong_class;
  }

  /**
   * 以下四个方法用来设置学生的一些信息；
   * @param name String
   */
  public void setName(String name) {
    this.name = name;
  }

  public void setClass(String theClass) {
    this.belong_class = theClass;
  }

  public void setDepartment(String department) {
    this.department = department;
  }

  /**
   * update()用来修改学生信息;
   */
  public boolean update() {
    return db.updateStudent(this.studentNo, this.name, this.department,
                            this.belong_class);
  }

  /**
   * 添加学生；
   * @param studentNo String
   * @param name String
   * @param department String
   * @param theclass String
   * @return boolean
   */
  public static boolean addStudent(String studentNo, String name,
                                   String department, String theclass) {
    return new DBHandler().addStudent(studentNo, name, department, theclass);
  }

  public static boolean deleteStudent(String number) {
    return new DBHandler().deleteStudent(number);
  }
}