mod.java

本系统采用Servlet+Jsp+JavaBean+SQL2000 设计方式

package bean;   
import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
  
public class Mod{   
      Connection  Con=null;
      Statement   Stmt=null;   
      public Mod(){   
          try{
		       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			   Con =DriverManager.getConnection("jdbc:odbc:pass","","");
			   Stmt=Con.createStatement();   
          }   
          catch(Exception e){   
               System.out.println("Error"+e.getMessage());   
          }
      }
	        
      public int getN(String num){
	       int i=0;
           try{
               ResultSet result=Stmt.executeQuery("SELECT*FROM pass WHERE num ='"+num+"'");
			   if(result!=null&&result.next())
			       i=1;
			   return i;                        
            }   
            catch(Exception e){}   
            return i;         
      }
	  
	  public String getEscore(String num){
	       try{
			   ResultSet result=Stmt.executeQuery("SELECT*FROM score WHERE num ='"+num+"'");
			   if(result!=null){
		    	   result.next();
			       return (result.getString("Escore"));
			   }
		   }
		   catch(Exception e){}   
            return null;
	  }
	  
	  public String getMscore(String num){
	       try{
			   ResultSet result=Stmt.executeQuery("SELECT*FROM score WHERE num ='"+num+"'");
			   if(result!=null){
	    		   result.next();
	    		   return (result.getString("Mscore"));
			   }
		   }
		   catch(Exception e){}   
            return null;
	  }
	  
	  public String getCscore(String num){
	       try{
			   ResultSet result=Stmt.executeQuery("SELECT*FROM score WHERE num ='"+num+"'");
			   if(result!=null){
		    	   result.next();
		    	   return (result.getString("Cscore"));
			   }
		   }
		   catch(Exception e){}   
            return null;
	  }
	  
	  public String getName(String num){
	       try{
			   ResultSet result=Stmt.executeQuery("SELECT*FROM pass WHERE num ='"+num+"'");
			   if(result!=null){
		    	   result.next();
	    		   return (result.getString("name"));
			   }
		   }
		   catch(Exception e){}   
            return null;
	  }
	  
	  public String getPass(String num){
	       try{
			   ResultSet result=Stmt.executeQuery("SELECT*FROM pass WHERE num ='"+num+"'");
			   if(result!=null){
	    		   result.next();
	    		   return (result.getString("pass"));
			   }
		   }
		   catch(Exception e){}   
            return null;
	  }
	  
	  public int setAll(String num,String name,String pass,String Escore,String Mscore,String Cscore){
	       int i=0,total;
		   total=(Integer.valueOf(Escore).intValue())+(Integer.valueOf(Mscore).intValue())+(Integer.valueOf(Cscore).intValue());
	       try{
			   Stmt.executeUpdate("UPDATE pass SET name ='"+name+"' WHERE num ='"+num+"'");
			   Stmt.executeUpdate("UPDATE pass SET pass ='"+pass+"' WHERE num ='"+num+"'");
			   Stmt.executeUpdate("UPDATE score SET Escore ='"+Escore+"' WHERE num ='"+num+"'");
			   Stmt.executeUpdate("UPDATE score SET Mscore ='"+Mscore+"' WHERE num ='"+num+"'");
			   Stmt.executeUpdate("UPDATE score SET Cscore ='"+Cscore+"' WHERE num ='"+num+"'");
			   Stmt.executeUpdate("UPDATE score SET Total='"+total+"' WHERE num='"+num+"'");
			   i=1;
			   return i;
		   }
		   catch(Exception e){}   
            return i;
	  }
}