程序包 org.ssssssss.magicapi.modules.db

类 SQLModule

java.lang.Object

org.ssssssss.magicapi.modules.db.SQLModule

所有已实现的接口:

DynamicModule<SQLModule>, org.ssssssss.script.functions.DynamicAttribute<SQLModule,SQLModule>

@MagicModule("db")
public class SQLModule
extends Object
implements org.ssssssss.script.functions.DynamicAttribute<SQLModule,SQLModule>, DynamicModule<SQLModule>

数据库查询模块

作者:

mxd

嵌套类概要

嵌套类

修饰符和类型	类	说明
(专用程序包) static class	SQLModule.MagicKeyHolder

字段概要

字段

修饰符和类型	字段	说明
private String	cacheName
private ColumnMapperAdapter	columnMapperAdapter
private org.springframework.jdbc.core.RowMapper<Map<String,Object>>	columnMapRowMapper
private MagicDynamicDataSource.DataSourceNode	dataSourceNode
private DialectAdapter	dialectAdapter
private MagicDynamicDataSource	dynamicDataSource
private String	logicDeleteColumn
private String	logicDeleteValue
private List<NamedTableInterceptor>	namedTableInterceptors
private PageProvider	pageProvider
private ResultProvider	resultProvider
private Function<String,String>	rowMapColumnMapper
private SqlCache	sqlCache
private List<SQLInterceptor>	sqlInterceptors
private long	ttl

构造器概要

构造器

构造器	说明
SQLModule()
SQLModule(MagicDynamicDataSource dynamicDataSource)

方法概要

