org.sequalite.utils
Class DAOUtils

java.lang.Object
  org.sequalite.utils.DAOUtils

public class DAOUtils
extends java.lang.Object

Field Summary

static boolean

createORmap

Constructor Summary

DAOUtils()

Method Summary

static java.lang.String	arrayToString(java.lang.Object[] objects) array To String
static java.util.List	clone(java.util.List list, SequaliteMapper mapper) Clone a list of objects
static java.lang.Object	clone(java.lang.Object base, SequaliteMapper mapper) Clone the object
static SequaliteMapper	constructPackageMetaData(java.lang.Class pojoClass)
static java.lang.Class	createClass(SequaliteMapper sqm, java.lang.String className) create Class
static java.lang.Object	createObject(java.lang.Class cls) create Object from Class
static void	dumpObject(java.io.PrintStream out, java.lang.Object obj) prints the Object to a stream
static void	dumpResultset(java.io.PrintStream out, java.sql.ResultSet rs) prints the resultset to a stream
static void	freeResources(java.lang.Object[] objects) close jdbc objects or files
static ChildMapper	getChildMapperByColumnName(ClassMapper ptm, java.lang.String columnName) Retrieves ChildMapper from ClassMapper using columnName
static ChildMapper	getChildMapperByName(ClassMapper ptm, java.lang.String javaName) Retrieves ChildMapper from ClassMapper using javaName
static java.lang.Object	getChildObject(java.lang.Object obj, ChildMapper child) gets Child Object
static java.util.List	getChildObjectList(java.lang.Object obj, ChildMapper child) get Child Object List
static ClassMapper	getClassMapper(SequaliteMapper sqm, java.lang.String className) Retrieves ClassMapper from SequaliteMapper
static java.lang.String	getColumns(ClassMapper table) retrieve comma separated columns
static java.sql.Connection	getConnection(java.sql.Driver driver, java.lang.String jdbcURL, java.lang.String user, java.lang.String password) creates database connection
static java.sql.Connection	getConnection(java.lang.String context, java.util.Properties prop) creates database connection
static java.lang.String	getCountSQL(java.lang.String query) creates the Count SQL for pagination using named SQL
static java.lang.String	getDeleteSQL(ClassMapper table) get Delete SQL
static java.lang.String	getDeleteSQL(ClassMapper table, java.lang.String criteria, java.lang.Object[] cValues) get Delete SQL
static java.lang.String	getDeleteSQLWithoutPK(ClassMapper table, java.lang.Object object, java.util.List valueList) Create DeleteSQL without PrimaryKey
static FieldMapper	getFieldMapperByColumnName(ClassMapper ptm, java.lang.String columnName) Retrieves FieldMapper from ClassMapper using columnName
static FieldMapper	getFieldMapperByName(ClassMapper ptm, java.lang.String javaName) Retrieves FieldMapper from ClassMapper using javaName
static java.lang.Object	getFieldValue(java.lang.Object obj, FieldMapper field) get Field Value
static java.lang.String	getFindSQL(ClassMapper table, java.lang.String filter, java.lang.Object[] cValues, java.lang.String orderBy)
static java.lang.String	getIdSQL(ClassMapper table, java.lang.String criteria, java.lang.Object[] cValues, java.lang.String sortBy) Gets the ID SQL
static java.lang.String	getInsertSQL(ClassMapper table, boolean autoIncrement) get Insert SQL
static SequaliteMapper	getPackageMetaData(java.lang.Class pojoClass) Reads the sequalite-mapper.xml metadata file for a package
static java.lang.String	getPaginationSQL(java.lang.String query, int page, int rowsPerPage, java.lang.String driver) creates the pagination SQL
static java.lang.Object	getPrimaryKeyValue(java.lang.Object obj, ClassMapper table) get PrimaryKey Value
static java.lang.String	getSelectSQL(ClassMapper table) get Select SQL
static SqlMapper	getSQL(ClassMapper table, java.lang.String sqlName) get Named SQL
static java.lang.String	getUpdateSQL(ClassMapper table) get Update SQL
static java.lang.String	getUpdateSQL(ClassMapper table, java.lang.String setter, java.lang.String criteria, java.lang.Object[] cValues)
static void	initDriver(java.lang.String driverClass) Initializes the driver class
static java.lang.Class[]	loadDrivers(java.lang.String[] jarPath) Loads the driver class
static javax.sql.DataSource	lookupDataSource(java.lang.String jndiName) Looks up the datasource
static SequaliteMapper	lookupMappings(java.lang.Class pojoClass) initialize OR mappings
static void	main(java.lang.String[] st)
static void	populateChild(java.lang.Object obj, SequaliteMapper sqm, ClassMapper table, java.lang.String columnName, java.lang.Object value) populate Single Child
static void	populateChildren(java.lang.Object obj, ClassMapper table, java.lang.String columnName, java.util.List valueList) populate Multiple Child
static void	populateField(java.lang.Object obj, ClassMapper table, java.lang.String columnName, java.lang.Object value) populate Field
static void	populateFieldFromResultSet(java.sql.ResultSet rs, java.lang.Object obj, ClassMapper table, FieldMapper field) populates Field From ResultSet
static int	populateInsertPSParamsWithFieldValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, ClassMapper table) populate Insert Prepared Statement Params With Field Values
static int	populateInsertPSParamsWithFieldValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, ClassMapper table, java.lang.StringBuffer sb) populate Insert Prepared Statement Params With Field Values
static void	populateObjectFromResultSet(java.sql.ResultSet rs, java.lang.Object obj, ClassMapper table, Session session, SequaliteMapper sequaliteMapper) populates an Object from resultset
static java.util.List	populateObjects(Session session, java.sql.ResultSet rs, java.lang.Class cls, ClassMapper table, SequaliteMapper mapper) Creates a list of objects from Resultset
static void	populatePrimaryKey(java.sql.ResultSet rs, java.lang.Object obj, ClassMapper table) populate Primary Key
static void	populateProxyObjectFromResultSet(java.sql.ResultSet rs, java.lang.Object obj, ClassMapper table, java.lang.String columnName, java.lang.String rsColumnName) populates proxy object
static java.util.List<SeQuaLiteModel>	populateProxyObjects(Session session, java.sql.ResultSet rs, java.lang.Class cls, ClassMapper table) Creates a list of objects from Resultset
static void	populatePSParams(java.sql.PreparedStatement ps, boolean insert, boolean autoIncrement, java.lang.Object object, SequaliteMapper sqm, ClassMapper table, java.lang.StringBuffer sb) populates preparedStatement parameters from Object
static void	populatePSParams(java.sql.PreparedStatement ps, java.lang.String sql, java.lang.Object[] values, java.util.logging.Level sqlLevel) populate Prepared Statement Params
static int	populatePSParamsWithChildPKValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, SequaliteMapper sqm, ClassMapper table) populate Prepared Statement Params With Child PriamryKey Value
static int	populatePSParamsWithChildPKValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, SequaliteMapper sqm, ClassMapper table, java.lang.StringBuffer sb) populate Prepared Statement Params With Child PriamryKey Value
static void	populateSeQuaLiteModelFromResultSet(java.sql.ResultSet rs, SeQuaLiteModel obj, ClassMapper table, Session session, SequaliteMapper mapper) populates an Object from resultset
static int	populateUpdatePSParamsWithFieldValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, ClassMapper table) populate Update Prepared Statement Params With Field Values
static int	populateUpdatePSParamsWithFieldValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, ClassMapper table, java.lang.StringBuffer sb) populate Update Prepared Statement Params With Field Values
static void	setPrimaryKeyValue(java.lang.Object obj, ClassMapper table, java.lang.Object value) set PrimaryKey Value
static java.lang.String	translateToOrderByClause(ClassMapper clazz, java.lang.String sql) traslates a sql to orderby clause
static java.lang.String	translateToSQL(ClassMapper clazz, java.lang.String sql) traslates a sql
static java.lang.String	translateToWhereClause(ClassMapper clazz, java.lang.String sql, java.lang.Object[] values) traslates a sql to where clause

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

createORmap

public static boolean createORmap

Constructor Detail

DAOUtils

public DAOUtils()

Method Detail

arrayToString

public static java.lang.String arrayToString(java.lang.Object[] objects)

array To String

Parameters:

objects -

Returns:

String

clone

public static java.util.List clone(java.util.List list,
                                   SequaliteMapper mapper)
                            throws SeQuaLiteException

Clone a list of objects

Parameters:

list -

mapper -

Returns:

Throws:

SeQuaLiteException

clone

public static java.lang.Object clone(java.lang.Object base,
                                     SequaliteMapper mapper)
                              throws SeQuaLiteException

Clone the object

Parameters:

base -

mapper -

Returns:

Throws:

SeQuaLiteException

constructPackageMetaData

public static SequaliteMapper constructPackageMetaData(java.lang.Class pojoClass)

createClass

public static java.lang.Class createClass(SequaliteMapper sqm,
                                          java.lang.String className)
                                   throws SeQuaLiteException

create Class

Parameters:

sqm -

className -

Returns:

Class

Throws:

SeQuaLiteException

createObject

public static java.lang.Object createObject(java.lang.Class cls)
                                     throws SeQuaLiteException

create Object from Class

Parameters:

cls -

Returns:

object

Throws:

SeQuaLiteException

