bonjour,
j'ai écrit ce programme mais si j'appuis sur enregistrer il affiche un msg d'errur.
voila mon code;
/////////////////////////////////////////////////////////////////////////////import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.text.ParseException;
class planifier {
protected static final int parameterIndex = 0;
JFrame f;
JPanel p1;
JLabel l1, l2, l3,l4,l5,l51,l6,l7,l8,lj8,lm8,la8,l9,l91;
JTextField tf1,tf4,tf5,tf6,tf8,tf9,tf91;
JComboBox tf3=null,tf7=null,tf2=null;
JComboBox jj=null,jm=null,ja=null;
JButton savebtn,resetbtn;
planifier(){
f=new JFrame("Planifier une/des formation(s)");
p1=new JPanel(new GridLayout(15,2,10,10));
l1=new JLabel("Affectation:");
l1.setHorizontalAlignment(SwingConstants.LEFT);
l2=new JLabel("Matricule:");
l2.setHorizontalAlignment(SwingConstants.LEFT);
l3=new JLabel("Sujet :");
l3.setHorizontalAlignment(SwingConstants.LEFT);
l4=new JLabel("Lieu :");
l4.setHorizontalAlignment(SwingConstants.LEFT);
l5=new JLabel("Heure :");
l5.setHorizontalAlignment(SwingConstants.LEFT);
l6=new JLabel("Durée :");
l6.setHorizontalAlignment(SwingConstants.LEFT);
l7=new JLabel("Formateur :");
l7.setHorizontalAlignment(SwingConstants.LEFT);
l8=new JLabel("Date de la formation :");
l8.setHorizontalAlignment(SwingConstants.LEFT);
lj8=new JLabel("Jour :");
lm8=new JLabel("Mois :");
la8=new JLabel("Année :");
l9=new JLabel("Document :");
l9.setHorizontalAlignment(SwingConstants.LEFT);
l91=new JLabel("Document de test :");
l91.setHorizontalAlignment(SwingConstants.LEFT);
tf1=new JTextField(12);
tf2=new JComboBox();
tf3=new JComboBox();
tf4=new JTextField(12);
tf5=new JTextField(12);
tf6=new JTextField(12);
tf7 = new JComboBox();
jj = new JComboBox();
jm = new JComboBox();
ja = new JComboBox();
int[] jo={1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31};
int[] moi={1,2,3,4,5,6,7,8,9,10,11,12};
int[] ann={2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015};
for(int i=0 ; i<jo.length ;i++){
jj.addItem(jo[i]);
}
for(int i=0 ; i<moi.length ;i++){
jm.addItem(moi[i]);
}
for(int i=0 ; i<ann.length ;i++){
ja.addItem(ann[i]);
}
tf9=new JTextField(12);
tf91=new JTextField(12);
savebtn=new JButton(" Enregistrer ");
savebtn.setBounds(new Rectangle(150, 170, 80, 16));
resetbtn=new JButton(" Annuler ");
p1.setLayout(null);
p1.setBorder(BorderFactory.createEtchedBorder());
addComponent(p1, l1, 5,17,106,18);
addComponent(p1, l2, 5,47,106,18);
addComponent(p1, l3, 5,77,106,18);
addComponent(p1, l8, 5,107,106,18);
addComponent(p1, l4, 5,137,106,18);
addComponent(p1, l5, 5,167,106,18);
addComponent(p1, l6, 5,197,106,18);
addComponent(p1, l7, 5,227,106,18);
addComponent(p1, l9, 5,257,106,18);
addComponent(p1, l91, 5,287,106,18);
addComponent(p1, tf1, 110,15,183,22);
addComponent(p1, tf2, 110,45,183,22);
addComponent(p1, tf3, 110,75,183,22);
addComponent(p1, jj, 110,105,53,22);
addComponent(p1, jm, 180,105,53,22);
addComponent(p1, ja, 250,105,53,22);
addComponent(p1, tf4, 110,135,183,22);
addComponent(p1, tf5, 110,165,183,22);
addComponent(p1, tf6, 110,195,183,22);
addComponent(p1, tf7, 110,225,183,22);
addComponent(p1, tf9, 110,255,183,22);
addComponent(p1, tf91, 110,285,183,22);
addComponent(p1, savebtn, 80,365,100,22);
addComponent(p1, resetbtn, 200,365,100,22);
f.getContentPane().add(p1);
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";
String db = "eracontacttt";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
PreparedStatement st=con.prepareStatement("select Sujet from formation");
ResultSet res=st.executeQuery();
while(res.next()){
tf3.addItem(res.getString("Sujet"));
}
con.close();
}
catch(Exception ee)
{
//JOptionPane.showMessageDialog(p1,"Ce matricule n'existe pas");
}
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
PreparedStatement st=con.prepareStatement("select formateur from formateur");
ResultSet res=st.executeQuery();
while(res.next()){
tf7.addItem(res.getString("formateur"));
}
con.close();
}
catch(Exception ee)
{
//JOptionPane.showMessageDialog(p1,"Ce matricule n'existe pas");
}
tf1.addKeyListener(new KeyAdapter() {
public void keyReleased(KeyEvent e) {
if( e.getKeyCode() == KeyEvent.VK_ENTER ){
String value=tf1.getText();
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";
String db = "eracontacttt";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
PreparedStatement st=con.prepareStatement("select mat from personnels where affectation='"+tf1.getText()+"'");
ResultSet res=st.executeQuery();
while(res.next()){
tf2.addItem(res.getString("mat"));
}
con.close();
}
catch(Exception ee)
{
//JOptionPane.showMessageDialog(p1,"Ce matricule n'existe pas");
}
}
}
});
resetbtn.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){
tf1.setText("");
tf2.setToolTipText("");
tf3.setToolTipText("");
tf4.setText("");
tf5.setText("");
tf6.setText("");
tf7.setSelectedItem("");
jj.setSelectedItem("");
jm.setSelectedItem("");
jj.setSelectedItem("");
tf9.setText("");
tf91.setText("");
}
});
savebtn.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){
if(tf4.getText().isEmpty())
JOptionPane.showMessageDialog(null, "Veuillez remplir le champ Lieux");
else
if(tf5.getText().isEmpty())
JOptionPane.showMessageDialog(null, "Veuillez remplir le champ Heure");
else
if(tf6.getText().isEmpty())
JOptionPane.showMessageDialog(null, "Veuillez remplir le champ Durée");
else
if(tf9.getText().isEmpty())
JOptionPane.showMessageDialog(null, "Veuillez remplir le champ Document");
else
if(tf91.getText().isEmpty())
JOptionPane.showMessageDialog(null, "Veuillez remplir le champ Document de test");
else
{
String value1=tf1.getText();
String value2=(String) tf2.getSelectedItem();
String value3=(String)tf3.getSelectedItem();
//String value3=(String) tf7.getSelectedItem();
String jour=jj.getSelectedItem().toString();
String mois=jm.getSelectedItem().toString();
String anné=ja.getSelectedItem().toString();
String date=jour+"/"+mois+"/"+anné;
String value4=date;
String value5=tf4.getText();
String value6=tf5.getText();
String value7=tf6.getText();
String value8=(String) tf7.getSelectedItem();
String value9=tf9.getText();
String value10=tf91.getText();
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";
String db = "eracontacttt";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
PreparedStatement st=con.prepareStatement("insert into plan_for(affectation,mat_ouv,sujet,date,lieu,heure,duree,formateur,doc,doc_test) values(?,?,?,?,?,?,?,?,?,?,?)");
st.setString(1,value1);
st.setString(2,value2);
st.setString(3,value3);
st.setString(4,value4);
st.setString(5,value5);
st.setString(6,value6);
st.setString(7,value7);
st.setString(8,value8);
st.setString(9,value9);
st.setString(10,value10);
st.executeUpdate();
JOptionPane.showMessageDialog(p1,"Les données sont correctement insérés dans la base de données.");
con.close();
tf1.setText("");
tf2.setSelectedItem("");
tf3.setSelectedItem("");
jj.setSelectedItem("");
jm.setSelectedItem("");
jj.setSelectedItem("");
tf4.setText("");
tf5.setText("");
tf6.setText("");
tf7.setSelectedItem("");
tf9.setText("");
tf91.setText("");
}
catch(Exception e){
JOptionPane.showMessageDialog(p1,"Erreur dans la présentation des données!");
}
}}
});
}
/** Add Component Without a Layout Manager (Absolute Positioning) */
private void addComponent(Container container,Component c,int x,int y,int width,int height) {
c.setBounds(x,y,width,height);
container.add(c);
} //end of addComponent()
void dis()
{
f.getContentPane().add(p1);
f.setSize(350,500);
f.setVisible(true);
f.setResizable(true);
}
public static void main(String z[]){
planifier pro=new planifier();
pro.dis();
}
}
/////////////////////////////////////////////////////////////////////
merci d'avance
Afficher la suite
