db.dbaccess
Class BankDB

java.lang.Object
  extended by db.dbaccess.BankDB

public class BankDB
extends java.lang.Object

Author:
Marc Rohe, 06.05.2007

Field Summary
static java.lang.String basicQuery
           
 
Constructor Summary
BankDB()
           
 
Method Summary
static boolean clear(java.sql.Connection cn)
          Leert Tabelle Banken
static java.util.Collection findAll(java.sql.Connection cn)
          FIndetr alle Banken
static prefuse.data.Table findAllDS(prefuse.data.io.sql.DatabaseDataSource ds)
           
static java.lang.Object[] findAllNames(java.sql.Connection cn, boolean alle)
          FIndetr alle Banken
static java.util.Collection findByFid(java.sql.Connection cn, int fid)
          Findet Bank nach Firmen-ID
static prefuse.data.Table findByFidDS(prefuse.data.io.sql.DatabaseDataSource ds, int fid)
           
static java.util.Collection findByName(java.sql.Connection cn, java.lang.String name)
          Sucht Bank nach Name
static prefuse.data.Table findByNameDS(prefuse.data.io.sql.DatabaseDataSource ds, java.lang.String name)
           
static int insert(java.sql.Connection cn, BankDTO dto)
          Fügt neue Bank ein...
static int update(java.sql.Connection cn, BankDTO dto)
          Ändert Datensatz in Tabelle Banken
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

basicQuery

public static final java.lang.String basicQuery
See Also:
Constant Field Values
Constructor Detail

BankDB

public BankDB()
Method Detail

insert

public static int insert(java.sql.Connection cn,
                         BankDTO dto)
Fügt neue Bank ein...

Parameters:
cn -
dto -
Returns:

findByFid

public static java.util.Collection findByFid(java.sql.Connection cn,
                                             int fid)
Findet Bank nach Firmen-ID

Parameters:
cn -
fid -
Returns:

findByFidDS

public static prefuse.data.Table findByFidDS(prefuse.data.io.sql.DatabaseDataSource ds,
                                             int fid)
Parameters:
ds -
fid -
Returns:

findAll

public static java.util.Collection findAll(java.sql.Connection cn)
FIndetr alle Banken

Parameters:
cn -
Returns:

findAllDS

public static prefuse.data.Table findAllDS(prefuse.data.io.sql.DatabaseDataSource ds)
Parameters:
ds -
Returns:

findAllNames

public static java.lang.Object[] findAllNames(java.sql.Connection cn,
                                              boolean alle)
FIndetr alle Banken

Parameters:
cn -
Returns:

findByName

public static java.util.Collection findByName(java.sql.Connection cn,
                                              java.lang.String name)
Sucht Bank nach Name

Parameters:
cn - Connection
name - String
Returns:
erg Collection

findByNameDS

public static prefuse.data.Table findByNameDS(prefuse.data.io.sql.DatabaseDataSource ds,
                                              java.lang.String name)
Parameters:
ds -
name -
Returns:

clear

public static boolean clear(java.sql.Connection cn)
Leert Tabelle Banken

Parameters:
cn -
Returns:

update

public static int update(java.sql.Connection cn,
                         BankDTO dto)
Ändert Datensatz in Tabelle Banken

Parameters:
cn -
dto -
Returns: