org.tinygroup.tinydb.operator.impl

Class BeanDBSqlQueryOperator<K>

java.lang.Object

org.tinygroup.tinydb.sql.impl.StatementTransformAdapter

org.tinygroup.tinydb.sql.impl.StatementTransformComposite

org.tinygroup.tinydb.operator.impl.DBSpringBaseOperator

org.tinygroup.tinydb.operator.impl.BeanDBSingleOperator<K>

org.tinygroup.tinydb.operator.impl.BeanDBBatchOperator<K>

org.tinygroup.tinydb.operator.impl.BeanDBSqlOperator<K>

org.tinygroup.tinydb.operator.impl.BeanDBSqlQueryOperator<K>

All Implemented Interfaces:

DbBaseOperator, DbBatchOperator<K>, DbRelationOperator, DbSingleOperator<K>, DbSqlOperator<K>, DbSqlQueryOperator<K>, TransactionOperator, StatementTransform

Direct Known Subclasses:

GenericDbOperator

public class BeanDBSqlQueryOperator<K>
extends BeanDBSqlOperator<K>
implements DbSqlQueryOperator<K>

Field Summary

Fields

Modifier and Type	Field and Description
protected BeanOperatorManager	manager

Fields inherited from class org.tinygroup.tinydb.operator.impl.DBSpringBaseOperator

jdbcTemplate

Fields inherited from class org.tinygroup.tinydb.sql.impl.StatementTransformAdapter

beanDbNameConverter, configuration, schema

Fields inherited from interface org.tinygroup.tinydb.operator.DbBaseOperator

DEFAULT_BEAN_TYPE

Constructor Summary

Constructors

Constructor and Description
BeanDBSqlQueryOperator()
BeanDBSqlQueryOperator(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate, Configuration configuration)

Method Summary

Modifier and Type	Method and Description
protected org.springframework.jdbc.core.SqlParameterValue	createSqlParameter(Object value, ColumnConfiguration primaryColumn)
protected org.springframework.jdbc.core.SqlParameterValue[]	createSqlParameterValue(Bean bean)
protected org.springframework.jdbc.core.SqlParameterValue	createSqlParamter(Object value, ColumnConfiguration primaryColumn) Deprecated.
void	generateOrderSqlClause(OrderBean[] orderBeans, StringBuffer stringBuffer) 生成order by 子句
void	generateQuerySqlClause(Conditions conditions, StringBuffer stringBuffer, List<Object> valueList) 产生SQL语句
void	generateSelectSqlClause(SelectBean[] selectBeans, StringBuffer stringBuffer) 生成查询部分的sql片段
String	generateSqlClause(SelectBean[] selectBeans, String beanType, Conditions conditions, OrderBean[] orderBeans, List<Object> valueList) 生成sql语句
String	generateSqlClause(String selectClause, String beanType, Conditions conditions, OrderBean[] orderBeans, List<Object> valueList)
int	getAutoIncreaseKey() 如果是自增长类型的Key返回新增加的值
Bean[]	getBeans(SelectBean[] selectBeans, String beanType, Conditions conditions, OrderBean[] orderBeans)
Bean[]	getBeans(SelectBean[] selectBeans, String beanType, Conditions conditions, OrderBean[] orderBeans, int start, int limit)
Bean[]	getBeans(String beanType, Conditions conditions, OrderBean[] orderBeans)
Bean[]	getBeans(String beanType, Conditions conditions, OrderBean[] orderBeans, int start, int limit)
Bean[]	getBeans(String selectClause, String beanType, Conditions conditions, OrderBean[] orderBeans)
Bean[]	getBeans(String selectClause, String beanType, Conditions conditions, OrderBean[] orderBeans, int start, int limit)
protected List<String>	getColumnNames(Bean bean) 获取操作的所有数据库字段名称
protected List<Integer>	getDataTypes(Bean bean) 获取操作的所有数据库字段类型
protected List<Integer>	getDataTypes(List<ColumnConfiguration> paramsKeys)
protected List<List<Object>>	getDeleteParams(Bean[] beans)
protected String	getDeleteSqlByKey(String beanType)
protected List<org.springframework.jdbc.core.SqlParameterValue[]>	getInsertParams(Bean[] beans)
BeanOperatorManager	getManager()
protected List<Object>	getParam(Bean bean, List<ColumnConfiguration> paramsKeys)
protected List<List<Object>>	getParamList(Bean[] beans, List<ColumnConfiguration> paramsKeys)
protected List<Object>	getParams(Bean bean)
protected List<org.springframework.jdbc.core.SqlParameterValue[]>	getParams(Bean[] beans, org.springframework.jdbc.core.SqlParameterValue[] values)
protected String	getPrimaryFieldName(DbBaseOperator operator, String beanType)
protected String	getPrimaryKeyValue(DbBaseOperator operator, Bean bean) 获取主键值
protected String	getQuerySql(String beanType)
Relation	getRelation(String beanType) 获取关联操作对象
String	getSchema() 获取schame
Bean	getSingleValue(SelectBean[] selectBeans, String beanType, Conditions conditions)
Bean	getSingleValue(String beanType, Conditions conditions)
Bean	getSingleValue(String selectClause, String beanType, Conditions conditions)
protected org.springframework.jdbc.core.SqlParameterValue[]	getSqlParameterValue(Bean bean, List<String> conditionColumns)
protected org.springframework.jdbc.core.SqlParameterValue[]	getSqlParameterValues(Bean bean)
protected org.springframework.jdbc.core.SqlParameterValue[]	getSqlParamterValue(Bean bean, List<String> conditionColumns) Deprecated.
protected String	getTableNameWithSchame(String tableName)
void	setManager(BeanOperatorManager manager)

