Package x.data.skydb

Class SkyDataSkyDBSupport

java.lang.Object

x.data.skydb.SkyDataSkyDBSupport

All Implemented Interfaces:

Serializable, SkyDataEntity

public class SkyDataSkyDBSupport
extends Object
implements Serializable, SkyDataEntity

The SkyDatabaseSupport utility for use in SkyLogicSystem.

Author:

Sakdsitt Likhitmetagool

See Also:

• Serialized Form

Constructor Summary

Constructors

Constructor	Description
SkyDataSkyDBSupport()

Method Summary

Modifier and Type	Method	Description
void	addIndex(String columnName)
SkyDataEntity	and(String entityName, Object entityValue)	Setup with condition for AND.
SkyDataEntity	and(String entityName, Object entityValue, Boolean likeFlag)	Setup with condition withOR LIKE flag.
SkyDataEntity	and(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4)
SkyDataEntity	and(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4, Object entityValue5, Object entityValue6, Object entityValue7, Object entityValue8)
SkyDataEntity	and(String entityName, Object entityValue1, Object entityValue2, String operation)	Setup with condition and 4 parameters.
SkyDataEntity	and(String entityName, Object entityValue, String operation)	Setup with condition and Operation.
SkyDataEntity	asc()	ASC order sort.
void	checkObject()	Check Condition object.
void	clearValue()	Clear value before new call.
static void	connect(String schemaName)	Open SQL SkyDatabase connection.
static void	connect(String schemaName, String entityName)	Open SQL SkyDatabase connection.
void	createIndex()
void	createIndex(String columnName)	Create index by default Model.
void	createTable()	Create table by default Model.
void	delete(XData obj)	Delete default model class data from database.
SkyDataEntity	desc()	ASC order sort.
void	dropTable()	Drop table by default Model.
Collection<XData>	execute()	Return query result relate with setup parameter.
XData	execute1()	Return query result just only one record (first object record).
Collection<XData>	find(String hql)	Find set of default model class data from database by CQL.
Collection<XData>	find(String hql, Object[] args)	Find set of default model class data from database by CQL.
XDataModel	getDataModel()	Check Condition object.
XDataModel	getDataModel(String dataModel)	Check Condition object.
XDataModel	getModel()
String	getName()	Get object name.
boolean	haveDeleteRight()	xxx
boolean	haveReadRight()	xxx
boolean	haveUpdateRight()	xxx
SkyDataEntity	id(Long id)	Set id to SkyDataEntity for load function.
SkyDataEntity	id(String id)	Set id to SkyDataEntity for load function.
SkyDataEntity	in()
SkyDataEntity	in(String dataModelName)	xxx
SkyDataEntity	in(SCIn in)	xxx
SkyDataEntity	index(String indexName)	Setup index object.
Iterable<String>	listTables()
XData	load()	Load default model class data from database relate with setup id.
XData	load(Long id)	Load any model class data from database.
XData	load(String id)	Load any model class data from database.
SkyDataEntity	loadAll()	loadAll.
SkyDataEntity	max(int i)	Set max result.
SkyDataEntity	model(String dataModelName)	Get Data Model
SkyDataEntity	modelx(String dataModelName)	Get System Data Model
SkyDataEntity	or(String entityName, Object entityValue)	Setup with condition for OR.
SkyDataEntity	or(String entityName, Object entityValue, Boolean likeFlag)	Setup with condition or LIKE flag.
SkyDataEntity	or(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4)
SkyDataEntity	or(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4, Object entityValue5, Object entityValue6, Object entityValue7, Object entityValue8)
SkyDataEntity	or(String entityName, Object entityValue1, Object entityValue2, String operation)	Setup with condition or 4 parameters.
SkyDataEntity	or(String entityName, Object entityValue, String operation)	Setup with condition or Operation.
SkyDataEntity	order(String entityName)	Setup order condition.
SkyDataEntity	q(String likeCondition)	Query Like Condition.
SkyDataEntity	qlike(String likeCondition)
String	queryString()	Return query string.
void	reset()	Clear value before new call.
void	save(XData obj)	Save default model class data to database.
SkyDataEntity	select(String selectObject)	Setup select object.
SkyDataEntity	sort(String sortType)	Setup sort type.
SkyDataEntity	sys()	xxx
SkyDataEntity	with(String entityName, Object entityValue)	Setup with condition.
SkyDataEntity	with(String entityName, Object entityValue, Boolean likeFlag)	Setup with condition with LIKE flag.
SkyDataEntity	with(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4)
SkyDataEntity	with(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4, Object entityValue5, Object entityValue6, Object entityValue7, Object entityValue8)
SkyDataEntity	with(String entityName, Object entityValue1, Object entityValue2, String operation)	Setup with condition with 4 parameters.
SkyDataEntity	with(String entityName, Object entityValue, String operation)	Setup with condition with Operation.
SkyDataEntity	withAND(String entityName, Object entityValue)	Setup with condition for AND.
SkyDataEntity	withAND(String entityName, Object entityValue, Boolean likeFlag)	Setup with condition withAND LIKE flag.
SkyDataEntity	withAND(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4)
SkyDataEntity	withAND(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4, Object entityValue5, Object entityValue6, Object entityValue7, Object entityValue8)
SkyDataEntity	withAND(String entityName, Object entityValue1, Object entityValue2, String operation)	Setup with condition withAND 4 parameters.
SkyDataEntity	withAND(String entityName, Object entityValue, String operation)	Setup with condition withAND Operation.
SkyDataEntity	withOR(String entityName, Object entityValue)	Setup with condition for OR.
SkyDataEntity	withOR(String entityName, Object entityValue, Boolean likeFlag)	Setup with condition withOR LIKE flag.
SkyDataEntity	withOR(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4)
SkyDataEntity	withOR(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4, Object entityValue5, Object entityValue6, Object entityValue7, Object entityValue8)
SkyDataEntity	withOR(String entityName, Object entityValue1, Object entityValue2, String operation)	Setup with condition withOR 4 parameters.
SkyDataEntity	withOR(String entityName, Object entityValue, String operation)	Setup with condition withOR Operation.

