course.java

采用基于B/S结构进行开发学生管理信息系统,本系统采用Servlet+Jsp+JavaBean+MySQL 的设计方式

package myBean;
import java.sql.*;
import myBeans.SQLBean;

public class Course {  
  private String id;
  private String name;
  private String dep;
  private String prepare;
  private float credit;
  private int period;
  private String semester;
  
  public void setPeriod(int period){this.period=period;}
  public int getPeriod(){return period;}
  public void setSemester(String s){semester=s;}
  public String getSemester(){return semester;}
  public void setPrepare(String s){prepare=s;}
  public String getPrepare(){return prepare;}
  public void setCredit(float s){credit=s;}
  public float getCredit(){return credit;}
  public void setDep(String s){dep=s;}
  public String getDep(){return dep;}
  public String getId() {
    return id;
  }
  public void setId(String id) {
    this.id = id;
  }
  public String getName() {
    return name;
  }
  public void setName(String name) {
    this.name = name;
  }

  public ResultSet getPrepares(){               //得到所能选择的预修课
 	String sql="select NAME,ID from course ";
 	SQLBean db = new SQLBean();
 	ResultSet rs = db.executeQuery(sql);
 	return rs; 	
 	}
 	
 		
 	public String getPrepareDep(){                 //察看预修课所在系
 		String s="no";
 	String sql="select DEPARTMENT from course ";
 	SQLBean db = new SQLBean();
 	try{
 	ResultSet rs = db.executeQuery(sql);
 	if(rs.next()){
 	   s=rs.getString("DEPARTMENT");  	   			
 		}
 	}catch(Exception e){ e.getMessage();}		
 	return s;}
 	
 	
    public ResultSet  getCour(String dep){ 
    	String sql = "";        //察看所有课程
		if(dep.equals("0000")){
		   sql = "select course.*,department.NAME from course,department where course.DEPARTMENT=department.ID";
		  }else{
		   sql = "select course.*,department.NAME from course,department where course.DEPARTMENT=department.ID and DEPARTMENT='"+dep+"'";
		}
		SQLBean db= new SQLBean();
		ResultSet rs = db.executeQuery(sql);
		 return rs;
		 }
	
	public ResultSet getCourse(String id){//查看课程信息
		String sql="select * from course  where ID='"+id+"'";
		SQLBean db= new SQLBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}	                         
	 
	 public ResultSet getMark(String id,String dep){//查看课程成绩
	 	String sql="";
	 	if(dep.equals("0000")){
	 		sql = "select ID,NAME,GRADE,CLASS_ID from stu_course,student where COURSEID='"+id+"' and ID=STUID order by ID";
	 	}else{sql = "select ID,NAME,GRADE,CLASS_ID from stu_course,student where COURSEID='"+id+"' and ID=STUID and DEPARTMENT='"+dep+"' order by ID";}
	 	SQLBean db=new SQLBean();
	 	ResultSet rs = db.executeQuery(sql);
	 	return rs;
	}
	  
	  public void updateMark(String stu_id,String cour_id,String grade){
	  	String sql = "update stu_course set GRADE='"+grade+"' where STUID='"+stu_id+"' and COURSEID='"+cour_id+"'";
      SQLBean db = new SQLBean();
      db.executeInsert(sql);
	  }
	                         
    public int deleteCourse(String id){  
        int num=0; 	
    	String sql="delete  from Course where ID ='"+id+"' ";
    	SQLBean db= new SQLBean();
        num=db.executeDelete(sql);
        return num;
    }                                           	
 	
 	public String getPrepareDep(String id){
 		String dep="";
 		String sql="select DEPARTMENT from course where ID='"+id+"'";
 		SQLBean db= new SQLBean();
 		try{
 		ResultSet rs = db.executeQuery(sql);
 		if(rs.next()) 
 		dep=rs.getString("DEPARTMENT");
 	       }catch(SQLException e){System.out.print(e.toString());}
 		return dep;
 		}
    public void updateCourse(String id){    	
      String sql="update course "+
                 " set NAME='"+name+"',PREPARE='"+prepare+"',"+
                 "DEPARTMENT='"+dep+"',CREDIT='"+credit+"',"+"PERIOD='"+period+"',SEMESTER='"+semester+"' "+
                 " where ID='"+id+"' ";
      SQLBean db= new SQLBean();
      db.executeInsert(sql);
   }
    	
    	
 	public void addCourse(){      
 		String sql="insert into course(ID,NAME,CREDIT,PREPARE,DEPARTMENT,PERIOD,SEMESTER) "+
 		           "VALUES('"+id+"','"+name+"','"+credit+"','"+prepare+"','"+dep+"','"+period+"','"+semester+"') ";
 		 SQLBean db = new SQLBean();
 		 db.executeInsert(sql);           
 		                  }	
 	
    public boolean hasLogin( String id){
    	boolean f=true;
    	String sql="select ID from course where ID='"+id+"'  ";
    	SQLBean db = new SQLBean();
    	try{
    	ResultSet rs =db.executeQuery(sql);
    	if(rs.next())
    	{f=false;}
          }catch(Exception e){ e.getMessage();}
    	return f;   
    	}
}