• Tutorials
• 1.8 Manual
• 1.7
• 1.6
• 1.5
• 1.4
• 1.3
• 1.2
• 1.1
• 1.0
• 1.9-dev
• API reference

Developer manual

• ^ Jelix components
• jDao: relational object mapping
  • DAO file
  • Instantiation and use of a dao factory and record
  • Manipulating a result set
  • Declaring methods in the XML file
  • Adding PHP methods to the factory
  • Automatic events

Jelix 1.7.15

Chapter: jDao: relational object mapping

« Zones

^ Jelix components

Classic forms »

Switch to language: FR

jDAO is the Object Relational Mapping system of Jelix. It is to provide an easy way to create, records and factories, using the DAO pattern.

A record object represents a database record: its properties are mapped on the fields of one or more tables.

A factory object provides some methods allowing to create a record, to save it, to destroy it or to retrieve some sets of record objects.

A record and factory object couple is described in a XML file. jDAO then handles the generation of the corresponding PHP objects.

The XML file allows to avoid the tiresome writing of SQL requests, and to take care of SQL injections problems: the generated objects handle everything. The XML file can be generated by a development tool, like for example one of the scripts featured with Jelix.

• DAO file
• Instantiation and use of a dao factory and record
• Manipulating a result set
• Declaring methods in the XML file
• Adding PHP methods to the factory
• Automatic events