package business.usermanage;

import java.sql.*;
import foundation.database.*;
import foundation.common.*;

/**
 * Title:       用戶登錄信息檢查
 */

public class Login extends DbCommunion {
	private String username;	//登錄用戶名
	private String passwd;		//登錄密碼
	private boolean isadmin;	//是否管理員登錄
	private long userid=0;		//用戶ID號

        /**
          * Executes a given statement on the given connection.  This object immediately becomes useless
          * after construction... it's meant as a one time execution.
          * @param connString java.lang.String
          * @param tableName java.lang.String
          * @exception com.lokitech.town.DataSetException The exception description.
          * @exception com.lokitech.town.ConnectionException The exception description.
          */
        public Login(String driver, String connString) throws CommonException
        {
            super(driver, connString);
            username = "";
            passwd = "";
            isadmin = false;
        }
        /**
          * Executes a given statement on the given connection.  This object immediately becomes useless
          * after construction... it's meant as a one time execution.
          * @param connString java.lang.String
          * @param tableName java.lang.String
          * @exception com.lokitech.town.DataSetException The exception description.
          * @exception com.lokitech.town.ConnectionException The exception description.
          */
        public Login(String driver, String connString,
                String username, String password) throws CommonException
        {
            super(driver, connString, username, password);
            username = "";
            passwd = "";
            isadmin = false;
        }

	public String getUsername() {
		return username;
	}
	public void setUsername(String newusername) {
		username = newusername;
	}

	public String getPasswd() {
		return passwd;
	}
	public void setPasswd(String newpasswd) {
		passwd = newpasswd;
	}

	public boolean getIsadmin() {
		return isadmin;
	}
	public void setIsadmin(boolean newIsadmin) {
		isadmin = newIsadmin;
	}

	public long getUserid() {
		return userid;
	}

	public void setUserid (long uid) {
		userid = uid;
	}

	public String getSql() {
                String sqlStr = "";
		if (isadmin) {
			sqlStr = "select * from my_BookAdminuser where adminuser = '" + StringUtils.toSql(username) + "' and adminpass = '" + StringUtils.toSql(passwd) + "'";
		}else {
			sqlStr = "select * from my_users where username = '" + StringUtils.toSql(username) + "' and password = '" + StringUtils.toSql(passwd) + "'";
		}
		return sqlStr;
	}

	public boolean excute() throws Exception {
                ResultSet rs = null;
		boolean flag = false;
		rs = executeQuery(getSql());
		if (rs.next()){
			if (!isadmin)
			{
				userid = rs.getLong("id");
			}
			flag = true;
		}
		rs.close();
		close();
		return flag;
	}
};