Top Qs
Chronologie
Chat
Contexte

JDOQL

De Wikipédia, l'encyclopédie libre

Remove ads

JDOQL est le langage d'interrogation spécifié par la norme JDO (Java Data Object). Le langage reprend la syntaxe de Java. Il prend en compte l'héritage et permet une navigation très simple.

Remove ads

Exemple 1 de requête JDOQL

  • JDOQL
  Employee.class, “salary>boss.salary”
  • Equivalent SQL
  SELECT Employee.*
  FROM Employee INNER JOIN Employee AS Boss ON Employee.boss = Boss.ID
  WHERE ((Employee.salary)>[boss].[salary]);

Exemple 2 de requête JDOQL

  • JDOQL
  Employee.class, “(salary>boss.salary) && (adr.city==boss.adr.city)”
  • Equivalent SQL
  SELECT Employee.*
  FROM ((Employee INNER JOIN Employee AS Boss ON Employee.boss = Boss.ID) INNER JOIN Address AS AddressEmployee ON Employee.adr = AddressEmployee.ID) 
  INNER JOIN Address AS       AddressBoss ON Boss.adr = AddressBoss.ID
  WHERE (((Employee.salary)>[boss].[salary]) AND ((AddressEmployee.City)=[AddressBoss].[City]));
Remove ads
Loading related searches...

Wikiwand - on

Seamless Wikipedia browsing. On steroids.

Remove ads