teach.java

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

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

public class Teach {

  private String class_id;
  private String cour_id;
  private String tea_id;
  private String room_id;
  private String cour_time;
  public String getClass_Id() {
    return class_id;
  }
  public void setClass_Id(String id) {
    this.class_id = id;
  }
  public String getCour_id() {
    return cour_id;
  }
  public void setCour_id(String cour_id) {
    this.cour_id = cour_id;
  }
  public String getTea_id() {
    return tea_id;
  }
  public void setTea_id(String tea_id) {
    this.tea_id = tea_id;
  }
  public String getRoom_id() {
    return room_id;
  }
  public void setRoom_id(String room_id) {
    this.room_id = room_id;
  }
  public String getCour_time() {
    return cour_time;
  }
  public void setCour_time(String time) {
    this.cour_time = time;
  }
  
  public ResultSet getCour_Teach(String classid, String semester){
  	String sql = "select course.NAME,teacher.NAME,COUR_TIME,ROOM from teach,course,teacher where teacher.ID=TEA_ID and course.ID=COUR_ID and CLASS_ID='"+classid+"' and SEMESTER='"+semester+"'";
    SQLBean db = new SQLBean();
    ResultSet rs = db.executeQuery(sql);
    return rs;
  }
  
  public String[][] getTea_Cour(String tea_id,int yea,int month){
  	String sql = "select CLASS_ID,course.NAME,COUR_TIME,ROOM,SEMESTER from course,teach where COUR_ID=ID and TEA_ID='"+tea_id+"'";
  	SQLBean db = new SQLBean();
  	String semester = "";String teac[][] = new String[4][5];
 try{
  	ResultSet rs = db.executeQuery(sql);
  	while(rs.next()){
  		int year = Integer.parseInt(rs.getString(1).substring(0,4));
  		int t = yea - year;
  		if(t <= 4 && month < 9){
         switch(t){
	         case 1: semester = "第二学期";break;
	         case 2: semester = "第四学期";break;
	         case 3: semester = "第六学期";break;
	         case 4: semester = "第八学期";break;
          }
      }else if(t < 4){
         switch(t){
           case 0: semester = "第一学期";break;
	         case 1: semester = "第三学期";break;
	         case 2: semester = "第五学期";break;
	         case 3: semester = "第七学期";break;
         }
  	  }else{}
  	  if(rs.getString(5).equals(semester)){
  	  	 String cour_time = rs.getString(3);
         for(int i=1;i<5;i++){
            if(cour_time.endsWith(String.valueOf(i))){
	             int j = 0;
	             if(cour_time.startsWith("M")){
		              j = 0;
		           }else if(cour_time.startsWith("Tu")){
		              j = 1;
		           }else if(cour_time.startsWith("W")){
		              j = 2;
		           }else if(cour_time.startsWith("Th")){
		              j = 3;
		           }else if(cour_time.startsWith("F")){
		              j = 4;
		           }
		           if(teac[i-1][j] == null)
		              teac[i-1][j] = rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(4);
		           else
		              teac[i-1][j] = teac[i-1][j]+" "+rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(4);
	         }
         }
  	  }
  }
 }catch(Exception e){e.getMessage();}
  return teac;
}
  
  public ResultSet getTeachers(){
  	String sql="select ID,NAME from teacher  ";
  	SQLBean db = new SQLBean();
  	ResultSet rs = db.executeQuery(sql);
  	return rs;
  }
    	                          
  public ResultSet getCourses(){
  	  	String sql="select ID,NAME from course  ";
  	SQLBean db = new SQLBean();
  	ResultSet rs = db.executeQuery(sql);
  	return rs;  	          
  }
  
  public ResultSet getClass_id(){
     String sql = "select ID from class";
     SQLBean db = new SQLBean();
     ResultSet rs = db.executeQuery(sql);
     return rs;
  }                            
  public boolean hasLogin(String id,String cour_time){   
  	boolean f=false;
    String sql="select CLASS_ID from teach where CLASS_ID ='"+id+"' and COUR_TIME='"+cour_time+"'";
  	SQLBean db =new SQLBean();
  	try{
  	ResultSet rs=db.executeQuery(sql);
  	if(rs.next()){ f=true;}
  	else{ f=false;}
  	}catch(Exception e){ e.getMessage();}
  	return f;
  }
  	
