org.sequalite.dao
Class BaseDAO

java.lang.Object
  org.sequalite.dao.BaseDAO

public class BaseDAO
extends java.lang.Object

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

BaseDAO

public BaseDAO()

BaseDAO

public BaseDAO(java.util.logging.Level sqlLevel)

Method Detail

delete

public int delete(java.sql.Connection connection,
                  ClassMapper table,
                  java.lang.String criteria,
                  java.lang.Object[] values)
           throws SeQuaLiteException

deletes database rows based on Class and criteria

Parameters:

connection -

table -

criteria -

values -

Returns:

Throws:

SQLSyntaxException

SeQuaLiteException

delete

public void delete(java.sql.Connection connection,
                   java.lang.Object object,
                   ClassMapper table)
            throws SeQuaLiteException

deletes object from database

Parameters:

connection -

object -

table -

Throws:

SeQuaLiteException

executeCall

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

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. So the first parameter will be a OUT parameter.

Parameters:

connection -

query -

inParams -

outParams - this is populated with the OUT param values in the order of their occurrences

Returns:

If the stored proc returns resultset values this will contain the returned values.

Throws:

SeQuaLiteException

executeUpdate

public int executeUpdate(java.sql.Connection connection,
                         java.lang.String query,
                         java.lang.Object[] values)
                  throws SeQuaLiteException

Execute a named sql defined in the O-R Map

Parameters:

connection -

query -

values -

Returns:

Throws:

SeQuaLiteException

find

public java.util.List find(java.sql.Connection connection,
                           java.lang.String query,
                           java.lang.Object[] values,
                           SeQuaLiteResultMapper mapper)
                    throws SeQuaLiteFinderException,
                           SeQuaLiteException

Execute a query and uses a SeQuaLiteRSMapper to return data returned from database

Parameters:

connection -

query -

values -

mapper -

Returns:

Throws:

SeQuaLiteFinderException

SeQuaLiteException

find

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

finds objects using criteria string

Parameters:

session -

connection -

voClass -

table -

filter -

values -

sortBy -

Returns:

Throws:

SeQuaLiteException

SeQuaLiteFinderException

SQLSyntaxException

find

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

finds objects using criteria array

Parameters:

session -

connection -

voClass -

table -

sqlName -

values -

Returns:

Throws:

SeQuaLiteException

SeQuaLiteFinderException

findAsProxy

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

finds proxys based on filter criteria

Parameters:

session -

connection -

voClass -

table -

criteria -

values -

sortBy -

Returns:

Throws:

SeQuaLiteException

SeQuaLiteFinderException

SQLSyntaxException

paginate

public java.util.List paginate(Session session,
                               SequaliteMapper mapper,
                               java.sql.Connection connection,
                               SeQuaLitePageModel pageModel,
                               ClassMapper table,
                               int page)
                        throws SeQuaLiteException,
                               SeQuaLiteFinderException

Gets the records for the specified page

Parameters:

session -

connection -

pageModel -

table -

page -

Returns:

Throws:

SeQuaLiteException

SeQuaLiteFinderException

populate

public void populate(java.sql.Connection connection,
                     java.lang.Object base,
                     Session session,
                     SequaliteMapper sequaliteMapper)
              throws SeQuaLiteException,
                     SeQuaLiteFinderException

converts a proxy to real object

Parameters:

connection -

base -

session -

Throws:

SeQuaLiteException

SeQuaLiteFinderException

SQLSyntaxException

save

public void save(java.sql.Connection conn,
                 java.lang.Object object,
                 SequaliteMapper sqm)
          throws SeQuaLiteException

saves object to database

Parameters:

conn -

object -

sqm -

Throws:

SeQuaLiteException

update

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

Update database

Parameters:

connection -

table -

setter -

values -

criteria -

values2 -

Returns:

Throws:

SeQuaLiteException

SQLSyntaxException