net.sohelp.boot.admin.core.db

类 MybatisHelper

java.lang.Object

net.sohelp.boot.admin.core.db.MybatisHelper

@Component
public class MybatisHelper
extends Object

从以下版本开始:

2024/3/30 18:09

作者:

AaronFung

构造器概要

构造器

构造器和说明
MybatisHelper(org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate)

方法概要

限定符和类型	方法和说明
int	delete(String namespace, Map<String,Object> paramMap)
double	getDouble(String namespace, Map<String,Object> paramMap)
int	getInt(String namespace, Map<String,Object> paramMap)
double	getLong(String namespace, Map<String,Object> paramMap)
Map	getMap(String namespace, Map<String,Object> paramMap)
Object	getObject(String namespace, Map<String,Object> paramMap)
String	getString(String namespace, Map<String,Object> paramMap)
int	insert(String namespace, Map<String,Object> paramMap)
List<Map>	list(String namespace, Map<String,Object> paramMap)
List<Map>	page(String namespace, Map<String,Object> paramMap) 自动分页 分页参数从Request获取offset和limit
List<Map>	page(String namespace, Map<String,Object> paramMap, int offset, int limit) 分页
int	update(String namespace, Map<String,Object> paramMap)
MybatisHelper	use(String datasource) 切换数据源

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

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

构造器详细资料

MybatisHelper

public MybatisHelper(org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate)

方法详细资料

use

@Comment(value="\u5207\u6362\u6570\u636e\u6e90")
public MybatisHelper use(String datasource)
                                                                    throws Exception

切换数据源

参数:

datasource - 数据源

返回:

抛出:

Exception

page

@Comment(value="\u81ea\u52a8\u5206\u9875")
public List<Map> page(String namespace,
                                                                  Map<String,Object> paramMap)

自动分页 分页参数从Request获取offset和limit

参数:

namespace -

paramMap -

返回:

page

@Comment(value="\u5206\u9875")
public List<Map> page(String namespace,
                                                      Map<String,Object> paramMap,
                                                      int offset,
                                                      int limit)

分页

参数:

namespace -

paramMap -

返回:

list

@Comment(value="\u67e5\u8be2")
public List<Map> list(String namespace,
                                                      Map<String,Object> paramMap)

参数:

namespace -

paramMap -

返回:

insert

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

参数:

namespace -

paramMap -

返回:

update

@Comment(value="\u66f4\u65b0")
public int update(String namespace,
                                                  Map<String,Object> paramMap)

参数:

namespace -

paramMap -

返回:

delete

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

参数:

namespace -

paramMap -

返回:

getMap

@Comment(value="\u83b7\u53d6\u5355\u6761\u6570\u636e")
public Map getMap(String namespace,
                                                                          Map<String,Object> paramMap)

参数:

namespace -

paramMap -

返回:

getObject

@Comment(value="\u83b7\u53d6\u5355\u6761\u6570\u636e")
public Object getObject(String namespace,
                                                                                Map<String,Object> paramMap)

参数:

namespace -

paramMap -

返回:

getString

@Comment(value="\u83b7\u53d6\u5b57\u7b26\u4e32")
public String getString(String namespace,
                                                                          Map<String,Object> paramMap)

参数:

namespace -

paramMap -

返回:

getInt

@Comment(value="\u83b7\u53d6\u6574\u6570")
public int getInt(String namespace,
                                                              Map<String,Object> paramMap)

参数:

namespace -

paramMap -

返回:

getDouble

@Comment(value="\u83b7\u53d6\u6d6e\u70b9\u6570")
public double getDouble(String namespace,
                                                                          Map<String,Object> paramMap)

参数:

namespace -

paramMap -

返回:

getLong

@Comment(value="\u83b7\u53d6\u957f\u6574\u6570")
public double getLong(String namespace,
                                                                        Map<String,Object> paramMap)

参数:

namespace -

paramMap -

返回: