package myBean;
import java.sql.*;
import myBeans.SQLBean;

public class DBA {
  private String id;
  private String password;
  private String name;
  private String sex;
  private String enrol;
  private String dep_id;
  private String info;
  
  public String getId() {return id;}
  public void setId(String id) {this.id = id;}
  public void setDep_id(String s){dep_id=s;}
  public String getDep_id(){return dep_id;}
  public void setPassword(String s){password=s;}
  public String getPassword(){return password;}
  
  public void setEnrol(String year){enrol=year;}
  public String getEnrol(){return enrol;} 
  public void setSex(String sex){this.sex=sex;}
  public String getSex(){return sex;}
  public void setName(String name){this.name=name;}
  public String getName(){return name;}
  public void setInfo(String info){this.info = info;}
  public String getInfo(){return info;}
                                                                    
  public boolean hasLogin(String id){   //檢查該帳號(hào)是否已經(jīng)注冊(cè)
  	boolean f=true;
   String sql="select * from studba where ID ='"+id+"'";
  	SQLBean db =new SQLBean();
  	try{
  	ResultSet rs=db.executeQuery(sql);
  	if(rs!=null && rs.next()){ f=false;}
  	else{ f=true;}
  	}catch(Exception e){ e.getMessage();}
  	return f;
  }
  	                       
  public ResultSet  getDBA(String dep){
  	String sql = "";
  	if(dep.equals("0000")){
  	   sql="select * from studba  ";
  	   }
  	else{
		   sql="select * from studba where DEPARTMENT='"+dep+"'";
		   }
		SQLBean db= new SQLBean();
		ResultSet rs = db.executeQuery(sql);
		 return rs;
	} 
		                         
		                         
	public String updateDBA(){
    	
      String sql="update studba "+
                 " set NAME='"+name+"',"+" SEX='"+sex+"', INFO='"+info+"', PASSWORD='"+password+"' where ID='"+id+"' ";
      SQLBean db= new SQLBean();
      db.executeInsert(sql);
      return sql;
  }	      			                         		                                                 	                       	                               
  	       
  public int deleteDBA(String id){
    	int num=0;
    	SQLBean db = new SQLBean();
    	String sql="delete from studba where ID = '"+id+"'";
    	num=db.executeDelete(sql);
    	return num;
    	}  
    	                      	                       
  public int addDBA()  {
  	int num = 0;
    String sql="insert into studba(ID,NAME,PASSWORD,SEX,ENROLLDAY,DEPARTMENT,INFO)  "+	
            "values('"+id+"','"+name+"','"+password+"','"+sex+"','"+enrol+"','"+dep_id+"','"+info+"') ";
    SQLBean db =new SQLBean();
    num=db.executeInsert(sql);
    return num;
 }
                                                   
}