|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.sequalite.utils.DAOUtils
public class DAOUtils
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 |
---|
public static boolean createORmap
Constructor Detail |
---|
public DAOUtils()
Method Detail |
---|
public static java.lang.String arrayToString(java.lang.Object[] objects)
objects
-
public static java.util.List clone(java.util.List list, SequaliteMapper mapper) throws SeQuaLiteException
list
- mapper
-
SeQuaLiteException
public static java.lang.Object clone(java.lang.Object base, SequaliteMapper mapper) throws SeQuaLiteException
base
- mapper
-
SeQuaLiteException
public static SequaliteMapper constructPackageMetaData(java.lang.Class pojoClass)
public static java.lang.Class createClass(SequaliteMapper sqm, java.lang.String className) throws SeQuaLiteException
sqm
- className
-
SeQuaLiteException
public static java.lang.Object createObject(java.lang.Class cls) throws SeQuaLiteException
cls
-
SeQuaLiteException
public static void dumpObject(java.io.PrintStream out, java.lang.Object obj)
out
- obj
- public static void dumpResultset(java.io.PrintStream out, java.sql.ResultSet rs)
out
- rs
- public static void freeResources(java.lang.Object[] objects) throws SeQuaLiteException
objects
-
SeQuaLiteException
public static ChildMapper getChildMapperByColumnName(ClassMapper ptm, java.lang.String columnName) throws SeQuaLiteException
ptm
- columnName
-
SeQuaLiteException
public static ChildMapper getChildMapperByName(ClassMapper ptm, java.lang.String javaName) throws SeQuaLiteException
ptm
- javaName
-
SeQuaLiteException
public static java.lang.Object getChildObject(java.lang.Object obj, ChildMapper child)
obj
- child
-
public static java.util.List getChildObjectList(java.lang.Object obj, ChildMapper child)
obj
- child
-
public static ClassMapper getClassMapper(SequaliteMapper sqm, java.lang.String className) throws SeQuaLiteException
sqm
- className
-
SeQuaLiteException
public static java.lang.String getColumns(ClassMapper table)
table
-
public static java.sql.Connection getConnection(java.sql.Driver driver, java.lang.String jdbcURL, java.lang.String user, java.lang.String password) throws SeQuaLiteException
driver
- jdbcURL
- user
- password
-
SeQuaLiteException
public static java.sql.Connection getConnection(java.lang.String context, java.util.Properties prop) throws SeQuaLiteException
context
- prop
-
SeQuaLiteException
public static java.lang.String getCountSQL(java.lang.String query) throws SeQuaLiteException
query
-
SeQuaLiteException
public static java.lang.String getDeleteSQL(ClassMapper table)
table
-
public static java.lang.String getDeleteSQL(ClassMapper table, java.lang.String criteria, java.lang.Object[] cValues) throws SeQuaLiteException
table
- criteria
-
SQLSyntaxException
SeQuaLiteException
public static java.lang.String getDeleteSQLWithoutPK(ClassMapper table, java.lang.Object object, java.util.List valueList) throws SeQuaLiteException
table
- object
- valueList
-
SeQuaLiteException
public static FieldMapper getFieldMapperByColumnName(ClassMapper ptm, java.lang.String columnName) throws SeQuaLiteException
ptm
- columnName
-
SeQuaLiteException
public static FieldMapper getFieldMapperByName(ClassMapper ptm, java.lang.String javaName) throws SeQuaLiteException
ptm
- javaName
-
SeQuaLiteException
public static java.lang.Object getFieldValue(java.lang.Object obj, FieldMapper field) throws SeQuaLiteException
obj
- field
-
SeQuaLiteException
public static java.lang.String getFindSQL(ClassMapper table, java.lang.String filter, java.lang.Object[] cValues, java.lang.String orderBy) throws SeQuaLiteException
table
- filter
- orderBy
-
SeQuaLiteException
public static java.lang.String getIdSQL(ClassMapper table, java.lang.String criteria, java.lang.Object[] cValues, java.lang.String sortBy) throws SeQuaLiteException
table
- criteria
- sortBy
-
SQLSyntaxException
SeQuaLiteException
public static java.lang.String getInsertSQL(ClassMapper table, boolean autoIncrement)
table
-
public static SequaliteMapper getPackageMetaData(java.lang.Class pojoClass) throws SeQuaLiteException
pojoClass
-
SeQuaLiteException
public static java.lang.String getPaginationSQL(java.lang.String query, int page, int rowsPerPage, java.lang.String driver) throws SeQuaLiteException
query
- page
- rowsPerPage
- driver
-
SeQuaLiteException
public static java.lang.Object getPrimaryKeyValue(java.lang.Object obj, ClassMapper table) throws SeQuaLiteException
obj
- table
-
SeQuaLiteException
public static java.lang.String getSelectSQL(ClassMapper table)
table
-
public static SqlMapper getSQL(ClassMapper table, java.lang.String sqlName) throws SeQuaLiteException
table
- sqlName
-
SeQuaLiteException
public static java.lang.String getUpdateSQL(ClassMapper table)
table
-
public static java.lang.String getUpdateSQL(ClassMapper table, java.lang.String setter, java.lang.String criteria, java.lang.Object[] cValues) throws SeQuaLiteException
SeQuaLiteException
public static void initDriver(java.lang.String driverClass) throws java.lang.Exception
driverClass
-
java.lang.Exception
public static java.lang.Class[] loadDrivers(java.lang.String[] jarPath) throws SeQuaLiteException
jarPath
-
SeQuaLiteException
public static javax.sql.DataSource lookupDataSource(java.lang.String jndiName) throws SeQuaLiteException
jndiName
-
SeQuaLiteException
public static SequaliteMapper lookupMappings(java.lang.Class pojoClass) throws SeQuaLiteException
pojoClass
-
SeQuaLiteException
public static void main(java.lang.String[] st)
public static void populateChild(java.lang.Object obj, SequaliteMapper sqm, ClassMapper table, java.lang.String columnName, java.lang.Object value) throws SeQuaLiteException
obj
- table
- columnName
- value
-
SeQuaLiteException
public static void populateChildren(java.lang.Object obj, ClassMapper table, java.lang.String columnName, java.util.List valueList) throws SeQuaLiteException
obj
- table
- columnName
- valueList
-
SeQuaLiteException
public static void populateField(java.lang.Object obj, ClassMapper table, java.lang.String columnName, java.lang.Object value) throws SeQuaLiteException
obj
- table
- columnName
- value
-
SeQuaLiteException
public static void populateFieldFromResultSet(java.sql.ResultSet rs, java.lang.Object obj, ClassMapper table, FieldMapper field) throws SeQuaLiteException
rs
- obj
- table
- field
-
SeQuaLiteException
public static int populateInsertPSParamsWithFieldValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, ClassMapper table) throws java.sql.SQLException, SeQuaLiteException
ps
- psCount
- object
- table
-
java.sql.SQLException
SeQuaLiteException
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
ps
- psCount
- object
- table
- sb
-
java.sql.SQLException
SeQuaLiteException
public static void populateObjectFromResultSet(java.sql.ResultSet rs, java.lang.Object obj, ClassMapper table, Session session, SequaliteMapper sequaliteMapper) throws java.sql.SQLException, SeQuaLiteException
rs
- obj
-
java.sql.SQLException
SeQuaLiteException
SQLSyntaxException
public static java.util.List populateObjects(Session session, java.sql.ResultSet rs, java.lang.Class cls, ClassMapper table, SequaliteMapper mapper) throws java.sql.SQLException
rs
- cls
-
java.sql.SQLException
public static void populatePrimaryKey(java.sql.ResultSet rs, java.lang.Object obj, ClassMapper table) throws java.sql.SQLException, SeQuaLiteException
rs
- obj
- table
-
java.sql.SQLException
SeQuaLiteException
public static void populateProxyObjectFromResultSet(java.sql.ResultSet rs, java.lang.Object obj, ClassMapper table, java.lang.String columnName, java.lang.String rsColumnName) throws SeQuaLiteException
rs
- obj
- table
- columnName
- rsColumnName
-
SeQuaLiteException
public static java.util.List<SeQuaLiteModel> populateProxyObjects(Session session, java.sql.ResultSet rs, java.lang.Class cls, ClassMapper table) throws java.sql.SQLException
rs
- cls
-
java.sql.SQLException
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
ps
- insert
- autoIncrement
- object
- sqm
- table
- sb
-
java.sql.SQLException
SeQuaLiteException
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
ps
- sql
- values
- sqlLevel
-
java.sql.SQLException
public static int populatePSParamsWithChildPKValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, SequaliteMapper sqm, ClassMapper table) throws java.sql.SQLException, SeQuaLiteException
ps
- psCount
- object
- sqm
- table
-
java.sql.SQLException
SeQuaLiteException
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
ps
- psCount
- object
- sqm
- table
- sb
-
java.sql.SQLException
SeQuaLiteException
public static void populateSeQuaLiteModelFromResultSet(java.sql.ResultSet rs, SeQuaLiteModel obj, ClassMapper table, Session session, SequaliteMapper mapper) throws java.sql.SQLException, SeQuaLiteException
rs
- obj
-
java.sql.SQLException
SeQuaLiteException
SQLSyntaxException
public static int populateUpdatePSParamsWithFieldValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, ClassMapper table) throws java.sql.SQLException, SeQuaLiteException
ps
- psCount
- object
- table
-
java.sql.SQLException
SeQuaLiteException
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
ps
- psCount
- object
- table
- sb
-
java.sql.SQLException
SeQuaLiteException
public static void setPrimaryKeyValue(java.lang.Object obj, ClassMapper table, java.lang.Object value) throws SeQuaLiteException
obj
- table
- value
-
SeQuaLiteException
public static java.lang.String translateToOrderByClause(ClassMapper clazz, java.lang.String sql)
clazz
- sql
-
public static java.lang.String translateToSQL(ClassMapper clazz, java.lang.String sql)
clazz
- sql
-
public static java.lang.String translateToWhereClause(ClassMapper clazz, java.lang.String sql, java.lang.Object[] values) throws SeQuaLiteException
clazz
- sql
-
SQLSyntaxException
SeQuaLiteException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |