package blueorb.db;

import java.sql.*;
import java.net.*;
import java.lang.Exception;
/**
 * Title:        Test project for JDBC and postgreSQL
 * Description:
 * Copyright:    Copyright (c) 2002
 * Company:      Blue Orb
 * @author Roman Levandovsky
 * @version 1.0
 */

public class DatabaseDriver {

  public DatabaseDriver() {
  }
  public static void main(String[] args) {
    DatabaseDriver databaseDriver1 = new DatabaseDriver();
    UserInterface gui = new UserInterface();

   try
    {
      System.out.println("Testing Class");
      Class.forName("org.postgresql.Driver");
      Class.forName("org.postgresql.Driver").newInstance();
      String dbHost = "jdbc:postgresql://192.168.1.18:5432/test";
      String postgres = "postgres";
      String pass = "123456";
      Connection con = DriverManager.getConnection(dbHost,postgres,pass);
      Statement stmt = con.createStatement();
      ResultSet result = stmt.executeQuery("SELECT *" + "FROM customers");
      String output;
      while(result.next())
      {
        output = result.getString("name");
        System.out.println(output);
        gui.showNames(output);
      }

      gui.insertNames(stmt);
      System.out.println(stmt);
      //TestDB test = new TestDB(stmt);
      //stmt.executeUpdate("INSERT INTO customers VALUES ('Sarah Ryz')");
      con.close();
    }catch(Exception e){e.printStackTrace();}


  }
}