How to write a Criteria hibernate join query?

Question

PostgreSQL

Help me make a CRITERIA request, or send a tutorial explaining how to do it, or explain to me with this example what is substituted where!...
Where the relation of userentity to statgame is one to many.
The SQL query is "SELECT * FROM testproj.userentity u JOIN testproj.statgame s ON u.id=s.userid WHERE u.id= :id" <- this should be dynamically populated as needed.

Answer 1

What for?!
You will have a simple select like
A statgame pull through @OneToMany
Simple select in CriteriaAPI

...
 CriteriaBuilder cb = em.getCriteriaBuilder();

  CriteriaQuery<userentity > q = cb.createQuery(userentity .class);
  Root<userentity > c = q.from(userentity .class);
  ParameterExpression<Integer> p = cb.parameter(Integer.class);
  q.select(c).where(cb.gt(c.get("id"), p));
...