|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectsemorg.sql.tables.AbstractTable
semorg.sql.tables.Conduct
public class Conduct
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 |
---|
public static List<KeyPair> lockedIds
protected int lecturerId
protected int seminartypeId
private static String tableName
protected static String conductInsertString
protected static String conductDeleteString
private static String createTableSQLString
Constructor Detail |
---|
public Conduct(int lecturerId, int seminartypeId, Timestamp creationDate, Timestamp modificationDate)
Method Detail |
---|
public static boolean tableOK()
true
, if the table is ok, false
otherwise.AbstractTable.tableOK(String)
public static void createConductTable(Statement statement) throws SQLException
statement
- instance of the class Statement, which is used for
executing the SQL statement createTableSQLString
.
SQLException
- If the execution or closing of the given statement fails.public void insertIntoDB() throws SQLException
conductInsertString
. Finally it fires a
TableChangedEvent-Listener with the appropriate type.
SQLException
- If the creation, manipulation, execution or closing of a
PreparedStatement instance used for querying the database
fails.- overview of all listener
types
public void deleteFromDB() throws SQLException
conductDeleteString
. Finally it fires a
TableChangedEvent-Listener with the appropriate type.
SQLException
- If the creation, manipulation, execution or closing of a
PreparedStatement instance used for querying the database
fails.- overview of all listener
types
public static Vector<DBColumn> getColumns()
DBColumn
instances according to
the properties of the table "conduct".
AbstractTable.getColumns(String tableAbbreviation)
public int getLecturerId()
public int getSeminartypeId()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |