package pck1;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JButton;

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import java.sql.*;

public class Connexon
{	public static void main(String[] args)
	{	Interface1 inter1 = new Interface1();
		inter1.methode1();
	}
}

class Interface1
{	private JFrame JFrame1;
	private JPanel JPanel1;
	
	private JButton JButton1;
	private JButton JButton2;
		
	public void methode1()
	{
	JFrame1 = new JFrame("Interface Nidhal");
	
	JPanel1= new JPanel();
	JPanel1.setLayout(null);
	
	JButton1= new JButton("Connexion");
	JPanel1.add(JButton1);
	JButton1.setBounds(50, 50, 150, 20);
	JButton1.addActionListener(new EcouteBoutonEnvoi1());
	
	JButton2= new JButton("Annuler");
	JPanel1.add(JButton2);
	JButton2.setBounds(250, 50, 150, 20);
	JButton2.addActionListener(new EcouteBoutonEnvoi2());
	
	JFrame1.getContentPane().add(BorderLayout.CENTER, JPanel1);
	JFrame1.setSize(900,800);
	JFrame1.setVisible(true);
	JFrame1.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	}

	public class EcouteBoutonEnvoi1 implements ActionListener
	{
		public void actionPerformed(ActionEvent ev)
		{ 
			System.out.println("Connexion...");
			clique1 clq = new clique1();
			clq.meth1();

		}
	}
	
	public class EcouteBoutonEnvoi2 implements ActionListener
	{
		public void actionPerformed(ActionEvent ev)
		{ 	
			System.out.println("Annuler...");	
		}
	}
}

class clique1
{	
	public void meth1()
	{
	try{
	
	Connection connexion = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","estest"); 
	Statement instruction = connexion.createStatement();
	ResultSet resultat = instruction.executeQuery("SELECT col1 FROM table1");
    while(resultat.next())
    {
    	System.out.println("Resultat: "+resultat.getString("col1")); 
    }  
    
	}catch (Exception e){
    System.out.println("echec pilote : "+e);
    }
	}
}