net.datenwerke.rs.base.service.reportengines.table.utils

Class TableModelDbHelper

java.lang.Object

net.datenwerke.rs.base.service.reportengines.table.utils.TableModelDbHelper

public class TableModelDbHelper
extends java.lang.Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	TableModelDbHelper.OverwriteMode

Constructor Summary

Constructors

Constructor and Description
TableModelDbHelper(<any> outputGeneratorProvider, DbPoolService dbPoolService)

Method Summary

Modifier and Type	Method and Description
RSTableModel	selectAsRsTableModel(ConnectionPoolConfig cpc, java.lang.String query)
RSTableModel	selectAsRsTableModel(java.sql.Connection connection, java.lang.String query)
int	writeRsTableModel(RSTableModel rsTableModel, ConnectionPoolConfig cpc, java.lang.String tableName)
int	writeRsTableModel(RSTableModel rsTableModel, ConnectionPoolConfig cpc, java.lang.String tableName, TableModelDbHelper.OverwriteMode overwriteMode, java.lang.String createTableStatement)
int	writeRsTableModel(RSTableModel rsTableModel, java.sql.Connection connection, java.lang.String tableName) Note that you need to close the connection manually
int	writeRsTableModel(RSTableModel rsTableModel, java.sql.Connection connection, java.lang.String tableName, TableModelDbHelper.OverwriteMode overwriteMode, java.lang.String createTableStatement)

Methods inherited from class java.lang.Object

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

Constructor Detail

TableModelDbHelper

public TableModelDbHelper(<any> outputGeneratorProvider,
                          DbPoolService dbPoolService)

Method Detail

selectAsRsTableModel

public RSTableModel selectAsRsTableModel(ConnectionPoolConfig cpc,
                                         java.lang.String query)
                                  throws java.sql.SQLException,
                                         java.io.IOException,
                                         java.lang.InterruptedException,
                                         java.util.concurrent.ExecutionException

Throws:

java.sql.SQLException

java.io.IOException

java.lang.InterruptedException

java.util.concurrent.ExecutionException

selectAsRsTableModel

public RSTableModel selectAsRsTableModel(java.sql.Connection connection,
                                         java.lang.String query)
                                  throws java.sql.SQLException,
                                         java.io.IOException

Throws:

java.sql.SQLException

java.io.IOException

writeRsTableModel

public int writeRsTableModel(RSTableModel rsTableModel,
                             java.sql.Connection connection,
                             java.lang.String tableName,
                             TableModelDbHelper.OverwriteMode overwriteMode,
                             java.lang.String createTableStatement)
                      throws DatabaseException,
                             java.sql.SQLException

Throws:

DatabaseException

java.sql.SQLException

writeRsTableModel

public int writeRsTableModel(RSTableModel rsTableModel,
                             java.sql.Connection connection,
                             java.lang.String tableName)
                      throws DatabaseException,
                             java.sql.SQLException

Note that you need to close the connection manually

Parameters:

rsTableModel -

connection -

tableName -

Throws:

DatabaseException

java.sql.SQLException

writeRsTableModel

public int writeRsTableModel(RSTableModel rsTableModel,
                             ConnectionPoolConfig cpc,
                             java.lang.String tableName)
                      throws DatabaseException,
                             java.sql.SQLException,
                             java.lang.InterruptedException,
                             java.util.concurrent.ExecutionException

Throws:

DatabaseException

java.sql.SQLException

java.lang.InterruptedException

java.util.concurrent.ExecutionException

writeRsTableModel

public int writeRsTableModel(RSTableModel rsTableModel,
                             ConnectionPoolConfig cpc,
                             java.lang.String tableName,
                             TableModelDbHelper.OverwriteMode overwriteMode,
                             java.lang.String createTableStatement)
                      throws DatabaseException,
                             java.sql.SQLException,
                             java.lang.InterruptedException,
                             java.util.concurrent.ExecutionException

Throws:

DatabaseException

java.sql.SQLException

java.lang.InterruptedException

java.util.concurrent.ExecutionException