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 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
protected void	entity_series_methods_from_SqlBoxContext_____________________()
static EntityNet	entityAutoNet(Class<?>... entityClass)
static int	entityCountAll(Class<?> entityClass, Object... optionItems)
static void	entityDelete(Object entity, Object... optionItems)
static void	entityDeleteById(Class<?> entityClass, Object id, Object... optionItems)
static int	entityDeleteByIdTry(Class<?> entityClass, Object id, Object... optionItems)
static int	entityDeleteTry(Object entity, Object... optionItems)
static boolean	entityExist(Object entity, Object... optionItems)
static boolean	entityExistById(Class<?> entityClass, Object id, Object... optionItems)
static <T> List<T>	entityFindAll(Class<T> entityClass, Object... optionItems)
static <T> List<T>	entityFindByIds(Class<T> entityClass, Iterable<?> ids, Object... optionItems)
static <T> List<T>	entityFindBySample(Object sampleBean, Object... optionItems)
static <T> List<T>	entityFindBySQL(Object... optionItems)
static <E> List<E>	entityFindRelatedList(Object entityOrIterable, Object... sqlItems)
static <E> Map<Object,E>	entityFindRelatedMap(Object entity, Object... sqlItems)
static <E> E	entityFindRelatedOne(Object entity, Object... sqlItems)
static <E> Set<E>	entityFindRelatedSet(Object entity, Object... sqlItems)
static <T> T	entityInsert(T entity, Object... optionItems)
static <T> T	entityLoad(T entity, Object... optionItems)
static <T> T	entityLoadById(Class<T> entityClass, Object entityId, Object... optionItems)
static <T> T	entityLoadByIdTry(Class<T> entityClass, Object entityId, Object... optionItems)
static int	entityLoadTry(Object entity, Object... optionItems)
static <T> T	entityUpdate(Object entity, Object... optionItems)
static int	entityUpdateTry(Object entity, Object... optionItems)
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... inlineSQL)
static <T> T	iInsert(Object... inlineSQL)
static <T> T	iQuery(Object... inlineSQL)
static <T> List<T>	iQueryForEntityList(Class<T> entityClass, Object... inlineSQL)
static <T> List<T>	iQueryForEntityList(Object... optionItems)
static long	iQueryForLongValue(Object... inlineSQL)
static List<Map<String,Object>>	iQueryForMapList(Object... items)
static <T> T	iQueryForObject(Object... inlineSQL)
static String	iQueryForString(Object... inlineSQL)
static int	iUpdate(Object... inlineSQL)
static <T> List<T>	nExecute(Connection conn, org.apache.commons.dbutils.ResultSetHandler<T> rsh, String sql, Object... params)
static int	nExecute(Connection conn, String sql, Object... params)
static <T> List<T>	nExecute(org.apache.commons.dbutils.ResultSetHandler rsh, String sql, Object... params)
static int	nExecute(String sql, Object... params)
static <T> T	nInsert(Connection conn, org.apache.commons.dbutils.ResultSetHandler<T> rsh, String sql, Object... params)
static <T> T	nInsert(org.apache.commons.dbutils.ResultSetHandler rsh, String sql, Object... params)
static SqlItem	noPagin() Disable PaginHandler
static <T> T	nQuery(Connection conn, org.apache.commons.dbutils.ResultSetHandler<T> rsh, String sql, Object... params)
static <T> T	nQuery(org.apache.commons.dbutils.ResultSetHandler<T> rsh, String sql, Object... params)
static long	nQueryForLongValue(Connection conn, String sql, Object... params)
static long	nQueryForLongValue(String sql, Object... params)
static List<Map<String,Object>>	nQueryForMapList(Connection conn, String sql, Object... params)
static List<Map<String,Object>>	nQueryForMapList(String sql, Object... params)
static <T> T	nQueryForObject(Connection conn, String sql, Object... params)
static <T> T	nQueryForObject(String sql, Object... params)
static String	nQueryForString(Connection conn, String sql, Object... params)
static String	nQueryForString(String sql, Object... params)
static int	nUpdate(Connection conn, String sql, Object... params)
static int	nUpdate(String sql, Object... params)
static PaginHandler	pagin(int pageNumber, int pageSize) Build a PaginHandler handler
static <T> T	pExecute(Object... inlineSQL)
static <T> T	pInsert(Object... inlineSQL)
protected void	pint_series_methods_from_DbPro_____________________()
static <T> T	pQuery(Object... inlineSQL)
static <T> List<T>	pQueryForEntityList(Class<T> entityClass, Object... inlineSQL)
static <T> List<T>	pQueryForEntityList(Object... optionItems)
static long	pQueryForLongValue(Object... inlineSQL)
static List<Map<String,Object>>	pQueryForMapList(Object... items)
static <T> T	pQueryForObject(Object... inlineSQL)
static String	pQueryForString(Object... inlineSQL)
static int	pUpdate(Object... inlineSQL)
static SqlItem	shardDB(Object... shardvalues) Build a SHARD_DATABASE type sqlItem
static SqlItem	shardTB(Object... shardvalues) Build a SHARD_TABLE type sqlItem
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... inlineSQL)
static <T> List<T>	tQueryForEntityList(Object... optionItems)
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, ioc, notNull, PARA, PARA0, param, PARAMS, 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

Constructor Detail

JSQLBOX

public JSQLBOX()

Method Detail

gctx

public static SqlBoxContext gctx()

Shortcut method equal to SqlBoxContext.getGlobalSqlBoxContext()

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

entity_series_methods_from_SqlBoxContext_____________________

protected void entity_series_methods_from_SqlBoxContext_____________________()

iQueryForEntityList

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

pQueryForEntityList

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

tQueryForEntityList

public static <T> List<T> tQueryForEntityList(Object... optionItems)

entityInsert

public static <T> T entityInsert(T entity,
                                 Object... optionItems)

entityUpdate

public static <T> T entityUpdate(Object entity,
                                 Object... optionItems)

entityUpdateTry

public static int entityUpdateTry(Object entity,
                                  Object... optionItems)

entityDelete

public static void entityDelete(Object entity,
                                Object... optionItems)

entityDeleteTry

public static int entityDeleteTry(Object entity,
                                  Object... optionItems)

entityDeleteById

public static void entityDeleteById(Class<?> entityClass,
                                    Object id,
                                    Object... optionItems)

entityDeleteByIdTry

public static int entityDeleteByIdTry(Class<?> entityClass,
                                      Object id,
                                      Object... optionItems)

entityExist

public static boolean entityExist(Object entity,
                                  Object... optionItems)

entityExistById

public static boolean entityExistById(Class<?> entityClass,
                                      Object id,
                                      Object... optionItems)

entityCountAll

public static int entityCountAll(Class<?> entityClass,
                                 Object... optionItems)

entityLoad

public static <T> T entityLoad(T entity,
                               Object... optionItems)

entityLoadTry

public static int entityLoadTry(Object entity,
                                Object... optionItems)

entityLoadById

public static <T> T entityLoadById(Class<T> entityClass,
                                   Object entityId,
                                   Object... optionItems)

entityLoadByIdTry

public static <T> T entityLoadByIdTry(Class<T> entityClass,
                                      Object entityId,
                                      Object... optionItems)

entityFindAll

public static <T> List<T> entityFindAll(Class<T> entityClass,
                                        Object... optionItems)

entityFindByIds

public static <T> List<T> entityFindByIds(Class<T> entityClass,
                                          Iterable<?> ids,
                                          Object... optionItems)

entityFindBySQL

public static <T> List<T> entityFindBySQL(Object... optionItems)

entityFindBySample

public static <T> List<T> entityFindBySample(Object sampleBean,
                                             Object... optionItems)

entityAutoNet

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

entityFindRelatedOne

public static <E> E entityFindRelatedOne(Object entity,
                                         Object... sqlItems)

entityFindRelatedList

public static <E> List<E> entityFindRelatedList(Object entityOrIterable,
                                                Object... sqlItems)

entityFindRelatedSet

public static <E> Set<E> entityFindRelatedSet(Object entity,
                                              Object... sqlItems)

entityFindRelatedMap

public static <E> Map<Object,E> entityFindRelatedMap(Object entity,
                                                     Object... sqlItems)

pint_series_methods_from_DbPro_____________________

protected void pint_series_methods_from_DbPro_____________________()

iQuery

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

iQueryForObject

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

iQueryForLongValue

public static long iQueryForLongValue(Object... inlineSQL)

iQueryForString

public static String iQueryForString(Object... inlineSQL)

iQueryForMapList

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

iUpdate

public static int iUpdate(Object... inlineSQL)

iInsert

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

iExecute

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

iQueryForEntityList

public static <T> List<T> iQueryForEntityList(Class<T> entityClass,
                                              Object... inlineSQL)

pQuery

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

pQueryForObject

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

pQueryForLongValue

public static long pQueryForLongValue(Object... inlineSQL)

pQueryForString

public static String pQueryForString(Object... inlineSQL)

pQueryForMapList

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

pUpdate

public static int pUpdate(Object... inlineSQL)

pInsert

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

pExecute

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

pQueryForEntityList

public static <T> List<T> pQueryForEntityList(Class<T> entityClass,
                                              Object... inlineSQL)

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... inlineSQL)

nQuery

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

nQueryForObject

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

nQueryForString

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

nQueryForLongValue

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

nQueryForMapList

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

nUpdate

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

nInsert

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

nExecute

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

nExecute

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

nQuery

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

nQueryForObject

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

nQueryForString

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

nQueryForLongValue

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

nQueryForMapList

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

nUpdate

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

nInsert

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

nExecute

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

nExecute

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