dboperatorstudent.java

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

// DBOperatorStudent.java

package caoyu;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;


public class DBOperatorStudent {
   Connection conn = null;
   PreparedStatement ps = null;
   Statement stmt = null;
   ResultSet rs = null;	
   public DBOperatorStudent()
   {
   	  try {
   	     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   	     conn = DriverManager.getConnection("jdbc:odbc:MyOwn","","");	
   	  }
   	  catch(Exception ex) {
   	     System.out.println(ex.getMessage());	
   	  }
   }
  public int addStudent(Students s) {
      int count=0;
      try{
          ps = conn.prepareStatement("insert into student values(?,?,?,?,?,?)");
          ps.setString(1,s.sname);
          ps.setString(2,s.sno);
          ps.setString(3,s.ssex);
          ps.setString(4,s.classno );
          ps.setString(5,s.birthday  );
          ps.setString(6,s.address  );
          count = ps.executeUpdate();
          ps.close();
          conn.close();
       }
       catch(Exception ex) {
          System.out.println(ex.getMessage());
       }
       return count;
    }
     public int addClass(Classes cl){                         //增加班级
    	int count=0;
    	try{ps=conn.prepareStatement("insert into class values(?,?,?,?,?,?)");
    		ps.setString(1,cl.classno);
    		ps.setString(2,cl.departmentno);
    		ps.setString(3,cl.gross_number);
    		ps.setString(4,cl.enter_date);
    		ps.setString(5,cl.monitor);
    		ps.setString(6,cl.major);
    		count = ps.executeUpdate();
          ps.close();
          conn.close();

    		}
    	
    	catch(Exception ex) {
          System.out.println(ex.getMessage());
       }
       return count;
    	
    	
    	
    }
    
    public void deleteClass(String cl){                          //删除班级
    	int count=0;
    	try{stmt=conn.createStatement();
    	    stmt.executeQuery("delete from class where classno='"+cl+"'");
    		
    	  
          ps.close();
          conn.close();

    		}
    	
    	catch(Exception ex) {
          System.out.println(ex.getMessage());
       }

    }
    
    
    
    
    public ResultSet queryStudent(String sno) {          //按学号查询的学生信息
       try{
       ps=conn.prepareStatement("execute proc_by_sno ?");   //存储过程实现(1)
       
            ps.setString(1,sno);
           // if(ps.executeUpdate()>=1)                           //注意这里的参数 很容易出错
                       
    		rs = ps.executeQuery();
    	    	//else 
    		 //JOptionPane.showMessageDialog(null,"学号不存在 ",
             //"WARING",JOptionPane.WARNING_MESSAGE);    
    		
    		
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
    
     public ResultSet queryStudent1(String sname) {   //指定学生名学生信息
       try{
       ps= conn.prepareStatement("execute proc_by_sname ?");//存储过程实现(2)
       ps.setString(1,sname);
       rs=ps.executeQuery();
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
    public ResultSet queryStudent2(String classno) {             //每个班级学生信息
       try{
      ps = conn.prepareStatement("execute pro_by_class ?"); //存储过程实现(3)
      ps.setString(1,classno);
      rs=ps.executeQuery();
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
   public ResultSet queryStudent4(String no) {                 //系信息
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select * from department where departmentno like'"+no+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
   
   public ResultSet queryStudent5(String sname) {//班级信息
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select * from class where monitor like'"+sname+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
   
    
    	public ResultSet queryStudent3(String monitor) {//系信息
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select * from class where monitor like'"+monitor+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
    	
    	
    	
    		public ResultSet queryStudent6(String classno) {//班级信息
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select * from class where classno like'"+classno+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
    	
    		
    	public ResultSet queryStudent7(String depatmentName) {//全系的班级信息
       try{
       stmt = conn.createStatement();
       rs = stmt.executeQuery("select s.classno,s.departmentno ,s.gross_number  ,s.enter_date  ,monitor ," 
        +"major from department,class s  where s.departmentno=department.departmentno and department_name like'"+depatmentName+"%'");
       }
       catch(Exception ex){
       	  System.out.println(ex.getMessage());
       }
       return rs;		
    }
    	
    	
    	
    	
    	
    	
    public void deleteStudnet(String sno) {     //删除学生（触发器）
       try{
          
          ps=conn.prepareStatement("delete from student where sno ='"+sno+"'");
          
          if(ps.executeUpdate()>=1)
          JOptionPane.showMessageDialog(null,"删除成功 ",
		 	         "WARING",JOptionPane.WARNING_MESSAGE);
	    	else
	    	 JOptionPane.showMessageDialog(null,"学号不存在 ",
		 	         "WARING",JOptionPane.WARNING_MESSAGE);       
          stmt.close();
          conn.close();
       }
       catch(Exception ex) {
          System.out.println(ex.getMessage());
       }	
    }
}