admin.java

学习jsp时做的一个书馆

 package library;

import java.sql.*;

public class admin{
    private String accountNo = "";
    private String passwd = "";
    
    public admin(String aNo,String pw){
    	accountNo = aNo;
    	passwd = pw;
    }
    
    public boolean isLogin()throws Exception {
    		
    	    DBConnection myConnection = DBConnection.Instance();
    		String sqlQuery = "select * from admin where adminId='" + this.accountNo +"' and passwd = '"+this.passwd+ "'";
    		ResultSet r = null;
    		
    		r = myConnection.runQuery( sqlQuery );
    		if (r.next()){
               return true;
    		}else{
			   return false;   
    		}
			
    }
}