修饰符和类型	方法	说明
private void	assertDatasourceNotNull()
int	batchUpdate(String sql, int batchSize, List<Object[]> args)	插入并返回主键
int	batchUpdate(String sql, List<Object[]> args)	插入并返回主键
int	batchUpdate(List<String> sqls)	插入并返回主键
private BoundSql	buildPageBoundSql(Dialect dialect, BoundSql boundSql, long offset, long limit)
SQLModule	cache(String cacheName)	使用缓存（采用默认缓存时间）
SQLModule	cache(String cacheName, long ttl)	使用缓存
SQLModule	camel()
SQLModule	cloneSQLModule()
SQLModule	columnCase(String name)
Integer	count(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml)	查询总条目数
Integer	count(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml, Map<String,Object> params)	查询总条目数
SQLModule	deleteCache(String name)
String	getCacheName()
String	getDataSourceName()
SQLModule	getDynamicAttribute(String key)	数据源切换
SQLModule	getDynamicModule(org.ssssssss.script.MagicScriptContext context)
org.springframework.jdbc.core.JdbcTemplate	getJdbcTemplate()
String	getLogicDeleteColumn()
String	getLogicDeleteValue()
SqlCache	getSqlCache()
long	getTtl()
Object	insert(BoundSql boundSql, String primary)
(专用程序包) void	insert(BoundSql boundSql, SQLModule.MagicKeyHolder keyHolder)
Object	insert(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml)	插入并返回主键
Object	insert(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml, String primary)	插入并返回主键
Object	insert(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml, String primary, Map<String,Object> params)	插入并返回主键
Object	insert(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml, Map<String,Object> params)	插入并返回主键，并传入变量信息
SQLModule	lower()
SQLModule	normal()
private Object	page(int count, BoundSql boundSql, Page page, Dialect dialect)
Object	page(BoundSql boundSql)
Object	page(BoundSql boundSql, Page page)
Object	page(org.ssssssss.script.runtime.RuntimeContext runtimeContext, int count, String sqlOrXml, long limit, long offset, Map<String,Object> params)	分页查询（手动传入count）
Object	page(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml)	分页查询,并传入变量信息
Object	page(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml, long limit, long offset)	分页查询（手动传入limit和offset参数）
Object	page(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml, long limit, long offset, Map<String,Object> params)	分页查询（手动传入limit和offset参数）
Object	page(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String countSqlOrXml, String sqlOrXml)	分页查询（手动传入分页SQL语句）
Object	page(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String countSqlOrXml, String sqlOrXml, Map<String,Object> params)	分页查询（手动传入分页SQL语句）
Object	page(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml, Map<String,Object> params)	分页查询
SQLModule	pascal()
private List<Map<String,Object>>	queryForList(BoundSql boundSql)
List<Map<String,Object>>	select(BoundSql boundSql)
List<Map<String,Object>>	select(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml)	查询List
List<Map<String,Object>>	select(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml, Map<String,Object> params)	查询List，并传入变量信息
Integer	selectInt(BoundSql boundSql)
Integer	selectInt(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml)	查询int值
Integer	selectInt(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml, Map<String,Object> params)	查询int值
Map<String,Object>	selectOne(BoundSql boundSql)
Map<String,Object>	selectOne(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml)	查询Map
Map<String,Object>	selectOne(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml, Map<String,Object> params)	查询Map,并传入变量信息
Object	selectValue(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml)	查询单行单列的值
Object	selectValue(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml, Map<String,Object> params)	查询单行单列的值，并传入变量信息
void	setCacheName(String cacheName)
void	setColumnMapperProvider(ColumnMapperAdapter columnMapperAdapter)
void	setColumnMapRowMapper(org.springframework.jdbc.core.RowMapper<Map<String,Object>> columnMapRowMapper)
void	setDataSourceNode(MagicDynamicDataSource.DataSourceNode dataSourceNode)
void	setDialectAdapter(DialectAdapter dialectAdapter)
void	setDynamicDataSource(MagicDynamicDataSource dynamicDataSource)
void	setLogicDeleteColumn(String logicDeleteColumn)
void	setLogicDeleteValue(String logicDeleteValue)
void	setNamedTableInterceptors(List<NamedTableInterceptor> namedTableInterceptors)
void	setPageProvider(PageProvider pageProvider)
void	setResultProvider(ResultProvider resultProvider)
void	setRowMapColumnMapper(Function<String,String> rowMapColumnMapper)
void	setSqlCache(SqlCache sqlCache)
void	setSqlInterceptors(List<SQLInterceptor> sqlInterceptors)
void	setTtl(long ttl)
NamedTable	table(String tableName)
Transaction	transaction()	开启事务，手动提交和回滚
Object	transaction(Function<?,?> function)	开启事务，在一个回调中进行操作
int	update(BoundSql boundSql)
int	update(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml)	执行update
int	update(org.ssssssss.script.runtime.RuntimeContext runtimeContext, String sqlOrXml, Map<String,Object> params)	执行update，并传入变量信息
SQLModule	upper()

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

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

从接口继承的方法 org.ssssssss.script.functions.DynamicAttribute

setDynamicAttribute

字段详细资料

dynamicDataSource

private MagicDynamicDataSource dynamicDataSource

dataSourceNode

private MagicDynamicDataSource.DataSourceNode dataSourceNode

pageProvider

private PageProvider pageProvider

resultProvider

private ResultProvider resultProvider

columnMapperAdapter

private ColumnMapperAdapter columnMapperAdapter

dialectAdapter

private DialectAdapter dialectAdapter

columnMapRowMapper

private org.springframework.jdbc.core.RowMapper<Map<String,Object>> columnMapRowMapper

rowMapColumnMapper

private Function<String,String> rowMapColumnMapper

sqlCache

private SqlCache sqlCache

cacheName

private String cacheName

sqlInterceptors

private List<SQLInterceptor> sqlInterceptors

namedTableInterceptors

private List<NamedTableInterceptor> namedTableInterceptors

ttl

private long ttl

logicDeleteColumn

private String logicDeleteColumn

logicDeleteValue

private String logicDeleteValue

构造器详细资料

SQLModule

public SQLModule()

SQLModule

public SQLModule(MagicDynamicDataSource dynamicDataSource)

方法详细资料

setPageProvider

public void setPageProvider(PageProvider pageProvider)

