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 |
| 构造器和说明 |
|---|
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.
|
delete, deleteById, executeUpdate_, executeUpdate, executeUpdate, executeUpdateMultiple, executeUpdateSingleColumn, executeUpdateSingleColumn, executeUpdateSingleColumnAdd, executeUpdateSingleColumnSubtract, insert, updateByIdprotected org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate
protected org.apache.ibatis.session.SqlSessionFactory sqlSessionFactory
protected org.apache.ibatis.session.SqlSession sqlSession
public DMBP_Update(Connection conn)
public DMBP_Update(org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate)
public int executeUpdate(String sql)
executeUpdate 在类中 DB_Updatesql - sql语句public int executeUpdate(String sql, Object... param)
executeUpdate 在类中 DB_Updatesql - sql语句param - 参数对象public int executeUpdate(SqlQuery sqlQuery)
executeUpdate 在类中 DB_UpdatesqlQuery - public int[] executeUpdateMultiple(SqlQuery[] sql)
executeUpdateMultiple 在类中 DB_Updatesql - sql语句(多个)public int executeUpdateSingleColumnAdd(String tableName, String column, BigDecimal value, String where, String... param)
executeUpdateSingleColumnAdd 在类中 DB_UpdatetableName - column - value - where - param - the parampublic int executeUpdateSingleColumnAdd(Class tableName, String column, BigDecimal value, String where, String... param)
tableName - column - value - where - public int executeUpdateSingleColumnSubtract(String tableName, String column, BigDecimal value, String where, String... param)
executeUpdateSingleColumnSubtract 在类中 DB_UpdatetableName - column - value - where - param - the parampublic int executeUpdateSingleColumnSubtract(Class tableName, String column, BigDecimal value, String where, String... param)
tableName - column - value - where - public int executeUpdateSingleColumn(String tableName, String column, Object value, String idName, String id)
executeUpdateSingleColumn 在类中 DB_UpdatetableName - column - value - idName - id - public int executeUpdateSingleColumn(Class tableName, String column, Object value, String idName, String id)
tableName - column - value - idName - id - public int executeUpdateSingleColumn(String tableName, String column, Object value, String where, String... param)
executeUpdateSingleColumn 在类中 DB_UpdatetableName - column - value - where - param - the parampublic int executeUpdateSingleColumn(Class tableName, String column, Object value, String where, String... param)
tableName - column - value - where - public int executeUpdateSingleColumnById(String tableName, String column, Object value, String id)
executeUpdateSingleColumnById 在类中 DB_UpdatetableName - column - value - id - public int executeUpdateSingleColumnById(Class tableName, String column, Object value, String id)
tableName - column - value - id - public int insert(String tableName, String[] column, Object... value)
DB_Updatepublic int delete(String tableName, String where, Object... param)
DB_Updatepublic int deleteById(String tableName, String id)
DB_UpdatedeleteById 在类中 DB_UpdatetableName - the table nameid - the idpublic int updateById(String tableName, String id, String[] column, Object... value)
DB_UpdateupdateById 在类中 DB_UpdatetableName - the table nameid - the idcolumn - the columnvalue - the valueCopyright © 2020. All rights reserved.