Π΅ΡΠ»ΠΈ Π·Π°ΠΏΡΡΠΊΠ°Ρ intellij, ΡΠΎ Π²ΡΠ²ΠΎΠ΄ ΠΊΠ°ΠΊ Π² ΡΡΠ»ΠΎΠ²ΠΈΠΈ Π·Π°Π΄Π°ΡΠΈ.Π½ΠΎ Π²Π°Π»ΠΈΠΊ Π½Π΅ ΠΏΡΠΎΠΏΡΡΠΊΠ°Π΅Ρ
package com.javarush.task.task23.task2309;
import com.javarush.task.task23.task2309.vo.*;
import java.util.List;
/*
ΠΠ½ΠΎΠ½ΠΈΠΌΠ½ΠΎΡΡΡ ΠΈΠ½ΠΎΠ³Π΄Π° ΡΠ°ΠΊ ΠΏΡΠΈΡΡΠ½Π°!
*/
public class Solution {
public static void main(String[] args) {
Solution solution = new Solution();
print(solution.getUsers());
print(solution.getLocations());
}
public List<User> getUsers(){
return new AbstractDbSelectExecutor<User>(){
@Override
public String getQuery() {
return String.format("SELECT*FROM %S",User.class.getSimpleName());
}
}.execute();
}
public List<Location> getLocations(){
return new AbstractDbSelectExecutor<Location>(){
@Override
public String getQuery() {
return String.format("SELECT*FROM %S",Location.class.getSimpleName());
}
}.execute();
}
public List<Subscription> getSubscriptions(){
return new AbstractDbSelectExecutor<Subscription>(){
@Override
public String getQuery() {
return String.format("SELECT*FROM %S",Subscription.class.getSimpleName());
}
}.execute();
}
public List<Subject> getSubjects(){
return new AbstractDbSelectExecutor<Subject>(){
@Override
public String getQuery() {
return String.format("SELECT*FROM %S",Subject.class.getSimpleName());
}
}.execute();
}
public List<Server> getServers(){
return new AbstractDbSelectExecutor<Server>(){
@Override
public String getQuery() {
return String.format("SELECT*FROM %S",Server.class.getSimpleName());
}
}.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()));
}
}
}