|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.sequalite.dao.BaseDAO
public class BaseDAO
Constructor Summary | |
---|---|
BaseDAO()
|
|
BaseDAO(java.util.logging.Level sqlLevel)
|
Method Summary | |
---|---|
int |
delete(java.sql.Connection connection,
ClassMapper table,
java.lang.String criteria,
java.lang.Object[] values)
deletes database rows based on Class and criteria |
void |
delete(java.sql.Connection connection,
java.lang.Object object,
ClassMapper table)
deletes object from database |
java.util.List |
executeCall(java.sql.Connection connection,
java.lang.String query,
java.lang.Object[] inParams,
java.util.List<java.lang.String> outParams)
Executes a database stored procedure Assumption, the Paramaters Order is IN first and then the OUT, the exception being for functions where they have a return value. |
int |
executeUpdate(java.sql.Connection connection,
java.lang.String query,
java.lang.Object[] values)
Execute a named sql defined in the O-R Map |
java.util.List |
find(java.sql.Connection connection,
java.lang.String query,
java.lang.Object[] values,
SeQuaLiteResultMapper mapper)
Execute a query and uses a SeQuaLiteRSMapper to return data returned from database |
java.util.List |
find(Session session,
SequaliteMapper mapper,
java.sql.Connection connection,
java.lang.Class voClass,
ClassMapper table,
java.lang.String sqlName,
java.lang.Object[] values)
finds objects using criteria array |
java.util.List |
find(Session session,
SequaliteMapper mapper,
java.sql.Connection connection,
java.lang.Class voClass,
ClassMapper table,
java.lang.String filter,
java.lang.Object[] values,
java.lang.String sortBy)
finds objects using criteria string |
java.util.List<SeQuaLiteModel> |
findAsProxy(Session session,
java.sql.Connection connection,
java.lang.Class voClass,
ClassMapper table,
java.lang.String criteria,
java.lang.Object[] values,
java.lang.String sortBy)
finds proxys based on filter criteria |
java.util.List |
paginate(Session session,
SequaliteMapper mapper,
java.sql.Connection connection,
SeQuaLitePageModel pageModel,
ClassMapper table,
int page)
Gets the records for the specified page |
void |
populate(java.sql.Connection connection,
java.lang.Object base,
Session session,
SequaliteMapper sequaliteMapper)
converts a proxy to real object |
void |
save(java.sql.Connection conn,
java.lang.Object object,
SequaliteMapper sqm)
saves object to database |
int |
update(java.sql.Connection connection,
ClassMapper table,
java.lang.String setter,
java.lang.Object[] values,
java.lang.String criteria,
java.lang.Object[] values2)
Update database |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public BaseDAO()
public BaseDAO(java.util.logging.Level sqlLevel)
Method Detail |
---|
public int delete(java.sql.Connection connection, ClassMapper table, java.lang.String criteria, java.lang.Object[] values) throws SeQuaLiteException
connection
- table
- criteria
- values
-
SQLSyntaxException
SeQuaLiteException
public void delete(java.sql.Connection connection, java.lang.Object object, ClassMapper table) throws SeQuaLiteException
connection
- object
- table
-
SeQuaLiteException
public java.util.List executeCall(java.sql.Connection connection, java.lang.String query, java.lang.Object[] inParams, java.util.List<java.lang.String> outParams) throws SeQuaLiteException
connection
- query
- inParams
- outParams
- this is populated with the OUT param values in the order of
their occurrences
SeQuaLiteException
public int executeUpdate(java.sql.Connection connection, java.lang.String query, java.lang.Object[] values) throws SeQuaLiteException
connection
- query
- values
-
SeQuaLiteException
public java.util.List find(java.sql.Connection connection, java.lang.String query, java.lang.Object[] values, SeQuaLiteResultMapper mapper) throws SeQuaLiteFinderException, SeQuaLiteException
connection
- query
- values
- mapper
-
SeQuaLiteFinderException
SeQuaLiteException
public java.util.List find(Session session, SequaliteMapper mapper, java.sql.Connection connection, java.lang.Class voClass, ClassMapper table, java.lang.String filter, java.lang.Object[] values, java.lang.String sortBy) throws SeQuaLiteException, SeQuaLiteFinderException
session
- connection
- voClass
- table
- filter
- values
- sortBy
-
SeQuaLiteException
SeQuaLiteFinderException
SQLSyntaxException
public java.util.List find(Session session, SequaliteMapper mapper, java.sql.Connection connection, java.lang.Class voClass, ClassMapper table, java.lang.String sqlName, java.lang.Object[] values) throws SeQuaLiteException, SeQuaLiteFinderException
session
- connection
- voClass
- table
- sqlName
- values
-
SeQuaLiteException
SeQuaLiteFinderException
public java.util.List<SeQuaLiteModel> findAsProxy(Session session, java.sql.Connection connection, java.lang.Class voClass, ClassMapper table, java.lang.String criteria, java.lang.Object[] values, java.lang.String sortBy) throws SeQuaLiteException, SeQuaLiteFinderException
session
- connection
- voClass
- table
- criteria
- values
- sortBy
-
SeQuaLiteException
SeQuaLiteFinderException
SQLSyntaxException
public java.util.List paginate(Session session, SequaliteMapper mapper, java.sql.Connection connection, SeQuaLitePageModel pageModel, ClassMapper table, int page) throws SeQuaLiteException, SeQuaLiteFinderException
session
- connection
- pageModel
- table
- page
-
SeQuaLiteException
SeQuaLiteFinderException
public void populate(java.sql.Connection connection, java.lang.Object base, Session session, SequaliteMapper sequaliteMapper) throws SeQuaLiteException, SeQuaLiteFinderException
connection
- base
- session
-
SeQuaLiteException
SeQuaLiteFinderException
SQLSyntaxException
public void save(java.sql.Connection conn, java.lang.Object object, SequaliteMapper sqm) throws SeQuaLiteException
conn
- object
- sqm
-
SeQuaLiteException
public int update(java.sql.Connection connection, ClassMapper table, java.lang.String setter, java.lang.Object[] values, java.lang.String criteria, java.lang.Object[] values2) throws SeQuaLiteException
connection
- table
- setter
- values
- criteria
- values2
-
SeQuaLiteException
SQLSyntaxException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |