net.sohelp.boot.admin.core.db

类 JdbcHelper

java.lang.Object

net.sohelp.boot.admin.core.db.JdbcHelper

@Component
public class JdbcHelper
extends Object

SQL数据操作

从以下版本开始:

2024/3/30 11:35

作者:

AaronFung

嵌套类概要

嵌套类

限定符和类型	类和说明
class	JdbcHelper.Table

构造器概要

构造器

构造器和说明
JdbcHelper(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate, org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate)

方法概要

限定符和类型	方法和说明
int[]	batchDelete(String sql, List params) 批量删除多条记录，针对JdbcTemplate
int[]	batchDelete(String sql, Object[] params) 批量删除多条记录，针对JdbcTemplate
int[]	batchDeleteByMap(String sql, List<Map> params) 批量删除多条记录 针对sqlSessionTemplate
int[]	batchUpdate(String sql, List<Object> params) 批量更新多条记录
int[]	batchUpdate(String sql, Object[] params) 指量更新
int[]	batchUpdateByMap(String sql, List<Map> params) 批量操作,针对jdbcTemplate
JdbcHelper	cache(String cacheName, long ttl)
void	clearTableCache() 清空数据库表字段缓存
int	delete(String sql, List params) 此接口主要针对MagicApi
int	delete(String sql, Map<String,Object> paramMap) 删除多条数据
int	delete(String sql, Object param)
int	delete(String sql, Object[] params) 删除指定记录，此接口主要针对MagicApi
JdbcHelper	deleteCache()
JdbcHelper	deleteCache(String name)
void	execute(String sql) 执行SQL语句命令
String	getCacheName()
String	getDatabaseName() 获取默认数据库名称
String	getDatabaseType()
double	getDouble(String sql, List<Object> params)
double	getDouble(String sql, Map<String,Object> paramMap)
double	getDouble(String sql, Object[] params) 获取Double数据
int	getInt(String sql, List<Map<String,Object>> params)
int	getInt(String sql, Map<String,Object> paramMap)
int	getInt(String sql, Object[] params) 获取Integer类型数据
String	getKey(String key)
long	getLong(String sql, List<Object> params)
long	getLong(String sql, Map<String,Object> paramMap) 获取Long类型数据
long	getLong(String sql, Object[] params) 获取Long类型数据
Object	getObject(String sql, List<Object> params)
Object	getObject(String sql, Map<String,Object> paramMap) 获取数据Object
Object	getObject(String sql, Object[] params) 获取单个Object类型数据
String	getString(String sql, List<Object> params)
String	getString(String sql, Map<String,Object> paramMap)
String	getString(String sql, Object[] params) 获取字符串数据
Map<String,String>	getTableComment() 获取默认数据源表备注
String	getTableComment(String tableName) 根据数据源获取表注释
Map<String,Map<String,Map<String,Object>>>	getTableField() 获取默认数据表字段
Map<String,Map<String,Object>>	getTableField(String tableName) 获取默认数据表字段
List	getValues(String sql, List<Object> params)
List	getValues(String sql, Map params) 获取单列数据列表
List	getValues(String sql, Object[] params) 获取单列数据列表
int	insert(String sql, List<Object> params) 插入一条数据
int	insert(String sql, Map<String,Object> paramMap)
int	insert(String sql, Object[] params) 插入数据，针对 jdbcTemplate
static JdbcHelper	instance()
void	removeTableCache(String key) 根据数据源刷新缓存
void	setCacheName(String cacheName) 设置缓存Key
void	setKey(String key)
JdbcHelper.Table	table(String tableName)
List<Map<String,Object>>	toList(String sql)
List<Map<String,Object>>	toList(String sql, List<Object> params)
List<Map<String,Object>>	toList(String sql, Map<String,Object> paramMap)
List<Map<String,Object>>	toList(String sql, Object[] params) 获取数据表
Map<String,Object>	toMap(String sql)
Map	toMap(String sql, List<Object> params)
Map<String,Object>	toMap(String sql, Map<String,Object> paramMap) 获取数据Map
Map<String,Object>	toMap(String sql, Object[] params) 获取单条Map数据
Pager<Map<String,Object>>	toPager(String sql)
Pager<Map<String,Object>>	toPager(String sql, List<Object> params)
Pager<Map<String,Object>>	toPager(String sql, List<Object> params, javax.servlet.http.HttpServletRequest request)
Pager<Map<String,Object>>	toPager(String sql, List<Object> params, int offset, int limit)
Pager<Map<String,Object>>	toPager(String sql, Map<String,Object> paramMap) 自动分页
Pager<Map<String,Object>>	toPager(String sql, Map<String,Object> paramMap, javax.servlet.http.HttpServletRequest request) 分页
Pager<Map<String,Object>>	toPager(String sql, Map<String,Object> paramMap, int offset, int limit) 手工分页
Pager<Map<String,Object>>	toPager(String sql, Object[] params) 分页
Pager<Map<String,Object>>	toPager(String sql, Object[] params, javax.servlet.http.HttpServletRequest request)
Pager<Map<String,Object>>	toPager(String sql, Object[] params, int offset, int limit) 手工分页
Pager<Map<String,Object>>	toPager(String sql, String countSQL, List<Object> params, javax.servlet.http.HttpServletRequest request) 分页查询
Pager<Map<String,Object>>	toPager(String sql, String countSQL, List<Object> params, int offset, int limit)
Pager<Map<String,Object>>	toPager(String sql, String countSQL, Map<String,Object> paramMap, int offset, int limit) 手工分页
Pager<Map<String,Object>>	toPager(String sql, String countSQL, Object[] params, javax.servlet.http.HttpServletRequest request)
Pager<Map<String,Object>>	toPager(String sql, String countSQL, Object[] params, int offset, int limit) 手工分页
org.ssssssss.magicapi.modules.db.Transaction	transaction() 开启事务，手动提交和回滚
Object	transaction(Function<?,?> function) 开启事务，在一个回调中进行操作
int	update(String sql, Map<String,Object> paramMap)
int	update(String sql, Object[] params) 更新指定记录
JdbcHelper	use(String key) 切换数据源进行SQL接口操作

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

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

