top.bayberry.core.db.helper.mybaitsplug

类 DMBP_Update

java.lang.Object

top.bayberry.core.db.helper.jpbc.DB_Update

top.bayberry.core.db.helper.mybaitsplug.DMBP_Update

public final class DMBP_Update
extends DB_Update

字段概要

字段

限定符和类型	字段和说明
protected org.apache.ibatis.session.SqlSession	sqlSession
protected org.apache.ibatis.session.SqlSessionFactory	sqlSessionFactory
protected org.mybatis.spring.SqlSessionTemplate	sqlSessionTemplate

从类继承的字段 top.bayberry.core.db.helper.jpbc.DB_Update

conn, debug

构造器概要

构造器

构造器和说明
DMBP_Update(Connection conn)
DMBP_Update(org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate)

方法概要

限定符和类型	方法和说明
int	delete(Class tableName, String where, Object... param)
int	delete(String tableName, String where, Object... param) Delete int.
int	deleteById(Class tableName, String id)
int	deleteById(String tableName, String id) Delete by id int.
int	executeUpdate(SqlQuery sqlQuery) executeQuery
int	executeUpdate(String sql) executeUpdate
int	executeUpdate(String sql, Object... param) executeUpdate
int[]	executeUpdateMultiple(SqlQuery[] sql) executeUpdateMultiple
int	executeUpdateSingleColumn(Class tableName, String column, Object value, String where, String... param) 更新单列数据
int	executeUpdateSingleColumn(Class tableName, String column, Object value, String idName, String id) 更新单列数据
int	executeUpdateSingleColumn(String tableName, String column, Object value, String where, String... param) 更新单列数据
int	executeUpdateSingleColumn(String tableName, String column, Object value, String idName, String id) 更新单列数据
int	executeUpdateSingleColumnAdd(Class tableName, String column, BigDecimal value, String where, String... param) 执行sql update++
int	executeUpdateSingleColumnAdd(String tableName, String column, BigDecimal value, String where, String... param) 执行sql update++
int	executeUpdateSingleColumnById(Class tableName, String column, Object value, String id) 更新单列数据
int	executeUpdateSingleColumnById(String tableName, String column, Object value, String id) 更新单列数据
int	executeUpdateSingleColumnSubtract(Class tableName, String column, BigDecimal value, String where, String... param) 执行sql update--
int	executeUpdateSingleColumnSubtract(String tableName, String column, BigDecimal value, String where, String... param) 执行sql update--
int	insert(Class tableName, String[] column, Object... value)
int	insert(String tableName, String[] column, Object... value) Insert int.
int	updateById(Class tableName, String id, String[] column, Object... value)
int	updateById(String tableName, String id, String[] column, Object... value) Update by id int.

从类继承的方法 top.bayberry.core.db.helper.jpbc.DB_Update

delete, deleteById, executeUpdate_, executeUpdate, executeUpdate, executeUpdateMultiple, executeUpdateSingleColumn, executeUpdateSingleColumn, executeUpdateSingleColumnAdd, executeUpdateSingleColumnSubtract, insert, updateById

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

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

字段详细资料

sqlSessionTemplate

protected org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate

sqlSessionFactory

protected org.apache.ibatis.session.SqlSessionFactory sqlSessionFactory

sqlSession

protected org.apache.ibatis.session.SqlSession sqlSession

构造器详细资料

DMBP_Update

public DMBP_Update(Connection conn)

DMBP_Update

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

方法详细资料

executeUpdate

public int executeUpdate(String sql)

executeUpdate

覆盖:

executeUpdate 在类中 DB_Update

参数:

sql - sql语句

返回:

the int

executeUpdate

public int executeUpdate(String sql,
                         Object... param)

executeUpdate

覆盖:

executeUpdate 在类中 DB_Update

参数:

sql - sql语句

param - 参数对象

返回:

the int

executeUpdate

public int executeUpdate(SqlQuery sqlQuery)

executeQuery

覆盖:

executeUpdate 在类中 DB_Update

参数:

sqlQuery -

返回:

the db result

executeUpdateMultiple

public int[] executeUpdateMultiple(SqlQuery[] sql)

executeUpdateMultiple

覆盖:

executeUpdateMultiple 在类中 DB_Update

参数:

