editercourse.java

一个用于学生注册选课信息管理的简单的管理系统

import java.util.*;
import java.util.Vector;
import java.io.*;
import java.sql.*;
public class EditerCourse
{
    private Vector courses=new Vector();
    private Course aCourse;
    private Connection aConnection;
    private Statement aStatement;
    private Student aStudent;
    private String courseclassid;
    private String coursename;
    private String coursexuefen;
    private String courseteacher;
    private String coursetime;
    private String courselocation;
    public EditerCourse(Student s)           
    {
        setStudent(s);          
        initialize(); 
    }
    public void initialize()
    {
        String url="jdbc:odbc:StudentAdministrator";
        String driver="sun.jdbc.odbc.JdbcOdbcDriver";
        try
        {
            Class.forName(driver);
            aConnection=DriverManager.getConnection(url,"","");
            aStatement=aConnection.createStatement();
        }
        catch(ClassNotFoundException e)
        {   System.out.println(e);    }
        catch(SQLException e)
        {   System.out.println(e);    }
    }
    public void terminate()
    {
        try
        {
            aStatement.close();
            aConnection.close();
        }
        catch(SQLException e)
        {   System.out.println(e);    }
    }
    public Course findCourse(String s)throws NotFoundException               
    {
        Course aCourse=null;
        String sqlQuery="select * from sc where courseClassId='"+s+"' and studId='"+aStudent.getStudId()+"'";
        try
        {
            ResultSet rs=aStatement.executeQuery(sqlQuery);
            boolean gotIt=rs.next();
            if(gotIt)
            {
            }
            else 
            {   throw(new NotFoundException());  }
            rs.close();
        }
        catch(SQLException e)
        {   System.out.println(e);    }
        return aCourse;
    }
   /* 
    public Course creatCourse(String s) throws NotFoundException
    {
        Course newCourse=null;
        String newname=s;
        String sqlQuery="select * from 课程列表 where 课程名='"+newname+"'";
         try
        {
            ResultSet rs=aStatement.executeQuery(sqlQuery);
            boolean gotIt=rs.next();
            if(gotIt)
            {
                coursename=rs.getString(1);
                coursexuefen=rs.getString(2);
                courseteacher=rs.getString(3);
                coursetime=rs.getString(4);
                courselocation=rs.getString(5);
                newCourse=new Course(coursename,coursexuefen,courseteacher,coursetime,courselocation);
            }
            else 
            {   throw(new NotFoundException("未找到可注册"));  }
            rs.close();
        }
        catch(SQLException e)
        {   System.out.println(e); System.out.println("错误一");   }
        return newCourse;
    }
    */
   public void addCourse(String s)
    {   
        String sqlQuery="insert into sc(studId,courseClassId) values('"+aStudent.getStudId()+"','"+s+"')";
            try
            {    int result=aStatement.executeUpdate(sqlQuery);     }
            catch(SQLException e)
            {   System.out.println(e);      }
              
    }
    public void deleteCourse(String s1)
    {
        String sqlQuery="delete from sc where studId='"+aStudent.getStudId()+"' and courseClassId='"+s1+"'";
        try
        {            
            int result=aStatement.executeUpdate(sqlQuery);
        }
        catch(SQLException e)
        {   System.out.println(e);    }
    }
    public void setStudent(Student s)
    {   aStudent=s; }
    public Student getStudent()
    {   return aStudent;}

    public Vector getMyCourse()
    {
        String sqlQuery="select sc.courseClassId,course.courseName,course.courseXuefen,teacher.TeachName,courseClass.courseClassTime,courseClass.courseClassRoom from sc,teacher,courseClass,course where courseClass.courseClassCourseId=course.courseNo and courseClass.courseClassTeachNo=teacher.teachId and courseClass.courseClassId=sc.courseClassId and sc.studId='"+aStudent.getStudId()+"'";
        try
        {
            ResultSet rs=aStatement.executeQuery(sqlQuery);
            boolean moreData=rs.next();
            if(moreData)
                while(moreData)
                {
                    courseclassid=rs.getString(1);
                    coursename=rs.getString(2);
                    coursexuefen=rs.getString(3);
                    courseteacher=rs.getString(4);
                    coursetime=rs.getString(5);
                    courselocation=rs.getString(6);
                    aCourse=new Course(courseclassid,coursename,coursexuefen,courseteacher,
                            coursetime,courselocation); 
                    courses.add(aCourse);       
                    moreData=rs.next();
                }
            rs.close();
        }
        catch(SQLException e)
        {   System.out.println(e);    }
        return courses;
    }  
    
}

class DuplicateException extends Exception
{
    public DuplicateException(String key)
    {
        System.out.println(key);
    }
}