构造器详细资料

JdbcHelper

public JdbcHelper(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate,
                  org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate)

参数:

jdbcTemplate -

sqlSessionTemplate -

方法详细资料

getCacheName

public String getCacheName()

setCacheName

public void setCacheName(String cacheName)

设置缓存Key

参数:

cacheName -

cache

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

instance

public static JdbcHelper instance()

返回:

setKey

public void setKey(String key)

getKey

public String getKey(String key)

clearTableCache

@Comment(value="\u6e05\u7a7a\u6570\u636e\u5e93\u8868\u5b57\u6bb5\u7f13\u5b58")
public void clearTableCache()
                                                                                                     throws SQLException

清空数据库表字段缓存

抛出:

SQLException

removeTableCache

@Comment(value="\u6839\u636e\u6570\u636e\u6e90\u5237\u65b0\u7f13\u5b58")
public void removeTableCache(@Comment(value="\u6570\u636e\u6e90\u540d\u79f0")
                                                                                                       String key)
                                                                                                throws SQLException

根据数据源刷新缓存

参数:

key - 数据源名称

抛出:

SQLException

getDatabaseName

@Comment(value="\u83b7\u53d6\u9ed8\u8ba4\u6570\u636e\u5e93\u540d\u79f0")
public String getDatabaseName()
                                                                                                 throws SQLException

获取默认数据库名称

返回:

抛出:

SQLException

getDatabaseType

@Comment(value="\u83b7\u53d6\u9ed8\u8ba4\u6570\u636e\u5e93\u7c7b\u578b")
public String getDatabaseType()
                                                                                                 throws SQLException

抛出:

SQLException

transaction