dumpObject

public static void dumpObject(java.io.PrintStream out,
                              java.lang.Object obj)

prints the Object to a stream

Parameters:

out -

obj -

dumpResultset

public static void dumpResultset(java.io.PrintStream out,
                                 java.sql.ResultSet rs)

prints the resultset to a stream

Parameters:

out -

rs -

freeResources

public static void freeResources(java.lang.Object[] objects)
                          throws SeQuaLiteException

close jdbc objects or files

Parameters:

objects -

Throws:

SeQuaLiteException

getChildMapperByColumnName

public static ChildMapper getChildMapperByColumnName(ClassMapper ptm,
                                                     java.lang.String columnName)
                                              throws SeQuaLiteException

Retrieves ChildMapper from ClassMapper using columnName

Parameters:

ptm -

columnName -

Returns:

child

Throws:

SeQuaLiteException

getChildMapperByName

public static ChildMapper getChildMapperByName(ClassMapper ptm,
                                               java.lang.String javaName)
                                        throws SeQuaLiteException

Retrieves ChildMapper from ClassMapper using javaName

Parameters:

ptm -

javaName -

Returns:

child

Throws:

SeQuaLiteException

getChildObject

public static java.lang.Object getChildObject(java.lang.Object obj,
                                              ChildMapper child)

gets Child Object

Parameters:

obj -

child -

Returns:

childObject

getChildObjectList

public static java.util.List getChildObjectList(java.lang.Object obj,
                                                ChildMapper child)

get Child Object List

Parameters:

obj -

child -

Returns:

list

getClassMapper

public static ClassMapper getClassMapper(SequaliteMapper sqm,
                                         java.lang.String className)
                                  throws SeQuaLiteException

Retrieves ClassMapper from SequaliteMapper

Parameters:

sqm -

className -

Returns:

classMapper

Throws:

SeQuaLiteException

getColumns

public static java.lang.String getColumns(ClassMapper table)

retrieve comma separated columns

Parameters:

table -

Returns:

string

getConnection

public static java.sql.Connection getConnection(java.sql.Driver driver,
                                                java.lang.String jdbcURL,
                                                java.lang.String user,
                                                java.lang.String password)
                                         throws SeQuaLiteException

creates database connection

Parameters:

driver -

jdbcURL -

user -

password -

Returns:

Throws:

SeQuaLiteException

getConnection

public static java.sql.Connection getConnection(java.lang.String context,
                                                java.util.Properties prop)
                                         throws SeQuaLiteException

creates database connection

Parameters:

context -

prop -

Returns:

dbConnection

Throws:

SeQuaLiteException

getCountSQL

public static java.lang.String getCountSQL(java.lang.String query)
                                    throws SeQuaLiteException

creates the Count SQL for pagination using named SQL

Parameters:

query -

Returns:

Throws:

SeQuaLiteException

getDeleteSQL

public static java.lang.String getDeleteSQL(ClassMapper table)

get Delete SQL

Parameters:

table -

Returns:

string

getDeleteSQL

public static java.lang.String getDeleteSQL(ClassMapper table,
                                            java.lang.String criteria,
                                            java.lang.Object[] cValues)
                                     throws SeQuaLiteException

get Delete SQL

Parameters:

table -

criteria -

Returns:

string

Throws:

SQLSyntaxException

SeQuaLiteException

getDeleteSQLWithoutPK

public static java.lang.String getDeleteSQLWithoutPK(ClassMapper table,
                                                     java.lang.Object object,
                                                     java.util.List valueList)
                                              throws SeQuaLiteException

Create DeleteSQL without PrimaryKey

Parameters:

table -

object -

valueList -

Returns:

Throws:

SeQuaLiteException

getFieldMapperByColumnName

public static FieldMapper getFieldMapperByColumnName(ClassMapper ptm,
                                                     java.lang.String columnName)
                                              throws SeQuaLiteException

Retrieves FieldMapper from ClassMapper using columnName

Parameters:

ptm -

columnName -

Returns:

field

Throws:

SeQuaLiteException

getFieldMapperByName

public static FieldMapper getFieldMapperByName(ClassMapper ptm,
                                               java.lang.String javaName)
                                        throws SeQuaLiteException

Retrieves FieldMapper from ClassMapper using javaName

Parameters:

ptm -

javaName -

Returns:

Throws:

SeQuaLiteException

getFieldValue

public static java.lang.Object getFieldValue(java.lang.Object obj,
                                             FieldMapper field)
                                      throws SeQuaLiteException

get Field Value

Parameters:

obj -

field -

Returns:

Throws:

SeQuaLiteException

getFindSQL

public static java.lang.String getFindSQL(ClassMapper table,
                                          java.lang.String filter,
                                          java.lang.Object[] cValues,
                                          java.lang.String orderBy)
                                   throws SeQuaLiteException

Parameters:

table -

filter -

orderBy -

Returns:

Throws:

SeQuaLiteException

getIdSQL

public static java.lang.String getIdSQL(ClassMapper table,
                                        java.lang.String criteria,
                                        java.lang.Object[] cValues,
                                        java.lang.String sortBy)
                                 throws SeQuaLiteException

Gets the ID SQL

Parameters:

table -

criteria -

sortBy -

Returns:

Throws:

SQLSyntaxException

SeQuaLiteException

getInsertSQL

public static java.lang.String getInsertSQL(ClassMapper table,
                                            boolean autoIncrement)

get Insert SQL

Parameters:

table -

Returns:

getPackageMetaData

public static SequaliteMapper getPackageMetaData(java.lang.Class pojoClass)
                                          throws SeQuaLiteException

Reads the sequalite-mapper.xml metadata file for a package

Parameters:

pojoClass -

Returns:

Throws:

SeQuaLiteException

getPaginationSQL

public static java.lang.String getPaginationSQL(java.lang.String query,
                                                int page,
                                                int rowsPerPage,
                                                java.lang.String driver)
                                         throws SeQuaLiteException

creates the pagination SQL

Parameters:

query -

page -

rowsPerPage -

driver -

Returns:

Throws:

SeQuaLiteException

getPrimaryKeyValue

public static java.lang.Object getPrimaryKeyValue(java.lang.Object obj,
                                                  ClassMapper table)
                                           throws SeQuaLiteException

get PrimaryKey Value

Parameters:

obj -

table -

Returns:

Throws:

SeQuaLiteException

getSelectSQL

public static java.lang.String getSelectSQL(ClassMapper table)

get Select SQL

Parameters:

table -

Returns:

getSQL

public static SqlMapper getSQL(ClassMapper table,
                               java.lang.String sqlName)
                        throws SeQuaLiteException

get Named SQL

Parameters:

table -

sqlName -

Returns:

Throws:

SeQuaLiteException

getUpdateSQL

public static java.lang.String getUpdateSQL(ClassMapper table)

get Update SQL

Parameters:

table -

Returns:

getUpdateSQL

public static java.lang.String getUpdateSQL(ClassMapper table,
                                            java.lang.String setter,
                                            java.lang.String criteria,
                                            java.lang.Object[] cValues)
                                     throws SeQuaLiteException

Throws:

SeQuaLiteException

initDriver

public static void initDriver(java.lang.String driverClass)
                       throws java.lang.Exception

Initializes the driver class

Parameters:

driverClass -

Throws:

java.lang.Exception

loadDrivers

public static java.lang.Class[] loadDrivers(java.lang.String[] jarPath)
                                     throws SeQuaLiteException

Loads the driver class

Parameters:

jarPath -

Returns:

Throws:

SeQuaLiteException

lookupDataSource

public static javax.sql.DataSource lookupDataSource(java.lang.String jndiName)
                                             throws SeQuaLiteException

Looks up the datasource

Parameters:

jndiName -

Returns:

Throws:

SeQuaLiteException

lookupMappings

public static SequaliteMapper lookupMappings(java.lang.Class pojoClass)
                                      throws SeQuaLiteException

initialize OR mappings

Parameters:

pojoClass -

Returns:

Throws:

SeQuaLiteException

main

public static void main(java.lang.String[] st)

populateChild

public static void populateChild(java.lang.Object obj,
                                 SequaliteMapper sqm,
                                 ClassMapper table,
                                 java.lang.String columnName,
                                 java.lang.Object value)
                          throws SeQuaLiteException

populate Single Child

Parameters:

obj -

table -

columnName -

value -

Throws:

SeQuaLiteException

populateChildren

public static void populateChildren(java.lang.Object obj,
                                    ClassMapper table,
                                    java.lang.String columnName,
                                    java.util.List valueList)
                             throws SeQuaLiteException

populate Multiple Child

Parameters:

obj -

table -

columnName -

valueList -

Throws:

SeQuaLiteException

populateField

public static void populateField(java.lang.Object obj,
                                 ClassMapper table,
                                 java.lang.String columnName,
                                 java.lang.Object value)
                          throws SeQuaLiteException

populate Field

Parameters:

obj -

table -

columnName -

value -

Throws:

SeQuaLiteException

populateFieldFromResultSet

public static void populateFieldFromResultSet(java.sql.ResultSet rs,
                                              java.lang.Object obj,
                                              ClassMapper table,
                                              FieldMapper field)
                                       throws SeQuaLiteException

populates Field From ResultSet

Parameters:

rs -

obj -

table -

field -

Throws:

SeQuaLiteException

populateInsertPSParamsWithFieldValues

public static int populateInsertPSParamsWithFieldValues(java.sql.PreparedStatement ps,
                                                        int psCount,
                                                        java.lang.Object object,
                                                        ClassMapper table)
                                                 throws java.sql.SQLException,
                                                        SeQuaLiteException

populate Insert Prepared Statement Params With Field Values

Parameters:

ps -

psCount -

object -

table -

Returns:

Throws:

java.sql.SQLException

SeQuaLiteException

populateInsertPSParamsWithFieldValues

public static int populateInsertPSParamsWithFieldValues(java.sql.PreparedStatement ps,
                                                        int psCount,
                                                        java.lang.Object object,
                                                        ClassMapper table,
                                                        java.lang.StringBuffer sb)
                                                 throws java.sql.SQLException,
                                                        SeQuaLiteException

populate Insert Prepared Statement Params With Field Values

Parameters:

ps -

psCount -

object -

table -

sb -

Returns:

Throws:

java.sql.SQLException

SeQuaLiteException

populateObjectFromResultSet

public static void populateObjectFromResultSet(java.sql.ResultSet rs,
                                               java.lang.Object obj,
                                               ClassMapper table,
                                               Session session,
                                               SequaliteMapper sequaliteMapper)
                                        throws java.sql.SQLException,
                                               SeQuaLiteException

populates an Object from resultset

Parameters:

rs -

obj -

Throws:

java.sql.SQLException

SeQuaLiteException

SQLSyntaxException

populateObjects

public static java.util.List populateObjects(Session session,
                                             java.sql.ResultSet rs,
                                             java.lang.Class cls,
                                             ClassMapper table,
                                             SequaliteMapper mapper)
                                      throws java.sql.SQLException

Creates a list of objects from Resultset

Parameters:

rs -

cls -

Returns:

Throws:

java.sql.SQLException

populatePrimaryKey

public static void populatePrimaryKey(java.sql.ResultSet rs,
                                      java.lang.Object obj,
                                      ClassMapper table)
                               throws java.sql.SQLException,
                                      SeQuaLiteException

populate Primary Key

Parameters:

rs -

obj -

table -

Throws:

java.sql.SQLException

SeQuaLiteException

populateProxyObjectFromResultSet

public static void populateProxyObjectFromResultSet(java.sql.ResultSet rs,
                                                    java.lang.Object obj,
                                                    ClassMapper table,
                                                    java.lang.String columnName,
                                                    java.lang.String rsColumnName)
                                             throws SeQuaLiteException

populates proxy object

Parameters:

rs -

obj -

table -

columnName -

rsColumnName -

Throws:

SeQuaLiteException

populateProxyObjects

public static java.util.List<SeQuaLiteModel> populateProxyObjects(Session session,
                                                                  java.sql.ResultSet rs,
                                                                  java.lang.Class cls,
                                                                  ClassMapper table)
                                                           throws java.sql.SQLException

Creates a list of objects from Resultset

Parameters:

rs -

cls -

Returns:

Throws:

java.sql.SQLException

populatePSParams

public static void populatePSParams(java.sql.PreparedStatement ps,
                                    boolean insert,
                                    boolean autoIncrement,
                                    java.lang.Object object,
                                    SequaliteMapper sqm,
                                    ClassMapper table,
                                    java.lang.StringBuffer sb)
                             throws java.sql.SQLException,
                                    SeQuaLiteException

