org.sequalite.dao
Class BaseDAO

java.lang.Object
  extended by 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