com.github.drinkjava2.jsqlbox
Class JSQLBOX

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

public abstract class JSQLBOX
extends JDBPRO

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

Since:

1.0.8

Author:

Yong Zhu

Field Summary

static SqlOption	AUTO_SQL
static SqlOption	EXECUTE
static SqlOption	IGNORE_NULL
static SqlOption	INSERT
static SqlOption	QUERY
static SqlItem	TAIL
static SqlOption	UPDATE
static SqlOption	USE_AUTO
static SqlOption	USE_BOTH
static SqlOption	USE_MASTER
static SqlOption	USE_SLAVE
static SqlOption	USE_TEMPLATE

Constructor Summary

JSQLBOX()

Method Summary

static SqlItem	alias(String... alias) Create a model configurations with iven alias name
static EntityNet	eAutoNet(Class<?>... entityClass)
static int	eCountAll(Class<?> entityClass, Object... items)
static void	eDelete(Object entity, Object... items)
static void	eDeleteById(Class<?> entityClass, Object id, Object... items)
static int	eDeleteByIdTry(Class<?> entityClass, Object id, Object... items)
static int	eDeleteTry(Object entity, Object... items)
static boolean	eExist(Object entity, Object... items)
static boolean	eExistById(Class<?> entityClass, Object id, Object... items)
static <T> List<T>	eFindAll(Class<T> entityClass, Object... items)
static <T> List<T>	eFindBySample(Object sampleBean, Object... items)
static <T> List<T>	eFindBySQL(Object... items)
static <T> List<T>	eFindRelatedList(Object entityOrIterable, Object... sqlItems)
static <T> Map<Object,T>	eFindRelatedMap(Object entity, Object... sqlItems)
static <T> T	eFindRelatedOne(Object entity, Object... sqlItems)
static <T> Set<T>	eFindRelatedSet(Object entity, Object... sqlItems)
static <T> T	eInsert(T entity, Object... items)
static <T> T	eLoad(T entity, Object... items)
static <T> T	eLoadById(Class<T> entityClass, Object entityId, Object... items)
static <T> T	eLoadByIdTry(Class<T> entityClass, Object entityId, Object... items)
static <T> T	eLoadBySQL(Object... items)
static int	eLoadTry(Object entity, Object... items)
static <T> T	eUpdate(Object entity, Object... items)
static int	eUpdateTry(Object entity, Object... items)
static SqlBoxContext	gctx() Shortcut method equal to SqlBoxContext.getGlobalSqlBoxContext()
static SqlItem	give(String from, String to) For EntityNet Query use, see user manual
static SqlItem	give(String from, String to, String fieldName) For EntityNet Query use, see user manual
static SqlItem	giveBoth(String from, String to) For EntityNet Query use, see user manual
static <T> T	iExecute(Object... items)
static <T> T	iInsert(Object... items)
static <T> T	iQuery(Object... items)
static <T> List<T>	iQueryForEntityList(Object... items)
static long	iQueryForLongValue(Object... items)
static List<Map<String,Object>>	iQueryForMapList(Object... items)
static <T> T	iQueryForObject(Object... items)
static String	iQueryForString(Object... items)
static int	iUpdate(Object... items)
static <T> List<T>	nExecute(Connection conn, org.apache.commons.dbutils.ResultSetHandler<T> rsh, String sql, Object... items)
static int	nExecute(Connection conn, String sql, Object... items)
static <T> List<T>	nExecute(org.apache.commons.dbutils.ResultSetHandler rsh, String sql, Object... items)
static int	nExecute(String sql, Object... items)
static <T> T	nInsert(Connection conn, org.apache.commons.dbutils.ResultSetHandler<T> rsh, String sql, Object... items)
static <T> T	nInsert(org.apache.commons.dbutils.ResultSetHandler rsh, String sql, Object... items)
static SqlItem	noPagin() Disable PaginHandler
static <T> T	nQuery(Connection conn, org.apache.commons.dbutils.ResultSetHandler<T> rsh, String sql, Object... items)
static <T> T	nQuery(org.apache.commons.dbutils.ResultSetHandler<T> rsh, String sql, Object... items)
static long	nQueryForLongValue(Connection conn, String sql, Object... items)
static long	nQueryForLongValue(String sql, Object... items)
static List<Map<String,Object>>	nQueryForMapList(Connection conn, String sql, Object... items)
static List<Map<String,Object>>	nQueryForMapList(String sql, Object... items)
static <T> T	nQueryForObject(Connection conn, String sql, Object... items)
static <T> T	nQueryForObject(String sql, Object... items)
static String	nQueryForString(Connection conn, String sql, Object... items)
static String	nQueryForString(String sql, Object... items)
static int	nUpdate(Connection conn, String sql, Object... items)
static int	nUpdate(String sql, Object... items)
static PaginHandler	pagin(int pageNumber, int pageSize) Build a PaginHandler handler
static <T> T	pExecute(Object... items)
static <T> T	pInsert(Object... items)
static <T> T	pQuery(Object... items)
static <T> List<T>	pQueryForEntityList(Object... items)
static long	pQueryForLongValue(Object... items)
static List<Map<String,Object>>	pQueryForMapList(Object... items)
static <T> T	pQueryForObject(Object... items)
static String	pQueryForString(Object... items)
static int	pUpdate(Object... items)
static Object[]	shard(Object... shardvalues) Build a SHARD_TABLE type sqlItem
static SqlItem	shardDB(Object... shardvalues) Build a SHARD_DATABASE type sqlItem
static SqlItem	shardTB(Object... shardvalues) Build a SHARD_TABLE type sqlItem
static SqlItem	tail(Object... tableName) Build a TAIL SqlItem, tableName is the only parameter
static <T> T	tExecute(Object... items)
static <T> T	tInsert(Object... items)
static <T> T	tQuery(Object... items)
static <T> List<T>	tQueryForEntityList(Class<T> entityClass, Object... items)
static long	tQueryForLongValue(Object... items)
static List<Map<String,Object>>	tQueryForMapList(Object... items)
static <T> T	tQueryForObject(Object... items)
static String	tQueryForString(Object... items)
static int	tUpdate(Object... items)