Methods inherited from class java.lang.Object

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

Constructor Details

SkyDataSkyDBSupport

public SkyDataSkyDBSupport()

Method Details

save

public void save(XData obj)
          throws Exception

Save default model class data to database.

Specified by:

save in interface SkyDataEntity

Throws:

Exception

delete

public void delete(XData obj)
            throws Exception

Delete default model class data from database.

Specified by:

delete in interface SkyDataEntity

Throws:

Exception

load

public XData load(Long id)
           throws Exception

Load any model class data from database.

Specified by:

load in interface SkyDataEntity

Throws:

Exception

load

public XData load(String id)
           throws Exception

Load any model class data from database.

Specified by:

load in interface SkyDataEntity

Throws:

Exception

max

public SkyDataEntity max(int i)
                  throws Exception

Set max result.

Specified by:

max in interface SkyDataEntity

Throws:

Exception

checkObject

public void checkObject()
                 throws Exception

Check Condition object.

Throws:

Exception

getDataModel

public XDataModel getDataModel()
                        throws Exception

Check Condition object.

Throws:

Exception

getDataModel

public XDataModel getDataModel(String dataModel)
                        throws Exception

Check Condition object.

Throws:

Exception

select

public SkyDataEntity select(String selectObject)
                     throws Exception

Setup select object.

Specified by:

select in interface SkyDataEntity

Throws:

Exception

index

public SkyDataEntity index(String indexName)
                    throws Exception

Setup index object.

Specified by:

index in interface SkyDataEntity

Throws:

Exception

with

public SkyDataEntity with(String entityName,
 Object entityValue)
                   throws Exception

Setup with condition.

Specified by:

with in interface SkyDataEntity

Throws:

Exception

with

public SkyDataEntity with(String entityName,
 Object entityValue,
 Boolean likeFlag)
                   throws Exception

Setup with condition with LIKE flag.

Specified by:

with in interface SkyDataEntity

Throws:

Exception

with

public SkyDataEntity with(String entityName,
 Object entityValue,
 String operation)
                   throws Exception

Setup with condition with Operation.

Specified by:

with in interface SkyDataEntity

Throws:

Exception

with

public SkyDataEntity with(String entityName,
 Object entityValue1,
 Object entityValue2,
 String operation)
                   throws Exception

Setup with condition with 4 parameters.

Specified by:

with in interface SkyDataEntity

Throws:

Exception

with

public SkyDataEntity with(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4)
                   throws Exception

Specified by:

with in interface SkyDataEntity

Throws:

Exception

with

public SkyDataEntity with(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4,
 Object entityValue5,
 Object entityValue6,
 Object entityValue7,
 Object entityValue8)
                   throws Exception

Specified by:

with in interface SkyDataEntity

Throws:

Exception

or

public SkyDataEntity or(String entityName,
 Object entityValue)
                 throws Exception

Setup with condition for OR.

Specified by:

or in interface SkyDataEntity

Throws:

Exception

or

public SkyDataEntity or(String entityName,
 Object entityValue,
 Boolean likeFlag)
                 throws Exception

Setup with condition or LIKE flag.

Specified by:

or in interface SkyDataEntity

Throws:

Exception

or

