Review

finding-7

/mubench/checkouts/chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabaseBoards.java

getBoardAdmins(Connection, String)

class SocialNetworkDatabaseBoards {
	public static ArrayList<String> getBoardAdmins(Connection conn, String board) {
		if (board.equals("freeforall")) {
			return null;
		}
		ArrayList<String> admins = new ArrayList<String>();
		String query = "SELECT * FROM main.boardadmins WHERE bname = ?";
		PreparedStatement pstmt = null;
		ResultSet adminResults = null;
		try {
			pstmt = conn.prepareStatement(query);
			pstmt.setString(1, board);
			adminResults = pstmt.executeQuery(query);
			while (adminResults.next()) {
				admins.add(adminResults.getString("username"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBManager.closePreparedStatement(pstmt);
			DBManager.closeResultSet(adminResults);
		}
		return admins;
	}

}