passw.java

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

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