dinhchuong7913 · August 11, 2018 19:23
diff --git a/CallNamedStoredProcedureQuery.java b/CallNamedStoredProcedureQuery.java
 StoredProcedureQuery q = this.em.createNamedStoredProcedureQuery(“getReviews”);
 q.setParameter(2, b.getId());
 List<Review> reviews = q.getResultList();
diff --git a/CallStoredProcedureQuery.java b/CallStoredProcedureQuery.java
 // set input parameter
 query.setParameter(“x”, 1.23d);
 query.setParameter(“y”, 4.56d);

 // call the stored procedure and get the result
 query.execute();
 Double sum = (Double) query.getOutputParameterValue(“sum”);
diff --git a/CustomFunction.java b/CustomFunction.java
 em.createQuery(“SELECT a FROM Author a WHERE a.id = function(‘calculate’, 1, 2)“, Author.class).getSingleResult();
diff --git a/ExplicitJoin.java b/ExplicitJoin.java
 em.createQuery(“SELECT b.title, p.name FROM Book b JOIN b.publisher p”).getResultList();
diff --git a/ImplictJoin.java b/ImplictJoin.java
 em.createQuery(“SELECT b.title, b.publisher.name FROM Book b”).getResultList();
diff --git a/JoinUnrelated.java b/JoinUnrelated.java
 em.createQuery(“SELECT p.firstName, p.lastName, n.phoneNumber FROM Person p JOIN PhoneBookEntry n ON p.firstName = n.firstName AND p.lastName = n.lastName“).getResultList();
diff --git a/Limit.java b/Limit.java
 em.createQuery(“SELECT a FROM Author a”).setMaxResults(10).getResultList();
diff --git a/Limit.sql b/Limit.sql
 SELECT * FROM author LIMIT 10
diff --git a/NamedStoredProcedureQuery.java b/NamedStoredProcedureQuery.java
 @NamedStoredProcedureQuery(
 name = “getReviews”,
 procedureName = “get_reviews”,
 resultClasses = Review.class,
 parameters = {
 	@StoredProcedureParameter(mode = ParameterMode.REF_CURSOR, type = void.class),
 	@StoredProcedureParameter(mode = ParameterMode.IN, type = Long.class)
 }
 )
diff --git a/PojoProjection.java b/PojoProjection.java
 List<BookPublisherValue> bookPublisherValues = em.createQuery(“SELECT new org.thoughts.on.java.model.BookPublisherValue(b.title, b.publisher.name) FROM Book b”,BookPublisherValue.class).getResultList();
diff --git a/ScalarValuesProjection.java b/ScalarValuesProjection.java
 List<Object[]> authorNames = em.createQuery(“SELECT a.firstName, a.lastName FROM Author a”).getResultList();
diff --git a/SimpleGroupBy.java b/SimpleGroupBy.java
 em.createQuery(“SELECT a, count(b) FROM Author a JOIN a.books b GROUP BY a”).getResultList();
diff --git a/SimpleOrderBy.java b/SimpleOrderBy.java
 em.createQuery(“SELECT a FROM Author a ORDER BY a.lastName”).getResultList();
diff --git a/SimpleSubQuery.java b/SimpleSubQuery.java
 Query q = em.createQuery(“SELECT a FROM Author a WHERE a.id IN (SELECT s.authorId FROM SpecialAuthors s)”);
diff --git a/SimpleWhereClause.java b/SimpleWhereClause.java
 Query q = em.createQuery(“SELECT a FROM Author a WHERE a.id = :id”);
diff --git a/StandardFunction.java b/StandardFunction.java
 em.createQuery(“SELECT a, count(b) FROM Author a JOIN a.books b GROUP BY a”).getResultList();
diff --git a/StoredProcedureQuery.java b/StoredProcedureQuery.java
 StoredProcedureQuery query = this.em.createStoredProcedureQuery(“calculate”);
 query.registerStoredProcedureParameter(“x”, Double.class, ParameterMode.IN);
 query.registerStoredProcedureParameter(“y”, Double.class, ParameterMode.IN);
 query.registerStoredProcedureParameter(“sum”, Double.class, ParameterMode.OUT);
	StoredProcedureQuery q = this.em.createNamedStoredProcedureQuery(“getReviews”);
	q.setParameter(2, b.getId());
	List<Review> reviews = q.getResultList();
	// set input parameter
	query.setParameter(“x”, 1.23d);
	query.setParameter(“y”, 4.56d);

	// call the stored procedure and get the result
	query.execute();
	Double sum = (Double) query.getOutputParameterValue(“sum”);
	@NamedStoredProcedureQuery(
	name = “getReviews”,
	procedureName = “get_reviews”,
	resultClasses = Review.class,
	parameters = {
	@StoredProcedureParameter(mode = ParameterMode.REF_CURSOR, type = void.class),
	@StoredProcedureParameter(mode = ParameterMode.IN, type = Long.class)
	}
	)
	StoredProcedureQuery query = this.em.createStoredProcedureQuery(“calculate”);
	query.registerStoredProcedureParameter(“x”, Double.class, ParameterMode.IN);
	query.registerStoredProcedureParameter(“y”, Double.class, ParameterMode.IN);
	query.registerStoredProcedureParameter(“sum”, Double.class, ParameterMode.OUT);