com.github.drinkjava2.jsqlbox
Class ActiveRecord<T>

java.lang.Object
  com.github.drinkjava2.jsqlbox.ActiveRecord<T>

All Implemented Interfaces:

EntityType, TailType

Direct Known Subclasses:

Tail

public class ActiveRecord<T>
extends Object
implements TailType, EntityType

Entity class extended from ActiveRecord will have CRUD methods, see below difference in jSqlBox to save ActiveRecord entity and normal entity(POJO) into database:

 ActiveRecord style:   
 
    SqlBoxContext ctx=new SqlBoxContext(dataSource);
    SqlBoxContext.setDefaultContext(ctx);           
    entity.insert(); 
 
    or 
    
    SqlBoxContext ctx=new SqlBoxContext(dataSource);
    entity.useContext(ctx);
    entity.insert();
    
    or 
    SqlBoxContext ctx=new SqlBoxContext(dataSource);
    entity.insert(ctx);
    
    
 Data Mapper style:  
 
    SqlBoxContext ctx=new SqlBoxContext(dataSource);
    ctx.eInsert(pojo);
    
    or
    
    SqlBoxContext ctx=new SqlBoxContext(dataSource);
    SqlBoxContext.setDefaultContext(ctx);           
    eInsert(pojo); //static import JSQLBOX.eInsert
    
    or 
    
    SqlBoxContext ctx1=new SqlBoxContext(dataSource);
    ctx2.insert(entity, ctx1);
 
 

Since:

1.0.0

Author:

Yong Zhu

Constructor Summary

ActiveRecord()

Method Summary

