com.github.drinkjava2.jdbpro
Class JDBPRO

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

Direct Known Subclasses:

JSQLBOX

public abstract class JDBPRO
extends Object

JDBPRO store some public static methods, usually used for static import to simplify programming

Since:

1.7.0.3

Author:

Yong Zhu

Field Summary

static SqlOption	USE_AUTO
static SqlOption	USE_BOTH
static SqlOption	USE_MASTER
static SqlOption	USE_SLAVE
static SqlOption	USE_TEMPLATE

Constructor Summary

JDBPRO()

Method Summary

protected void	________INLINE_Methods________()
protected void	________SqlItem_Methods________()
static SqlItem	bind(Object... parameters) For tXxxx style templateEngine use, return a SqlItemType.PUT type SqlItem instance, Usage: put("key1",value1,"key2",value2...);
static SqlItem	disableHandlers(Class<?>... args) Create a SqlOption.IOC_OBJECT type SqlItem instance, args will create instance by IocTool
static SqlItem	ioc(Class<?>... args) Create a SqlOption.IOC_OBJECT type SqlItem instance, args will create instance by IocTool
static SqlItem	notNull(Object... items) If last param is not null, then add all items in SQL
static String	PARA(Object... params) Cache parameters in ThreadLocal and return an empty String
static String	PARA0(Object... params) Clear all ThreadLocal parameters first, then cache parameters in ThreadLocal and return an empty String, a non parameter param0() call equal to clearAllInlineThreadlocalParams()
static SqlItem	param(Object... parameters) Return a SqlItemType.PARAM type SqlItem instance
static Object[]	PARAMS() Build a PreparedSQL instance by given in-line style SQL and parameters stored in ThreadLocal
static String	QUES(Object... params) Cache parameters in ThreadLocal and return a "?" String
static String	QUES0(Object... params) Clear all ThreadLocal parameters first, then cache parameters in ThreadLocal, then return a "?" String
static SqlItem	question(Object... parameters) Cache parameters and return a "?" String
static SqlItem	sql(Object... parameters) Cache parameters and return an empty String
static SqlItem	switchTo(DbPro dpPro) Switch to another DbPro
static String	VALUESQUES() Create "values(?,?,?...,?)" String according how many SQL parameters be cached in ThreadLocal
static SqlItem	valuesQuestions() Create "values(?,?,?...,?)" String according how many SQL parameters be cached

Methods inherited from class java.lang.Object

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

Field Detail

USE_MASTER

public static final SqlOption USE_MASTER

USE_SLAVE

public static final SqlOption USE_SLAVE

USE_BOTH

public static final SqlOption USE_BOTH

USE_AUTO

public static final SqlOption USE_AUTO

USE_TEMPLATE

public static final SqlOption USE_TEMPLATE

Constructor Detail

JDBPRO

public JDBPRO()

Method Detail

________INLINE_Methods________

protected void ________INLINE_Methods________()

PARA0

public static String PARA0(Object... params)

Clear all ThreadLocal parameters first, then cache parameters in ThreadLocal and return an empty String, a non parameter param0() call equal to clearAllInlineThreadlocalParams()

PARA

public static String PARA(Object... params)

Cache parameters in ThreadLocal and return an empty String

PARAMS

public static Object[] PARAMS()

Build a PreparedSQL instance by given in-line style SQL and parameters stored in ThreadLocal

Parameters:

inlineSQL -

Returns:

PreparedSQL instance

QUES0

public static String QUES0(Object... params)

Clear all ThreadLocal parameters first, then cache parameters in ThreadLocal, then return a "?" String

QUES

public static String QUES(Object... params)

Cache parameters in ThreadLocal and return a "?" String

VALUESQUES

public static String VALUESQUES()

Create "values(?,?,?...,?)" String according how many SQL parameters be cached in ThreadLocal

________SqlItem_Methods________

protected void ________SqlItem_Methods________()

param

public static SqlItem param(Object... parameters)

Return a SqlItemType.PARAM type SqlItem instance

sql

public static SqlItem sql(Object... parameters)

Cache parameters and return an empty String

question

public static SqlItem question(Object... parameters)

Cache parameters and return a "?" String

notNull

public static SqlItem notNull(Object... items)

If last param is not null, then add all items in SQL

Parameters:

param - The param

Returns:

a SqlItem instance will be used by iPrepare method

valuesQuestions

public static SqlItem valuesQuestions()

Create "values(?,?,?...,?)" String according how many SQL parameters be cached

switchTo

public static SqlItem switchTo(DbPro dpPro)

Switch to another DbPro

bind

public static SqlItem bind(Object... parameters)

For tXxxx style templateEngine use, return a SqlItemType.PUT type SqlItem instance, Usage: put("key1",value1,"key2",value2...);

ioc

public static SqlItem ioc(Class<?>... args)

Create a SqlOption.IOC_OBJECT type SqlItem instance, args will create instance by IocTool

disableHandlers

public static SqlItem disableHandlers(Class<?>... args)

Create a SqlOption.IOC_OBJECT type SqlItem instance, args will create instance by IocTool