com.erlitech.ejava.utils

Class XdbUtil

java.lang.Object

com.erlitech.ejava.utils.XdbUtil

public class XdbUtil
extends Object

jdbc操作类 V2.0 2017-11-08

Author:

孙振强

Field Summary

Fields

Modifier and Type	Field and Description
static String	allowResultNull
static HashMap<String,Connection>	connectionMap
static String	propertyName

Constructor Summary

Constructors

Constructor and Description
XdbUtil()

Method Summary

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

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

connectionMap

public static HashMap<String,Connection> connectionMap

Constructor Detail

XdbUtil

public XdbUtil()

Method Detail

getConnection

public static Connection getConnection(String jdbcName)
                                throws SQLException

获得数据库的连接

Throws:

SQLException - SQL错误捕获

readList

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

查询多条记录

Parameters:

xql - xql对象

Returns:

查询结果JSONArray

readList

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

readOne

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

查询单条记录

Parameters:

xql - xql对象

Returns:

查询结果JSONObject

readOne

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

readValue

public static String readValue(XqlUtil xql,
                               String key)

查询单条记录单值

Parameters:

xql - xql对象

key - 查询字段

Returns:

查询结果String

readValue

public static String readValue(XqlUtil xql,
                               String key,
                               String jdbcName)

readNum

public static Integer readNum(XqlUtil xql)

查询记录数, 输入xql

Parameters:

xql - xql对象

Returns:

查询结果Integer

readNum

public static Integer readNum(XqlUtil xql,
                              String jdbcName)

select

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

查询记录, 输入sql

Parameters:

sql - 查询SQL语句

Returns:

查询结果JSONArray

select

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

executeQuery

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

执行SQL，查

Parameters:

sql - 查询SQL语句

Returns:

查询结果JSONArray

executeQuery

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

readNumBySql

public static Integer readNumBySql(String sql)

查询记录数, 输入sql

Parameters:

sql - 查询SQL语句

Returns:

查询结果Integer

readNumBySql

public static Integer readNumBySql(String sql,
                                   String jdbcName)

readNumBySqlCount

public static Integer readNumBySqlCount(String sql)

查询记录数, 输入sql, 获取count

Parameters:

sql - 查询SQL语句

Returns:

查询结果Integer

readNumBySqlCount

public static Integer readNumBySqlCount(String sql,
                                        String jdbcName)

insert

public static String insert(XqlUtil xql)

新增记录

Parameters:

xql - xql对象

Returns:

新增记录主键

insert

public static String insert(XqlUtil xql,
                            String jdbcName)

delete

public static Integer delete(XqlUtil xql)

删除记录

Parameters:

xql - xql对象

Returns:

删除记录数

delete

public static Integer delete(XqlUtil xql,
                             String jdbcName)

update

public static Integer update(XqlUtil xql)

修改记录

Parameters:

xql - xql对象

Returns:

修改记录数

update

public static Integer update(XqlUtil xql,
                             String jdbcName)

executeUpdate

public static Integer executeUpdate(String sql)

执行SQL，增、删、改

Parameters:

sql - SQL语句

Returns:

执行结果

executeUpdate

public static Integer executeUpdate(String sql,
                                    String jdbcName)

executeInsert

public static String executeInsert(String sql)

执行SQL，增

Parameters:

sql - SQL语句

Returns:

执行结果

executeInsert

public static String executeInsert(String sql,
                                   String jdbcName)

executeBatchStaticSQL

public static boolean executeBatchStaticSQL(List<String> list)

执行SQL，批量，无返回

Parameters:

list - SQL语句List

executeBatchStaticSQL

public static boolean executeBatchStaticSQL(List<String> list,
                                            String jdbcName)

closeConnection

public static void closeConnection()

关闭Connection

closeConnection

public static void closeConnection(String jdbcName)

insertList

public static void insertList(List<XqlUtil> listXql)

新增记录，批量Xql

Parameters:

listXql - Xql对象List

insertList

public static void insertList(List<XqlUtil> listXql,
                              String jdbcName)

insertJaListWithTableName

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

新增记录，批量数据

Parameters:

table - 表名

jaList - 数据 JSONArray

insertJaListWithTableName

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