Package x.data.sql.mysql

Class SkyDataMySQLUtils

java.lang.Object

x.data.sql.mysql.SkyDataMySQLUtils

Direct Known Subclasses:

SkyDataMySQLCommon

public class SkyDataMySQLUtils
extends Object

The Skydata SQL utility for use in SkyLogicSystem.

Author:

Sakdsitt Likhitmetagool

Constructor Summary

Constructors

Constructor	Description
SkyDataMySQLUtils()

Method Summary

Modifier and Type	Method	Description
static void	chkconnect()	Open SQL SkyDatabase connection.
static void	chkconnectNative()	Open SQL SkyDatabase connection.
static void	closeNative()	Close SQL SkyDatabase connection.
static void	connect(String schemaName)	Open SQL SkyDatabase connection.
static void	connect(String schemaName, String entityName)	Open SQL SkyDatabase connection.
static void	connectNative(String schemaName)	Open SQL SkyDatabase connection.
static ResultSet	executeQuery(String sql)	Execute query SkyDatabase by SQL.
static ResultSet	executeQueryObject(String sql, Object[] args)	Execute query SkyDatabase by SQL.
static ResultSet	executeQueryObjects(String sql, Object[] args)	Execute query SkyDatabase by SQL.
static boolean	executeSQL(String sql)	Execute SkyDatabase by SQL.
static int	executeUpdate(String sql)	Execute update SkyDatabase by SQL.
static int	executeUpdateObject(String sql, Object[] args)	Execute update SkyDatabase by SQL.
static int	executeUpdateObjects(String sql, Object[] args)	Execute update SkyDatabase by SQL.

Methods inherited from class java.lang.Object

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

Constructor Details

SkyDataMySQLUtils

public SkyDataMySQLUtils()

Method Details

connect

public static void connect(String schemaName)

Open SQL SkyDatabase connection.

connect

public static void connect(String schemaName,
 String entityName)

Open SQL SkyDatabase connection.

chkconnect

public static void chkconnect()

Open SQL SkyDatabase connection.

connectNative

public static void connectNative(String schemaName)

Open SQL SkyDatabase connection.

chkconnectNative

public static void chkconnectNative()

Open SQL SkyDatabase connection.

executeSQL

public static boolean executeSQL(String sql)
                          throws SQLException,
ClassNotFoundException

Execute SkyDatabase by SQL.

Throws:

SQLException

ClassNotFoundException

executeUpdate

public static int executeUpdate(String sql)
                         throws SQLException,
ClassNotFoundException

Execute update SkyDatabase by SQL.

Throws:

SQLException

ClassNotFoundException

executeUpdateObject

public static int executeUpdateObject(String sql,
 Object[] args)
                               throws SQLException,
ClassNotFoundException

Execute update SkyDatabase by SQL.

Throws:

SQLException

ClassNotFoundException

executeUpdateObjects

public static int executeUpdateObjects(String sql,
 Object[] args)
                                throws SQLException,
ClassNotFoundException

Execute update SkyDatabase by SQL.

Throws:

SQLException

ClassNotFoundException

executeQuery

public static ResultSet executeQuery(String sql)
                              throws SQLException,
ClassNotFoundException

Execute query SkyDatabase by SQL.

Throws:

SQLException

ClassNotFoundException

executeQueryObject

public static ResultSet executeQueryObject(String sql,
 Object[] args)
                                    throws SQLException,
ClassNotFoundException

Execute query SkyDatabase by SQL.

Throws:

SQLException

ClassNotFoundException

executeQueryObjects

public static ResultSet executeQueryObjects(String sql,
 Object[] args)
                                     throws SQLException,
ClassNotFoundException

Execute query SkyDatabase by SQL.

Throws:

SQLException

ClassNotFoundException

closeNative

public static void closeNative()
                        throws ClassNotFoundException,
SQLException

Close SQL SkyDatabase connection.

Throws:

ClassNotFoundException

SQLException