Methods inherited from class com.github.drinkjava2.jdbpro.JDBPRO

________INLINE_Methods________, ________SqlItem_Methods________, bind, disableHandlers, notNull, PARA, PARA0, param, PARAMS, ques, QUES, QUES0, question, sql, switchTo, VALUESQUES, valuesQuestions

Methods inherited from class java.lang.Object

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

Field Detail

USE_TEMPLATE

public static final SqlOption USE_TEMPLATE

EXECUTE

public static final SqlOption EXECUTE

UPDATE

public static final SqlOption UPDATE

INSERT

public static final SqlOption INSERT

QUERY

public static final SqlOption QUERY

USE_AUTO

public static final SqlOption USE_AUTO

USE_MASTER

public static final SqlOption USE_MASTER

USE_SLAVE

public static final SqlOption USE_SLAVE

USE_BOTH

public static final SqlOption USE_BOTH

IGNORE_NULL

public static final SqlOption IGNORE_NULL

AUTO_SQL

public static final SqlOption AUTO_SQL

TAIL

public static final SqlItem TAIL

Constructor Detail

JSQLBOX

public JSQLBOX()

Method Detail

gctx

public static SqlBoxContext gctx()

Shortcut method equal to SqlBoxContext.getGlobalSqlBoxContext()

tail

public static SqlItem tail(Object... tableName)

Build a TAIL SqlItem, tableName is the only parameter

pagin

public static PaginHandler pagin(int pageNumber,
                                 int pageSize)

Build a PaginHandler handler

alias

public static SqlItem alias(String... alias)

Create a model configurations with iven alias name

give

public static SqlItem give(String from,
                           String to,
                           String fieldName)

For EntityNet Query use, see user manual

give

public static SqlItem give(String from,
                           String to)

For EntityNet Query use, see user manual

giveBoth

public static SqlItem giveBoth(String from,
                               String to)

For EntityNet Query use, see user manual

noPagin

public static SqlItem noPagin()

Disable PaginHandler

shardTB

public static SqlItem shardTB(Object... shardvalues)

Build a SHARD_TABLE type sqlItem

shardDB

public static SqlItem shardDB(Object... shardvalues)

Build a SHARD_DATABASE type sqlItem

shard

public static Object[] shard(Object... shardvalues)

Build a SHARD_TABLE type sqlItem

eFindAll

public static <T> List<T> eFindAll(Class<T> entityClass,
                                   Object... items)

eFindBySample

public static <T> List<T> eFindBySample(Object sampleBean,
                                        Object... items)

eFindBySQL

public static <T> List<T> eFindBySQL(Object... items)

eInsert

public static <T> T eInsert(T entity,
                            Object... items)

eLoad

public static <T> T eLoad(T entity,
                          Object... items)

eLoadById

public static <T> T eLoadById(Class<T> entityClass,
                              Object entityId,
                              Object... items)

eLoadByIdTry

public static <T> T eLoadByIdTry(Class<T> entityClass,
                                 Object entityId,
                                 Object... items)

eLoadBySQL

public static <T> T eLoadBySQL(Object... items)

eUpdate

public static <T> T eUpdate(Object entity,
                            Object... items)

eExist

public static boolean eExist(Object entity,
                             Object... items)

eExistById

public static boolean eExistById(Class<?> entityClass,
                                 Object id,
                                 Object... items)

eCountAll

public static int eCountAll(Class<?> entityClass,
                            Object... items)

eDeleteByIdTry

public static int eDeleteByIdTry(Class<?> entityClass,
                                 Object id,
                                 Object... items)

eDeleteTry

public static int eDeleteTry(Object entity,
                             Object... items)

