top.bayberry.core.db.helper.jpbc

类 DB_Update

java.lang.Object

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

直接已知子类:

DJPA_Update, DMBP_Update

public class DB_Update
extends Object

jdbc Update

          ┌─┐       ┌─┐
       ┌──┘ ┴───────┘ ┴──┐
       │                 │
       │       ───       │
       │  ─┬┘       └┬─  │
       │                 │
       │       ─┴─       │
       │                 │
       └───┐         ┌───┘
           │         │
           │         │
           │         │
           │         └──────────────┐
           │                        │
           │                        ├─┐
           │      author:lelouch    ┌─┘
           │                        │
           └─┐  ┐  ┌───────┬──┐  ┌──┘
             │ ─┤ ─┤       │ ─┤ ─┤
             └──┴──┘       └──┴──┘
                 神兽保佑
                 代码无BUG!
 

作者:

lelouch

字段概要

字段

限定符和类型	字段和说明
protected Connection	conn The Conn.
static boolean	debug 是否显示日志

构造器概要

构造器

构造器和说明
DB_Update(Connection conn) Instantiates a new Db update.

方法概要

限定符和类型	方法和说明
protected static int	delete(Connection conn, String tableName, String where, Object... param) 执行sql delete
int	delete(String tableName, String where, Object... param) Delete int.
protected static int	deleteById(Connection conn, String tableName, String id) 执行sql delete
int	deleteById(String tableName, String id) Delete by id int.
protected static int	executeUpdate_(Connection conn, String sql, Object[] param) executeUpdate
protected static int	executeUpdate(Connection conn, String sql) executeUpdate
protected static int	executeUpdate(Connection conn, String sql, Object... param) executeUpdate
int	executeUpdate(SqlQuery sqlQuery) executeQuery
int	executeUpdate(String sql) executeUpdate
int	executeUpdate(String sql, Object... param) executeUpdate
protected static int[]	executeUpdateMultiple(Connection conn, SqlQuery[] sql) executeUpdateMultiple
int[]	executeUpdateMultiple(SqlQuery[] sql) executeUpdateMultiple
protected static int	executeUpdateSingleColumn(Connection conn, String tableName, String column, Object value, String where, String... param) 更新单列数据
protected static int	executeUpdateSingleColumn(Connection conn, String 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) 更新单列数据
protected static int	executeUpdateSingleColumnAdd(Connection conn, String 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(String tableName, String column, Object value, String id) 更新单列数据
protected static int	executeUpdateSingleColumnSubtract(Connection conn, String 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--
protected static int	insert(Connection conn, String tableName, String[] column, Object... value) 执行sql insert
int	insert(String tableName, String[] column, Object... value) Insert int.
protected static int	updateById(Connection conn, String tableName, String id, String[] column, Object... value) 执行sql update
int	updateById(String tableName, String id, String[] column, Object... value) Update by id int.

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

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

字段详细资料

conn

protected Connection conn

The Conn.

debug

public static boolean debug

是否显示日志

构造器详细资料

DB_Update

public DB_Update(Connection conn)

Instantiates a new Db update.

参数:

conn - the conn

方法详细资料

executeUpdate

public int executeUpdate(String sql)

executeUpdate

参数:

sql - sql语句

返回:

the int

executeUpdate

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

executeUpdate

参数:

sql - sql语句

param - 参数对象

返回:

the int

executeUpdate

public int executeUpdate(SqlQuery sqlQuery)

executeQuery

参数:

sqlQuery - the sql query

返回:

the db result

executeUpdateMultiple

public int[] executeUpdateMultiple(SqlQuery[] sql)

executeUpdateMultiple

参数:

sql - sql语句(多个)

返回:

the int [ ]

executeUpdateSingleColumnAdd

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

执行sql update++

参数:

tableName - the table name

column - the column

value - the value

where - the where

param - the param

返回:

int

executeUpdateSingleColumnSubtract

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

执行sql update--

参数:

tableName - the table name

column - the column

value - the value

where - the where

param - the param

返回:

int

executeUpdateSingleColumn

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

更新单列数据

参数:

tableName - the table name

column - the column

value - the value

idName - the id name

id - the id

返回:

int

executeUpdateSingleColumn

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

更新单列数据

参数:

tableName - the table name

column - the column

value - the value

where - the where

param - the param

返回:

int

executeUpdateSingleColumnById

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

更新单列数据

参数:

tableName - the table name

column - the column

value - the value

id - the id

返回:

int

insert

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

Insert int.

参数:

tableName - the table name

column - the column

value - the value

返回:

the int

delete

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

Delete int.

参数:

tableName - the table name

where - the where

param - the param

返回:

the int

deleteById

public int deleteById(String tableName,
                      String id)

Delete by id int.

参数:

tableName - the table name

id - the id

返回:

the int

updateById

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

Update by id int.

参数:

tableName - the table name

id - the id

column - the column

value - the value

返回:

the int

executeUpdate

protected static int executeUpdate(Connection conn,
                                   String sql,
                                   Object... param)

executeUpdate

参数:

conn - 连接对象

sql - sql语句

param - 参数对象

返回:

the int

executeUpdate

protected static int executeUpdate(Connection conn,
                                   String sql)

executeUpdate

参数:

conn - 连接对象

sql - sql语句

返回:

the int

executeUpdate_

protected static int executeUpdate_(Connection conn,
                                    String sql,
                                    Object[] param)

executeUpdate

参数:

conn - 连接对象

sql - sql语句

param - 参数对象

返回:

the int

executeUpdateMultiple

protected static int[] executeUpdateMultiple(Connection conn,
                                             SqlQuery[] sql)

executeUpdateMultiple

参数:

conn - 连接对象

sql - sql语句(多个)

返回:

the int [ ]

executeUpdateSingleColumn

protected static int executeUpdateSingleColumn(Connection conn,
                                               String tableName,
                                               String column,
                                               Object value,
                                               String idName,
                                               String id)

更新单列数据

参数:

conn - the conn

tableName - the table name

column - the column

value - the value

idName - the id name

id - the id

返回:

int

executeUpdateSingleColumn

protected static int executeUpdateSingleColumn(Connection conn,
                                               String tableName,
                                               String column,
                                               Object value,
                                               String where,
                                               String... param)

更新单列数据

参数:

conn - the conn

tableName - the table name

column - the column

value - the value

where - the where

param - the param

返回:

int

executeUpdateSingleColumnAdd

protected static int executeUpdateSingleColumnAdd(Connection conn,
                                                  String tableName,
                                                  String column,
                                                  BigDecimal value,
                                                  String where,
                                                  String... param)

执行sql update++

参数:

conn - the conn

tableName - the table name

column - the column

value - the value

where - the where

param - the param

返回:

int

executeUpdateSingleColumnSubtract

protected static int executeUpdateSingleColumnSubtract(Connection conn,
                                                       String tableName,
                                                       String column,
                                                       BigDecimal value,
                                                       String where,
                                                       String... param)

执行sql update--

参数:

conn - the conn

tableName - the table name

column - the column

value - the value

where - the where

param - the param

返回:

int

insert

protected static int insert(Connection conn,
                            String tableName,
                            String[] column,
                            Object... value)

执行sql insert

参数:

conn - the conn

tableName - the table name

column - the column

value - the value

返回:

int

deleteById

protected static int deleteById(Connection conn,
                                String tableName,
                                String id)

执行sql delete

参数:

conn - the conn

tableName - the table name

id - the id

返回:

int

delete

protected static int delete(Connection conn,
                            String tableName,
                            String where,
                            Object... param)

执行sql delete

参数:

conn - the conn

tableName - the table name

where - the where

param - the param

返回:

int

updateById

protected static int updateById(Connection conn,
                                String tableName,
                                String id,
                                String[] column,
                                Object... value)

执行sql update

参数:

conn - the conn

tableName - the table name

id - the id

column - the column

value - the value

返回:

int