si.wfcidata
Class AFDBManager

java.lang.Object
  si.wfcidata.AFDBManager

public class AFDBManager
extends java.lang.Object

AFDBManager

Version:

1.1.5,

Author:

Flowring co.

Field Summary

static int	DB_TYPE_IBMDB2
static int	DB_TYPE_INFORMIX
static int	DB_TYPE_MSSQL
static int	DB_TYPE_MYSQL
static int	DB_TYPE_ODBC
static int	DB_TYPE_ORACLE
static int	DB_TYPE_PROGRESS
static int	DB_TYPE_SYBASE

Constructor Summary

AFDBManager(WFCI wfci)
Consturctor

Method Summary

void	addAFDBConnectionURL(int seq, int type, java.lang.String dburl) Add a db URL to db configuration, and specify its sequence number in it.
void	addAFDBConnectionURL(int seq, int type, java.lang.String name, java.lang.String dburl) Add a db URL to db configuration, and specify its sequence number in it.
void	addAFDBConnectionURL(int seq, int type, java.lang.String dburl, java.lang.String username, java.lang.String password) Add a db URL to db configuration, and specify its sequence number in it
void	addAFDBConnectionURL(int seq, int type, java.lang.String name, java.lang.String dburl, java.lang.String username, java.lang.String password) Add a db URL to db configuration, and specify its sequence number in it
AFDBConnection	createAFDBConnection(int seq) Create a AFDBConnection with specified db URL.
AFDBConnection	createAFDBConnection(java.lang.String name) Create a AFDBConnection with specified db URL.
java.util.HashMap	deleteAFDBConnectionURL(java.lang.String name) Delete a db URL from db configuration by given name
java.util.HashMap	getAFDBConnectionURL(int seq) Get the db configuration info with the specific sequence number
java.util.HashMap	getAFDBConnectionURL(java.lang.String name) Get the db configuration info with the specific name
java.util.Vector	getAFDBConnectionURLList() Get all db configurations
boolean	testAFDBConnection(int seq) Test a AFDBConnection with specified db URL.
boolean	testAFDBConnection(java.lang.String name) Test a AFDBConnection with specified db URL.

Methods inherited from class java.lang.Object

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

Field Detail

DB_TYPE_IBMDB2

public static final int DB_TYPE_IBMDB2

See Also:

Constant Field Values

DB_TYPE_INFORMIX

public static final int DB_TYPE_INFORMIX

See Also:

Constant Field Values

DB_TYPE_MSSQL

public static final int DB_TYPE_MSSQL

See Also:

Constant Field Values

DB_TYPE_MYSQL

public static final int DB_TYPE_MYSQL

See Also:

Constant Field Values

DB_TYPE_ODBC

public static final int DB_TYPE_ODBC

See Also:

Constant Field Values

DB_TYPE_ORACLE

public static final int DB_TYPE_ORACLE

See Also:

Constant Field Values

DB_TYPE_PROGRESS

public static final int DB_TYPE_PROGRESS

See Also:

Constant Field Values

DB_TYPE_SYBASE

public static final int DB_TYPE_SYBASE

See Also:

Constant Field Values

Constructor Detail

AFDBManager

public AFDBManager(WFCI wfci)

Consturctor

Parameters:

wfci - WFCI interface

Method Detail

addAFDBConnectionURL

public void addAFDBConnectionURL(int seq,
                                 int type,
                                 java.lang.String dburl)
                          throws WFCIException

Add a db URL to db configuration, and specify its sequence number in it. Database's username is "sa" by default. Database's password is "sql" by default.

Parameters:

seq - user-defined database sequence number

type - database type

dburl - database URL

Throws:

WFCIException

addAFDBConnectionURL

public void addAFDBConnectionURL(int seq,
                                 int type,
                                 java.lang.String name,
                                 java.lang.String dburl)
                          throws WFCIException

Add a db URL to db configuration, and specify its sequence number in it. Database's username is "sa" by default. Database's password is "sql" by default.

Parameters:

seq - user-defined database sequence number

type - database type

name - the recognized name

dburl - database URL

Throws:

WFCIException

addAFDBConnectionURL

public void addAFDBConnectionURL(int seq,
                                 int type,
                                 java.lang.String dburl,
                                 java.lang.String username,
                                 java.lang.String password)
                          throws WFCIException

Add a db URL to db configuration, and specify its sequence number in it

Parameters:

seq - user-defined database sequence number, from 1 to 5 by default

type - database type

dburl - database URL

username - database's username

password - database's password

Throws:

WFCIException

addAFDBConnectionURL

public void addAFDBConnectionURL(int seq,
                                 int type,
                                 java.lang.String name,
                                 java.lang.String dburl,
                                 java.lang.String username,
                                 java.lang.String password)
                          throws WFCIException

Add a db URL to db configuration, and specify its sequence number in it

Parameters:

seq - user-defined database sequence number, from 1 to 5 by default

type - database type

name - the recognized name

dburl - database URL

username - database's username

password - database's password

Throws:

WFCIException

createAFDBConnection

public AFDBConnection createAFDBConnection(int seq)
                                    throws WFCIException

Create a AFDBConnection with specified db URL.

Parameters:

seq - user-defined database sequence number

Returns:

the AFDBConnection object

Throws:

WFCIException

createAFDBConnection

public AFDBConnection createAFDBConnection(java.lang.String name)
                                    throws WFCIException

Create a AFDBConnection with specified db URL.

Parameters:

seq - user-defined database name.

Returns:

the AFDBConnection object

Throws:

WFCIException

deleteAFDBConnectionURL

public java.util.HashMap deleteAFDBConnectionURL(java.lang.String name)
                                          throws WFCIException

Delete a db URL from db configuration by given name

Parameters:

name - the recognized name

Returns:

the HashMap object which shows the deleted configuration

Throws:

WFCIException

getAFDBConnectionURL

public java.util.HashMap getAFDBConnectionURL(int seq)
                                       throws WFCIException

Get the db configuration info with the specific sequence number

Parameters:

seq - user-defined database sequence number

Returns:

the HashMap object which shows the configuration

Throws:

WFCIException

getAFDBConnectionURL

public java.util.HashMap getAFDBConnectionURL(java.lang.String name)
                                       throws WFCIException

Get the db configuration info with the specific name

Parameters:

name - the recognized name

Returns:

the HashMap object which shows the configuration

Throws:

WFCIException

getAFDBConnectionURLList

public java.util.Vector getAFDBConnectionURLList()
                                          throws WFCIException

Get all db configurations

Returns:

all db configurations

Throws:

WFCIException

testAFDBConnection

public boolean testAFDBConnection(int seq)
                           throws WFCIException

Test a AFDBConnection with specified db URL.

Parameters:

seq - user-defined database sequence number

Returns:

true if testing is successful.

Throws:

WFCIException

testAFDBConnection

public boolean testAFDBConnection(java.lang.String name)
                           throws WFCIException

Test a AFDBConnection with specified db URL.

Parameters:

seq - user-defined database name.

Returns:

true if testing is successful.

Throws:

WFCIException