public class SqlExecutor extends Object
| Constructor and Description |
|---|
SqlExecutor(DbConfig config,
Connection conn)
构造
|
| Modifier and Type | Method and Description |
|---|---|
boolean |
call(String sql,
Object... params)
执行调用存储过程
此方法不会关闭Connection |
ResultSet |
callQuery(String sql,
Object... params)
执行调用存储过程
此方法不会关闭Connection |
int |
execute(String sql,
Map<String,Object> paramMap)
执行非查询语句
语句包括 插入、更新、删除 此方法不会关闭Connection |
int |
execute(String sql,
Object... params)
执行非查询语句
语句包括 插入、更新、删除 此方法不会关闭Connection |
int[] |
executeBatch(Iterable<String> sqls)
批量执行非查询语句
语句包括 插入、更新、删除 此方法不会关闭Connection |
int[] |
executeBatch(String... sqls)
批量执行非查询语句
语句包括 插入、更新、删除 此方法不会关闭Connection |
int[] |
executeBatch(String sql,
Iterable<Object[]> paramsBatch)
批量执行非查询语句
语句包括 插入、更新、删除 此方法不会关闭Connection |
Long |
executeForGeneratedKey(String sql,
Map<String,Object> paramMap)
执行非查询语句，返回主键
发查询语句包括 插入、更新、删除 此方法不会关闭Connection |
Long |
executeForGeneratedKey(String sql,
Object... params)
执行非查询语句，返回主键
发查询语句包括 插入、更新、删除 此方法不会关闭Connection |
static SqlExecutor |
of(DbConfig config,
Connection conn)
创建SqlExecutor
|
<T> T |
query(SerFunction<Connection,PreparedStatement> statementFunc,
RsHandler<T> rsh)
|
<T> T |
query(SqlBuilder sqlBuilder,
RsHandler<T> rsh)
执行查询语句
此方法不会关闭Connection |
<T> T |
query(String sql,
RsHandler<T> rsh,
Map<String,Object> paramMap)
执行查询语句，例如：select * from table where field1=:name1
此方法不会关闭Connection |
<T> T |
query(String sql,
RsHandler<T> rsh,
Object... params)
执行查询语句
此方法不会关闭Connection |
public SqlExecutor(DbConfig config, Connection conn)
config - 配置conn - Connectionpublic static SqlExecutor of(DbConfig config, Connection conn)
config - 配置conn - Connectionpublic int execute(String sql, Map<String,Object> paramMap) throws DbException
sql - SQL，使用name做为占位符，例如:nameparamMap - 参数MapDbException - SQL执行异常public int execute(String sql, Object... params) throws DbException
sql - SQLparams - 参数DbException - SQL执行异常public boolean call(String sql, Object... params) throws DbException
sql - SQLparams - 参数DbException - SQL执行异常public ResultSet callQuery(String sql, Object... params) throws DbException
sql - SQLparams - 参数DbException - SQL执行异常public Long executeForGeneratedKey(String sql, Map<String,Object> paramMap) throws DbException
sql - SQLparamMap - 参数MapDbException - SQL执行异常public Long executeForGeneratedKey(String sql, Object... params) throws DbException
sql - SQLparams - 参数DbException - SQL执行异常public int[] executeBatch(String sql, Iterable<Object[]> paramsBatch) throws DbException
sql - SQLparamsBatch - 批量的参数DbException - SQL执行异常public int[] executeBatch(String... sqls) throws DbException
sqls - SQL列表DbException - SQL执行异常public int[] executeBatch(Iterable<String> sqls) throws DbException
sqls - SQL列表DbException - SQL执行异常public <T> T query(String sql, RsHandler<T> rsh, Map<String,Object> paramMap) throws DbException
T - 处理结果类型sql - 查询语句，使用参数名占位符，例如:namersh - 结果集处理对象paramMap - 参数对DbException - SQL执行异常public <T> T query(SqlBuilder sqlBuilder, RsHandler<T> rsh) throws DbException
T - 处理结果类型sqlBuilder - SQL构建器，包含参数rsh - 结果集处理对象DbException - SQL执行异常public <T> T query(String sql, RsHandler<T> rsh, Object... params) throws DbException
T - 处理结果类型sql - 查询语句rsh - 结果集处理对象params - 参数DbException - SQL执行异常public <T> T query(SerFunction<Connection,PreparedStatement> statementFunc, RsHandler<T> rsh) throws DbException
T - 处理结果类型statementFunc - 自定义PreparedStatement创建函数rsh - 自定义结果集处理DbException - SQL执行异常Copyright © 2025. All rights reserved.