com.qa.framework.library.database

类 DBHelper

java.lang.Object

com.qa.framework.library.database.DBHelper

public class DBHelper
extends Object

The type Db DBHelper.

构造器概要

构造器

构造器和说明
DBHelper()

方法概要

限定符和类型	方法和说明
static void	beginTransaction() 开启事务
static void	commitTransaction() 提交事务
static <T> boolean	deleteEntity(Class<T> entityClass, long id) 删除实体
static int	executeUpdate(String sql, Object... params) 执行更新语句（包括：update、insert、delete）
static Connection	getConnection() Gets connection.
static Connection	getConnection(String poolname) 获取数据库连接
static boolean	hasRecord(String sql, Object... params) Has record boolean.
static void	initSQL(String sqlPath) 初始化 SQL 脚本
static <T> boolean	insertEntity(Class<T> entityClass, Map<String,Object> fieldMap) 插入实体
long	queryCount(String sql, Object... params) Query count long.
static <T> T	queryEntity(Class<T> entityClass, String sql, Object... params) 查询实体
static <T> List<T>	queryEntityList(Class<T> entityClass, String sql, Object... params) 查询实体列表
static String	queryField(String sql, String columnName, Object... params) Query field string.
static Map<String,Object>	queryOneRow(String sql, Object... params) Query one row map.
static List<Map<String,Object>>	queryRows(String sql, Object... params) 执行查询语句
static void	rollbackTransaction() 回滚事务
static <T> boolean	updateEntity(Class<T> entityClass, long id, Map<String,Object> fieldMap) 更新实体

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

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

构造器详细资料

DBHelper

public DBHelper()

方法详细资料

getConnection

public static Connection getConnection(String poolname)

获取数据库连接

参数:

poolname - the poolname

返回:

the connection

getConnection

public static Connection getConnection()

Gets connection.

返回:

the connection

beginTransaction

public static void beginTransaction()

开启事务

commitTransaction

public static void commitTransaction()

提交事务

rollbackTransaction

public static void rollbackTransaction()

回滚事务

initSQL

public static void initSQL(String sqlPath)

初始化 SQL 脚本

参数:

sqlPath - the sql path

queryRows

public static List<Map<String,Object>> queryRows(String sql,
                                                 Object... params)

执行查询语句

参数:

sql - the sql

params - the params

返回:

the list

queryOneRow

public static Map<String,Object> queryOneRow(String sql,
                                             Object... params)

Query one row map.

参数:

sql - the sql

params - the params

返回:

the map

queryField

public static String queryField(String sql,
                                String columnName,
                                Object... params)

Query field string.

参数:

sql - the sql

columnName - the column name

params - the params

返回:

the string

hasRecord

public static boolean hasRecord(String sql,
                                Object... params)

Has record boolean.

参数:

sql - the sql

params - the params

返回:

the boolean

executeUpdate

public static int executeUpdate(String sql,
                                Object... params)

执行更新语句（包括：update、insert、delete）

参数:

sql - the sql

params - the params

返回:

the int

queryEntityList

public static <T> List<T> queryEntityList(Class<T> entityClass,
                                          String sql,
                                          Object... params)

查询实体列表

类型参数:

T - the type parameter

参数:

entityClass - the entity class

sql - the sql

params - the params

返回:

the list

queryEntity

public static <T> T queryEntity(Class<T> entityClass,
                                String sql,
                                Object... params)

查询实体

类型参数:

T - the type parameter

参数:

entityClass - the entity class

sql - the sql

params - the params

返回:

the t

insertEntity

public static <T> boolean insertEntity(Class<T> entityClass,
                                       Map<String,Object> fieldMap)

插入实体

类型参数:

T - the type parameter

参数:

entityClass - the entity class

fieldMap - the field map

返回:

the boolean

updateEntity

public static <T> boolean updateEntity(Class<T> entityClass,
                                       long id,
                                       Map<String,Object> fieldMap)

更新实体

类型参数:

T - the type parameter

参数:

entityClass - the entity class

id - the id

fieldMap - the field map

返回:

the boolean

deleteEntity

public static <T> boolean deleteEntity(Class<T> entityClass,
                                       long id)

删除实体

类型参数:

T - the type parameter

参数:

entityClass - the entity class

id - the id

返回:

the boolean

queryCount

public long queryCount(String sql,
                       Object... params)

Query count long.

参数:

sql - the sql

params - the params

返回:

the long