GamesService.java
package ui.entities.gamebase.service;
import jakarta.persistence.EntityManager;
import jakarta.persistence.criteria.*;
import ui.entities.gamebase.Games;
import ui.entities.gamebase.Games_;
import java.util.List;
public class GamesService {
private final EntityManager em;
public GamesService(EntityManager em) {
this.em = em;
}
public List<Games> select(char firstLetter) {
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Games> query = cb.createQuery(Games.class);
Root<Games> games = query.from(Games.class);
Path<String> name = games.get(Games_.name);
final Predicate predicate;
if (Character.isLetter(firstLetter)) {
predicate = cb.like(name, firstLetter + "%");
} else {
// the first character matches everything EXCEPT letters
predicate = cb.and(cb.not(cb.like(name, "a%")), cb.not(cb.like(name, "b%")), cb.not(cb.like(name, "c%")),
cb.not(cb.like(name, "d%")), cb.not(cb.like(name, "e%")), cb.not(cb.like(name, "f%")),
cb.not(cb.like(name, "g%")), cb.not(cb.like(name, "h%")), cb.not(cb.like(name, "i%")),
cb.not(cb.like(name, "j%")), cb.not(cb.like(name, "k%")), cb.not(cb.like(name, "l%")),
cb.not(cb.like(name, "m%")), cb.not(cb.like(name, "n%")), cb.not(cb.like(name, "o%")),
cb.not(cb.like(name, "p%")), cb.not(cb.like(name, "q%")), cb.not(cb.like(name, "r%")),
cb.not(cb.like(name, "s%")), cb.not(cb.like(name, "t%")), cb.not(cb.like(name, "u%")),
cb.not(cb.like(name, "v%")), cb.not(cb.like(name, "w%")), cb.not(cb.like(name, "x%")),
cb.not(cb.like(name, "y%")), cb.not(cb.like(name, "z%")));
}
query.where(predicate).orderBy(cb.asc(name)).select(games);
return em.createQuery(query).getResultList();
}
}