setResultProvider

public void setResultProvider(ResultProvider resultProvider)

setColumnMapperProvider

public void setColumnMapperProvider(ColumnMapperAdapter columnMapperAdapter)

setDialectAdapter

public void setDialectAdapter(DialectAdapter dialectAdapter)

setColumnMapRowMapper

public void setColumnMapRowMapper(org.springframework.jdbc.core.RowMapper<Map<String,Object>> columnMapRowMapper)

setRowMapColumnMapper

public void setRowMapColumnMapper(Function<String,String> rowMapColumnMapper)

setDynamicDataSource

public void setDynamicDataSource(MagicDynamicDataSource dynamicDataSource)

setSqlInterceptors

public void setSqlInterceptors(List<SQLInterceptor> sqlInterceptors)

setNamedTableInterceptors

public void setNamedTableInterceptors(List<NamedTableInterceptor> namedTableInterceptors)

setDataSourceNode

public void setDataSourceNode(MagicDynamicDataSource.DataSourceNode dataSourceNode)

getCacheName

public String getCacheName()

setCacheName

public void setCacheName(String cacheName)

getTtl

public long getTtl()

setTtl

public void setTtl(long ttl)

getLogicDeleteColumn

public String getLogicDeleteColumn()

setLogicDeleteColumn

public void setLogicDeleteColumn(String logicDeleteColumn)

getLogicDeleteValue

public String getLogicDeleteValue()

setLogicDeleteValue

public void setLogicDeleteValue(String logicDeleteValue)

getSqlCache

public SqlCache getSqlCache()

setSqlCache

public void setSqlCache(SqlCache sqlCache)

cloneSQLModule

public SQLModule cloneSQLModule()

transaction

@Comment("\u5f00\u542f\u4e8b\u52a1\uff0c\u5e76\u5728\u56de\u8c03\u4e2d\u5904\u7406")
public Object transaction(@Comment(name="function",value="\u56de\u8c03\u51fd\u6570\uff0c\u5982\uff1a()=>{....}")
 Function<?,?> function)

开启事务，在一个回调中进行操作

参数:

function - 回调函数

transaction

@Comment("\u5f00\u542f\u4e8b\u52a1\uff0c\u8fd4\u56de\u4e8b\u52a1\u5bf9\u8c61")
public Transaction transaction()

开启事务，手动提交和回滚

cache

@Comment("\u4f7f\u7528\u7f13\u5b58")
public SQLModule cache(@Comment(name="cacheName",value="\u7f13\u5b58\u540d")
 String cacheName,
 @Comment(name="ttl",value="\u8fc7\u671f\u65f6\u95f4")
 long ttl)

使用缓存

参数:

cacheName - 缓存名

ttl - 过期时间

cache

@Comment("\u4f7f\u7528\u7f13\u5b58\uff0c\u8fc7\u671f\u65f6\u95f4\u91c7\u7528\u9ed8\u8ba4\u914d\u7f6e")
public SQLModule cache(@Comment(name="cacheName",value="\u7f13\u5b58\u540d")
 String cacheName)

使用缓存（采用默认缓存时间）

参数:

cacheName - 缓冲名

camel

@Comment("\u91c7\u7528\u9a7c\u5cf0\u5217\u540d")
public SQLModule camel()

pascal

@Comment("\u91c7\u7528\u5e15\u65af\u5361\u5217\u540d")
public SQLModule pascal()

lower

@Comment("\u91c7\u7528\u5168\u5c0f\u5199\u5217\u540d")
public SQLModule lower()

upper

@Comment("\u91c7\u7528\u5168\u5927\u5199\u5217\u540d")
public SQLModule upper()

normal

@Comment("\u5217\u540d\u4fdd\u6301\u539f\u6837")
public SQLModule normal()

columnCase

@Comment("\u6307\u5b9a\u5217\u540d\u8f6c\u6362")
public SQLModule columnCase(String name)

getDynamicAttribute

public SQLModule getDynamicAttribute(String key)

数据源切换

指定者:

