org.beetl.sql.core

类 SQLScript

java.lang.Object

org.beetl.sql.core.SQLScript

public class SQLScript
extends Object

构造器概要

构造器

构造器和说明
SQLScript(SQLSource sqlSource, SQLManager sm)

方法概要

限定符和类型	方法和说明
protected List	checkAnnotatonAfterSelect(Class target, List entitys, SQLResult sqlResult)
protected void	checkAnnotatonBeforeSelect(Class target, Map<String,Object> paras) 检查目标类是否有申明ormquery,如果有，改写result.mapingEntrys
protected void	clean(boolean isUpdate, Connection conn, PreparedStatement ps)
protected void	clean(boolean isUpdate, Connection conn, PreparedStatement ps, ResultSet rs)
protected void	clean(Connection conn)
int	deleteById(Class<?> clazz, Object objId)
boolean	existById(Class clazz, Object objId)
String	getId()
List<SQLResultListener>	getListener()
String	getSql()
int	insert(Object paras)
int	insert(Object paras, KeyHolder holder)
int[]	insertBatch(List<?> list, LinkedList keys, boolean autoDbAssignKey)
int	insertBySqlId(Map map, KeyHolder holder, String keyName)
<T> List<T>	mappingSelect(ResultSet rs, Class<T> clazz)
protected SQLResult	run(Map<String,Object> paras)
protected SQLResult	run(Map<String,Object> paras, org.beetl.core.Context ctx)
<T> List<T>	select(Class<T> clazz, Map<String,Object> paras)
<T> List<T>	select(Class<T> clazz, Map<String,Object> paras, RowMapper<T> mapper)
<T> List<T>	select(Class<T> clazz, Object paras)
<T> List<T>	select(Map<String,Object> paras, Class<T> mapping, RowMapper<T> mapper, long start, long size)
<T> List<T>	select(Object paras, Class<T> mapping, RowMapper<T> mapper, long start, long end)
long	selectCount(Map<String,Object> paras)
long	selectCount(Object paras)
<T> T	selectSingle(Map<String,Object> map, Class<T> target)
<T> T	selectUnique(Map<String,Object> map, Class<T> target)
void	setListener(List<SQLResultListener> listener)
<T> T	single(Class<T> clazz, RowMapper<T> mapper, Object objId)
<T> T	single(Class<T> clazz, RowMapper<T> mapper, Object objId, boolean throwException)
<T> T	singleSelect(Object paras, Class<T> target)
int[]	sqlReadyBatchExecuteUpdate(SQLBatchReady batch)
int	sqlReadyExecuteUpdate(SQLReady p)
<T> List<T>	sqlReadySelect(Class<T> clazz, SQLReady p)
<T> T	unique(Class<T> clazz, RowMapper<T> mapper, Object objId)
int	update(Map<String,Object> paras)
int	update(Object obj)
int[]	updateBatch(List<?> list)
int[]	updateBatch(Map<String,Object>[] maps)

从类继承的方法 java.lang.Object

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

构造器详细资料

SQLScript

public SQLScript(SQLSource sqlSource,
                 SQLManager sm)

方法详细资料

run

protected SQLResult run(Map<String,Object> paras)

run

protected SQLResult run(Map<String,Object> paras,
                        org.beetl.core.Context ctx)

checkAnnotatonBeforeSelect

protected void checkAnnotatonBeforeSelect(Class target,
                                          Map<String,Object> paras)

检查目标类是否有申明ormquery,如果有，改写result.mapingEntrys

参数:

target -

checkAnnotatonAfterSelect

protected List checkAnnotatonAfterSelect(Class target,
                                         List entitys,
                                         SQLResult sqlResult)

insert

public int insert(Object paras)

insert

public int insert(Object paras,
                  KeyHolder holder)

insertBySqlId

public int insertBySqlId(Map map,
                         KeyHolder holder,
                         String keyName)

singleSelect

public <T> T singleSelect(Object paras,
                          Class<T> target)

selectSingle

public <T> T selectSingle(Map<String,Object> map,
                          Class<T> target)

selectUnique

public <T> T selectUnique(Map<String,Object> map,
                          Class<T> target)

select

public <T> List<T> select(Class<T> clazz,
                          Object paras)

select

public <T> List<T> select(Class<T> clazz,
                          Map<String,Object> paras,
                          RowMapper<T> mapper)

select

public <T> List<T> select(Class<T> clazz,
                          Map<String,Object> paras)

mappingSelect

public <T> List<T> mappingSelect(ResultSet rs,
                                 Class<T> clazz)
                          throws SQLException

抛出:

SQLException

select

public <T> List<T> select(Map<String,Object> paras,
                          Class<T> mapping,
                          RowMapper<T> mapper,
                          long start,
                          long size)

select

public <T> List<T> select(Object paras,
                          Class<T> mapping,
                          RowMapper<T> mapper,
                          long start,
                          long end)

selectCount

public long selectCount(Object paras)

selectCount

public long selectCount(Map<String,Object> paras)

update

public int update(Map<String,Object> paras)

update

public int update(Object obj)

updateBatch

public int[] updateBatch(Map<String,Object>[] maps)

insertBatch

public int[] insertBatch(List<?> list,
                         LinkedList keys,
                         boolean autoDbAssignKey)

updateBatch

public int[] updateBatch(List<?> list)

unique

public <T> T unique(Class<T> clazz,
                    RowMapper<T> mapper,
                    Object objId)

single

public <T> T single(Class<T> clazz,
                    RowMapper<T> mapper,
                    Object objId)

existById

public boolean existById(Class clazz,
                         Object objId)

single

public <T> T single(Class<T> clazz,
                    RowMapper<T> mapper,
                    Object objId,
                    boolean throwException)

deleteById

public int deleteById(Class<?> clazz,
                      Object objId)

sqlReadySelect

public <T> List<T> sqlReadySelect(Class<T> clazz,
                                  SQLReady p)

sqlReadyExecuteUpdate

public int sqlReadyExecuteUpdate(SQLReady p)

sqlReadyBatchExecuteUpdate

public int[] sqlReadyBatchExecuteUpdate(SQLBatchReady batch)

clean

protected void clean(boolean isUpdate,
                     Connection conn,
                     PreparedStatement ps,
                     ResultSet rs)

clean

protected void clean(boolean isUpdate,
                     Connection conn,
                     PreparedStatement ps)

clean

protected void clean(Connection conn)

getId

public String getId()

getSql

public String getSql()

getListener

public List<SQLResultListener> getListener()

setListener

public void setListener(List<SQLResultListener> listener)