public SkyDataEntity or(String entityName,
 Object entityValue,
 String operation)
                 throws Exception

Setup with condition or Operation.

Specified by:

or in interface SkyDataEntity

Throws:

Exception

or

public SkyDataEntity or(String entityName,
 Object entityValue1,
 Object entityValue2,
 String operation)
                 throws Exception

Setup with condition or 4 parameters.

Specified by:

or in interface SkyDataEntity

Throws:

Exception

or

public SkyDataEntity or(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4)
                 throws Exception

Specified by:

or in interface SkyDataEntity

Throws:

Exception

or

public SkyDataEntity or(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4,
 Object entityValue5,
 Object entityValue6,
 Object entityValue7,
 Object entityValue8)
                 throws Exception

Specified by:

or in interface SkyDataEntity

Throws:

Exception

withOR

public SkyDataEntity withOR(String entityName,
 Object entityValue)
                     throws Exception

Setup with condition for OR.

Specified by:

withOR in interface SkyDataEntity

Throws:

Exception

withOR

public SkyDataEntity withOR(String entityName,
 Object entityValue,
 Boolean likeFlag)
                     throws Exception

Setup with condition withOR LIKE flag.

Specified by:

withOR in interface SkyDataEntity

Throws:

Exception

withOR

public SkyDataEntity withOR(String entityName,
 Object entityValue,
 String operation)
                     throws Exception

Setup with condition withOR Operation.

Specified by:

withOR in interface SkyDataEntity

Throws:

Exception

withOR

public SkyDataEntity withOR(String entityName,
 Object entityValue1,
 Object entityValue2,
 String operation)
                     throws Exception

Setup with condition withOR 4 parameters.

Specified by:

withOR in interface SkyDataEntity

Throws:

Exception

withOR

public SkyDataEntity withOR(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4)
                     throws Exception

Specified by:

withOR in interface SkyDataEntity

Throws:

Exception

withOR

public SkyDataEntity withOR(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4,
 Object entityValue5,
 Object entityValue6,
 Object entityValue7,
 Object entityValue8)
                     throws Exception

Specified by:

withOR in interface SkyDataEntity

Throws:

Exception

and

public SkyDataEntity and(String entityName,
 Object entityValue)
                  throws Exception

Setup with condition for AND.

Specified by:

and in interface SkyDataEntity

Throws:

Exception

and

public SkyDataEntity and(String entityName,
 Object entityValue,
 Boolean likeFlag)
                  throws Exception

Setup with condition withOR LIKE flag.

Specified by:

and in interface SkyDataEntity

Throws:

Exception

and

public SkyDataEntity and(String entityName,
 Object entityValue,
 String operation)
                  throws Exception

Setup with condition and Operation.

Specified by:

and in interface SkyDataEntity

Throws:

Exception

and

public SkyDataEntity and(String entityName,
 Object entityValue1,
 Object entityValue2,
 String operation)
                  throws Exception

Setup with condition and 4 parameters.

Specified by:

and in interface SkyDataEntity

Throws:

Exception

and

public SkyDataEntity and(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4)
                  throws Exception

Specified by:

and in interface SkyDataEntity

Throws:

Exception

and

public SkyDataEntity and(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4,
 Object entityValue5,
 Object entityValue6,
 Object entityValue7,
 Object entityValue8)
                  throws Exception

Specified by:

and in interface SkyDataEntity

Throws:

Exception

withAND

public SkyDataEntity withAND(String entityName,
 Object entityValue)
                      throws Exception

Setup with condition for AND.

Specified by:

withAND in interface SkyDataEntity

Throws:

Exception

withAND

public SkyDataEntity withAND(String entityName,
 Object entityValue,
 Boolean likeFlag)
                      throws Exception

Setup with condition withAND LIKE flag.

Specified by:

withAND in interface SkyDataEntity

Throws:

Exception

withAND

public SkyDataEntity withAND(String entityName,
 Object entityValue,
 String operation)
                      throws Exception

Setup with condition withAND Operation.

Specified by:

withAND in interface SkyDataEntity

Throws:

Exception

withAND

public SkyDataEntity withAND(String entityName,
 Object entityValue1,
 Object entityValue2,
 String operation)
                      throws Exception

Setup with condition withAND 4 parameters.

Specified by:

withAND in interface SkyDataEntity

Throws:

Exception

withAND

public SkyDataEntity withAND(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4)
                      throws Exception

Specified by:

withAND in interface SkyDataEntity

Throws:

Exception

withAND

public SkyDataEntity withAND(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4,
 Object entityValue5,
 Object entityValue6,
 Object entityValue7,
 Object entityValue8)
                      throws Exception

Specified by:

withAND in interface SkyDataEntity