populates preparedStatement parameters from Object

Parameters:

ps -

insert -

autoIncrement -

object -

sqm -

table -

sb -

Throws:

java.sql.SQLException

SeQuaLiteException

populatePSParams

public static void populatePSParams(java.sql.PreparedStatement ps,
                                    java.lang.String sql,
                                    java.lang.Object[] values,
                                    java.util.logging.Level sqlLevel)
                             throws java.sql.SQLException

populate Prepared Statement Params

Parameters:

ps -

sql -

values -

sqlLevel -

Throws:

java.sql.SQLException

populatePSParamsWithChildPKValues

public static int populatePSParamsWithChildPKValues(java.sql.PreparedStatement ps,
                                                    int psCount,
                                                    java.lang.Object object,
                                                    SequaliteMapper sqm,
                                                    ClassMapper table)
                                             throws java.sql.SQLException,
                                                    SeQuaLiteException

populate Prepared Statement Params With Child PriamryKey Value

Parameters:

ps -

psCount -

object -

sqm -

table -

Returns:

Throws:

java.sql.SQLException

SeQuaLiteException

populatePSParamsWithChildPKValues

public static int populatePSParamsWithChildPKValues(java.sql.PreparedStatement ps,
                                                    int psCount,
                                                    java.lang.Object object,
                                                    SequaliteMapper sqm,
                                                    ClassMapper table,
                                                    java.lang.StringBuffer sb)
                                             throws java.sql.SQLException,
                                                    SeQuaLiteException

populate Prepared Statement Params With Child PriamryKey Value

Parameters:

ps -

psCount -

object -

sqm -

table -

sb -

Returns:

Throws:

java.sql.SQLException

SeQuaLiteException

populateSeQuaLiteModelFromResultSet

public static void populateSeQuaLiteModelFromResultSet(java.sql.ResultSet rs,
                                                       SeQuaLiteModel obj,
                                                       ClassMapper table,
                                                       Session session,
                                                       SequaliteMapper mapper)
                                                throws java.sql.SQLException,
                                                       SeQuaLiteException

populates an Object from resultset

Parameters:

rs -

obj -

Throws:

java.sql.SQLException

SeQuaLiteException

SQLSyntaxException

populateUpdatePSParamsWithFieldValues

public static int populateUpdatePSParamsWithFieldValues(java.sql.PreparedStatement ps,
                                                        int psCount,
                                                        java.lang.Object object,
                                                        ClassMapper table)
                                                 throws java.sql.SQLException,
                                                        SeQuaLiteException

populate Update Prepared Statement Params With Field Values

Parameters:

ps -

psCount -

object -

table -

Returns:

Throws:

java.sql.SQLException

SeQuaLiteException

populateUpdatePSParamsWithFieldValues

public static int populateUpdatePSParamsWithFieldValues(java.sql.PreparedStatement ps,
                                                        int psCount,
                                                        java.lang.Object object,
                                                        ClassMapper table,
                                                        java.lang.StringBuffer sb)
                                                 throws java.sql.SQLException,
                                                        SeQuaLiteException

populate Update Prepared Statement Params With Field Values

Parameters:

ps -

psCount -

object -

table -

sb -

Returns:

Throws:

java.sql.SQLException

SeQuaLiteException

setPrimaryKeyValue

public static void setPrimaryKeyValue(java.lang.Object obj,
                                      ClassMapper table,
                                      java.lang.Object value)
                               throws SeQuaLiteException

set PrimaryKey Value

Parameters:

obj -

table -

value -

Throws:

SeQuaLiteException

translateToOrderByClause

public static java.lang.String translateToOrderByClause(ClassMapper clazz,
                                                        java.lang.String sql)

traslates a sql to orderby clause

Parameters:

clazz -

sql -

Returns:

translateToSQL

public static java.lang.String translateToSQL(ClassMapper clazz,
                                              java.lang.String sql)

traslates a sql

Parameters:

clazz -

sql -

Returns:

translateToWhereClause

public static java.lang.String translateToWhereClause(ClassMapper clazz,
                                                      java.lang.String sql,
                                                      java.lang.Object[] values)
                                               throws SeQuaLiteException

traslates a sql to where clause

Parameters:

clazz -

sql -

Returns:

Throws:

SQLSyntaxException

SeQuaLiteException