References to JDBC

• driver the class name of the jdbc driver. This is not the name of the jar file. Oracle provides oracle.jdbc.OracleDriver. MicroSoft provides com.microsoft.jdbc.sqlserver.SQLServerDriver.
• urlPrefix a database url of the form jdbc:subprotocol:subname the default is "jdbc:oracle:oci:@". The interpretation of this url is vendor specific.
• user -the database user on whose behalf the connection is being made
• password - the user's password
• database - the name of the datbase
• urlSuffix - additional vendor specific parameters, for example portnumber.

• connect() establishes database connection. It returns a boolean status. connect() combines urlPrefix,database and urlSuffix into a single string.

• disconnect() breaks database connection. It returns true if the disconnect worked.
• isConnected() returns the status of the database connection.
• commit() commits a transaction
• selectUser() gets the user from the connection