com.erlitech.ejava.utils

Class XdbUtil

java.lang.Object

com.erlitech.ejava.utils.XdbUtil

public class XdbUtil
extends Object

jdbc操作类

Author:

孙振强

Field Summary

Fields

Modifier and Type	Field and Description
static String	allowResultNull
static String	propertyName

Constructor Summary

Constructors

Constructor and Description
XdbUtil()

Method Summary

Modifier and Type	Method and Description
static void	closeConnection() 关闭Connection
static Integer	delete(XqlUtil xql) 删除记录
static void	executeBatchStaticSQL(List<String> list) 执行SQL，批量，无返回
static String	executeInsert(String sql) 执行SQL，增
static com.alibaba.fastjson.JSONArray	executeQuery(String sql) 执行SQL，查
static Integer	executeUpdate(String sql) 执行SQL，增、删、改
static void	getConnection() 获得数据库的连接
static String	insert(XqlUtil xql) 新增记录
static void	insertJaListWithTableName(String table, com.alibaba.fastjson.JSONArray jaList) 新增记录，批量数据
static void	insertList(List<XqlUtil> listXql) 新增记录，批量Xql
static com.alibaba.fastjson.JSONArray	readList(XqlUtil xql) 查询多条记录
static Integer	readNum(XqlUtil xql) 查询记录数, 输入xql
static Integer	readNumBySql(String sql) 查询记录数, 输入sql
static com.alibaba.fastjson.JSONObject	readOne(XqlUtil xql) 查询单条记录
static String	readValue(XqlUtil xql, String key) 查询单条记录单值
static com.alibaba.fastjson.JSONArray	select(String sql) 查询记录, 输入sql
static Integer	update(XqlUtil xql) 修改记录

Methods inherited from class java.lang.Object

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

Field Detail

propertyName

public static String propertyName

allowResultNull

public static String allowResultNull

Constructor Detail

XdbUtil

public XdbUtil()

Method Detail

getConnection

public static void getConnection()
                          throws SQLException

获得数据库的连接

Throws:

SQLException - SQL错误捕获

readList

public static com.alibaba.fastjson.JSONArray readList(XqlUtil xql)

查询多条记录

Parameters:

xql - xql对象

Returns:

查询结果JSONArray

readOne

public static com.alibaba.fastjson.JSONObject readOne(XqlUtil xql)

查询单条记录

Parameters:

xql - xql对象

Returns:

查询结果JSONObject

readValue

public static String readValue(XqlUtil xql,
                               String key)

查询单条记录单值

Parameters:

xql - xql对象

key - 查询字段

Returns:

查询结果String

readNum

public static Integer readNum(XqlUtil xql)

查询记录数, 输入xql

Parameters:

xql - xql对象

Returns:

查询结果Integer

select

public static com.alibaba.fastjson.JSONArray select(String sql)

查询记录, 输入sql

Parameters:

sql - 查询SQL语句

Returns:

查询结果JSONArray

executeQuery

public static com.alibaba.fastjson.JSONArray executeQuery(String sql)

执行SQL，查

Parameters:

sql - 查询SQL语句

Returns:

查询结果JSONArray

readNumBySql

public static Integer readNumBySql(String sql)

查询记录数, 输入sql

Parameters:

sql - 查询SQL语句

Returns:

查询结果Integer

insert

public static String insert(XqlUtil xql)

新增记录

Parameters:

xql - xql对象

Returns:

新增记录主键

delete

public static Integer delete(XqlUtil xql)

删除记录

Parameters:

xql - xql对象

Returns:

删除记录数

update

public static Integer update(XqlUtil xql)

修改记录

Parameters:

xql - xql对象

Returns:

修改记录数

executeUpdate

public static Integer executeUpdate(String sql)

执行SQL，增、删、改

Parameters:

sql - SQL语句

Returns:

执行结果

executeInsert

public static String executeInsert(String sql)

执行SQL，增

Parameters:

sql - SQL语句

Returns:

执行结果

executeBatchStaticSQL

public static void executeBatchStaticSQL(List<String> list)

执行SQL，批量，无返回

Parameters:

list - SQL语句List

closeConnection

public static void closeConnection()

关闭Connection

insertList

public static void insertList(List<XqlUtil> listXql)

新增记录，批量Xql

Parameters:

listXql - Xql对象List

insertJaListWithTableName

public static void insertJaListWithTableName(String table,
                                             com.alibaba.fastjson.JSONArray jaList)

新增记录，批量数据

Parameters:

table - 表名

jaList - 数据 JSONArray