Throws:

Exception

order

public SkyDataEntity order(String entityName)
                    throws Exception

Setup order condition.

Specified by:

order in interface SkyDataEntity

Throws:

Exception

q

public SkyDataEntity q(String likeCondition)
                throws Exception

Query Like Condition.

Specified by:

q in interface SkyDataEntity

Throws:

Exception

qlike

public SkyDataEntity qlike(String likeCondition)
                    throws Exception

Specified by:

qlike in interface SkyDataEntity

Throws:

Exception

sort

public SkyDataEntity sort(String sortType)
                   throws Exception

Setup sort type.

Specified by:

sort in interface SkyDataEntity

Throws:

Exception

asc

public SkyDataEntity asc()
                  throws Exception

ASC order sort.

Specified by:

asc in interface SkyDataEntity

Throws:

Exception

desc

public SkyDataEntity desc()
                   throws Exception

ASC order sort.

Specified by:

desc in interface SkyDataEntity

Throws:

Exception

loadAll

public SkyDataEntity loadAll()
                      throws Exception

loadAll.

Specified by:

loadAll in interface SkyDataEntity

Throws:

Exception

execute

public Collection<XData> execute()
                          throws Exception

Return query result relate with setup parameter.

Specified by:

execute in interface SkyDataEntity

Throws:

Exception

execute1

public XData execute1()
               throws Exception

Return query result just only one record (first object record).

Specified by:

execute1 in interface SkyDataEntity

Throws:

Exception

clearValue

public void clearValue()

Clear value before new call.

reset

public void reset()

Clear value before new call.

Specified by:

reset in interface SkyDataEntity

createTable

public void createTable()
                 throws Exception

Create table by default Model.

Specified by:

createTable in interface SkyDataEntity

Throws:

Exception

createIndex

public void createIndex(String columnName)
                 throws Exception

Create index by default Model.

Throws:

Exception

dropTable

public void dropTable()
               throws Exception

Drop table by default Model.

Specified by:

dropTable in interface SkyDataEntity

Throws:

Exception

in

public SkyDataEntity in()

Specified by:

in in interface SkyDataEntity

in

public SkyDataEntity in(String dataModelName)

xxx

modelx

public SkyDataEntity modelx(String dataModelName)
                     throws Exception

Get System Data Model

Specified by:

modelx in interface SkyDataEntity

Throws:

Exception

model

public SkyDataEntity model(String dataModelName)
                    throws Exception

Get Data Model

Specified by:

model in interface SkyDataEntity

Throws:

Exception

getModel

public XDataModel getModel()
                    throws Exception

Specified by:

getModel in interface SkyDataEntity

Throws:

Exception

in

public SkyDataEntity in(SCIn in)

xxx

Specified by:

in in interface SkyDataEntity

sys

public SkyDataEntity sys()

xxx

Specified by:

sys in interface SkyDataEntity

id

public SkyDataEntity id(Long id)
                 throws Exception

Set id to SkyDataEntity for load function.

Specified by:

id in interface SkyDataEntity

Throws:

Exception

id

public SkyDataEntity id(String id)
                 throws Exception

Set id to SkyDataEntity for load function.

Specified by:

id in interface SkyDataEntity

Throws:

Exception

load

public XData load()
           throws Exception

Load default model class data from database relate with setup id.

Specified by:

load in interface SkyDataEntity

Throws:

Exception

getName

public String getName()
               throws Exception

Get object name.

Throws:

Exception

haveReadRight

public boolean haveReadRight()

xxx

haveUpdateRight

public boolean haveUpdateRight()

xxx

haveDeleteRight

public boolean haveDeleteRight()

xxx

addIndex

public void addIndex(String columnName)
              throws Exception

Specified by:

addIndex in interface SkyDataEntity

Throws:

Exception

connect

public static void connect(String schemaName)

Open SQL SkyDatabase connection.

connect

public static void connect(String schemaName,
 String entityName)

Open SQL SkyDatabase connection.

listTables

public Iterable<String> listTables()
                            throws Exception

Specified by:

listTables in interface SkyDataEntity

Throws:

Exception

find

public Collection<XData> find(String hql)
                       throws Exception

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

Specified by:

find in interface SkyDataEntity

Throws:

Exception

find

public Collection<XData> find(String hql,
 Object[] args)
                       throws Exception

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

Specified by:

find in interface SkyDataEntity

Throws:

Exception

queryString

public String queryString()
                   throws Exception

Return query string.

Specified by:

queryString in interface SkyDataEntity

Throws:

Exception

createIndex

public void createIndex()
                 throws Exception

Specified by:

createIndex in interface SkyDataEntity

Throws:

Exception