dao
Class SzenarienDaoMysql

java.lang.Object
  extended by dao.AquaDaoMysql
      extended by dao.SzenarienDaoMysql
All Implemented Interfaces:
SzenarienDao

public class SzenarienDaoMysql
extends AquaDaoMysql
implements SzenarienDao


Field Summary
static java.lang.String DELETE_BY_ID
           
static java.lang.String DIM_ID
           
static java.lang.String ID
           
static java.lang.String INSERT
           
static java.lang.String LICHTAUS
           
static java.lang.String LICHTEIN
           
static java.lang.String NAME
           
static java.lang.String PHMAX
           
static java.lang.String PHMIN
           
static java.lang.String SELECT_ALL
           
static java.lang.String SELECT_BY_ID
           
static java.lang.String SHORTNAME
           
static java.lang.String TEMPMAX
           
static java.lang.String TEMPMIN
           
static java.lang.String UPDATE
           
 
Constructor Summary
SzenarienDaoMysql(java.lang.String url)
           
 
Method Summary
 int create(java.lang.String name, java.lang.String shortname, double tempMin, double tempMax, double phMin, double phMax, java.util.Date lichtEin, java.util.Date lichtAus, int dim_ID)
          Speichert neu Szenario
 void delete(int id)
          L�scht bestimte Szenario
 java.util.Vector<Szenario> read()
          Liest Szenarien.
 void update(int id, java.lang.String name, java.lang.String shortname, double tempMin, double tempMax, double phMin, double phMax, java.util.Date lichtEin, java.util.Date lichtAus, int dim_ID)
          Speichert neu Werte f�r bestimte Szenario
 
Methods inherited from class dao.AquaDaoMysql
close, getCallableStatement, getConnection, getPreparedStatement, getStatement
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

ID

public static final java.lang.String ID
See Also:
Constant Field Values

NAME

public static final java.lang.String NAME
See Also:
Constant Field Values

SHORTNAME

public static final java.lang.String SHORTNAME
See Also:
Constant Field Values

TEMPMIN

public static final java.lang.String TEMPMIN
See Also:
Constant Field Values

TEMPMAX

public static final java.lang.String TEMPMAX
See Also:
Constant Field Values

PHMIN

public static final java.lang.String PHMIN
See Also:
Constant Field Values

PHMAX

public static final java.lang.String PHMAX
See Also:
Constant Field Values

LICHTEIN

public static final java.lang.String LICHTEIN
See Also:
Constant Field Values

LICHTAUS

public static final java.lang.String LICHTAUS
See Also:
Constant Field Values

DIM_ID

public static final java.lang.String DIM_ID
See Also:
Constant Field Values

INSERT

public static final java.lang.String INSERT
See Also:
Constant Field Values

SELECT_ALL

public static final java.lang.String SELECT_ALL
See Also:
Constant Field Values

SELECT_BY_ID

public static final java.lang.String SELECT_BY_ID
See Also:
Constant Field Values

UPDATE

public static final java.lang.String UPDATE
See Also:
Constant Field Values

DELETE_BY_ID

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

SzenarienDaoMysql

public SzenarienDaoMysql(java.lang.String url)
Method Detail

create

public int create(java.lang.String name,
                  java.lang.String shortname,
                  double tempMin,
                  double tempMax,
                  double phMin,
                  double phMax,
                  java.util.Date lichtEin,
                  java.util.Date lichtAus,
                  int dim_ID)
           throws AquaDaoException
Description copied from interface: SzenarienDao
Speichert neu Szenario

Specified by:
create in interface SzenarienDao
Returns:
id
Throws:
AquaDaoException

read

public java.util.Vector<Szenario> read()
                                throws AquaDaoException
Description copied from interface: SzenarienDao
Liest Szenarien.

Specified by:
read in interface SzenarienDao
Returns:
Vector
Throws:
AquaDaoException

update

public void update(int id,
                   java.lang.String name,
                   java.lang.String shortname,
                   double tempMin,
                   double tempMax,
                   double phMin,
                   double phMax,
                   java.util.Date lichtEin,
                   java.util.Date lichtAus,
                   int dim_ID)
            throws AquaDaoException
Description copied from interface: SzenarienDao
Speichert neu Werte f�r bestimte Szenario

Specified by:
update in interface SzenarienDao
Throws:
AquaDaoException

delete

public void delete(int id)
            throws AquaDaoException
Description copied from interface: SzenarienDao
L�scht bestimte Szenario

Specified by:
delete in interface SzenarienDao
Throws:
AquaDaoException