classp.java

《JSP程序设计实用教程》-梁建武-源代码（补充）-4567.rar

 package stu;
 
import java.sql.*;

public class classp  {

  private String id;
  private String cour_id;
  private String tea_id;
  private String room_id;
  private String cour_time;
  public String getId() {
    return id;
  }
  public void setId(String id) {
    this.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  getClassp(){         //察看所有课程
		String sql="select * from classes   ";
		sqlBean db= new sqlBean();
		ResultSet rs = db.executeQuery(sql);
		 return rs;
		                         }

  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 boolean hasLogin(){   
  	boolean f=true;
    String sql="select id from classes 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 boolean hasMoretea(){   //检查教师是否同一时间上两门课程
              boolean f=true;
              String sql="select id from classes  "+
              "where tea_id='"+tea_id+"' and cour_time='"+cour_time+"'   "; 
              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 boolean hasMoreroom(){   //检查同一教室是否同一时间上两门课程
              boolean f=true;
              String sql="select id from classes  "+
              "where room_id='"+room_id+"' and cour_time='"+cour_time+"'   "; 
              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 addClass(){	
  	String sql="insert into classes(id,tea_id,cour_id,room_id,cour_time)  "+
  	           "values('"+id+"','"+tea_id+"','"+cour_id+"','"+room_id+"','"+cour_time+"') ";
  	           
  		sqlBean db =new sqlBean(); 
  		db.executeInsert(sql);
  		}                  
    public void deleteClass(){   	
    	String sql="delete  from classes where id ='"+id+"' ";
    	sqlBean db= new sqlBean();
    	db.executeDelete(sql);
    	}       
}