package com.course;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(String id){     	boolean f=false;    String sql="select id from classes where id ='"+id+"'";  	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 hasMoreclass(String tea_id,String cour_time){           String temp="";    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()){ temp=rs.getString("id");}  	else{ temp="no";}  	}catch(Exception e){ System.out.print(e.getMessage());}  	return temp;          	                  }  	                    //添加班級 	                    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+"') ";  	    try{         		sqlBean db =new sqlBean();   		db.executeInsert(sql);} catch(Exception e){System.out.print(e.toString());}  		}  		  	//更新班級信息	   public void updateClass(String id,String tea_id,String cour_id,                           String room_id,String cour_time){    	      String sql="update classes "+                 " set tea_id='"+tea_id+"',cour_id='"+cour_id+"',"+                 "room_id='"+room_id+"',cour_time='"+cour_time+"'  "+                 " where id='"+id+"' ";                 sqlBean db= new sqlBean();                 db.executeInsert(sql);                 }    //更新班級信息的異構形式，不包含教師和時間參數               public void updateClass(String id,String cour_id,                          String room_id){    	      String sql="update classes "+                 " set cour_id='"+cour_id+"',"+                 "room_id='"+room_id+"' "+                 " where id='"+id+"' ";                 sqlBean db= new sqlBean();                 db.executeInsert(sql);                 }           //刪除班級                public int deleteClass(String id){          int num=0; 	    	String sql="delete  from classes where id ='"+id+"' ";    	sqlBean db= new sqlBean();        num=db.executeDelete(sql);        return num;    	}    //得到全部班級信息	   public ResultSet getClasses(){   	   	String sql="select classes.id,tea_id,cour_id,room_id,cour_time, "+			"course.name as cour_name,teacher.name as tea_name "+      		"from classes ,course,teacher  "+     		"where classes.cour_id=course.id "+    		"and classes.tea_id=teacher.id ";   			sqlBean db= new sqlBean();		ResultSet rs = db.executeQuery(sql);		 return rs;              	} 	                                           	 	   	                   }