achgpass.java

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

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