loginuser.java

来自「精通从JavaScript到Jsp范例程序设计」· Java 代码 · 共 79 行

package xbook.bookstore ;

import xbook.common.*;
import java.sql.*;

public class loginUser{

	private boolean isMember;
	private boolean checked;
	private String id = "";
	private String password = "";
	private SQLBridge sqlBridge;
	
	public loginUser(){
	}
	
	public void setId( String id ){
		isMember = false;
		checked = false;
		this.id = id;
	}
	
	public String getId(){
		return this.id;
	}
	
	public void setPassword( String password ){
		isMember = false;
		checked = false;
		this.password = password;
	}
	
	public String getPassword(){
		return this.password;
	}
	
	public void setSqlBridge( SQLBridge sqlBridge ){
		isMember = false;
		checked = false;
		this.sqlBridge = sqlBridge;
	}
	
	public boolean isAdminUser() throws SQLException{
	
		if( !checked ){ 
			checked = true;
			try{
				sqlBridge.execSQL( "select password from adminUsers where id ='" + this.id + "'" );			
				if( sqlBridge.nextRow() && sqlBridge.getFieldString( "password" ).equals( password ) )
					this.isMember = true;
			}
			catch( SQLException	sqlex ){
				checked = false;
				throw sqlex;
			}			
		}	
		
		return this.isMember;
	}
	
	public boolean isMember() throws SQLException{
	
		if( !checked ){ 
			checked = true;
			try{
				sqlBridge.execSQL( "select password from users where del_mark = 'n' and id ='" + this.id + "'" );			
				if( sqlBridge.nextRow() && sqlBridge.getFieldString( "password" ).equals( password ) )
					this.isMember = true;
			}
			catch( SQLException	sqlex ){
				checked = false;
				throw sqlex;
			}			
		}	
		
		return this.isMember;
	}
	
}