@Comment(value="\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

public org.ssssssss.magicapi.modules.db.Transaction transaction()

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

getTableComment

@Comment(value="\u6839\u636e\u6570\u636e\u540d\u83b7\u53d6\u8868\u6ce8\u91ca")
public String getTableComment(@Comment(value="\u6570\u636e\u6e90\u540d\u79f0")
                                                                                                              String tableName)
                                                                                                       throws SQLException

根据数据源获取表注释

参数:

tableName - 数据源

返回:

抛出:

SQLException

getTableComment

@Comment(value="\u83b7\u53d6\u5f53\u524d\u9ed8\u8ba4\u6570\u636e\u5e93\u8868\u6ce8\u91ca")
public Map<String,String> getTableComment()
                                                                                                                               throws SQLException

获取默认数据源表备注

返回:

抛出:

SQLException

getTableField

@Comment(value="\u6839\u636e\u6570\u636e\u5e93\u540d\u548c\u8868\uff0c\u83b7\u53d6\u8868\u5b57\u6bb5\u6ce8\u91ca")
public Map<String,Map<String,Object>> getTableField(@Comment(value="\u8868\u540d")
                                                                                                                                                                        String tableName)
                                                                                                                                                                 throws SQLException

获取默认数据表字段

返回:

抛出:

SQLException

getTableField

@Comment(value="\u6839\u636e\u6570\u636e\u5e93\u540d\u548c\u8868\uff0c\u83b7\u53d6\u8868\u5b57\u6bb5\u6ce8\u91ca")
public Map<String,Map<String,Map<String,Object>>> getTableField()
                                                                                                                                                                             throws SQLException

获取默认数据表字段

返回:

抛出:

SQLException

use

@Comment(value="\u5207\u6362\u6570\u636e\u6e90")
public JdbcHelper use(@Comment(value="\u6570\u636e\u6e90")
                                                                        String key)
                                                                 throws SQLException

切换数据源进行SQL接口操作

参数:

key - 数据源

返回:

抛出:

SQLException

table

@Comment(value="\u4f7f\u7528\u8868")
public JdbcHelper.Table table(@Comment(value="\u8868\u540d")
                                                                    String tableName)
                                                             throws SQLException

抛出:

SQLException

toPager

@Comment(value="\u5206\u9875\u67e5\u8be2")
public Pager<Map<String,Object>> toPager(@Comment(value="\u67e5\u8be2\u8bed\u53e5\uff1aselect * from table where id=? and name=?")
                                                                                     String sql,
                                                                                     @Comment(value="\u4f8b\u5982:[id,name]")
                                                                                     List<Object> params,
                                                                                     @Comment(value="\u4ece\u7b2c\u51e0\u884c\u8d77")
                                                                                     int offset,
                                                                                     @Comment(value="\u4e00\u9875\u663e\u793a\u51e0\u884c")
                                                                                     int limit)

toPager

public Pager<Map<String,Object>> toPager(String sql,
                                         Object[] params,
                                         int offset,
                                         int limit)

手工分页

参数:

sql -

params -

offset -

limit -

返回:

toPager

@Comment(value="\u5206\u9875\u67e5\u8be2")
public Pager<Map<String,Object>> toPager(@Comment(value="\u67e5\u8be2\u8bed\u53e5,\u4f8b\u5982:select * from table where field1=? and field2=?")
                                                                                     String sql,
                                                                                     @Comment(value="\u7edf\u8ba1\u884c\u6570\u8bed\u53e5,\u4f8b\u5982\uff1aselect count(*) from table where field1=? and field2=?")
                                                                                     String countSQL,
                                                                                     @Comment(value="\u4f8b\u5982\uff1a[\u53c2\u65701,\u53c2\u65702]")
                                                                                     List<Object> params,
                                                                                     @Comment(value="\u4ece\u7b2c\u51e0\u884c\u8d77")
                                                                                     int offset,
                                                                                     @Comment(value="\u4e00\u9875\u663e\u793a\u51e0\u884c")
                                                                                     int limit)

toPager

@Comment(value="\u5206\u9875\u67e5\u8be2")
public Pager<Map<String,Object>> toPager(@Comment(value="\u67e5\u8be2\u8bed\u53e5,\u4f8b\u5982:select * from table where field1=? and field2=?")
                                                                                     String sql,
                                                                                     @Comment(value="\u7edf\u8ba1\u884c\u6570\u8bed\u53e5,\u4f8b\u5982\uff1aselect count(*) from table where field1=? and field2=?")
                                                                                     String countSQL,
                                                                                     @Comment(value="\u4f8b\u5982\uff1a[\u53c2\u65701,\u53c2\u65702]")
                                                                                     List<Object> params,
                                                                                     javax.servlet.http.HttpServletRequest request)

分页查询

参数:

sql -

countSQL -

params -

request -

返回:

toPager

public Pager<Map<String,Object>> toPager(String sql,
                                         String countSQL,
                                         Object[] params,
                                         int offset,
                                         int limit)

手工分页

参数:

sql - 查询SQL

countSQL - 统计总记录数SQL

params -

offset -

limit -

返回:

toPager

public Pager<Map<String,Object>> toPager(String sql,
                                         Object[] params)

分页

参数:

sql - 查询SQL语句

params -

返回:

toPager

public Pager<Map<String,Object>> toPager(String sql,
                                         String countSQL,
                                         Object[] params,
                                         javax.servlet.http.HttpServletRequest request)

toPager

public Pager<Map<String,Object>> toPager(String sql,
                                         Object[] params,
                                         javax.servlet.http.HttpServletRequest request)

toList

@Comment(value="\u5217\u8868\u67e5\u8be2,\u4f8b\u5982 select * from table where field1=#{field1} and field2=#{field2}")
public List<Map<String,Object>> toList(String sql)

参数:

sql -

返回:

toList

public List<Map<String,Object>> toList(String sql,
                                       Object[] params)

获取数据表

参数:

sql -

params -

返回:

deleteCache

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

deleteCache

@Comment(value="\u5220\u9664`SQL`\u7f13\u5b58")
public JdbcHelper deleteCache()

toList

@Comment(value="\u5217\u8868\u67e5\u8be2")
public List<Map<String,Object>> toList(String sql,
                                                                                   List<Object> params)

参数:

sql -

params -

返回:

getValues

@Comment(value="\u83b7\u53d6\u6570\u636e\u5217")
public List getValues(@Comment(value="\u5355\u5217\u67e5\u8be2\u8bed\u53e5,\u4f8b\u5982: select id from table where field=? and field1=?")
                                                                        String sql,
                                                                        @Comment(value="\u53c2\u6570:[\u53c2\u65701\uff0c\u53c2\u65702]")
                                                                        Object[] params)

获取单列数据列表

参数:

sql -

params -

返回:

getValues

@Comment(value="\u83b7\u53d6\u6570\u636e\u5217\uff0c\u4f8b\u5982\uff1a[1,3,4,5]")
public List getValues(@Comment(value="\u5355\u5217\u67e5\u8be2\u8bed\u53e5\uff0c\u4f8b\u5982\uff1aselect id from table where field1=? and field2=?")
                                                                                                         String sql,
                                                                                                         @Comment(value="\u4f8b\u5982\uff1a[\u53c2\u65701,\u53c2\u65702]")
                                                                                                         List<Object> params)

参数:

sql -

params -

返回:

getValues

@Comment(value="\u83b7\u53d6\u6570\u636e\u5217\uff0c\u4f8b\u5982\uff1a[1,3,4,5]")
public List getValues(@Comment(value="\u5355\u5217\u67e5\u8be2\u8bed\u53e5\uff0c\u4f8b\u5982\uff1aselect id from table where name=?")
                                                                                                         String sql,
                                                                                                         @Comment(value="\u4f8b\u5982\uff1a{name:\'1\'}")
                                                                                                         Map params)

获取单列数据列表

参数:

sql -

params -

返回:

insert

@Comment(value="\u63d2\u5165\u6570\u636e\uff0c\u9488\u5bf9 jdbcTemplate")
public int insert(@Comment(value="\u63d2\u5165\u8bed\u53e5:insert table(field1,field2) values (?,?)")
                                                                                             String sql,
                                                                                             @Comment(value="\u53c2\u6570\uff1a[\u53c2\u65701\uff0c\u53c2\u65702]")
                                                                                             Object[] params)

插入数据，针对 jdbcTemplate

参数:

sql -

params -

返回:

insert

@Comment(value="\u63d2\u5165\u6570\u636e\uff0c\u9488\u5bf9 jdbcTemplate")
public int insert(String sql,
                                                                                             List<Object> params)

插入一条数据

参数:

sql -

params - ['1','mame','old']

返回:

batchUpdateByMap

@Comment(value="\u6279\u91cf\u64cd\u4f5c,\u9488\u5bf9jdbcTemplate")
public int[] batchUpdateByMap(@Comment(value="\u66f4\u65b0\u8bed\u53e5\uff1aupdate table set name=? where id=?")
                                                                                                   String sql,
                                                                                                   @Comment(value="\u4f8b\u5982\uff1a[{id\uff1a3,name:\'a\'},{id:4,name:\'b\'}]")
                                                                                                   List<Map> params)

批量操作,针对jdbcTemplate

参数:

sql - 'update table name=#{name} where id=#{id}'

params - [{id:'1',name:'aaa'},{id:'2',name:'bbb'}]

返回:

update

public int update(String sql,
                  Object[] params)

更新指定记录

参数:

sql - 'update table set name=? where id=?'

params - [name,id]

返回:

delete

public int delete(@Comment(value="\u4f8b\u5982: delete from table=? where id =? and name=?")
                  String sql,
                  @Comment(value="\u4f8b\u5982\uff1a[table,id,name]")
                  Object[] params)

删除指定记录，此接口主要针对MagicApi

参数:

sql - 'delete from table=? where id =? and name=?'

params - [table,id,name]

返回:

delete

public int delete(String sql,
                  Object param)

batchDeleteByMap

@Comment(value="\u6279\u91cf\u5220\u9664\u591a\u6761\u8bb0\u5f55,\u9488\u5bf9sqlSessionTemplate")
public int[] batchDeleteByMap(@Comment(value="\u4f8b\u5982\uff1adelete from table where id=#{id} and name=#{name}")
                                                                                                                                 String sql,
                                                                                                                                 @Comment(value="\u4f8b\u5982\uff1a[{id:\'1\',name:\'aa\'},{id:\'2\',name:\'b\'}]")
                                                                                                                                 List<Map> params)

批量删除多条记录 针对sqlSessionTemplate

参数:

sql - 'delete from table where id=#{id} and name=#{name}'

params - [{id:'1',name:'aa'},{id:'2',name:'b'}]

返回:

batchDelete

@Comment(value="\u6279\u91cf\u5220\u9664\u591a\u6761\u8bb0\u5f55\uff0c\u9488\u5bf9JdbcTemplate")
public int[] batchDelete(@Comment(value="\u4f8b\u5982\uff1adelete from table where id=?\' \u6216\u8005 delete from table where id=? and name=?")
                                                                                                                           String sql,
                                                                                                                           @Comment(value=" [id,id,id] \u6216\u8005 [[id,name],[id,name], [id,name],[id,name]]")
                                                                                                                           List params)

批量删除多条记录，针对JdbcTemplate

参数:

sql - 'delete from table where id=?' 或者 delete from table where id=? and name=?

params - [id,id,id] 或者 [[id,name],[id,name], [id,name],[id,name]]

返回:

batchDelete

public int[] batchDelete(String sql,
                         Object[] params)

批量删除多条记录，针对JdbcTemplate

参数:

sql - 'delete from table where id=?'

params -

返回:

delete

@Comment(value="\u5220\u9664\u8bb0\u5f55")
public int delete(@Comment(value="\u4f8b\u5982\uff1adelete from table=? where id =? and name=?")
                                                              String sql,
                                                              @Comment(value="\u53c2\u6570\uff1a[id,name]")
                                                              List params)

此接口主要针对MagicApi

参数:

sql - 'delete from table=? where id =? and name=?'

params - [table,id,name]

返回:

execute

@Comment(value="\u6267\u884c\u811a\u672c\u8bed\u53e5\uff0c\u6ca1\u6709\u8fd4\u56de\u503c")
public void execute(@Comment(value="\u811a\u672c\u8bed\u53e5")
                                                                                                                String sql)
                                                                                                         throws SQLException

执行SQL语句命令

参数:

sql -

抛出:

SQLException

toMap

@Comment(value="\u83b7\u53d6\u5355\u6761Map\u6570\u636e")
public Map<String,Object> toMap(@Comment(value="\u5355\u6761\u6570\u636e\u67e5\u8be2\u8bed\u53e5")
                                                                                           String sql,
                                                                                           Object[] params)

获取单条Map数据

参数:

sql -

params -

返回:

toMap

public Map toMap(String sql,
                 List<Object> params)

参数:

sql -

params -

返回:

getObject

public Object getObject(String sql,
                        Object[] params)

获取单个Object类型数据

参数:

sql -

params -

返回:

getString

@Comment(value="\u83b7\u53d6\u5b57\u7b26\u4e32\u6570\u636e")
public String getString(String sql,
                                                                                      Object[] params)

获取字符串数据

参数:

sql -

params -

返回:

getString

@Comment(value="\u83b7\u53d6\u5b57\u7b26\u4e32\u6570\u636e")
public String getString(String sql,
                                                                                      List<Object> params)

参数:

sql -

params -

返回:

getInt

@Comment(value="\u83b7\u53d6Integer\u7c7b\u578b\u6570\u636e")
public int getInt(String sql,
                                                                                 Object[] params)

获取Integer类型数据

参数:

sql -

params -

返回:

getInt

@Comment(value="\u83b7\u53d6Integer\u7c7b\u578b\u6570\u636e")
public int getInt(String sql,
                                                                                 List<Map<String,Object>> params)

参数:

sql -

params -

返回:

getLong

@Comment(value="\u83b7\u53d6Long\u7c7b\u578b\u6570\u636e")
public long getLong(String sql,
                                                                                Object[] params)

获取Long类型数据

参数:

sql -

params -

返回:

getLong

@Comment(value="\u83b7\u53d6Long\u7c7b\u578b\u6570\u636e")
public long getLong(String sql,
                                                                                Map<String,Object> paramMap)

获取Long类型数据

参数:

sql -

paramMap -

返回:

getLong

@Comment(value="\u83b7\u53d6Long\u7c7b\u578b\u6570\u636e")
public long getLong(String sql,
                                                                                List<Object> params)

getDouble

@Comment(value="\u83b7\u53d6Double\u7c7b\u578b\u6570\u636e")
public double getDouble(String sql,
                                                                                      Object[] params)

获取Double数据

参数:

sql -

params -

返回:

getDouble

@Comment(value="\u83b7\u53d6Double\u7c7b\u578b\u6570\u636e")
public double getDouble(String sql,
                                                                                      List<Object> params)

toPager

@Comment(value="\u624b\u5de5\u5206\u9875")
public Pager<Map<String,Object>> toPager(String sql,
                                                                                     Map<String,Object> paramMap,
                                                                                     int offset,
                                                                                     int limit)

手工分页

参数:

sql -

paramMap -

offset -

limit -

返回:

toPager

@Comment(value="\u624b\u5de5\u5206\u9875")
public Pager<Map<String,Object>> toPager(String sql,
                                                                                     String countSQL,
                                                                                     Map<String,Object> paramMap,
                                                                                     int offset,
                                                                                     int limit)

手工分页

参数:

sql -

countSQL -

paramMap -

offset -

limit -

返回:

toPager

@Comment(value="\u5206\u9875\u67e5\u8be2")
public Pager<Map<String,Object>> toPager(String sql)

toPager

@Comment(value="\u5206\u9875\u67e5\u8be2")
public Pager<Map<String,Object>> toPager(String sql,
                                                                                     Map<String,Object> paramMap)

自动分页

参数:

sql -

paramMap -

返回:

toPager

@Comment(value="\u5206\u9875\u67e5\u8be2")
public Pager<Map<String,Object>> toPager(String sql,
                                                                                     List<Object> params)

参数:

sql -

params -

返回:

toPager

@Comment(value="\u5206\u9875\u67e5\u8be2")
public Pager<Map<String,Object>> toPager(String sql,
                                                                                     List<Object> params,
                                                                                     javax.servlet.http.HttpServletRequest request)

参数:

sql -

params -

request -

返回:

toPager

@Comment(value="\u5206\u9875\u67e5\u8be2")
public Pager<Map<String,Object>> toPager(String sql,
                                                                                     Map<String,Object> paramMap,
                                                                                     javax.servlet.http.HttpServletRequest request)

分页

参数:

sql -

paramMap -

request -

返回:

toList

@Comment(value="\u83b7\u53d6\u5217\u8868")
public List<Map<String,Object>> toList(String sql,
                                                                                   Map<String,Object> paramMap)

参数:

sql -

paramMap -

返回:

insert

@Comment(value="\u63d2\u5165\u6570\u636e")
public int insert(String sql,
                                                              Map<String,Object> paramMap)

update

@Comment(value="\u66f4\u65b0\u6570\u636e")
public int update(@Comment(value="\u4f8b\u5982\uff1aupdate table set name=#{name} where id=#{id}")
                                                              String sql,
                                                              @Comment(value="\u4f8b\u5982\uff1a{id:1,name:\'a\'}")
                                                              Map<String,Object> paramMap)

batchUpdate

@Comment(value="\u6279\u91cf\u66f4\u65b0\u6570\u636e")
public int[] batchUpdate(String sql,
                                                                                 Object[] params)

指量更新

参数:

sql - ’update table set name=1 where id=? 或者 update table set name=? where id=?

params - [id,id,id,id] 或者 [[name,id],[name,id],['name','id']]

返回:

batchUpdate

@Comment(value="\u6279\u91cf\u66f4\u65b0\u6570\u636e")
public int[] batchUpdate(String sql,
                                                                                 List<Object> params)

批量更新多条记录

参数:

sql - 'update table name=22 where id=? 或者 update table name=? where id=?

params - [id,id,id,id] 或者[[name,id],[name,id]]

返回:

delete

@Comment(value="\u5220\u9664\u6570\u636e")
public int delete(String sql,
                                                              Map<String,Object> paramMap)

删除多条数据

参数:

sql - 'delete from table where id=#{id}'

paramMap - {id:2}

返回:

toMap

public Map<String,Object> toMap(String sql,
                                Map<String,Object> paramMap)

获取数据Map

参数:

sql - 'select * from table where id=#{id}'

paramMap - {id:2}

返回:

toMap

public Map<String,Object> toMap(String sql)

getObject

public Object getObject(String sql,
                        Map<String,Object> paramMap)

获取数据Object

参数:

sql - 'select * from table where id=#{id}'

paramMap - {id:2}

返回:

getObject

public Object getObject(String sql,
                        List<Object> params)

参数:

sql -

params -

返回:

getString

public String getString(String sql,
                        Map<String,Object> paramMap)

参数:

sql -

paramMap -

返回:

getInt

public int getInt(String sql,
                  Map<String,Object> paramMap)

参数:

sql -

paramMap -

返回:

getDouble

public double getDouble(String sql,
                        Map<String,Object> paramMap)