Package net.simplace.core.service

Class DatabaseHelper

java.lang.Object

net.simplace.core.service.DatabaseHelper

public final class DatabaseHelper
extends Object

Provides some methods for performing database operations. It's not implemented as static methods to share some ressources. It's not implemendes as singleton to avoid snychronisation problems.

Author:

Andreas Enders

Constructor Summary

Constructors

Constructor	Description
DatabaseHelper()

Method Summary

Modifier and Type	Method	Description
static void	copyData(boolean doDropBeforeCopy, Connection aSourceConnection, String aSourceTableName, Connection aTargetConnection, String aTargetTableName)
static LinkedHashMap<String,LinkedList<Object>>	readResult(Connection aConnection, String aStatement)

Methods inherited from class java.lang.Object

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

Constructor Details

DatabaseHelper

public DatabaseHelper()

Method Details

copyData

public static void copyData(boolean doDropBeforeCopy,
 Connection aSourceConnection,
 String aSourceTableName,
 Connection aTargetConnection,
 String aTargetTableName)
                     throws SQLException

Parameters:

doDropBeforeCopy -

aSourceConnection -

aSourceTableName -

aTargetConnection -

aTargetTableName -

Throws:

SQLException

readResult

public static LinkedHashMap<String,LinkedList<Object>> readResult(Connection aConnection,
 String aStatement)

Parameters:

aConnection -

aStatement -

Returns:

the complete result of the statement as Map of columns