EJB: Query Language

Introdução

Terminologia

Sintaxe Simplificada

Exemplos

Queries simples de "finder" methods

Exemplo 1

  SELECT OBJECT(p)
  FROM Player p

Exemplo 2

  SELECT DISTINCT OBJECT(p)
  FROM Player p
  WHERE p.position = ?1

Exemplo 3

  SELECT DISTINCT OBJECT(p) 
  FROM Player p 
  WHERE p.position = ?1 AND p.name = ?2

Queries de "finder" methods que navegam para beans relacionados

Exemplo 4

  SELECT DISTINCT OBJECT(p)
  FROM Player p, IN (p.teams) AS t
  WHERE t.city = ?1

Exemplo 5

  SELECT DISTINCT OBJECT(p) 
  FROM Player p, IN (p.teams) AS t 
  WHERE t.league = ?1

Exemplo 6

  SELECT DISTINCT OBJECT(p)
  FROM Player p, IN (p.teams) AS t
  WHERE t.league.sport = ?1

Queries de "finder" methods com outras expressões condicionais

Exemplo 7

  SELECT OBJECT(p)
  FROM Player p
  WHERE p.teams IS EMPTY

Exemplo 8

  SELECT DISTINCT OBJECT(p)
  FROM Player p
  WHERE p.salary BETWEEN ?1 AND ?2
        p.salary >= ?1 AND p.salary <= ?2

Exemplo 9

  SELECT DISTINCT OBJECT(p1) 
  FROM Player p1, Player p2 
  WHERE p1.salary > p2.salary AND p2.name = ?1

Queries "select"

Exemplo 10

  SELECT DISTINCT t.league
  FROM Player p, IN (p.teams) AS t
  WHERE p = ?1

Exemplo 11

  SELECT DISTINCT t.league.sport
  FROM Player p, IN (p.teams) AS t
  WHERE p = ?1

ejbql programa