Bonjour,
svp , je veux inserr des données ussu d'un JTextFiled dans ma base Voici mon code ...mais
toujours un probleme de connection a ma base ..merci de m'aider
package Livre;
import java.awt.Color;
import java.awt.Component;
import javax.swing.InputVerifier;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.InputVerifier;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import java.io.*;
import javax.swing.*;
import javax.swing.tree.DefaultMutableTreeNode;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.sql.*;
public class Livre {
public static String titre;
public static String auteur;
private static final String ResultSet = null;
private static final String Statement = null;
public Livre(String titre, String auteur){
this.titre=titre;
this.auteur=auteur;
frame();
}
public void frame(){
JFrame f=new JFrame();
f.setSize(400,300);
f.setVisible(true);
JButton b1=new JButton("Ajouter Livre");
final JTextField t1=new JTextField();
final JTextField t2=new JTextField();
f.setLocationRelativeTo(null);
JMenuBar mb=new JMenuBar();
JMenu file=new JMenu("File");
JMenu edit=new JMenu("Edit");
JMenu help=new JMenu("Help");
JMenuItem e1=new JMenuItem("New Alt+Sheft+All");
JMenuItem e2=new JMenuItem("Open File ");
JMenuItem e3=new JMenuItem("Close Ctrl+W");
JMenuItem e4=new JMenuItem("Close All Ctrl+All+W");
JMenuItem e5=new JMenuItem("Save");
JMenuItem e6=new JMenuItem("Save As");
JMenuItem e7=new JMenuItem("Save All");
JMenuItem k1=new JMenuItem("Paste");
JMenuItem k2=new JMenuItem("Delete");
JMenuItem k3=new JMenuItem("Select All");
JMenuItem k4=new JMenuItem("Find/Replace");
JMenuItem k5=new JMenuItem("Find Next");
mb.add(file);
mb.add(edit);
mb.add(help);
file.add(e1);
file.add(e2);
file.add(e3);
file.add(e4);
file.add(e5);
file.add(e6);
file.add(e7);
edit.add(k1);
edit.add(k2);
edit.add(k3);
edit.add(k4);
edit.add(k5);
f.setJMenuBar(mb);
JLabel l1=new JLabel("TITRE :");
JLabel l2=new JLabel("AUTEUR :");
/*
Color color1 = Color.ORANGE;
Color color2 = Color.DARK_GRAY;
Color color3 = Color.WHITE;
Color color4 = Color.BLACK;
*/
// f.getContentPane().setBackground(color1);
f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
JPanel p=new JPanel(null);
f.setContentPane(p);
//p.setBackground(color3);
p.add(b1);
p.add(l1);
p.add(l2);
p.add(t1);
p.add(t2);
b1.setBounds(500,200,220,30);
l1.setBounds(500,100,130,30);
l2.setBounds(500,150,130,30);
t1.setBounds(560,100,160,30);
t2.setBounds(560,150,160,30);
// b1.setForeground(color3);
//b1.setBackground(color2);
b1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
final String titre=t1.getText();
String auteur=t2.getText();
// JOptionPane.showMessageDialog(null,"merci");
//t1.setText(auteur);
//Livre livre2=new Livre(titre,auteur);
Connection cnx=null;
try
{
Class.forName("com.mysql.jdbc.Driver");
cnx=DriverManager.getConnection("jdbc:mysql://localhost/etablissements","root","");
System.out.println("connexion etablie");
Statement st=cnx.createStatement();
//livre2.ajouter_livre(cnx);
st.executeQuery("INSERT INTO client VALUES('"+t1.toString()+"','"+t2.toString()+"')");
st.close();
cnx.close();
}catch(Exception ex){
System.out.println("Exception"+ex.getMessage());
}
}
});
}
public static void main(String[] args) {
// TODO Auto-generated method stub
Livre livre1=new Livre(titre,auteur);
//livre1.ajouter_livre();
}
}
Afficher la suite