eLoadTry

public static int eLoadTry(Object entity,
                           Object... items)

eUpdateTry

public static int eUpdateTry(Object entity,
                             Object... items)

eDelete

public static void eDelete(Object entity,
                           Object... items)

eDeleteById

public static void eDeleteById(Class<?> entityClass,
                               Object id,
                               Object... items)

eAutoNet

public static EntityNet eAutoNet(Class<?>... entityClass)

eFindRelatedOne

public static <T> T eFindRelatedOne(Object entity,
                                    Object... sqlItems)

eFindRelatedList

public static <T> List<T> eFindRelatedList(Object entityOrIterable,
                                           Object... sqlItems)

eFindRelatedSet

public static <T> Set<T> eFindRelatedSet(Object entity,
                                         Object... sqlItems)

eFindRelatedMap

public static <T> Map<Object,T> eFindRelatedMap(Object entity,
                                                Object... sqlItems)

pQuery

public static <T> T pQuery(Object... items)

pQueryForObject

public static <T> T pQueryForObject(Object... items)

pQueryForLongValue

public static long pQueryForLongValue(Object... items)

pQueryForString

public static String pQueryForString(Object... items)

pQueryForMapList

public static List<Map<String,Object>> pQueryForMapList(Object... items)

pUpdate

public static int pUpdate(Object... items)

pInsert

public static <T> T pInsert(Object... items)

pExecute

public static <T> T pExecute(Object... items)

pQueryForEntityList

public static <T> List<T> pQueryForEntityList(Object... items)

iQuery

public static <T> T iQuery(Object... items)

iQueryForObject

public static <T> T iQueryForObject(Object... items)

iQueryForLongValue

public static long iQueryForLongValue(Object... items)

iQueryForString

public static String iQueryForString(Object... items)

iQueryForMapList

public static List<Map<String,Object>> iQueryForMapList(Object... items)

iUpdate

public static int iUpdate(Object... items)

iInsert

public static <T> T iInsert(Object... items)

iExecute

public static <T> T iExecute(Object... items)

iQueryForEntityList

public static <T> List<T> iQueryForEntityList(Object... items)

nQuery

public static <T> T nQuery(Connection conn,
                           org.apache.commons.dbutils.ResultSetHandler<T> rsh,
                           String sql,
                           Object... items)

nQueryForObject

public static <T> T nQueryForObject(Connection conn,
                                    String sql,
                                    Object... items)

nQueryForString

public static String nQueryForString(Connection conn,
                                     String sql,
                                     Object... items)

nQueryForLongValue

public static long nQueryForLongValue(Connection conn,
                                      String sql,
                                      Object... items)

nQueryForMapList

public static List<Map<String,Object>> nQueryForMapList(Connection conn,
                                                        String sql,
                                                        Object... items)

nUpdate

public static int nUpdate(Connection conn,
                          String sql,
                          Object... items)

nInsert

public static <T> T nInsert(Connection conn,
                            org.apache.commons.dbutils.ResultSetHandler<T> rsh,
                            String sql,
                            Object... items)

nExecute

public static int nExecute(Connection conn,
                           String sql,
                           Object... items)

nExecute

public static <T> List<T> nExecute(Connection conn,
                                   org.apache.commons.dbutils.ResultSetHandler<T> rsh,
                                   String sql,
                                   Object... items)

nQuery

public static <T> T nQuery(org.apache.commons.dbutils.ResultSetHandler<T> rsh,
                           String sql,
                           Object... items)

nQueryForObject

public static <T> T nQueryForObject(String sql,
                                    Object... items)

nQueryForString

public static String nQueryForString(String sql,
                                     Object... items)

nQueryForLongValue

public static long nQueryForLongValue(String sql,
                                      Object... items)

nQueryForMapList

public static List<Map<String,Object>> nQueryForMapList(String sql,
                                                        Object... items)

nUpdate

public static int nUpdate(String sql,
                          Object... items)

nInsert

public static <T> T nInsert(org.apache.commons.dbutils.ResultSetHandler rsh,
                            String sql,
                            Object... items)

nExecute

public static int nExecute(String sql,
                           Object... items)

nExecute

public static <T> List<T> nExecute(org.apache.commons.dbutils.ResultSetHandler rsh,
                                   String sql,
                                   Object... items)

tQuery

public static <T> T tQuery(Object... items)

tQueryForObject

public static <T> T tQueryForObject(Object... items)

tQueryForLongValue

public static long tQueryForLongValue(Object... items)

tQueryForString

public static String tQueryForString(Object... items)

tQueryForMapList

public static List<Map<String,Object>> tQueryForMapList(Object... items)

tUpdate

public static int tUpdate(Object... items)

tInsert

public static <T> T tInsert(Object... items)

tExecute

public static <T> T tExecute(Object... items)

tQueryForEntityList

public static <T> List<T> tQueryForEntityList(Class<T> entityClass,
                                              Object... items)