Package x.data.sql.mysql

Class SkyDataMySQLCommon

java.lang.Object

x.data.sql.mysql.SkyDataMySQLUtils

x.data.sql.mysql.SkyDataMySQLCommon

public class SkyDataMySQLCommon
extends SkyDataMySQLUtils

The SkyDatabaseSupport utility for use in SkyLogicSystem.

Author:

Sakdsitt Likhitmetagool

Constructor Summary

Constructors

Constructor	Description
SkyDataMySQLCommon()

Method Summary

Modifier and Type	Method	Description
static void	createIndex(String columnName, XDataModel dataModelObj)	Create index by default Model.
static void	createTable(XDataModel dataModelObj)	Create table by default Model.
static void	delete(XData obj, XDataModel dataModelObj)	Delete default model class data from database.
static void	dropTable(XDataModel dataModelObj)	Drop table by default Model.
static Collection<XData>	find(String hql, Object[] args, XDataModel dataModelObj, boolean systemData, MySQLParameter parameters)	Find set of default model class data from database by CQL.
static Collection<XData>	find(String hql, XDataModel dataModelObj, boolean systemData, MySQLParameter parameters)	Find set of default model class data from database by CQL.
static XDataModel	getDataModel(String dataModelName, boolean systemData)	Check Condition object.
static SkyDataMySQLCommon	getInstance()	xxxx
static String	java2dbDatatype(String javaDatatype)	Transform.
static XData	load(Long id, XDataModel dataModelObj, boolean systemData)	Load any model class data from database.
static XData	loadL2(Long id, String model, boolean loadBigField, boolean systemData)	Load any model class data from database.
static XData	loadL3(Long id, String model, boolean loadBigField, boolean systemData)	Load any model class data from database.
static void	save(XData obj, XDataModel dataModelObj)	Save default model class data to database.

Methods inherited from class x.data.sql.mysql.SkyDataMySQLUtils

chkconnect, chkconnectNative, closeNative, connect, connect, connectNative, executeQuery, executeQueryObject, executeQueryObjects, executeSQL, executeUpdate, executeUpdateObject, executeUpdateObjects

Methods inherited from class java.lang.Object

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

Constructor Details

SkyDataMySQLCommon

public SkyDataMySQLCommon()

Method Details

getInstance

public static SkyDataMySQLCommon getInstance()

xxxx

save

public static void save(XData obj,
 XDataModel dataModelObj)
                 throws Exception

Save default model class data to database.

Throws:

Exception

delete

public static void delete(XData obj,
 XDataModel dataModelObj)
                   throws Exception

Delete default model class data from database.

Throws:

Exception

load

public static XData load(Long id,
 XDataModel dataModelObj,
 boolean systemData)
                  throws Exception

Load any model class data from database.

Throws:

Exception

loadL2

public static XData loadL2(Long id,
 String model,
 boolean loadBigField,
 boolean systemData)
                    throws Exception

Load any model class data from database.

Throws:

Exception

loadL3

public static XData loadL3(Long id,
 String model,
 boolean loadBigField,
 boolean systemData)
                    throws Exception

Load any model class data from database.

Throws:

Exception

find

public static Collection<XData> find(String hql,
 XDataModel dataModelObj,
 boolean systemData,
 MySQLParameter parameters)
                              throws Exception

Find set of default model class data from database by CQL.

Throws:

Exception

find

public static Collection<XData> find(String hql,
 Object[] args,
 XDataModel dataModelObj,
 boolean systemData,
 MySQLParameter parameters)
                              throws Exception

Find set of default model class data from database by CQL.

Throws:

Exception

java2dbDatatype

public static String java2dbDatatype(String javaDatatype)

Transform.

createTable

public static void createTable(XDataModel dataModelObj)
                        throws Exception

Create table by default Model.

Throws:

Exception

createIndex

public static void createIndex(String columnName,
 XDataModel dataModelObj)
                        throws Exception

Create index by default Model.

Throws:

Exception

dropTable

public static void dropTable(XDataModel dataModelObj)
                      throws Exception

Drop table by default Model.

Throws:

Exception

getDataModel

public static XDataModel getDataModel(String dataModelName,
 boolean systemData)
                               throws Exception

Check Condition object.

Throws:

Exception