import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.Vector; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JPanel; public class Eleve extends JFrame implements ActionListener{ private JButton button = new JButton(); JPanel pan = new JPanel(); private String dateNaiss; private String nomBut; public Eleve() { String pilote = "com.mysql.jdbc.Driver"; try{ Class.forName(pilote); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/eleves","root",""); Statement stmt = conn.createStatement(); String requete = "SELECT date_naiss FROM eleves"; ResultSet resultat = stmt.executeQuery(requete); while (resultat.next()) { dateNaiss = resultat.getString("date_naiss"); button = new JButton ("date de naissance le : "+dateNaiss); button.setName(dateNaiss); ==>setName button.addActionListener(this); pan.add(button); setContentPane(pan); } } catch (Exception e){ System.out.println("echec pilote : "+e); } } public void actionPerformed(ActionEvent e) { if (e.getSource().equals(button)) { nomBut button.getName(); > getName() String pilote = "com.mysql.jdbc.Driver"; try{ Class.forName(pilote); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/eleves","root",""); Statement stmt = conn.createStatement(); String rekette "SELECT nom_eleve FROM eleves WHERE date_naiss "+"""+nomBut+"""; System.out.println(rekette); ResultSet resultatt = stmt.executeQuery(rekette); try { while (resultatt.next()) { String nom = resultatt.getString("nom_eleve"); System.out.println("nom_eleve" +nom); } } catch (Exception e1){ System.out.println("echec pilote : "+e1); } } catch (Exception e1){ System.out.println("echec pilote : "+e1); } } } public static void main(String[] args) { Eleve elv = new Eleve(); elv.setSize(200,200); elv.setVisible(true); } }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question