private static Appointment createOneFromResultSet(ResultSet resultSet)
			throws SQLException {
		Appointment rtn = new Appointment();
		rtn.id = resultSet.getLong("id");
		rtn.name = resultSet.getString("name");
		rtn.initiatorId = resultSet.getLong("initiatorId");
		rtn.venueId = resultSet.getLong("venueId");
		rtn.startTime = resultSet.getLong("startTime");
		rtn.endTime = resultSet.getLong("endTime");
		rtn.info = resultSet.getString("info");
		rtn.frequency = resultSet.getInt("frequency");
		rtn.lastDay = resultSet.getLong("lastDay");
		rtn.freqHelper = resultSet.getInt("freqHelper");
		rtn.isJoint = resultSet.getInt("isJoint") > 0;
		if (rtn.isJoint)
		{
			// aAcceptedId
			rtn.findArray("aAcceptedId", rtn.aAcceptedId);

			// aRejectedId
			rtn.findArray("aRejectedId", rtn.aRejectedId);

			// aWaitingId
			rtn.findArray("aWaitingId", rtn.aWaitingId);
		}

		return rtn;
	}