getDynamicAttribute 在接口中 org.ssssssss.script.functions.DynamicAttribute<SQLModule,SQLModule>

select

@Comment("\u67e5\u8be2SQL\uff0c\u8fd4\u56deList\u7c7b\u578b\u7ed3\u679c")
public List<Map<String,Object>> select(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml)

查询List

select

@Comment("\u67e5\u8be2SQL\uff0c\u5e76\u4f20\u5165\u53d8\u91cf\u4fe1\u606f\uff0c\u8fd4\u56deList\u7c7b\u578b\u7ed3\u679c")
public List<Map<String,Object>> select(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml,
 @Comment(name="params",value="\u53d8\u91cf\u4fe1\u606f")
 Map<String,Object> params)

查询List，并传入变量信息

select

public List<Map<String,Object>> select(BoundSql boundSql)

queryForList

private List<Map<String,Object>> queryForList(BoundSql boundSql)

assertDatasourceNotNull

private void assertDatasourceNotNull()

update

@Comment("\u6267\u884cupdate\u64cd\u4f5c\uff0c\u8fd4\u56de\u53d7\u5f71\u54cd\u884c\u6570")
public int update(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml)

执行update

update

@Comment("\u6267\u884cupdate\u64cd\u4f5c\uff0c\u5e76\u4f20\u5165\u53d8\u91cf\u4fe1\u606f\uff0c\u8fd4\u56de\u53d7\u5f71\u54cd\u884c\u6570")
public int update(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml,
 @Comment(name="params",value="\u53d8\u91cf\u4fe1\u606f")
 Map<String,Object> params)

执行update，并传入变量信息

update

public int update(BoundSql boundSql)

insert

@Comment("\u6267\u884cinsert\u64cd\u4f5c\uff0c\u8fd4\u56de\u63d2\u5165\u4e3b\u952e")
public Object insert(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml)

插入并返回主键

insert

@Comment("\u6267\u884cinsert\u64cd\u4f5c\uff0c\u5e76\u4f20\u5165\u53d8\u91cf\u4fe1\u606f\uff0c\u8fd4\u56de\u63d2\u5165\u4e3b\u952e")
public Object insert(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml,
 @Comment(name="params",value="\u53d8\u91cf\u4fe1\u606f")
 Map<String,Object> params)

插入并返回主键，并传入变量信息

insert

@Comment("\u6267\u884cinsert\u64cd\u4f5c\uff0c\u8fd4\u56de\u63d2\u5165\u4e3b\u952e")
public Object insert(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml,
 @Comment(name="primary",value="\u4e3b\u952e\u5217")
 String primary)

插入并返回主键

insert

@Comment("\u6267\u884cinsert\u64cd\u4f5c\uff0c\u5e76\u4f20\u5165\u4e3b\u952e\u548c\u53d8\u91cf\u4fe1\u606f\uff0c\u8fd4\u56de\u63d2\u5165\u4e3b\u952e")
public Object insert(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml,
 @Comment(name="primary",value="\u4e3b\u952e\u5217")
 String primary,
 @Comment(name="params",value="\u53d8\u91cf\u4fe1\u606f")
 Map<String,Object> params)

插入并返回主键

insert

void insert(BoundSql boundSql,
 SQLModule.MagicKeyHolder keyHolder)

batchUpdate

@Comment("\u6279\u91cf\u6267\u884c\u64cd\u4f5c\uff0c\u8fd4\u56de\u53d7\u5f71\u54cd\u7684\u884c\u6570")
public int batchUpdate(String sql,
 List<Object[]> args)

插入并返回主键

getJdbcTemplate

public org.springframework.jdbc.core.JdbcTemplate getJdbcTemplate()

deleteCache

@Comment("\u5220\u9664`SQL`\u7f13\u5b58")
public SQLModule deleteCache(@Comment("\u7f13\u5b58\u540d\u79f0")
 String name)

batchUpdate

