com.cosylab.vdct.rdb
Class RdbConnection

java.lang.Object
  extended by com.cosylab.vdct.rdb.RdbConnection

public class RdbConnection
extends java.lang.Object

Author:
ssah

Constructor Summary
RdbConnection()
           
 
Method Summary
 void appendRow(java.lang.String table, java.lang.Object[][] keyPairs, java.lang.Object[][] valuePairs)
           
 void closeConnection()
           
 void commit()
           
 java.sql.Connection createConnection()
           
 void deleteRows(java.lang.String table, java.lang.Object[][] keyPairs)
           
 void displayStatistics()
           
 java.sql.Connection getConnection()
           
 void insertRow(java.lang.String table, java.lang.Object[][] keyPairs, java.lang.Object[][] valuePairs)
           
 boolean isConnection()
           
 java.sql.ResultSet loadRows(java.lang.String table, java.lang.Object[] columns, java.lang.Object[][] keyPairs)
           
 java.sql.ResultSet loadRows(java.lang.String table, java.lang.Object[] columns, java.lang.Object[][] keyPairs, java.lang.String conditions)
           
 java.sql.ResultSet loadRows(java.lang.String table, java.lang.Object[] columns, java.lang.Object[][] keyPairs, java.lang.String conditions, java.lang.String orderBy)
           
 void resetStatistics()
           
 void rollbackConnection()
           
 void saveRow(java.lang.String table, java.lang.Object[][] keyPairs, java.lang.Object[][] valuePairs)
           
 void setParameters(java.lang.String host, java.lang.String database, java.lang.String user, java.lang.String password)
           
 void updateRow(java.lang.String table, java.lang.Object[][] keyPairs, java.lang.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 java.lang.Exception
Throws:
java.lang.Exception
Method Detail

setParameters

public void setParameters(java.lang.String host,
                          java.lang.String database,
                          java.lang.String user,
                          java.lang.String password)

isConnection

public boolean isConnection()

commit

public void commit()
            throws java.sql.SQLException
Throws:
java.sql.SQLException

createConnection

public java.sql.Connection createConnection()
                                     throws java.sql.SQLException
Throws:
java.sql.SQLException

getConnection

public java.sql.Connection getConnection()

rollbackConnection

public void rollbackConnection()
                        throws java.sql.SQLException
Throws:
java.sql.SQLException

closeConnection

public void closeConnection()
                     throws java.sql.SQLException
Throws:
java.sql.SQLException

loadRows

public java.sql.ResultSet loadRows(java.lang.String table,
                                   java.lang.Object[] columns,
                                   java.lang.Object[][] keyPairs)
                            throws java.sql.SQLException
Throws:
java.sql.SQLException

loadRows

public java.sql.ResultSet loadRows(java.lang.String table,
                                   java.lang.Object[] columns,
                                   java.lang.Object[][] keyPairs,
                                   java.lang.String conditions)
                            throws java.sql.SQLException
Throws:
java.sql.SQLException

loadRows

public java.sql.ResultSet loadRows(java.lang.String table,
                                   java.lang.Object[] columns,
                                   java.lang.Object[][] keyPairs,
                                   java.lang.String conditions,
                                   java.lang.String orderBy)
                            throws java.sql.SQLException
Throws:
java.sql.SQLException

insertRow

public void insertRow(java.lang.String table,
                      java.lang.Object[][] keyPairs,
                      java.lang.Object[][] valuePairs)
               throws java.sql.SQLException
Throws:
java.sql.SQLException

updateRow

public void updateRow(java.lang.String table,
                      java.lang.Object[][] keyPairs,
                      java.lang.Object[][] valuePairs)
               throws java.sql.SQLException
Throws:
java.sql.SQLException

deleteRows

public void deleteRows(java.lang.String table,
                       java.lang.Object[][] keyPairs)
                throws java.sql.SQLException
Throws:
java.sql.SQLException

saveRow

public void saveRow(java.lang.String table,
                    java.lang.Object[][] keyPairs,
                    java.lang.Object[][] valuePairs)
             throws java.sql.SQLException
Throws:
java.sql.SQLException

appendRow

public void appendRow(java.lang.String table,
                      java.lang.Object[][] keyPairs,
                      java.lang.Object[][] valuePairs)
               throws java.sql.SQLException
Throws:
java.sql.SQLException

displayStatistics

public void displayStatistics()

resetStatistics

public void resetStatistics()