Review

finding-11

database/DatabaseAdmin.java

getGroupList(Connection)

class DatabaseAdmin {
	/**
	 * Returns a Map of a cappella groups with aid as key and 
	 * aname as value. If error, return null.
	 * @param conn
	 * @return HashMap of groups
	 */
	public static Map<Integer, String> getGroupList(Connection conn) {
		Map<Integer, String> groupList = new HashMap<Integer, String>();
		Statement stmt = null;
		ResultSet groups = null;
		String query = "SELECT aid, aname FROM main.acappella";
		try {
			stmt = conn.createStatement();
			groups = stmt.executeQuery(query);
			while (groups.next()) {
				groupList.put(groups.getInt("aid"), groups.getString("aname"));
			}
		} catch (SQLException e) {
			return null;
		} finally {
			DBManager.closeResultSet(groups);
			DBManager.closeStatement(stmt);
		}
		return groupList;
	}

}