The core package of EoD SQL most developers will not need to make use of
any of the other packages. Of the types in this package only a few
are of importance to most developers, these are:
- QueryTool - The main entry point for the API
- BaseQuery - The super-interface of all Query types
- @Select - Used to describe a "SELECT * FROM table" type of SQL query
- @Update - Used to describe a "UPDATE table SET" type of SQL query
- @Call - Used to describe a "CALL find_user(id)" type of SQL query
-
DataSet - An implementation of java.util.List
that can remain connected to the database. DataSet can be thought
of as EoD SQL's replacement for java.sql.ResultSet.
-
DataIterator - An Iterator that remains
connected to the database, and implements a forward-only view of the ResultSet.
A DataIterator is often much faster and lighter weight than other
return types.
To use EoD SQL you will need at least three of your own types:
- One or more Query interfaces - see BaseQuery for more information
- Data Objects - which will be bound to a each row of a ResultSet
- Your normal code which will invoke methods you declared in your Query interface in order to interact wit the database
For more information about usage of EoD SQL, please refere to the EoD SQL Tutorial.