Review

finding-16

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

getAllUsersOfGroup(Connection, int)

class DatabaseAdmin {
	/**
	 * Retrieves a list of all users of a group given the group's aid. Returns null 
	 * if error.
	 * @param conn
	 * @param aid
	 * @return 
	 */
	public static List<String> getAllUsersOfGroup(Connection conn, int aid) {
		List<String> users = new ArrayList<String>();
		String query = "SELECT username FROM main.users WHERE aid = ?";
		PreparedStatement pstmt = null;
		ResultSet result = null;
		try {
			pstmt = conn.prepareStatement(query);
			pstmt.setInt(1, aid);
			result = pstmt.executeQuery();
			while (result.next()) {
				users.add(result.getString("username"));
			}
			if (users.size() == 0) {
				users = null;
			}
		} catch (SQLException e) {
			if (DEBUG) e.printStackTrace();
			users = null;
		} finally {
			DBManager.closeResultSet(result);
			DBManager.closePreparedStatement(pstmt);
		}
		return users;
	}
}