/*
 * GNTConnection.java
 *
 * Created on December 8, 2003, 10:16 PM
 */

package gnt;

import java.sql.*;
import palm.conduit.Log;
/**
 *
 * @author  Owner
 */
public class GNTConnection {
  
  private static Connection con = null;
  private static boolean initialized = false;
  private static ResultSet rs = null;
  
  /** Creates a new instance of GNTConnection */
  public GNTConnection() {
  }
  
  protected void init(String username, String password) {
    try {
      if (!initialized) {

        Class.forName("com.mysql.jdbc.Driver").newInstance();
        initialized = true;
      }

      if (con == null) {
        String dbURL = "jdbc:mysql://localhost:3306/gnotet";
        con = DriverManager.getConnection(dbURL, username, password);
      }
    } catch (ClassNotFoundException cnfe) {
      Log.AddEntry("Could not open database", Log.SYNC_WARNING, false);
    } catch (InstantiationException ie) {
      Log.AddEntry("Could not open database", Log.SYNC_WARNING, false);
    } catch (java.sql.SQLException sqle) {
      Log.AddEntry("Could not open database", Log.SYNC_WARNING, false);
    } catch (IllegalAccessException iae) {
      Log.AddEntry("Could not open database", Log.SYNC_WARNING, false);
    }
  }
  
  protected void close() {
    try {
      con.close();
    } catch (SQLException sqle) {
      Log.AddEntry("Database closing failed.", Log.SYNC_WARNING, false);
    }
  }
  
  protected void closeRS(ResultSet rs) {
    if (rs != null) {
      try {
        rs.getStatement().close();
        rs.close();
      } catch (SQLException sqle) {
        Log.AddEntry("Database Error (Could not close ResultSet/Statement)", Log.SYNC_WARNING, false);
      }
    }
  }
  
  protected ResultSet execQ(String sql) {
    try {
      Statement stmt = null;
      if (rs == null) {
        stmt = con.createStatement();
        rs = stmt.executeQuery("Select * from replacement");
      }

    } catch (SQLException sqle) {
      Log.AddEntry("Database Error (Could not get data.)", Log.SYNC_WARNING, false);
    }
    
    return rs;
  }
  
}