@Comment("\u6279\u91cf\u6267\u884c\u64cd\u4f5c\uff0c\u8fd4\u56de\u53d7\u5f71\u54cd\u7684\u884c\u6570")
public int batchUpdate(String sql,
 int batchSize,
 List<Object[]> args)

插入并返回主键

batchUpdate

@Comment("\u6279\u91cf\u6267\u884c\u64cd\u4f5c\uff0c\u8fd4\u56de\u53d7\u5f71\u54cd\u7684\u884c\u6570")
public int batchUpdate(@Comment(name="sqls",value="`SQL`\u8bed\u53e5")
 List<String> sqls)

插入并返回主键

insert

public Object insert(BoundSql boundSql,
 String primary)

page

@Comment("\u6267\u884c\u5206\u9875\u67e5\u8be2\uff0c\u5206\u9875\u6761\u4ef6\u81ea\u52a8\u83b7\u53d6")
public Object page(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml,
 @Comment(name="params",value="\u53d8\u91cf\u4fe1\u606f")
 Map<String,Object> params)

分页查询

page

@Comment("\u6267\u884c\u5206\u9875\u67e5\u8be2\uff0c\u5e76\u4f20\u5165\u53d8\u91cf\u4fe1\u606f\uff0c\u5206\u9875\u6761\u4ef6\u81ea\u52a8\u83b7\u53d6")
public Object page(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml)

分页查询,并传入变量信息

page

@Comment("\u6267\u884c\u5206\u9875\u67e5\u8be2\uff0c\u5206\u9875\u6761\u4ef6\u624b\u52a8\u4f20\u5165")
public Object page(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml,
 @Comment(name="limit",value="\u9650\u5236\u6761\u6570")
 long limit,
 @Comment(name="offset",value="\u8df3\u8fc7\u6761\u6570")
 long offset)

分页查询（手动传入limit和offset参数）

page

@Comment("\u6267\u884c\u5206\u9875\u67e5\u8be2\uff0c\u5e76\u4f20\u5165\u53d8\u91cf\u4fe1\u606f\uff0c\u5206\u9875\u6761\u4ef6\u624b\u52a8\u4f20\u5165")
public Object page(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml,
 @Comment(name="limit",value="\u9650\u5236\u6761\u6570")
 long limit,
 @Comment(name="offset",value="\u8df3\u8fc7\u6761\u6570")
 long offset,
 @Comment(name="params",value="\u53d8\u91cf\u4fe1\u606f")
 Map<String,Object> params)

分页查询（手动传入limit和offset参数）

page

public Object page(BoundSql boundSql)

getDataSourceName

public String getDataSourceName()

page

@Comment("\u6267\u884c\u5206\u9875\u67e5\u8be2\uff0c\u5206\u9875`SQL`\u8bed\u53e5\u624b\u52a8\u4f20\u5165")
public Object page(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="countSqlOrXml",value="count\u8bed\u53e5")
 String countSqlOrXml,
 @Comment(name="sqlOrXml",value="\u67e5\u8be2\u8bed\u53e5")
 String sqlOrXml)

分页查询（手动传入分页SQL语句）

page

@Comment("\u6267\u884c\u5206\u9875\u67e5\u8be2\uff0c\u5e76\u4f20\u5165\u53d8\u91cf\u4fe1\u606f\uff0c\u5206\u9875`SQL`countSqlOrXml")
public Object page(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="countSqlOrXml",value="count\u8bed\u53e5")
 String countSqlOrXml,
 @Comment(name="sqlOrXml",value="\u67e5\u8be2\u8bed\u53e5")
 String sqlOrXml,
 @Comment(name="params",value="\u53d8\u91cf\u4fe1\u606f")
 Map<String,Object> params)

分页查询（手动传入分页SQL语句）

page

