Dokumentace

3 SQL Features

This chapter describes all available SQL features of the AuDAO generator.

3.1 SQL Features
1. 3.1.1 Primary Keys
2. 3.1.2 Indexes
3. 3.1.3 Foreign Keys
4. 3.1.4 Sequences
5. 3.1.5 Data

3.1 SQL Features

3.1.1 Primary Keys

Primary keys are automatically generated on SQL level. Although primary keys can contain more than one column, it is recommended to use only one-column primary keys due to limitations of the DAO layer.

The primary key columns are recognized by the column flag <pk/>.

See also: XSD - column

3.1.2 Indexes

Indexes are automatically generated on SQL level. Both unique and nonunique indexes are supported.

Indexes are defined by separate indexes/index definitions.

See also: XSD - index

3.1.3 Foreign Keys

Foreign keys are automatically generated on SQL level.

Foreign keys are generated when <ref> reference is used.

See also: XSD - ref

3.1.4 Sequences

Sequences are automatically generated on SQL level only for Oracle DB.

Sequences are generated when <auto/> with <pk/> is used.

See also: XSD - column

3.1.5 Data

Data insertion statements are automatically generated for standard databases.

Data insertion statements are generated when <data> definition is present.

See also: XSD - table

Index

Online Generátor

Vyzkoušejte zadarmo náš online DAO generátor.

Vytvořte konfigurační XML soubor a získejte zadarmo vygenerované SQL skripty a Java třídy !

GQL Parser

Stáhněte si zdrojové či binární soubory GQL parseru.

Query q =
 new GqlDynamic()
  .parseQuery(
   "SELECT * FROM Ent");

Plná podpora GQL. Více...

Poslední úpravy: 2012-04-14

O aplikaci O soukromí