psman.dbi
Class MySQL

java.lang.Object
  |
  +--psman.dbi.SQL
        |
        +--psman.dbi.MySQL

All Implemented Interfaces:

DBI

public final class MySQL

extends SQL

The MySQL database driver.

Version:

$Id: MySQL.java,v 1.7 2004/05/05 12:33:58 sc2 Exp $

Author:

Martin Godisch

Field Summary

Fields inherited from class psman.dbi.SQL

C, database, hostname, password, port, protocol, username

Fields inherited from interface psman.dbi.DBI

APPELRULESET, CATEGORY, CERTIFICATE, CERTIFICATE_PUBLIC_KEY, CHAIN, CONFIGURATION, DATA_FIELD, DATA_FIELD_CATEGORY, DATA_FIELD_CERTIFICATE, DISCLOSURE_PURPOSE, DISCLOSURE_RECIPIENT, MASTER, PERSON, PROPERTY, PROPERTY_CERTIFICATE, PSEUDONYM, PSEUDONYM_PROPERTY, PSEUDONYM_PSEUDONYM_TYPE, PSEUDONYM_TYPE, PUBLIC_KEY, PUBLIC_KEY_CERTIFICATE, PURPOSE, RECIPIENT, ROLE, ROLE_TPARTNER_PSEUDONYM_TYPE, RULE, SECRET_KEY, T_PARTNER, T_PARTNER_TYPE, TABLE_NAME, TRANSACTION, TRANSACTION_DATA_FIELD, TYPE

Constructor Summary

MySQL()

Method Summary

void	create(int table) Create a predefined database table.
java.lang.String	getURL() Return the database URL.
psman.data.DataField[]	selectDataField(java.lang.String name, psman.data.TPartner owner) Select a data field by its name and owner.
psman.data.DataField[]	selectDataField(psman.data.TPartner owner) Select a data field by its owner.
psman.data.DataField	selectDataField(psman.data.TPartner owner, java.lang.String name, java.util.Date valid_from, java.util.Date valid_until) Select a data field by its properties.

Methods inherited from class psman.dbi.SQL

appelRuleSetTable, categoryTable, certificateTable, chainTable, configurationTable, connect, connect, create, dataFieldTable, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, disconnect, drop, drop, getDriverID, getServerID, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, isConnected, isReadOnly, personTable, propertyTable, pseudonymTable, pseudonymTypeTable, publicKeyTable, purposeTable, recipientTable, roleTable, ruleTable, secretKeyTable, selectAppelRuleSet, selectAppelRuleSet, selectCategory, selectCategory, selectCategory, selectCategory, selectCertificate, selectCertificate, selectCertificate, selectCertificate, selectCertificate, selectCertificate, selectChain, selectChain, selectChain, selectConfiguration, selectConfiguration, selectDataField, selectDataField, selectDataField, selectDataField, selectDataField, selectPerson, selectPerson, selectPerson, selectProperty, selectProperty, selectProperty, selectProperty, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonymType, selectPseudonymType, selectPseudonymType, selectPseudonymType, selectPseudonymType, selectPseudonymType, selectPseudonymType, selectPublicKey, selectPublicKey, selectPublicKey, selectPurpose, selectPurpose, selectPurpose, selectPurpose, selectRecipient, selectRecipient, selectRecipient, selectRecipient, selectRole, selectRole, selectRole, selectRule, selectRule, selectSecretKey, selectSecretKey, selectTPartner, selectTPartner, selectTPartner, selectTPartner, selectTPartner, selectTransaction, selectTransaction, selectTransaction, selectTransaction, selectTransaction, selectTransaction, selectTransaction, selectTransaction, selectType, selectType, selectType, selectType, set, set, set, set, set, set, set, set, setReadOnly, tPartnerTable, transactionTable, typeTable, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQL

public MySQL()
      throws java.lang.Exception

Method Detail

create

public void create(int table)
            throws java.lang.Exception

Description copied from interface: DBI

Create a predefined database table.

Specified by:

create in interface DBI

Specified by:

create in class SQL

Parameters:

table - ID of the table to be created.

Throws:

java.lang.Exception - if a database access error occurs.

See Also:

the table IDs, DBI.drop(int)

getURL

public java.lang.String getURL()

Description copied from class: SQL

Return the database URL. The URL is constructed using the property fields.

Overrides:

getURL in class SQL

Returns:

The database URL.

See Also:

SQL.connect(Properties data)

selectDataField

public psman.data.DataField[] selectDataField(java.lang.String name,
                                              psman.data.TPartner owner)
                                       throws java.lang.Exception

Description copied from interface: DBI

Select a data field by its name and owner.

Specified by:

selectDataField in interface DBI

Overrides:

selectDataField in class SQL

Parameters:

name - the name of the data field

owner - the owner of the data field

Returns:

the specified data field

Throws:

java.lang.Exception - if a database access error occurs.

selectDataField

public psman.data.DataField[] selectDataField(psman.data.TPartner owner)
                                       throws java.lang.Exception

Description copied from interface: DBI

Select a data field by its owner.

Specified by:

selectDataField in interface DBI

Overrides:

selectDataField in class SQL

Parameters:

owner - the owner of the data field

Returns:

the specified data field

Throws:

java.lang.Exception - if a database access error occurs.

selectDataField

public psman.data.DataField selectDataField(psman.data.TPartner owner,
                                            java.lang.String name,
                                            java.util.Date valid_from,
                                            java.util.Date valid_until)
                                     throws java.lang.Exception

Description copied from interface: DBI

Select a data field by its properties.

Parameters:

owner - the owner of the data field

name - the name of the data field

valid_from - the valid_from of the data field

valid_until - the valid_until of the data field

Returns:

the specified data field

Throws:

java.lang.Exception - if a database access error occurs.