Package 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 Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	TableModelDbHelper.OverwriteMode

Constructor Summary

Constructors

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

Method Summary

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

Methods inherited from class java.lang.Object

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

Constructor Details

TableModelDbHelper

public TableModelDbHelper(<any> outputGeneratorProvider,
 DbPoolService dbPoolService)

Method Details

selectAsRsTableModel

public RSTableModel selectAsRsTableModel(ConnectionPoolConfig cpc,
 String query)
                                  throws SQLException,
IOException,
InterruptedException,
ExecutionException

Throws:

SQLException

IOException

InterruptedException

ExecutionException

selectAsRsTableModel

public RSTableModel selectAsRsTableModel(Connection connection,
 String query)
                                  throws SQLException,
IOException

Throws:

SQLException

IOException

writeRsTableModel

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

Throws:

DatabaseException

SQLException

writeRsTableModel

public int writeRsTableModel(RSTableModel rsTableModel,
 Connection connection,
 String tableName)
                      throws DatabaseException,
SQLException

Note that you need to close the connection manually

Parameters:

rsTableModel -

connection -

tableName -

writeRsTableModel

public int writeRsTableModel(RSTableModel rsTableModel,
 ConnectionPoolConfig cpc,
 String tableName)
                      throws DatabaseException,
SQLException,
InterruptedException,
ExecutionException

Throws:

DatabaseException

SQLException

InterruptedException

ExecutionException

writeRsTableModel

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

Throws:

DatabaseException

SQLException

InterruptedException

ExecutionException