org.b3log.latke.repository.jdbc.util

Class JdbcUtil

java.lang.Object

org.b3log.latke.repository.jdbc.util.JdbcUtil

public final class JdbcUtil
extends Object

JDBC utilities.

Version:

1.1.2.8, May 17, 2019

Author:

Love Yao, Liang Ding

Method Summary

Modifier and Type	Method and Description
static boolean	executeSql(String sql, Connection connection, boolean isDebug) Executes the specified SQL with the specified connection.
static boolean	executeSql(String sql, List<Object> paramList, Connection connection, boolean isDebug) Executes the specified SQL with the specified params and connection...
static void	fromOracleClobEmpty(JSONObject jsonObject) Process Oracle CLOB empty string.
static JSONArray	queryJsonArray(String sql, List<Object> paramList, Connection connection, String tableName, boolean isDebug) queryJsonArray.
static JSONObject	queryJsonObject(String sql, List<Object> paramList, Connection connection, String tableName, boolean isDebug) queryJsonObject.

Methods inherited from class java.lang.Object

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

Method Detail

executeSql

public static boolean executeSql(String sql,
                                 Connection connection,
                                 boolean isDebug)
                          throws SQLException

Executes the specified SQL with the specified connection.

Parameters:

sql - the specified SQL

connection - connection the specified connection

isDebug - the specified debug flag

Returns:

true if success, returns false otherwise

Throws:

SQLException - SQLException

executeSql

public static boolean executeSql(String sql,
                                 List<Object> paramList,
                                 Connection connection,
                                 boolean isDebug)
                          throws SQLException

Executes the specified SQL with the specified params and connection...

Parameters:

sql - the specified SQL

paramList - the specified params

connection - the specified connection

isDebug - the specified debug flag

Returns:

true if success, returns false otherwise

Throws:

SQLException - SQLException

queryJsonObject

public static JSONObject queryJsonObject(String sql,
                                         List<Object> paramList,
                                         Connection connection,
                                         String tableName,
                                         boolean isDebug)
                                  throws SQLException,
                                         JSONException,
                                         RepositoryException

queryJsonObject.

Parameters:

sql - sql

paramList - paramList

connection - connection

tableName - tableName

isDebug - the specified debug flag

Returns:

JSONObject only one record.

Throws:

SQLException - SQLException

JSONException - JSONException

RepositoryException - repositoryException

queryJsonArray

public static JSONArray queryJsonArray(String sql,
                                       List<Object> paramList,
                                       Connection connection,
                                       String tableName,
                                       boolean isDebug)
                                throws SQLException,
                                       JSONException,
                                       RepositoryException

queryJsonArray.

Parameters:

sql - sql

paramList - paramList

connection - connection

tableName - tableName

isDebug - the specified debug flag

Returns:

JSONArray

Throws:

SQLException - SQLException

JSONException - JSONException

RepositoryException - repositoryException

fromOracleClobEmpty

public static void fromOracleClobEmpty(JSONObject jsonObject)

Process Oracle CLOB empty string.

Parameters:

jsonObject - the specified JSON object