package blueorb.db;


import java.awt.event.*;
import java.awt.TextField;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.DriverManager;
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 InsertButtonClicked implements ActionListener
{

  TextField dbNameToAdd;
  Statement dbStmnt;
  public InsertButtonClicked(TextField name, Statement stmt)
  {
    dbNameToAdd = name;
    dbStmnt = stmt;
    System.out.println(dbStmnt);
  }

  public void actionPerformed(ActionEvent e)
  {
    try
    {

      String input = dbNameToAdd.getText();

    }catch (Exception i){};
     updateDB();
  }

  public void updateDB()
  {
            try{
      String sql = "INSERT INTO customers VALUES ('Some Name')";
      this.dbStmnt.executeUpdate(sql);

      }catch(Exception e){e.printStackTrace();}
  }
}