?? classp.java
字號(hào):
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); } }
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -