voivç le code
package MyProject;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Stagiaire{
static InputStreamReader lecteur;
static BufferedReader entree;
static String url = "jdbc:odbc:gestion_stagiaire";
static Connection con=null;
static ResultSet rs=null;
static boolean rep=false;
void connexion(){
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(url,"","");
//içi 1er ereur my frame souligné en rouge--->(erreuer invalid)//
public class MyFrame extends JFrame implements ActionListener{
private JButton add;
private JButton sup;
private JButton mod;
private JButton rech;
private JButton quitter;
public MyFrame(){
super("My Frame");
JPanel jPanel1 = new JPanel();
JLabel jLabel = new JLabel();
JPanel jPane2 = new JPanel();
JLabel jLabe3= new JLabel();
JLabel jLabe4 = new JLabel();
add=new JButton ("ajouter");
sup=new JButton(" Supprimer ");
mod=new JButton(" Modifier ");
rech= new JButton ("rechercher");
quitter= new JButton (" quitter");
add.addActionListener(this);
sup.addActionListener(this);
mod.addActionListener(this);
rech.addActionListener(this);
quitter.addActionListener(this);
getContentPane().setLayout(new FlowLayout());
getContentPane().add(add);
getContentPane().add(sup);
getContentPane().add(mod);
getContentPane().add(rech);
getContentPane().add(quitter);
JTextField text=new JTextField();
JTextField text1=new JTextField();
JTextField text2=new JTextField();
JTextField text3=new JTextField();
pack();
setVisible(true);
}
public void afficher_stagiaire() throws SQLException{
connexion();
PreparedStatement ps = con.prepareStatement("SELECT * from stagiaire");
rs = ps.executeQuery();
while(rs.next()==true){
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
System.out.println(rs.getString(4));
}
}
public void actionPerformed(ActionEvent ae){
if(ae.getSource().equals(add))
System.out.println("Entrer code Stagiaire");
String code = entree.readLine();
PreparedStatement ps = con.prepareStatement("SELECT * from Stagiaire where code_stg = '" + code + "'");
rs = ps.executeQuery();
while(rs.next()==true){
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
System.out.println(rs.getString(4));
}
}
----->//tt cette extrait souligné en rouge,et en utulisant focus-->aucun suggestion!!//
public void supprimer_Stagiaire() throws IOException, SQLException{
connexion();
System.out.println("Entrer mat Stagiaire");
String code = entree.readLine();
verifier(code,"SELECT code_stg from Stagiaire");
if (rep==false){
System.out.println("Stagiaire Introuvable");}
else{
PreparedStatement ps = con.prepareStatement("delete from Stagiaire where code_stg = '" + code + "'");
ps.executeUpdate();
System.out.println("Stagiaire Supprimé");}
}
public void Ajouter_Stagiaire() throws NumberFormatException, IOException, SQLException{
connexion();
String code = entree.readLine();
verifier(code,"SELECT code_stg from Stagiaire");
if (rep==true){
System.out.println("Stagiaire Déja existe");
}
else{
System.out.println("Entrer le nom");
String nom=entree.readLine();
System.out.println("Entrer le prenom");
String prenom=entree.readLine();
System.out.println("Entrer la date de naissance");
String dte=entree.readLine();
System.out.println("Entrer le lieu de naissance");
String ldte=entree.readLine();
System.out.println("Entrer l'adresse");
String adre=entree.readLine();
System.out.println("Entrer le tel");
String tel=entree.readLine();
PreparedStatement ps = con.prepareStatement("insert into Stagiaire values ('" + code + "','" + nom + "','" + prenom + "','" + dte + "','" + ldte + "','" + adre + "','" + tel + "')");
ps.executeUpdate();
System.out.println("Stagiaire Ajouté");}
}
/*if(ae.getSource().equals(rech))
System.out.println("Recherche");
if(ae.getSource().equals(quitter))
System.out.println("Quitter");*/
private void verifier(String code, String string) {
// TODO Auto-generated method stub
}
}
public void main(String[] args){
new MyFrame();
}
//*public void verifier(String code, String string) {
// TODO Auto-generated method stub
}*/
TT ça ne done pas de debogae,et les package et main se marquent croix rouge !!! :cry:
Mercii bien
voivç le code
package MyProject;
TT ça ne done pas de debogae,et les package et main se marquent croix rouge !!! :cry:
Mercii bien