dboperatorcourse.java

这个是我二年级写的一个教务管理系统 大家可以下来

// DBOperatorCourse.java

package caoyu;

import java.sql.*;

   class DBOperatorCourse {
   Connection conn = null;
   PreparedStatement ps = null;
   Statement stmt = null;
   ResultSet rs = null;	
   public DBOperatorCourse()
   {
   	  try {
   	     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   	     conn = DriverManager.getConnection("jdbc:odbc:MyOwn","","");	
   	  }
   	  catch(Exception ex) {
   	     System.out.println(ex.getMessage());	
   	  }
   }
   public int addCourse(Course c) {
      int count=0;
      try{
          ps = conn.prepareStatement("insert into Course values(?,?,?,?,?)");
          ps.setString(1,c.cno);
          ps.setString(2,c.cname);
          ps.setString(3,c.tno);
          ps.setString(4,c.credit);
          ps.setString(5,c.period);
          count = ps.executeUpdate();
          ps.close();
          conn.close();
       }
       catch(Exception ex) {
          System.out.println(ex.getMessage());
       }
       return count;
    }
    public ResultSet queryCourse(String cno) {
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select * from Course  where cno like'"+cno+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
    
    public ResultSet queryCourse1(String sno) {    //按学号查找选课信息(视图)
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select * from courseInformation  where sno like'"+sno+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
    public ResultSet queryCourse2(String sname) {    //按姓名查找选课信息（视图）
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select * from courseInformation  where sname like'"+sname+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
    
    public ResultSet queryCourse3(String sno) {        //供选课信息(视图)
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select * from For_select_course  where cno like'"+sno+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
     
    public ResultSet queryCourse4(String sno) {        //个人成绩表格打印 (视图)
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select * from Mark_by_sno  where sno like'"+sno+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
    
    public ResultSet queryCourse5(String classno) {         //班级成绩表格打印
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select  s.sno,s.sname, sum(grade) from student s,grade g,class cla where "
       +"s.sno=g.sno and s.classno=cla.classno and "
       +"cla.classno='"+classno+"'group by s.sno,s.sname order by sum(grade) desc ");

       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
    public void deleteCourse(String cname) {
       try{
          stmt = conn.createStatement();
          stmt.executeUpdate("delete from Course  where cname ='"+cname+"'");
          stmt.close();
          conn.close();
       }
       catch(Exception ex) {
          System.out.println(ex.getMessage());
       }	
    }
}