Methods inherited from class org.tinygroup.tinydb.operator.impl.BeanDBSqlOperator

account, account, account, account, execute, execute, execute, getBeans, getBeans, getBeans, getBeans, getBeans, getCursorPageBeans, getCursorPageBeans, getCursorPageBeans, getCursorPageBeans, getDialectPageBeans, getDialectPageBeans, getDialectPageBeans, getDialectPageBeans, getPageBeans, getPageBeans, getPageBeans, getPageBeans, getPager, getPager, getPager, getPager, getPager, getSingleValue, getSingleValue, getSingleValue, getSingleValue

Methods inherited from class org.tinygroup.tinydb.operator.impl.BeanDBBatchOperator

batchDelete, batchDelete, batchDelete, batchDelete, batchInsert, batchInsert, batchInsert, batchInsert, batchUpdate, batchUpdate, batchUpdate, batchUpdate, deleteBean, deleteById, deleteById, executeBatch, executeBatchByList, executeBatchByList, executeBatchByMap, getBeans, getBeansById, getBeansById, insertBean, updateBean

Methods inherited from class org.tinygroup.tinydb.operator.impl.BeanDBSingleOperator

beanNotExist, checkMoreToOne, checkOneToMore, createRelationBean, createRelationBeans, delete, deleteById, deleteTopBean, getBean, getRelationBeans, insert, insertTopBean, processRelation, relationProcess, update, update, updateTopBean

Methods inherited from class org.tinygroup.tinydb.operator.impl.DBSpringBaseOperator

account, beginTransaction, checkNullParamList, commitTransaction, deleteNullParamList, execute, executeBatchBySqlParamterValues, executeBatchOperator, executeBatchOperator, executeByArray, executeByList, executeByMap, executeBySqlParameterValue, executeBySqlParameterValues, findBeans, findBeans, findBeansByList, findBeansByListForCursorPage, findBeansByListForDialectPage, findBeansByListForPage, findBeansByMap, findBeansByMapForCursorPage, findBeansByMapForDialectPage, findBeansByMapForPage, findBeansForCursorPage, findBeansForDialectPage, findBeansForPage, getBeanDbNameConverter, getDialect, getParamArray, getTransactionDefinition, getTransactionManager, getUniqueCode, operatorDebugLog, operatorDebugLogNoParam, operatorErrorLog, operatorErrorLogNoParam, queryForInt, queryForIntByList, queryForIntByMap, queryObject, queryObjectByMap, rollbackTransaction, setBeanDbNameConverter, setDialect, setJdbcTemplate, setTransactionDefinition, setTransactionManager

Methods inherited from class org.tinygroup.tinydb.sql.impl.StatementTransformComposite

setConfiguration, setSchema, toDelete, toInsert, toSelect, toUpdate

