com.github.drinkjava2.jdbpro
Class PreparedSQL

java.lang.Object
  com.github.drinkjava2.jdbpro.PreparedSQL

public class PreparedSQL
extends Object

PreparedSQL is a temporary object used for store SQL, parameter, ResultSetHandlers, SqlHandlers, Connection and templateEngine..., it's not thread-safe

Since:

1.7.0

Author:

Yong Zhu

Constructor Summary

PreparedSQL()

PreparedSQL(SqlOption type, Connection conn, org.apache.commons.dbutils.ResultSetHandler<?> rsh, String sql, Object... params)

Method Summary

void	addGives(String[] gives)
void	addGlobalAndThreadedHandlers(ImprovedQueryRunner dbPro)
void	addHandler(org.apache.commons.dbutils.ResultSetHandler handler)
void	addHandler(SqlHandler handler)
void	addModel(Object model)
void	addNoParamHandlerByClass(Class handlerClass)
void	addOther(SqlItem obj)
void	addParam(Object param)
StringBuilder	addSql(Object sqlPiece)
void	addSqlHandler(SqlHandler sqlHandler)
void	addSqlOrParam(boolean inlineStyle, String item) if InlineStyle=true or SQL is empty, add as SQL, else add as parameter
void	addTemplateMap(Map<String,Object> map) Add map content to current template map, if keys already exist will use new value replace
void	addTemplateParam(SqlItem sp)
void	changeResultSetHandler(org.apache.commons.dbutils.ResultSetHandler<?> rsh)
void	disableHandlers(Object[] handlersClass)
void	enableAllHandlers()
String[]	getAliases()
Connection	getConnection()
String	getDebugInfo() This is used for debug only
List<Class<?>>	getDisabledHandlers()
Object	getEntityNet()
List<String[]>	getGivesList()
Boolean	getIgnoreNull()
SqlOption	getMasterSlaveOption()
Object[]	getModels()
SqlOption	getOperationType()
List<SqlItem>	getOthers()
Object[]	getParams()
int	getParamSize()
org.apache.commons.dbutils.ResultSetHandler<?>	getResultSetHandler()
String	getSql()
StringBuilder	getSqlBuilder()
List<SqlHandler>	getSqlHandlers()
DbPro	getSwitchTo()
SqlTemplateEngine	getTemplateEngine()
Map<String,Object>	getTemplateParamMap()
protected void	GetterSetters_________________________()
Boolean	getUseTemplate()
void	giveBoth(String alias1, String alias2)
void	ifNullSetType(SqlOption type) If current type is null, set with new type value
void	ifNullSetUseTemplate(Boolean useTemplate) If current type is null, set with new type value
boolean	isDisabledHandler(Object handler)
void	setAliases(String[] aliases)
void	setConnection(Connection connection)
void	setDisabledHandlers(List<Class<?>> disabledHandlers)
void	setEntityNet(Object entityNet)
void	setGivesList(List<String[]> givesList)
void	setIgnoreNull(Boolean ignoreNull)
void	setLastAliases(String... alias)
void	setMasterSlaveOption(SqlOption masterSlaveOption)
void	setModels(Object[] models)
void	setOperationType(SqlOption operationType)
void	setOthers(List<SqlItem> others)
void	setParams(Object[] params)
void	setResultSetHandler(org.apache.commons.dbutils.ResultSetHandler<?> rsh)
void	setSql(String sql)
void	setSqlBuilder(StringBuilder sqlBuilder)
void	setSqlHandlers(List<SqlHandler> sqlHandlers)
void	setSwitchTo(DbPro switchTo)
void	setTemplateEngine(SqlTemplateEngine templateEngine)
void	setTemplateParamMap(Map<String,Object> templateParamMap)
void	setUseTemplate(Boolean useTemplate)

Methods inherited from class java.lang.Object

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

Constructor Detail

PreparedSQL

public PreparedSQL()

PreparedSQL

public PreparedSQL(SqlOption type,
                   Connection conn,
                   org.apache.commons.dbutils.ResultSetHandler<?> rsh,
                   String sql,
                   Object... params)

Method Detail

getDebugInfo

public String getDebugInfo()

This is used for debug only

addSql

public StringBuilder addSql(Object sqlPiece)

addParam

public void addParam(Object param)

addModel

public void addModel(Object model)

setLastAliases

public void setLastAliases(String... alias)

addGives

public void addGives(String[] gives)

giveBoth

public void giveBoth(String alias1,
                     String alias2)

addTemplateMap

public void addTemplateMap(Map<String,Object> map)

Add map content to current template map, if keys already exist will use new value replace

addTemplateParam

public void addTemplateParam(SqlItem sp)

addSqlHandler

public void addSqlHandler(SqlHandler sqlHandler)

disableHandlers

public void disableHandlers(Object[] handlersClass)

isDisabledHandler

public boolean isDisabledHandler(Object handler)

enableAllHandlers

public void enableAllHandlers()

getParamSize

public int getParamSize()

setResultSetHandler

public void setResultSetHandler(org.apache.commons.dbutils.ResultSetHandler<?> rsh)

changeResultSetHandler

public void changeResultSetHandler(org.apache.commons.dbutils.ResultSetHandler<?> rsh)

addHandler

public void addHandler(org.apache.commons.dbutils.ResultSetHandler handler)

addHandler

public void addHandler(SqlHandler handler)

addNoParamHandlerByClass

public void addNoParamHandlerByClass(Class handlerClass)

getParams

public Object[] getParams()

addGlobalAndThreadedHandlers

public void addGlobalAndThreadedHandlers(ImprovedQueryRunner dbPro)

ifNullSetType

public void ifNullSetType(SqlOption type)

If current type is null, set with new type value

ifNullSetUseTemplate

public void ifNullSetUseTemplate(Boolean useTemplate)

If current type is null, set with new type value

addOther

public void addOther(SqlItem obj)

addSqlOrParam

public void addSqlOrParam(boolean inlineStyle,
                          String item)

if InlineStyle=true or SQL is empty, add as SQL, else add as parameter

GetterSetters_________________________

protected void GetterSetters_________________________()

getOperationType

public SqlOption getOperationType()

setOperationType

public void setOperationType(SqlOption operationType)

getConnection

public Connection getConnection()

setConnection

public void setConnection(Connection connection)

getSql

public String getSql()

setSql

public void setSql(String sql)

getUseTemplate

public Boolean getUseTemplate()

setUseTemplate

public void setUseTemplate(Boolean useTemplate)

getTemplateEngine

public SqlTemplateEngine getTemplateEngine()

setTemplateEngine

public void setTemplateEngine(SqlTemplateEngine templateEngine)

getTemplateParamMap

public Map<String,Object> getTemplateParamMap()

setTemplateParamMap

public void setTemplateParamMap(Map<String,Object> templateParamMap)

getSqlHandlers

public List<SqlHandler> getSqlHandlers()

setSqlHandlers

public void setSqlHandlers(List<SqlHandler> sqlHandlers)

getResultSetHandler

public org.apache.commons.dbutils.ResultSetHandler<?> getResultSetHandler()

setParams

public void setParams(Object[] params)

setMasterSlaveOption

public void setMasterSlaveOption(SqlOption masterSlaveOption)

getSwitchTo

public DbPro getSwitchTo()

setSwitchTo

public void setSwitchTo(DbPro switchTo)

getMasterSlaveOption

public SqlOption getMasterSlaveOption()

getDisabledHandlers

public List<Class<?>> getDisabledHandlers()

setDisabledHandlers

public void setDisabledHandlers(List<Class<?>> disabledHandlers)

getAliases

public String[] getAliases()

setAliases

public void setAliases(String[] aliases)

getModels

public Object[] getModels()

setModels

public void setModels(Object[] models)

getGivesList

public List<String[]> getGivesList()

setGivesList

public void setGivesList(List<String[]> givesList)

getEntityNet

public Object getEntityNet()

setEntityNet

public void setEntityNet(Object entityNet)

getOthers

public List<SqlItem> getOthers()

setOthers

public void setOthers(List<SqlItem> others)

getSqlBuilder

public StringBuilder getSqlBuilder()

setSqlBuilder

public void setSqlBuilder(StringBuilder sqlBuilder)

getIgnoreNull

public Boolean getIgnoreNull()

setIgnoreNull

public void setIgnoreNull(Boolean ignoreNull)