【Java开源代码栏目提醒】:以下是网学会员为您推荐的Java开源代码-classp.java,希望本篇文章对您学习有所帮助。
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;
}
}