Methods inherited from class org.tinygroup.tinydb.sql.impl.StatementTransformAdapter

checkBeanPropertyNull, getConditionParams, getConditionSql, getDeleteSql, getFullTableName, getInsertSql, getTableName, getUpdateSql

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.tinygroup.tinydb.operator.DbBaseOperator

getBeanDbNameConverter, getDialect, getUniqueCode, setBeanDbNameConverter, setConfiguration, setDialect, setJdbcTemplate, setSchema

Field Detail

manager

protected BeanOperatorManager manager

Constructor Detail

BeanDBSqlQueryOperator

public BeanDBSqlQueryOperator()

BeanDBSqlQueryOperator

public BeanDBSqlQueryOperator(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate,
                              Configuration configuration)

Method Detail

generateQuerySqlClause

public void generateQuerySqlClause(Conditions conditions,
                                   StringBuffer stringBuffer,
                                   List<Object> valueList)

产生SQL语句

Parameters:

queryBean -

stringBuffer - 用于存放SQL

valueList - 用于存放值列表

generateSelectSqlClause

public void generateSelectSqlClause(SelectBean[] selectBeans,
                                    StringBuffer stringBuffer)

生成查询部分的sql片段

Parameters:

selectBeans -

stringBuffer -

generateOrderSqlClause

public void generateOrderSqlClause(OrderBean[] orderBeans,
                                   StringBuffer stringBuffer)

生成order by 子句

Parameters:

orderBeans -

stringBuffer -

generateSqlClause

public String generateSqlClause(SelectBean[] selectBeans,
                                String beanType,
                                Conditions conditions,
                                OrderBean[] orderBeans,
                                List<Object> valueList)

生成sql语句

Parameters:

selectBeans -

queryBean -

orderBeans -

valueList -

generateSqlClause

public String generateSqlClause(String selectClause,
                                String beanType,
                                Conditions conditions,
                                OrderBean[] orderBeans,
                                List<Object> valueList)

getBeans

public Bean[] getBeans(SelectBean[] selectBeans,
                       String beanType,
                       Conditions conditions,
                       OrderBean[] orderBeans)
                throws TinyDbException

Specified by:

getBeans in interface DbSqlQueryOperator<K>

Throws:

TinyDbException

getBeans

public Bean[] getBeans(SelectBean[] selectBeans,
                       String beanType,
                       Conditions conditions,
                       OrderBean[] orderBeans,
                       int start,
                       int limit)
                throws TinyDbException

Specified by:

getBeans in interface DbSqlQueryOperator<K>

Throws:

TinyDbException

getBeans

public Bean[] getBeans(String beanType,
                       Conditions conditions,
                       OrderBean[] orderBeans,
                       int start,
                       int limit)
                throws TinyDbException

Specified by:

getBeans in interface DbSqlQueryOperator<K>

Throws:

TinyDbException

getSingleValue

public Bean getSingleValue(String beanType,
                           Conditions conditions)
                    throws TinyDbException

Specified by:

getSingleValue in interface DbSqlQueryOperator<K>

Throws:

TinyDbException

getSingleValue

public Bean getSingleValue(SelectBean[] selectBeans,
                           String beanType,
                           Conditions conditions)
                    throws TinyDbException

Specified by:

getSingleValue in interface DbSqlQueryOperator<K>

Throws:

TinyDbException

getBeans

public Bean[] getBeans(String selectClause,
                       String beanType,
                       Conditions conditions,
                       OrderBean[] orderBeans)
                throws TinyDbException

Specified by:

getBeans in interface DbSqlQueryOperator<K>

Throws:

TinyDbException

getBeans

public Bean[] getBeans(String selectClause,
                       String beanType,
                       Conditions conditions,
                       OrderBean[] orderBeans,
                       int start,
                       int limit)
                throws TinyDbException

Specified by:

getBeans in interface DbSqlQueryOperator<K>

Throws:

TinyDbException

getSingleValue

public Bean getSingleValue(String selectClause,
                           String beanType,
                           Conditions conditions)
                    throws TinyDbException

Specified by:

getSingleValue in interface DbSqlQueryOperator<K>

Throws:

TinyDbException

getBeans

public Bean[] getBeans(String beanType,
                       Conditions conditions,
                       OrderBean[] orderBeans)
                throws TinyDbException

Specified by:

getBeans in interface DbSqlQueryOperator<K>

Throws:

TinyDbException

getAutoIncreaseKey

public int getAutoIncreaseKey()
                       throws TinyDbException

Description copied from interface: DbBaseOperator

如果是自增长类型的Key返回新增加的值

Specified by:

getAutoIncreaseKey in interface DbBaseOperator

Returns:

Throws:

TinyDbException

getDeleteSqlByKey

protected String getDeleteSqlByKey(String beanType)
                            throws TinyDbException

Throws:

TinyDbException

getColumnNames

protected List<String> getColumnNames(Bean bean)

获取操作的所有数据库字段名称

Overrides:

getColumnNames in class StatementTransformAdapter

Parameters:

bean -

Returns:

getDataTypes

protected List<Integer> getDataTypes(Bean bean)

获取操作的所有数据库字段类型

Parameters:

bean -

Returns:

getSqlParameterValues

protected org.springframework.jdbc.core.SqlParameterValue[] getSqlParameterValues(Bean bean)

getDataTypes

protected List<Integer> getDataTypes(List<ColumnConfiguration> paramsKeys)

createSqlParamter

@Deprecated
protected org.springframework.jdbc.core.SqlParameterValue createSqlParamter(Object value,
                                                                                        ColumnConfiguration primaryColumn)

Deprecated.

createSqlParameter

protected org.springframework.jdbc.core.SqlParameterValue createSqlParameter(Object value,
                                                                             ColumnConfiguration primaryColumn)

getSqlParamterValue

@Deprecated
protected org.springframework.jdbc.core.SqlParameterValue[] getSqlParamterValue(Bean bean,
                                                                                            List<String> conditionColumns)
                                                                                     throws TinyDbException

Deprecated.

Throws:

TinyDbException

getSqlParameterValue

protected org.springframework.jdbc.core.SqlParameterValue[] getSqlParameterValue(Bean bean,
                                                                                 List<String> conditionColumns)
                                                                          throws TinyDbException

Throws:

TinyDbException

getParamList

protected List<List<Object>> getParamList(Bean[] beans,
                                          List<ColumnConfiguration> paramsKeys)

getParam

protected List<Object> getParam(Bean bean,
                                List<ColumnConfiguration> paramsKeys)

createSqlParameterValue

protected org.springframework.jdbc.core.SqlParameterValue[] createSqlParameterValue(Bean bean)
                                                                             throws TinyDbException

Throws:

TinyDbException

getInsertParams

protected List<org.springframework.jdbc.core.SqlParameterValue[]> getInsertParams(Bean[] beans)
                                                                           throws TinyDbException

Throws:

TinyDbException

getParams

protected List<org.springframework.jdbc.core.SqlParameterValue[]> getParams(Bean[] beans,
                                                                            org.springframework.jdbc.core.SqlParameterValue[] values)

getDeleteParams

protected List<List<Object>> getDeleteParams(Bean[] beans)

getParams

protected List<Object> getParams(Bean bean)

getQuerySql

protected String getQuerySql(String beanType)
                      throws TinyDbException

Throws:

TinyDbException

getTableNameWithSchame

protected String getTableNameWithSchame(String tableName)

Overrides:

getTableNameWithSchame in class StatementTransformAdapter

getSchema

public String getSchema()

Description copied from interface: DbBaseOperator

获取schame

Specified by:

getSchema in interface DbBaseOperator

Overrides:

getSchema in class StatementTransformAdapter

getManager

public BeanOperatorManager getManager()

Specified by:

getManager in interface DbBaseOperator

setManager

public void setManager(BeanOperatorManager manager)

Specified by:

setManager in interface DbBaseOperator

getRelation

public Relation getRelation(String beanType)

Description copied from interface: DbRelationOperator

获取关联操作对象

Specified by:

getRelation in interface DbRelationOperator

Returns:

getPrimaryFieldName

protected String getPrimaryFieldName(DbBaseOperator operator,
                                     String beanType)
                              throws TinyDbException

Throws:

TinyDbException

getPrimaryKeyValue

protected String getPrimaryKeyValue(DbBaseOperator operator,
                                    Bean bean)
                             throws TinyDbException

获取主键值

Parameters:

operator -

bean -

Returns:

Throws:

TinyDbException