Package com.cosylab.vdct.rdb

Class RdbConnection

java.lang.Object

com.cosylab.vdct.rdb.RdbConnection

public class RdbConnection
extends Object

Author:

ssah

Constructor Summary

Constructors

Constructor	Description
RdbConnection()

Method Summary

Modifier and Type	Method	Description
void	appendRow(String table, Object[][] keyPairs, Object[][] valuePairs)
void	closeConnection()
void	commit()
Connection	createConnection()
void	deleteRows(String table, Object[][] keyPairs)
void	displayStatistics()
Connection	getConnection()
void	insertRow(String table, Object[][] keyPairs, Object[][] valuePairs)
boolean	isConnection()
ResultSet	loadRows(String table, Object[] columns, Object[][] keyPairs)
ResultSet	loadRows(String table, Object[] columns, Object[][] keyPairs, String conditions)
ResultSet	loadRows(String table, Object[] columns, Object[][] keyPairs, String conditions, String orderBy)
void	resetStatistics()
void	rollbackConnection()
void	saveRow(String table, Object[][] keyPairs, Object[][] valuePairs)
void	setParameters(String host, String database, String user, String password)
void	updateRow(String table, Object[][] keyPairs, Object[][] valuePairs)

Methods inherited from class java.lang.Object

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

Constructor Detail

RdbConnection

public RdbConnection()
              throws Exception

Throws:

Exception - foo

Method Detail

setParameters

public void setParameters(String host,
                          String database,
                          String user,
                          String password)

Parameters:

host - host

database - database

user - user

password - password

isConnection

public boolean isConnection()

Returns:

something

commit

public void commit()
            throws SQLException

Throws:

SQLException - foo

createConnection

public Connection createConnection()
                            throws SQLException

Returns:

something

Throws:

SQLException - foo

getConnection

public Connection getConnection()

Returns:

something

rollbackConnection

public void rollbackConnection()
                        throws SQLException

Throws:

SQLException - foo

closeConnection

public void closeConnection()
                     throws SQLException

Throws:

SQLException - foo

loadRows

public ResultSet loadRows(String table,
                          Object[] columns,
                          Object[][] keyPairs)
                   throws SQLException

Parameters:

table - table

columns - columns

keyPairs - keyPairs

Returns:

something

Throws:

SQLException - foo

loadRows

public ResultSet loadRows(String table,
                          Object[] columns,
                          Object[][] keyPairs,
                          String conditions)
                   throws SQLException

Parameters:

table - table

columns - columns

keyPairs - keyPairs

conditions - conditions

Returns:

something

Throws:

SQLException - foo

loadRows

public ResultSet loadRows(String table,
                          Object[] columns,
                          Object[][] keyPairs,
                          String conditions,
                          String orderBy)
                   throws SQLException

Parameters:

table - table

columns - columns

keyPairs - keyPairs

conditions - conditions

orderBy - orderBy

Returns:

something

Throws:

SQLException - foo

insertRow

public void insertRow(String table,
                      Object[][] keyPairs,
                      Object[][] valuePairs)
               throws SQLException

Parameters:

table - table

keyPairs - keyPairs

valuePairs - valuePairs

Throws:

SQLException - foo

updateRow

public void updateRow(String table,
                      Object[][] keyPairs,
                      Object[][] valuePairs)
               throws SQLException

Parameters:

table - table

keyPairs - keyPairs

valuePairs - valuePairs

Throws:

SQLException - foo

deleteRows

public void deleteRows(String table,
                       Object[][] keyPairs)
                throws SQLException

Parameters:

table - table

keyPairs - keyPairs

Throws:

SQLException - foo

saveRow

public void saveRow(String table,
                    Object[][] keyPairs,
                    Object[][] valuePairs)
             throws SQLException

Parameters:

table - table

keyPairs - keyPairs

valuePairs - valuePairs

Throws:

SQLException - foo

appendRow

public void appendRow(String table,
                      Object[][] keyPairs,
                      Object[][] valuePairs)
               throws SQLException

Parameters:

table - table

keyPairs - keyPairs

valuePairs - valuePairs

Throws:

SQLException - foo

displayStatistics

public void displayStatistics()

resetStatistics

public void resetStatistics()