DoctorDb.java

Go to the documentation of this file.

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;

// Database configuration information is all in here

class DoctorDb implements ConnectionFactory
{
  // Practice number for this practice (kludge)
  public static final int PRACTICE_ID = 67;
  
  public Connection connect() throws ClassNotFoundException, SQLException
  {
    Class.forName("org.postgresql.Driver");
    Connection conn = DriverManager.getConnection(
      "jdbc:postgresql://localhost/doctor",
      "postgres", "lewrujop"
    );
    return conn;
  }
  
  public void disconnect(Connection conn) throws SQLException
  {
    if (conn != null) conn.close();
  }
  
  
  
  // guessing this is a happy way to make a singleton in java
  
  static DoctorDb singleton;
  
  public static DoctorDb getSingleton()
  {
    if (singleton == null) singleton = new DoctorDb();
    return singleton;
  }
  
}

---