sql - sql语句(多个)

返回:

the int [ ]

executeUpdateSingleColumnAdd

public int executeUpdateSingleColumnAdd(String tableName,
                                        String column,
                                        BigDecimal value,
                                        String where,
                                        String... param)

执行sql update++

覆盖:

executeUpdateSingleColumnAdd 在类中 DB_Update

参数:

tableName -

column -

value -

where -

param - the param

返回:

executeUpdateSingleColumnAdd

public int executeUpdateSingleColumnAdd(Class tableName,
                                        String column,
                                        BigDecimal value,
                                        String where,
                                        String... param)

执行sql update++

参数:

tableName -

column -

value -

where -

返回:

executeUpdateSingleColumnSubtract

public int executeUpdateSingleColumnSubtract(String tableName,
                                             String column,
                                             BigDecimal value,
                                             String where,
                                             String... param)

执行sql update--

覆盖:

executeUpdateSingleColumnSubtract 在类中 DB_Update

参数:

tableName -

column -

value -

where -

param - the param

返回:

executeUpdateSingleColumnSubtract

public int executeUpdateSingleColumnSubtract(Class tableName,
                                             String column,
                                             BigDecimal value,
                                             String where,
                                             String... param)

执行sql update--

参数:

tableName -

column -

value -

where -

返回:

executeUpdateSingleColumn

public int executeUpdateSingleColumn(String tableName,
                                     String column,
                                     Object value,
                                     String idName,
                                     String id)

更新单列数据

覆盖:

executeUpdateSingleColumn 在类中 DB_Update

参数:

tableName -

column -

value -

idName -

id -

返回:

executeUpdateSingleColumn

public int executeUpdateSingleColumn(Class tableName,
                                     String column,
                                     Object value,
                                     String idName,
                                     String id)

更新单列数据

参数:

tableName -

column -

value -

idName -

id -

返回:

executeUpdateSingleColumn

public int executeUpdateSingleColumn(String tableName,
                                     String column,
                                     Object value,
                                     String where,
                                     String... param)

更新单列数据

覆盖:

executeUpdateSingleColumn 在类中 DB_Update

参数:

tableName -

column -

value -

where -

param - the param

返回:

executeUpdateSingleColumn

public int executeUpdateSingleColumn(Class tableName,
                                     String column,
                                     Object value,
                                     String where,
                                     String... param)

更新单列数据

参数:

tableName -

column -

value -

where -

返回:

executeUpdateSingleColumnById

public int executeUpdateSingleColumnById(String tableName,
                                         String column,
                                         Object value,
                                         String id)

更新单列数据

覆盖:

executeUpdateSingleColumnById 在类中 DB_Update

参数:

tableName -

column -

value -

id -

返回:

executeUpdateSingleColumnById

public int executeUpdateSingleColumnById(Class tableName,
                                         String column,
                                         Object value,
                                         String id)

更新单列数据

参数:

tableName -

column -

value -

id -

返回:

insert

public int insert(String tableName,
                  String[] column,
                  Object... value)

从类复制的说明: DB_Update

Insert int.

覆盖:

insert 在类中 DB_Update

参数:

tableName - the table name

column - the column

value - the value

返回:

the int

insert

public int insert(Class tableName,
                  String[] column,
                  Object... value)

delete

public int delete(String tableName,
                  String where,
                  Object... param)

从类复制的说明: DB_Update

Delete int.

覆盖:

delete 在类中 DB_Update

参数:

tableName - the table name

where - the where

param - the param

返回:

the int

delete

public int delete(Class tableName,
                  String where,
                  Object... param)

deleteById

public int deleteById(String tableName,
                      String id)

从类复制的说明: DB_Update

Delete by id int.

覆盖:

deleteById 在类中 DB_Update

参数:

tableName - the table name

id - the id

返回:

the int

deleteById

public int deleteById(Class tableName,
                      String id)

updateById

public int updateById(String tableName,
                      String id,
                      String[] column,
                      Object... value)

从类复制的说明: DB_Update

Update by id int.

覆盖:

updateById 在类中 DB_Update

参数:

tableName - the table name

id - the id

column - the column

value - the value

返回:

the int

updateById

public int updateById(Class tableName,
                      String id,
                      String[] column,
                      Object... value)