chgpass.java

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

package bean;   
import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
  
public class Chgpass{   
      Connection  Con=null;
      Statement   Stmt=null;   
      public Chgpass(){   
          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 String getN(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 int setPass(String num,String oldpass,String newpass){
	       int i=0;
	       try{
			   ResultSet result=Stmt.executeQuery("SELECT*FROM pass WHERE num ='"+num+"'");
			   if(result!=null){
		    	   result.next();
		    	   String formpass=(String)result.getString("pass");
		    	   if(oldpass.equals(formpass)){
			           Stmt.executeUpdate("UPDATE pass SET pass='"+newpass+"' WHERE num='"+num+"'");
			    	   i=1;
		    	   }
			   else i=2;
			   }
			   return i;
		   }
		   catch(Exception e){}   
            return i;
	  }
}