Review

finding-3

database/SocialNetworkDatabaseBoards.java

isBoardAdmin(Connection, String, String)

class SocialNetworkDatabaseBoards {
	/**
	 * Checks whether the user is part of this board.
	 * Assumes the board is valid.
	 */
	public static Boolean isBoardAdmin(Connection conn, String username, String boardName) {
		String isAdminQ = "SELECT * FROM main.boardadmins WHERE username = ? AND bname = ?";
		PreparedStatement pstmt = null;
		ResultSet adminResult = null;
		Boolean isAdmin = null;
		try {
			pstmt = conn.prepareStatement(isAdminQ);
			pstmt.setString(1, username);
			pstmt.setString(2, boardName);
			adminResult = pstmt.executeQuery();
			isAdmin = new Boolean(adminResult.next());
		}
		catch (SQLException e) {
			e.printStackTrace();
		}
		finally {
			DBManager.closePreparedStatement(pstmt);
			DBManager.closeResultSet(adminResult);
		}
		return isAdmin;
	}

}