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 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 hasMoreclass(){   //檢查教師是否同一時(shí)間上兩門課程        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 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);  		}                    }