EntityNet	autoNet(Class<?>... entityClass)
int	countAll(Object... items)
protected void	crudMethods__________________()
SqlBoxContext	ctx(Object... items)
void	delete(Object... items)
void	deleteById(Object id, Object... items)
int	deleteByIdTry(Object id, Object... items)
int	deleteTry(Object... items)
int	eCountAll(Class<?> entityClass, Object... items)
void	eDelete(Object entity, Object... items)
void	eDeleteById(Class<?> entityClass, Object id, Object... items)
int	eDeleteByIdTry(Class<?> entityClass, Object id, Object... items)
int	eDeleteTry(Object entity, Object... items)
boolean	eExist(Object entity, Object... items)
boolean	eExistById(Class<?> entityClass, Object id, Object... items)
<E> List<E>	eFindAll(Class<E> entityClass, Object... items)
<E> List<E>	eFindBySample(Object sampleBean, Object... items)
<E> List<E>	eFindBySQL(Object... items)
<E> List<E>	eFindRelatedList(Object entityOrIterable, Object... items)
<E> Map<Object,E>	eFindRelatedMap(Object entity, Object... items)
<E> E	eFindRelatedOne(Object entity, Object... items)
<E> Set<E>	eFindRelatedSet(Object entity, Object... items)
<E> E	eInsert(E entity, Object... items)
<E> E	eLoad(E entity, Object... items)
<E> E	eLoadById(Class<E> entityClass, Object entityId, Object... items)
<E> E	eLoadByIdTry(Class<E> entityClass, Object entityId, Object... items)
int	eLoadTry(Object entity, Object... items)
<E> E	eUpdate(Object entity, Object... items)
int	eUpdateTry(Object entity, Object... items)
boolean	exist(Object... items)
boolean	existById(Object id, Object... items)
List<T>	findAll(Object... items)
List<T>	findBySample(Object... items)
List<T>	findBySQL(Object... items)
<E> List<E>	findRelatedList(Object... items)
<E> Map<Object,E>	findRelatedMap(Object... items)
<E> E	findRelatedOne(Object... items)
<E> Set<E>	findRelatedSet(Object... items)
T	forFields(String... fieldNames)
T	forTails(String... columnNames)
<V> V	getField(String fieldName)
<V> V	getTail(String columnName)
<E> E	iExecute(Object... items)
<E> E	iInsert(Object... items)
T	insert(Object... items)
protected static Object[]	insertThisClassIfNotHave(Object entity, Object... items) For ORM query, if self class is ignored, use this method to put entity's model class
<E> E	iQuery(Object... items)
<E> List<E>	iQueryForEntityList(Object... items)
long	iQueryForLongValue(Object... items)
List<Map<String,Object>>	iQueryForMapList(Object... items)
<E> E	iQueryForObject(Object... items)
String	iQueryForString(Object... items)
int	iUpdate(Object... items)
T	load(Object... items)
T	loadById(Object id, Object... items)
T	loadByIdTry(Object id, Object... items)
T	loadBySQL(Object... items)
int	loadTry(Object... items)
protected void	miscMethods__________________()
TableModel	model()
<E> List<E>	nExecute(Connection conn, org.apache.commons.dbutils.ResultSetHandler<E> rsh, String sql, Object... items)
int	nExecute(Connection conn, String sql, Object... items)
<E> List<E>	nExecute(org.apache.commons.dbutils.ResultSetHandler rsh, String sql, Object... items)
int	nExecute(String sql, Object... items)
<E> E	nInsert(Connection conn, org.apache.commons.dbutils.ResultSetHandler<E> rsh, String sql, Object... items)
<E> E	nInsert(org.apache.commons.dbutils.ResultSetHandler rsh, String sql, Object... items)
<E> E	nQuery(Connection conn, org.apache.commons.dbutils.ResultSetHandler<E> rsh, String sql, Object... items)
<E> E	nQuery(org.apache.commons.dbutils.ResultSetHandler<E> rsh, String sql, Object... items)
long	nQueryForLongValue(Connection conn, String sql, Object... items)
long	nQueryForLongValue(String sql, Object... items)
List<Map<String,Object>>	nQueryForMapList(Connection conn, String sql, Object... items)
List<Map<String,Object>>	nQueryForMapList(String sql, Object... items)
<E> E	nQueryForObject(Connection conn, String sql, Object... items)
<E> E	nQueryForObject(String sql, Object... items)
String	nQueryForString(Connection conn, String sql, Object... items)
String	nQueryForString(String sql, Object... items)
int	nUpdate(Connection conn, String sql, Object... items)
int	nUpdate(String sql, Object... items)
<E> E	pExecute(Object... items)
<E> E	pInsert(Object... items)
<E> E	pQuery(Object... items)
<E> List<E>	pQueryForEntityList(Object... items)
long	pQueryForLongValue(Object... items)
List<Map<String,Object>>	pQueryForMapList(Object... items)
<E> E	pQueryForObject(Object... items)
String	pQueryForString(Object... items)
int	pUpdate(Object... items)
T	putField(Object... fieldAndValues)
T	putTail(Object... columAndValues)
T	putValues(Object... values)
Object[]	shard(Object... items) Return current table and SqlBoxContext based on shard key value
SqlBoxContext	shardDB(Object... items) Return current SqlBoxContext based on shard key value
String	shardTB(Object... items) Return current table based on shard key value
Map<String,Object>	tails()
<E> E	tExecute(Object... items)
<E> E	tInsert(Object... items)
<E> E	tQuery(Object... items)
<E> List<E>	tQueryForEntityList(Class<E> entityClass, Object... items)
long	tQueryForLongValue(Object... items)
List<Map<String,Object>>	tQueryForMapList(Object... items)
<E> E	tQueryForObject(Object... items)
String	tQueryForString(Object... items)
int	tUpdate(Object... items)
T	update(Object... items)
int	updateTry(Object... items)
T	useContext(SqlBoxContext ctx)

Methods inherited from class java.lang.Object

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

Constructor Detail

ActiveRecord

public ActiveRecord()

Method Detail

miscMethods__________________

protected void miscMethods__________________()

ctx

public SqlBoxContext ctx(Object... items)

model

public TableModel model()

useContext

public T useContext(SqlBoxContext ctx)

tails

public Map<String,Object> tails()

Specified by:

tails in interface TailType

getField

public <V> V getField(String fieldName)

getTail

public <V> V getTail(String columnName)

putTail

public T putTail(Object... columAndValues)

putField

public T putField(Object... fieldAndValues)

forFields

public T forFields(String... fieldNames)

forTails

public T forTails(String... columnNames)

putValues

public T putValues(Object... values)

shardTB

public String shardTB(Object... items)

Return current table based on shard key value

shardDB

public SqlBoxContext shardDB(Object... items)

Return current SqlBoxContext based on shard key value

shard

public Object[] shard(Object... items)

Return current table and SqlBoxContext based on shard key value

insertThisClassIfNotHave

protected static Object[] insertThisClassIfNotHave(Object entity,
                                                   Object... items)

