dboperatorteacher.java

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

// DBOperatorTeacher.java

package caoyu;

import java.sql.*;

public class DBOperatorTeacher {
   Connection conn = null;
   PreparedStatement ps = null;
   Statement stmt = null;
   ResultSet rs = null;	
   public DBOperatorTeacher()
   {
   	  try {
   	     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   	     conn = DriverManager.getConnection("jdbc:odbc:MyOwn","","");	
   	  }
   	  catch(Exception ex) {
   	     System.out.println(ex.getMessage());	
   	  }
   }
    public int addTeacher(Teachers tea) {
      int count=0;
      try{
          ps = conn.prepareStatement("insert into teacher values(?,?,?,?,?,?)");
          ps.setString(1,tea.tname);
          ps.setString(2,tea.tno);
          ps.setString(3,tea.tsex);
          ps.setString(4,tea.pro);
          ps.setString(5,tea.telephone);
          ps.setString(6,tea.address);
          count = ps.executeUpdate();
          ps.close();
          conn.close();
       }
       catch(Exception ex) {
          System.out.println(ex.getMessage());
       }
       return count;
    }
    public ResultSet queryTeacher(String tno) {    //按教师号查找教师信息
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select * from teacher where tno like'"+tno+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
    
      public ResultSet queryTeacher3(String tname) {    //按教师姓名查找教师信息
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select * from teacher where tname like'"+tname+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
    public ResultSet queryTeacher1(String tno) {   //按教师号查找授课信息(视图)
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select * from teaching_information_by_tno where tno like'"+tno+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }

    public ResultSet queryTeacher2(String tname) {   //按教师姓名查找授课信息(视图)
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select * from teaching_information_by_tno where tname like'"+tname+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
    
    public void deleteTeacher(String tno) {
       try{
          stmt = conn.createStatement();
          stmt.executeUpdate("delete from teacher where tno ='"+tno+"'");
          stmt.close();
          conn.close();
       }
       catch(Exception ex) {
          System.out.println(ex.getMessage());
       }	
    }
}