teacher.java

采用基于B/S结构进行开发学生管理信息系统,本系统采用Servlet+Jsp+JavaBean+MySQL 的设计方式

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

public class Teacher {
  
 private String id;
 private String name;
 private String password;
 private String title;
 private String dep;
 private String entryyear;
 
 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;}
 public void setDepart(String dep){this.dep=dep;}
 public String getDepart(){return dep;}
 public void setEntryyear(String year){entryyear=year;} 
 public String getEntryyear(){return entryyear;}	                     

 public ResultSet getInformation(String tea_id){
 	String sql = "select teacher.*,department.NAME from teacher,department where teacher.DEPARTMENT=department.ID and teacher.ID='"+tea_id+"'";
  SQLBean db =new SQLBean();
  ResultSet rs = db.executeQuery(sql);
  return rs;
}

 public ResultSet getCourse( ){
 	String sql="select DISTINCT(COUR_ID),NAME "+
          "from teach,course "+
           "where teach.TEA_ID='"+id+"' "+
          "and course.ID=teach.COUR_ID";
	    SQLBean  sqlbean = new SQLBean();
  	  ResultSet rs = sqlbean.executeQuery(sql);
  	  return rs;
	}
	
	public ResultSet getCourse(String id ){
 	String sql="select DISTINCT(COUR_ID),NAME "+
          "from teach,course "+
           "where teach.TEA_ID='"+id+"' "+
          "and course.ID=teach.COUR_ID";
	    SQLBean  sqlbean = new SQLBean();
  	  ResultSet rs = sqlbean.executeQuery(sql);
  	  return rs;
	}
	
	public ResultSet  getClaandCour(String tea_id){
		String sql="select COUR_ID,NAME,CLASS_ID from teach,course where course.ID=teach.COUR_ID and TEA_ID='"+tea_id+"'";
	  SQLBean db = new SQLBean();
	  ResultSet rs = db.executeQuery(sql);
	  return rs;
	}
	
	public ResultSet getDep(String dep){
	 String sql = "";
	 if(dep.equals("0000"))
	 	 sql = "select ID,NAME from department ";
	 else
     sql = "select ID,NAME from department where ID='"+dep+"'";	
   SQLBean db = new SQLBean();
   ResultSet rs = db.executeQuery(sql);
   return rs;
	}
	
	public ResultSet getTeacher(String cour_id){
		String sql = "select teacher.*,department.NAME from teacher,department,teach where teacher.DEPARTMENT=department.ID and teach.TEA_ID=teacher.ID and teach.COUR_ID='"+cour_id+"'";
    SQLBean db = new SQLBean();
    ResultSet rs = db.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,DEPARTMENT,ENTRYYEAR)  "+
		           "values('"+id+"','"+name+"','"+title+"','"+password+"','"+dep+"','"+entryyear+"') ";
		 SQLBean db =new SQLBean();
		 db.executeInsert(sql);          
	}
		                    
	public ResultSet getAll(String dep){
		
		String sql="";
		if(dep.equals("0000")){
			sql = "select teacher.*,department.NAME from teacher,department where teacher.DEPARTMENT=department.ID";
		}else{
		  sql = "select teacher.*,department.NAME from teacher,department where teacher.DEPARTMENT=department.ID and teacher.DEPARTMENT='"+dep+"'";
	  }
		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;
    	}			                    
		                    
}