semorg.sql.tables
Class Conduct

java.lang.Object
  extended by semorg.sql.tables.AbstractTable
      extended by semorg.sql.tables.Conduct

public class Conduct
extends AbstractTable

Models the association "Conduct" between the classes Lecturer and Presentation: a Lecturer conducts a SeminarType (association has a * cardinality).


Field Summary
protected static String conductDeleteString
          SQL query to delete a conduct record.
protected static String conductInsertString
          SQL query to insert a conduct record.
private static String createTableSQLString
          SQL statement for creating the table "conduct" (if not exists).
protected  int lecturerId
          The id of the lecturer.
static List<KeyPair> lockedIds
          A list of id-pairs of locked records.
protected  int seminartypeId
          The id of the seminartype.
private static String tableName
          The name of the corresponding table in the database.
 
Fields inherited from class semorg.sql.tables.AbstractTable
creationDate, modificationDate, NULL_ID
 
Constructor Summary
Conduct(int lecturerId, int seminartypeId, Timestamp creationDate, Timestamp modificationDate)
          Creates an instance of the class Conduct with the given parameters.
 
Method Summary
static void createConductTable(Statement statement)
          Creates the table "conduct" if it does not exist.
 void deleteFromDB()
          Delets a conduct record from the db using the conductDeleteString.
static Vector<DBColumn> getColumns()
          Returns a vector of DBColumn instances according to the properties of the table "conduct".
 int getLecturerId()
           
 int getSeminartypeId()
           
 void insertIntoDB()
          Inserts a conduct record into the db using the conductInsertString.
static boolean tableOK()
          Checks if the according DB table exists.
 
Methods inherited from class semorg.sql.tables.AbstractTable
addDBTableChangedListener, createExtendedQueryString, fireTableChangedEvent, getColumns, getCreationDate, getModificationDate, getNext, getPrevious, removeDBTableChangedListener, setModificationDate, tableOK
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

lockedIds

public static List<KeyPair> lockedIds
A list of id-pairs of locked records. This list is meant to prevent the manipulation / deletion of records whose association is currently edited.


lecturerId

protected int lecturerId
The id of the lecturer.


seminartypeId

protected int seminartypeId
The id of the seminartype.


tableName

private static String tableName
The name of the corresponding table in the database.


conductInsertString

protected static String conductInsertString
SQL query to insert a conduct record.


conductDeleteString

protected static String conductDeleteString
SQL query to delete a conduct record.


createTableSQLString

private static String createTableSQLString
SQL statement for creating the table "conduct" (if not exists).

Constructor Detail

Conduct

public Conduct(int lecturerId,
               int seminartypeId,
               Timestamp creationDate,
               Timestamp modificationDate)
Creates an instance of the class Conduct with the given parameters.

Method Detail

tableOK

public static boolean tableOK()
Checks if the according DB table exists.

Returns:
true, if the table is ok, false otherwise.
See Also:
AbstractTable.tableOK(String)

createConductTable

public static void createConductTable(Statement statement)
                               throws SQLException
Creates the table "conduct" if it does not exist.

Parameters:
statement - instance of the class Statement, which is used for executing the SQL statement createTableSQLString.
Throws:
SQLException - If the execution or closing of the given statement fails.

insertIntoDB

public void insertIntoDB()
                  throws SQLException
Inserts a conduct record into the db using the conductInsertString. Finally it fires a TableChangedEvent-Listener with the appropriate type.

Throws:
SQLException - If the creation, manipulation, execution or closing of a PreparedStatement instance used for querying the database fails.
See Also:
- overview of all listener types

deleteFromDB

public void deleteFromDB()
                  throws SQLException
Delets a conduct record from the db using the conductDeleteString. Finally it fires a TableChangedEvent-Listener with the appropriate type.

Throws:
SQLException - If the creation, manipulation, execution or closing of a PreparedStatement instance used for querying the database fails.
See Also:
- overview of all listener types

getColumns

public static Vector<DBColumn> getColumns()
Returns a vector of DBColumn instances according to the properties of the table "conduct".

Returns:
the vector of DBColumn instances according to the properties of the class Conduct.
See Also:
AbstractTable.getColumns(String tableAbbreviation)

getLecturerId

public int getLecturerId()

getSeminartypeId

public int getSeminartypeId()