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

public class Department {
  
 private String id;
 private String name;
 private String cname;
 private int class_count;
 
 public void setClass_count(int s){class_count = s;}
 public int getClass_count(){return class_count;}
 public void setName(String s){name=s;}
 public String getName(){return name;}
 public void setCname(String  s){cname=s;}
 public String getCname(){return cname;}
 public String  getId(){return id;}	                    
 public void setId(String id){this.id=id;} 	                     
	
	public void addDepartment(){
		String sql="insert into department(ID,NAME,CNAME,CLA_COUNT)  "+
		           "values('"+id+"','"+name+"','"+cname+"','"+class_count+"') ";
		 SQLBean db =new SQLBean();
		 db.executeInsert(sql);          
	}
		                    
	public ResultSet getAll(String dep){
		String sql="";
		if(dep.equals("0000")){
		  sql = "select * from department" ;
		}else{sql = "select * from department where ID='"+dep+"'";}
		SQLBean db =new SQLBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
		}
		
    public  void update(){
    	
    	String sql= "update department set NAME='"+name+"', "+
    	             "CNAME='"+cname+"'"+
    	             "where ID='"+id+"' ";
    	
    	 SQLBean db =new SQLBean();
    	 db.executeInsert(sql); 
    }
    	  	
 /*   public void invalid(String id){
    	String sql="update department set STATUS='"+0+"' where ID ='"+id+"' ";
    	SQLBean db= new SQLBean();
    	db.executeUpdate(sql);
    }	*/
    public int  delete(String id){
    	int num = 0;
    	if(isdel(id)){
    		String s="delete from class where DEPARTMENT='"+id+"'";
    		String sq="delete from student where DEPARTMENT='"+id+"'";
    		String sql="delete from department where ID='"+id+"'";
    		SQLBean db= new SQLBean();
    		try{
    		    db.executeDelete(sq);
    		    db.executeDelete(s);
    		    num = db.executeDelete(sql);
    		  }catch(Exception e){e.getMessage();}
    	}
    	return num;
    }
    
    public boolean isdel(String id){
    	String sql="select ID from student where DEPARTMENT='"+id+"' and STATUS='"+1+"'";
    	boolean f = true;
    	SQLBean db= new SQLBean();
    	try{
    	     ResultSet rs = db.executeQuery(sql);
    	     if(rs.next()){
    		      f=false;
    	     }
    	  }catch(Exception e){e.getMessage();}
    	return true;
    }	
    
    public boolean hasLogin(String name){
    	boolean f = true;
    	String sql="select ID from department where NAME='"+name+"'";
    	SQLBean db = new SQLBean();
    	try{
    	     ResultSet rs=db.executeQuery(sql);
    	     if(rs.next()){
    		      f = false;
    	      }
    	    }catch(Exception e){e.getMessage();}
    	return f;
    }	                    
		                    
}