import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.beans.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

import javax.swing.Icon;
import javax.swing.JButton;
import javax.swing.JOptionPane;

public class Povezivanje {

    private static final String ID = null;

    public static void main(String[] args) {
    }

    public Povezivanje(String Povezivanje){
          Connection con = null;
          Statement st = null;
          try{
              con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","hr","hr");
              st = (Statement) con.createStatement();
              ((java.sql.Statement) st).executeUpdate(Povezivanje);
              JOptionPane.showMessageDialog(null,"Upit je izvrsen");
          }catch(Exception ex){
              JOptionPane.showMessageDialog(null,ex.getMessage());
          }


                   private   JButton (String upis);{

                        JButton dugme = new JButton(upis);

                      dugme.addActionListener(new  ActionListener() {

                     public void actionPerformed(ActionEvent e) {
                     try{
                         upis("insert into reklama (NAZIV_REKLAME, ID, TRAJANJE_REKLAME, DATUM_POCETKA, DATUM_KRAJA) values ('"+text2.getText()+"','"+id1.getText()+"',"+ text3.getText()+"','" + text4.getText()+ "','" + text5.getText()+")" );
                     }
                     catch(Exception ex){}
                     }
                 });

                return dugme;
            }


          izbrisi(String izbrisi ); {

          dugmeizbrisi.addActionListener(new  ActionListener() {

            public void actionPerformed(ActionEvent e) {
                    try{

                izbrisi("delete from reklame where id = "+ unos.getText());


 }
         catch(Exception ex){}
         }


          });

        return izbrisi;


         public provjeri (String[] args) {


             try {
                String sql  = " select naziv_reklame, ID from reklama";
                ResultSet rs = ((java.sql.Statement) st).executeQuery(sql);
                        while (rs.next())
                            System.out.println(
                                "naziv reklame : " + rs.getString("Naziv_reklame") +  ",  ID: " +   rs.getString("ID")  );

                         String ID = rs.getString(ID);



            } catch (Exception e) {


                System.out.println(e);
            }
        return ID;
        }
    }














    }

    private void upis(Object object) {
        // TODO Auto-generated method stub

    }

}