String sqlStatement = "SELECT AccountHolderId, Passcode from CIS4720.DBO.AccountHolder " +
"where Username)= '" + logonName + "'";

while (rset.next())
    {
        if(rset.getInt("Username")=logonName){
            int whosOnFirst = rset.getInt("AccountHolderId");
        }