package informationsystem.information;

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

public class Student {
  public Student() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private String Price;
  private String Capacity;
  private String Factory;
  private String belong_interface;
  private String DetailContent;
  private String ApplyType;

  private DBHandler db = new DBHandler();

  public Student(String Price) {
    ResultSet rs = db.getStudent(Price);
    try {
      while (rs.next()) {
        this.Price= Price;
        this.Capacity = rs.getString("Capacity");
        this.Factory= rs.getString("Factory");
        this.belong_interface = rs.getString("InterfaceType");
        this.DetailContent=rs.getString("DetailContent");
         this.ApplyType=rs.getString("ApplyType");//****************************
      }
    }
    catch (SQLException ex) {
      ex.printStackTrace();
    }
    finally {
      try {
        rs.close();
      }
      catch (SQLException ex) {
        ex.printStackTrace();
      }
    }
  }

  public Student(String price, String Capacity, String Factory,
                 String belong_interface,String ApplyType,String DetailContent) {
    this.Price= price;
    this.Capacity=Capacity;
    this.Factory = Factory;
    this.belong_interface = belong_interface;
    this.DetailContent=DetailContent;
    this.ApplyType=ApplyType;
  }

  /**
   *
   * 以下四個方法用來獲取學生的基本信息。
   */

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

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

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

  public String getBelongClass() {
    return this.belong_interface;
  }
  public String getDetailContent() {   //***************************
      return this.DetailContent;
  }
  public String getApplyType() {
    return this.ApplyType;
  }

  /**
   * 以下四個方法用來設置學生的一些信息；
   * @param name String
   */
  public void setName(String Capacity) {
    this.Capacity= Capacity;
  }

  public void setClass(String InterfaceType) {
    this.belong_interface= InterfaceType;
  }

  public void setDepartment(String Factory) {
    this.Factory= Factory;
  }
  public void setDetailContent(String DetailContent) {
     this.DetailContent= DetailContent;
   }
   public void setApplyType(String ApplyType) {
   this.ApplyType= ApplyType;
 }


  /**
   * update()用來修改學生信息;
   */
  public boolean update() {
    return db.updateStudent(this.Price, this.Capacity, this.Factory,
                            this.belong_interface,this.ApplyType);//*********************
  }

  /**
   * 添加學生；
   * @param studentNo String
   * @param name String
   * @param department String
   * @param theclass String
   * @return boolean
   */
  public static boolean addStudent(String Price, String Capacity,
                                   String Factory,String InterfaceType,String ApplyType) {
    return new DBHandler().addStudent(Price, Capacity, Factory, InterfaceType,ApplyType);
  }

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

  private void jbInit() throws Exception {
  }
}