package com.course;
import java.sql.*;

public class teacher {
//定義教師相關的信息
 String id;
 String name;
 String password;
 String title;
 
 public void setPassword(String s){password = s;}
 public String getPassword(){return password;}
 public void setName(String s){name=s;}
 public String getName(){return name;}
 public void setTitle(String  s){title=s;}
 public String getTitle(){return title;}
 public String  getId(){return id;}	                    
 public void setId(String id){this.id=id;} 	                     
 //根據教師ID得到所教授的全部課程信息
 public ResultSet getCourse( ){
 	String sql="select course.name "+
          "from classes,course "+
           "where classes.tea_id='"+id+"' "+
          "and course.id=classes.cour_id";
	  sqlBean  sqlbean = new sqlBean();
  	  ResultSet rs = sqlbean.executeQuery(sql);
  	  return rs;
	}
	
//檢查該教師是否已經注冊
	public boolean hasLogin(String id){   
  	boolean f=true;
   String sql="select id from teacher where id ='"+id+"'";
  	sqlBean db =new sqlBean();
  	try{
  	ResultSet rs=db.executeQuery(sql);
  	if(rs.next()){ f=false;}
  	else{ f=true;}
  	}catch(Exception e){ e.getMessage();}
  	return f;
  	                       }
	
	//添加新教師
	public void addTeacher(){
		
		String sql="insert into teacher(id,name,title,password)  "+
		           "values('"+id+"','"+name+"','"+title+"','"+password+"') ";
		 sqlBean db =new sqlBean();
		 db.executeInsert(sql);          
		                    }
	//得到全部教師信息	                    
	public ResultSet getAll(){
		
		String sql="select * from teacher";
		sqlBean db =new sqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
		}
	//更新教師信息	
    public  void update()	{
    	
    	String sql= "update teacher set name='"+name+"', "+
    	             "title='"+title+"' ,password='"+password+"' "+
    	             "where id='"+id+"' ";
    	
    	            sqlBean db =new sqlBean();
    	           db.executeInsert(sql); 
    	           
    	}
    	
    //刪除教師	
    public int delete(String id){
    	int num=0;
    	String sql="delete  from teacher where id ='"+id+"' ";
    	sqlBean db= new sqlBean();
    	num=db.executeDelete(sql);
    	return num;
    	}			                    
		                    
}