Package com.storedobject.core

Class RawSQL

java.lang.Object

com.storedobject.core.RawSQL

All Implemented Interfaces:

ResourceOwner

public final class RawSQL
extends Object
implements ResourceOwner

This class is for internal purpose only.

Field Summary

Fields

Modifier and Type	Field	Description
static final int	CLOSED
static final int	COMPILE
static boolean	debug
static final int	EOQ
static final int	RUNNING
static final int	SOQ

Method Summary

Modifier and Type	Method	Description
void	addSQL(String sql)
void	cancel()
void	close()
void	commit()
static Process	dumpDatabase(String securityPassword, boolean sql, String databaseName)	Dump data of a given database.
boolean	eoq()
boolean	execute()
boolean	execute(String sql)
int	executeUpdate()
int	executeUpdate(String sql)
boolean	getAutoNext()
static SQLConnector	getConnector()
DatabaseMetaData	getDatabaseMetaData()
int	getError()
static SQLNullConnectionHandler	getNullConnectionHandler()
AutoCloseable	getResource()	Get the "resource" owned by this "resource owner".
ResultSet	getResult()
long	getRowCount()
String	getSQL()
int	getState()
Statement	getStatement()
void	logWarnings(SQLException w)
boolean	next()
PreparedStatement	prepare(String sql)
CallableStatement	prepareCall(String sql)
static Process	restoreDatabase(String securityPassword, String databaseName)	Restore data to a given database.
void	rollback()
void	setAutoCommit(boolean mode)
void	setAutoNext(boolean autoNext)
static void	setConnector(SQLConnector connector)
void	setError(int error)
static void	setNullConnectionHandler(SQLNullConnectionHandler handler)
void	setSQL(String sql)
long	skip()
long	skip(long rows)

Methods inherited from class java.lang.Object

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

Field Details

debug

public static boolean debug

RUNNING

public static final int RUNNING

See Also:

• Constant Field Values

SOQ

public static final int SOQ

See Also:

• Constant Field Values

EOQ

public static final int EOQ

See Also:

• Constant Field Values

COMPILE

public static final int COMPILE

See Also:

• Constant Field Values

CLOSED

public static final int CLOSED

See Also:

• Constant Field Values

Method Details

getResource

public AutoCloseable getResource()

Description copied from interface: ResourceOwner

Get the "resource" owned by this "resource owner".

Specified by:

getResource in interface ResourceOwner

Returns:

The "resource" owned by this "resource owner".

setAutoNext

public void setAutoNext(boolean autoNext)

getAutoNext

public boolean getAutoNext()

getError

public int getError()

setError

public void setError(int error)

setSQL

public void setSQL(String sql)

addSQL

public void addSQL(String sql)

getSQL

public String getSQL()

getDatabaseMetaData

public DatabaseMetaData getDatabaseMetaData()
                                     throws Exception

Throws:

Exception

prepare

public PreparedStatement prepare(String sql)

prepareCall

public CallableStatement prepareCall(String sql)
                              throws Exception

Throws:

Exception

getStatement

public Statement getStatement()
                       throws SQLException

Throws:

SQLException

executeUpdate

public int executeUpdate(String sql)

executeUpdate

public int executeUpdate()

execute

public boolean execute(String sql)

execute

public boolean execute()

cancel

public void cancel()

close

public void close()

next

public boolean next()

skip

public long skip()

skip

public long skip(long rows)

getRowCount

public long getRowCount()

eoq

public boolean eoq()

getState

public int getState()

getResult

public ResultSet getResult()

setNullConnectionHandler

public static void setNullConnectionHandler(SQLNullConnectionHandler handler)

getNullConnectionHandler

public static SQLNullConnectionHandler getNullConnectionHandler()

setConnector

public static void setConnector(SQLConnector connector)

getConnector

public static SQLConnector getConnector()

logWarnings

public void logWarnings(SQLException w)
                 throws Error_Running_SQL

Throws:

Error_Running_SQL

rollback

public void rollback()

commit

public void commit()

setAutoCommit

public void setAutoCommit(boolean mode)

dumpDatabase

public static Process dumpDatabase(String securityPassword,
 boolean sql,
 String databaseName)

Dump data of a given database.

Parameters:

securityPassword - Security password.

sql - True if download as plain SQL statements.

databaseName - Database name (if null is passed, current DB is dumped).

Returns:

Data dumping process. The OutputStream of the process will stream out the data.

restoreDatabase

public static Process restoreDatabase(String securityPassword,
 String databaseName)

Restore data to a given database.

Parameters:

securityPassword - Security password.

databaseName - Name of the database to restore.

Returns:

Data loading process. The InputStream of the process can accept SQL commands for restoring the data.