For ORM query, if self class is ignored, use this method to put entity's model class

crudMethods__________________

protected void crudMethods__________________()

insert

public T insert(Object... items)

update

public T update(Object... items)

updateTry

public int updateTry(Object... items)

delete

public void delete(Object... items)

deleteTry

public int deleteTry(Object... items)

deleteById

public void deleteById(Object id,
                       Object... items)

deleteByIdTry

public int deleteByIdTry(Object id,
                         Object... items)

exist

public boolean exist(Object... items)

existById

public boolean existById(Object id,
                         Object... items)

countAll

public int countAll(Object... items)

load

public T load(Object... items)

loadTry

public int loadTry(Object... items)

loadById

public T loadById(Object id,
                  Object... items)

loadByIdTry

public T loadByIdTry(Object id,
                     Object... items)

loadBySQL

public T loadBySQL(Object... items)

findAll

public List<T> findAll(Object... items)

findBySQL

public List<T> findBySQL(Object... items)

findBySample

public List<T> findBySample(Object... items)

autoNet

public EntityNet autoNet(Class<?>... entityClass)

findRelatedOne

public <E> E findRelatedOne(Object... items)

findRelatedList

public <E> List<E> findRelatedList(Object... items)

findRelatedSet

public <E> Set<E> findRelatedSet(Object... items)

findRelatedMap

public <E> Map<Object,E> findRelatedMap(Object... items)

eFindAll

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

eFindBySample

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

eFindBySQL

public <E> List<E> eFindBySQL(Object... items)

eInsert

public <E> E eInsert(E entity,
                     Object... items)

eLoad

public <E> E eLoad(E entity,
                   Object... items)

eLoadById

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

eLoadByIdTry

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

eUpdate

public <E> E eUpdate(Object entity,
                     Object... items)

eExist

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

eExistById

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

eCountAll

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

eDeleteByIdTry

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

eDeleteTry

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

eLoadTry

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

eUpdateTry

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

eDelete

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

eDeleteById

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

eFindRelatedOne

public <E> E eFindRelatedOne(Object entity,
                             Object... items)

eFindRelatedList

public <E> List<E> eFindRelatedList(Object entityOrIterable,
                                    Object... items)

eFindRelatedSet

public <E> Set<E> eFindRelatedSet(Object entity,
                                  Object... items)

eFindRelatedMap

public <E> Map<Object,E> eFindRelatedMap(Object entity,
                                         Object... items)

pQuery

public <E> E pQuery(Object... items)

pQueryForObject

public <E> E pQueryForObject(Object... items)

pQueryForLongValue

public long pQueryForLongValue(Object... items)

pQueryForString

public String pQueryForString(Object... items)

pQueryForMapList

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

pUpdate

public int pUpdate(Object... items)

pInsert

public <E> E pInsert(Object... items)

pExecute

public <E> E pExecute(Object... items)

pQueryForEntityList

public <E> List<E> pQueryForEntityList(Object... items)

iQuery

public <E> E iQuery(Object... items)

iQueryForObject

public <E> E iQueryForObject(Object... items)

iQueryForLongValue

public long iQueryForLongValue(Object... items)

iQueryForString

public String iQueryForString(Object... items)

iQueryForMapList

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

iUpdate

public int iUpdate(Object... items)

iInsert

public <E> E iInsert(Object... items)

iExecute

public <E> E iExecute(Object... items)

iQueryForEntityList

public <E> List<E> iQueryForEntityList(Object... items)

nQuery

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

nQueryForObject

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

nQueryForString

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

nQueryForLongValue

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

nQueryForMapList

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

nUpdate

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

nInsert

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

nExecute

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

nExecute

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

nQuery

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

nQueryForObject

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

nQueryForString

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

nQueryForLongValue

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

nQueryForMapList

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

nUpdate

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

nInsert

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

nExecute

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

nExecute

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

tQuery

public <E> E tQuery(Object... items)

tQueryForObject

public <E> E tQueryForObject(Object... items)

tQueryForLongValue

public long tQueryForLongValue(Object... items)

tQueryForString

public String tQueryForString(Object... items)

tQueryForMapList

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

tUpdate

public int tUpdate(Object... items)

tInsert

public <E> E tInsert(Object... items)

tExecute

public <E> E tExecute(Object... items)

tQueryForEntityList

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