ins.java

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

package bean;   
import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
  
public class Ins{   
      Connection  Con=null;
      Statement   Stmt=null;  
      public Ins(){   
          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 Insert(String num){
	       int i=0;
           try{
		       ResultSet result=Stmt.executeQuery("SELECT*FROM pass WHERE num ='"+num+"'");
			   if(result!=null&&result.next())i=2;
			   else{
                   Stmt.executeUpdate("INSERT INTO pass(num) VALUES('"+num+"')");
				   Stmt.executeUpdate("INSERT INTO score(num) VALUES('"+num+"')");
				   i=1;
			   }
			   return i;                          
            }   
            catch(Exception e){}  
            return i;         
      }
	  
	  public int InsName(String num,String name,String pass){
	       int i=0;
           try{
		       ResultSet result=Stmt.executeQuery("SELECT*FROM pass WHERE num ='"+num+"'");
			   if(result!=null&&result.next()){
                   Stmt.executeUpdate("UPDATE pass SET name='"+name+"' WHERE num='"+num+"'");
				   Stmt.executeUpdate("UPDATE pass SET pass='"+pass+"' WHERE num='"+num+"'");
				   i=1;
			   }
			   return i;                          
            }   
            catch(Exception e){}   
            return i;         
      }
	  
	  
	  public int InsScore(String num,String Escore,String Mscore,String Cscore){
	       int i=0,total;
		   total=(Integer.valueOf(Escore).intValue())+(Integer.valueOf(Mscore).intValue())+(Integer.valueOf(Cscore).intValue());
           try{
		       ResultSet result=Stmt.executeQuery("SELECT*FROM pass WHERE num ='"+num+"'");
			   if(result!=null&&result.next()){
                  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='"+Integer.toString(total)+"' WHERE num='"+num+"'");
				  i=1;
			   }
			   return i;                          
            }   
            catch(Exception e){}   
            return i;         
      }
}