Not passing last 5 requirements

Question about the task

Resolved

Not able to pass: I was trying a whole bunch of different ways to return the string for the getQuery() method to see if any of them passed. I even tried removing 'abstract' from getQuery and typing in:

return "SELECT * FROM " + ((Class) ((ParameterizedType) this.getClass().
                        getGenericSuperclass()).getActualTypeArguments()[0]).getSimpleName().toUpperCase();

No matter what I do I can't pass the last 5 requirements, they all say the same thing (for the specific class) Each element of the list returned by the getUsers method must contain the string "Received from executing 'SELECT * FROM USER'" in the description field. My output: Id=1, name='User-1', description=Received from executing 'SELECT * FROM USER' Id=2, name='User-2', description=Received from executing 'SELECT * FROM USER' Id=3, name='User-3', description=Received from executing 'SELECT * FROM USER' Id=4, name='User-4', description=Received from executing 'SELECT * FROM USER' Id=5, name='User-5', description=Received from executing 'SELECT * FROM USER' Id=1, name='Location-1', description=Received from executing 'SELECT * FROM LOCATION' Id=2, name='Location-2', description=Received from executing 'SELECT * FROM LOCATION' Id=3, name='Location-3', description=Received from executing 'SELECT * FROM LOCATION' Id=4, name='Location-4', description=Received from executing 'SELECT * FROM LOCATION' Id=5, name='Location-5', description=Received from executing 'SELECT * FROM LOCATION'

1. In the vo package, create public User, Location, Server, Subject, and Subscription classes, which inherit NamedItem
2. In the Solution class, for each class, create a method that returns a list of instances of the class.

For example, the User class will have a public List<User> getUsers() method
For the Location class, it will be public List<Location> getLocations() method

3. In each of these methods, create an anonymous class from AbstractDbSelectExecutor and call the required method on it.
Hint:
the body of the method should begin like this: return new AbstractDbSelectExecutor

4. Example output for User and Location:

Id=5, name='User-5', description=Received from executing 'SELECT * FROM USER'
Id=1, name='Location-1', description=Received from executing 'SELECT * FROM LOCATION'

5. Analyze the example output and create the correct query for all classes.

Requirements:

A public User class that inherits the NamedItem class must be created in the vo package.
A public Location class that inherits NamedItem must be created in the vo package.
A public Server class that inherits NamedItem must be created in the vo package.
A public Subject class that inherits NamedItem must be created in the vo package.
A public Subscription class that inherits NamedItem must be created in the vo package.
An AbstractDbSelectExecutor object with a User parameter must be created in the getUsers method.
An AbstractDbSelectExecutor object with a Location parameter must be created in the getLocations method.
An AbstractDbSelectExecutor object with a Server parameter must be created in the getServers method.
An AbstractDbSelectExecutor object with a Subject parameter must be created in the getSubjects method.
An AbstractDbSelectExecutor object with a Subscription parameter must be created in the getSubscriptions method.
The getUsers method must return the correct list (according to the task conditions).
The getLocations method must return the correct list (according to the task conditions).
The getServers method must return the correct list (according to the task conditions).
The getSubjects method must return the correct list (according to the task conditions).
The getSubscriptions method must return the correct list (according to the task conditions).

package com.codegym.task.task23.task2309; import com.codegym.task.task23.task2309.vo.*; import java.lang.reflect.ParameterizedType; import java.util.AbstractList; import java.util.List; /* Sometimes anonymity is so nice! */ public class Solution { public static void main(String[] args) { Solution solution = new Solution(); print(solution.getUsers()); print(solution.getLocations()); } public static List<User> getUsers(){ return new AbstractDbSelectExecutor<User>(){ @Override public String getQuery() { return "SELECT * FROM USER"; } }.execute(); } public static List<Location> getLocations(){ return new AbstractDbSelectExecutor<Location>(){ @Override public String getQuery() { return "SELECT * FROM " + ((Class) ((ParameterizedType) this.getClass(). getGenericSuperclass()).getActualTypeArguments()[0]).getSimpleName().toUpperCase(); } }.execute(); } public static List<Server> getServers(){ return new AbstractDbSelectExecutor<Server>(){ @Override public String getQuery() { return "SELECT * FROM " + ((Class) ((ParameterizedType) this.getClass(). getGenericSuperclass()).getActualTypeArguments()[0]).getSimpleName().toUpperCase(); } }.execute(); } public static List<Subscription> getSubscriptions(){ return new AbstractDbSelectExecutor<Subscription>(){ @Override public String getQuery() { return "SELECT * FROM " + ((Class) ((ParameterizedType) this.getClass(). getGenericSuperclass()).getActualTypeArguments()[0]).getSimpleName().toUpperCase(); } }.execute(); } public static List<Subject> getSubjects(){ return new AbstractDbSelectExecutor<Subject>(){ @Override public String getQuery() { return "SELECT * FROM " + ((Class) ((ParameterizedType) this.getClass(). getGenericSuperclass()).getActualTypeArguments()[0]).getSimpleName().toUpperCase(); } }.execute(); } public static void print(List list) { String format = "Id=%d, name='%s', description=%s"; for (Object obj : list) { NamedItem item = (NamedItem) obj; System.out.println(String.format(format, item.getId(), item.getName(), item.getDescription())); } } }

Comments (6)

Popular
New
Old

You must be signed in to leave a comment

Oleh

Level 32 , Kyiv, Ukraine

12 April 2019, 14:45

solution

You will be very upset

Guadalupe Gagnon

Level 37 , Tampa, United States

12 April 2019, 14:57

*closes eyes* Hit me.....

Oleh

Level 32 , Kyiv, Ukraine

12 April 2019, 15:00

You don't need "static" getters.

Guadalupe Gagnon

Level 37 , Tampa, United States

12 April 2019, 15:12

Blah, I should have seen that they were being called using a Solution object. Well it only took me 24 attempts, but finally it is solved. Thanks for the help!!!

Oleh

Level 32 , Kyiv, Ukraine

12 April 2019, 15:17

np, you can ask me after tenth attempt

Guadalupe Gagnon

Level 37 , Tampa, United States

12 April 2019, 15:30