de.unidu.is.util
Class MySQLDB

java.lang.Object
  de.unidu.is.util.DB
      de.unidu.is.util.MySQLDB

public class MySQLDB

extends DB

This class encapsulates a MySQL RDBMS (using JDBC), where connections are managed by a connection pool.

This class uses the logger "unidu.db" by default.

Since:

2004-01-04

Version:

$Revision: 1.5 $, $Date: 2005/02/21 17:29:29 $

Author:

Henrik Nottelmann

Field Summary

Fields inherited from class de.unidu.is.util.DB

dataSource, dataSources, dbURI, dbUser, formatter, logger, result2conn, result2stmt

Constructor Summary

MySQLDB(java.lang.String host, java.lang.String db, java.lang.String user, java.lang.String password)
Creates a new instance.

MySQLDB(java.lang.String host, java.lang.String db, java.lang.String user, java.lang.String password, org.apache.log4j.Logger logger)
Creates a new instance.

Methods inherited from class de.unidu.is.util.DB

close, close, createTable, createTableIfNotExists, dropTable, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdateIgnoreError, existsTable, freeConnection, getColumns, getConnection, getDbURI, getDbUser, insert, insert, insertIfMissing, insertIfMissing, makeIdentifier, remove, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQLDB

public MySQLDB(java.lang.String host,
               java.lang.String db,
               java.lang.String user,
               java.lang.String password)

Creates a new instance.

Parameters:

host - MySQL server host

db - MySQL database

user - MySQL user

password - MySQL password

MySQLDB

public MySQLDB(java.lang.String host,
               java.lang.String db,
               java.lang.String user,
               java.lang.String password,
               org.apache.log4j.Logger logger)

Creates a new instance.

Parameters:

host - MySQL server host

db - MySQL database

user - MySQL user

password - MySQL password

logger - DB logger