@Comment("\u6267\u884c\u5206\u9875\u67e5\u8be2\uff0c\u5e76\u4f20\u5165\u53d8\u91cf\u4fe1\u606f\uff0c\u5206\u9875`SQL`count")
public Object page(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="count",value="\u603b\u6761\u6570")
 int count,
 @Comment(name="sqlOrXml",value="\u67e5\u8be2\u8bed\u53e5")
 String sqlOrXml,
 @Comment(name="limit",value="\u9650\u5236\u6761\u6570")
 long limit,
 @Comment(name="offset",value="\u8df3\u8fc7\u6761\u6570")
 long offset,
 @Comment(name="params",value="\u53d8\u91cf\u4fe1\u606f")
 Map<String,Object> params)

分页查询（手动传入count）

page

private Object page(int count,
 BoundSql boundSql,
 Page page,
 Dialect dialect)

page

public Object page(BoundSql boundSql,
 Page page)

count

@Comment("\u67e5\u8be2\u603b\u6761\u76ee\u6570")
public Integer count(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml)

查询总条目数

count

@Comment("\u67e5\u8be2\u603b\u6761\u76ee\u6570\uff0c\u5e76\u4f20\u5165\u53d8\u91cf\u4fe1\u606f")
public Integer count(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml,
 @Comment(name="params",value="\u53d8\u91cf\u4fe1\u606f")
 Map<String,Object> params)

查询总条目数

selectInt

@Comment("\u67e5\u8be2int\u503c\uff0c\u9002\u5408\u5355\u884c\u5355\u5217int\u7684\u7ed3\u679c")
public Integer selectInt(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml)

查询int值

selectInt

@Comment("\u67e5\u8be2int\u503c\uff0c\u5e76\u4f20\u5165\u53d8\u91cf\u4fe1\u606f\uff0c\u9002\u5408\u5355\u884c\u5355\u5217int\u7684\u7ed3\u679c")
public Integer selectInt(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml,
 @Comment(name="params",value="\u53d8\u91cf\u4fe1\u606f")
 Map<String,Object> params)

查询int值

selectInt

public Integer selectInt(BoundSql boundSql)

selectOne

@Comment("\u67e5\u8be2\u5355\u6761\u7ed3\u679c\uff0c\u67e5\u4e0d\u5230\u8fd4\u56denull")
public Map<String,Object> selectOne(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml)

查询Map

selectOne

@Comment("\u67e5\u8be2\u5355\u6761\u7ed3\u679c\uff0c\u5e76\u4f20\u5165\u53d8\u91cf\u4fe1\u606f\uff0c\u67e5\u4e0d\u5230\u8fd4\u56denull")
public Map<String,Object> selectOne(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml,
 @Comment(name="params",value="\u53d8\u91cf\u4fe1\u606f")
 Map<String,Object> params)

查询Map,并传入变量信息

selectOne

public Map<String,Object> selectOne(BoundSql boundSql)

selectValue

@Comment("\u67e5\u8be2\u5355\u884c\u5355\u5217\u7684\u503c")
public Object selectValue(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml)

查询单行单列的值

selectValue

@Comment("\u67e5\u8be2\u5355\u884c\u5355\u5217\u7684\u503c\uff0c\u5e76\u4f20\u5165\u53d8\u91cf\u4fe1\u606f")
public Object selectValue(org.ssssssss.script.runtime.RuntimeContext runtimeContext,
 @Comment(name="sqlOrXml",value="`SQL`\u8bed\u53e5\u6216`xml`")
 String sqlOrXml,
 @Comment(name="params",value="\u53d8\u91cf\u4fe1\u606f")
 Map<String,Object> params)

查询单行单列的值，并传入变量信息

table

@Comment("\u6307\u5b9atable\uff0c\u8fdb\u884c\u5355\u8868\u64cd\u4f5c")
public NamedTable table(@Comment(name="tableName",value="\u8868\u540d")
 String tableName)

buildPageBoundSql

private BoundSql buildPageBoundSql(Dialect dialect,
 BoundSql boundSql,
 long offset,
 long limit)

getDynamicModule

public SQLModule getDynamicModule(org.ssssssss.script.MagicScriptContext context)

指定者:

getDynamicModule 在接口中 DynamicModule<SQLModule>