  	public String hasMoretea(String class_id,String cour_id){
  	  boolean f = false;String temp="";
  	  String sql="select TEA_ID from teach where CLASS_ID='"+class_id+"' and COUR_ID='"+cour_id+"'";
  	  SQLBean db = new SQLBean();
  	  ResultSet rs = null;
  	  try{
  	     rs=db.executeQuery(sql);
  	     if(rs.next()){
  	     	 temp = rs.getString(1);
  	     }
  	     else{temp = "no";}
  	    }catch(Exception e){ System.out.print(e.getMessage());}
  	    return temp;
  	}
  	                                                                              
   public ResultSet hasMorecourse(String tea_id,String cour_time){   //检查教师是否同一时间上两门课程
    
    String sql="select COUR_ID,ROOM from teach  "+
               "where TEA_ID='"+tea_id+"' and COUR_TIME='"+cour_time+"' "; 
      SQLBean db = new SQLBean();  
      ResultSet rs = null;       	
   try{
  	rs =db.executeQuery(sql);
  	}catch(Exception e){ System.out.print(e.getMessage());}
  	return rs;        
  }
  	                  
  public String hasMoreteacher(String cour_time,String room_id){
  	String temp = "";
    String sql="select TEA_ID from teach where COUR_TIME='"+cour_time+"' and ROOM='"+room_id+"'";
    try{
      SQLBean db = new SQLBean();
      ResultSet rs=db.executeQuery(sql);
      if(rs.next()){
      	temp = rs.getString(1);
      }else{temp = "no";}
  }catch(Exception e){ System.out.print(e.getMessage());}
   return temp;
  }
  	                  
  public void addTeach(){
  	String sql="insert into teach(CLASS_ID,TEA_ID,COUR_ID,ROOM,COUR_TIME)  "+
  	           "values ('"+class_id+"','"+tea_id+"','"+cour_id+"','"+room_id+"','"+cour_time+"') ";
  	    try{       
  		    SQLBean db =new SQLBean(); 
  		    db.executeInsert(sql);
  		   } catch(Exception e){System.out.print(e.toString());}
  		}
  		
  		
   public void updateTeach(String id,String tea_id,String cour_id,
                           String room_id,String cour_time){    	
      String sql="update teach "+
                 " set TEA_ID='"+tea_id+"',COUR_ID='"+cour_id+"',"+
                 "ROOM='"+room_id+"',COUR_TIME='"+cour_time+"'  "+
                 " where CLASS_ID='"+id+"' ";
                 SQLBean db= new SQLBean();
                 db.executeInsert(sql);
   }
                 
  public void updateTeach(String id,String cour_id,
                          String room_id){    	
      String sql="update teach "+
                 " set COUR_ID='"+cour_id+"',"+
                 "ROOM='"+room_id+"' "+
                 " where CLASS_ID='"+id+"' ";
                 SQLBean db= new SQLBean();
                 db.executeInsert(sql);
  }       
                 
   public int deleteTeach(String id,String cour_id,String cour_time){  
        int num=0; 	
    	  String sql="delete  from teach where CLASS_ID ='"+id+"' and COUR_ID='"+cour_id+"' and COUR_TIME='"+cour_time+"'";
    	  SQLBean db= new SQLBean();
        num=db.executeDelete(sql);
        return num;
   }
    	
   public ResultSet getTeach(){
   	
   	String sql="select CLASS_ID,TEA_ID,COUR_ID,ROOM,COUR_TIME, "+
			"course.NAME COUR_NAME,teacher.NAME TEA_NAME "+
      		"from teach ,course,teacher  "+
     		"where teach.COUR_ID=course.ID "+
    		"and teach.TEA_ID=teacher.ID ";
   	 SQLBean db= new SQLBean();
		 ResultSet rs = db.executeQuery(sql);
		 return rs;           
   	} 	                                           	
 	   	                 
  
}