tppt.db
Class SybaseHandler

java.lang.Object
  |
  +--tppt.db.DBHandler
        |
        +--tppt.db.SybaseHandler

public class SybaseHandler

extends DBHandler

SybaseHandler is the class that implements the Sybase dependent methods in order to run the tool on the Sybase. This class extends the DBHandler so it inherits all the implemented methods from its parents but it has its own behavior for the abstract methods and that is reuqired to implement in this class.

Version:

2.0

Author:

Jodie Wu

See Also:

DBHandler

Fields inherited from class tppt.db.DBHandler

connection

Constructor Summary

SybaseHandler()

Method Summary

void	dropStoredProcedures() Drop all the user-created store procedures.
void	dropTables() Clean up the database, including all the user databases and constriants.
boolean	setMaxRowsForTable(java.sql.CallableStatement sp, java.lang.String table) Set up the maximum-rows-per-page for specific table.
boolean	setMaxRowsPerPage() Set up the maximum row per page for all the user created tables.

Methods inherited from class tppt.db.DBHandler

closeConnection, closeReader, dbConnection, dropATable, dropConstraint, dropSP, executeStmt, initDB, initStatement, main, SQLFileExecutor, twoPhaseDBInit

Methods inherited from class java.lang.Object

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

Constructor Detail

SybaseHandler

public SybaseHandler()

Method Detail

dropStoredProcedures

public void dropStoredProcedures()

Drop all the user-created store procedures.

Overrides:

dropStoredProcedures in class DBHandler

See Also:

DBHandler.dropSP(String)

dropTables

public void dropTables()

Clean up the database, including all the user databases and constriants.

Overrides:

dropTables in class DBHandler

See Also:

DBHandler.dropConstraint(String,String), DBHandler.dropATable(String)

setMaxRowsForTable

public boolean setMaxRowsForTable(java.sql.CallableStatement sp,
                                  java.lang.String table)

Set up the maximum-rows-per-page for specific table.

Overrides:

setMaxRowsForTable in class DBHandler

Parameters:

sp - the CallableStatement to execute the maximun-rows setup.

table - the table name.

Returns:

returns true if setup sucessfully, false otherwise.

setMaxRowsPerPage

public boolean setMaxRowsPerPage()

Set up the maximum row per page for all the user created tables.

Overrides:

setMaxRowsPerPage in class DBHandler

Returns:

returns true if no error occurs during setting up, false otherwise.

See Also:

setMaxRowsForTable(CallableStatement,String)