Salut encore
je veux enregistrer dans plusieur table a la fois
par exemple on a table1, table2,table3
et les deux dernier prend une valuer qui est la clés primaire de table1
voila le code :
//MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
try {
NumNom="'"+(String)jcbResponsable.getSelectedItem()+"'";
ResultSet rsr = str.executeQuery("SELECT N° FROM Responsable where Nom like "+NumNom);
rsr.next();
Nim=rsr.getInt(1);
}
catch (SQLException g){
System.out.println(g.toString());
}
//MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
//MMMMMMMMMMMMMMMMMMMMMMMMMMMMM Ajoutter MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
Statement st = null;
Intitulé="'"+txt.getText()+"'";
Résumé="'"+txtResume.getText()+"'";
Résultat="'"+txtResultat.getText()+"'";
Domaine="'"+jcbDomaine.getSelectedItem()+"'";
Région="'"+jcbRegion.getSelectedItem()+"'";
Année="'"+txtAnnee.getText()+"'";
OrganismeCoo="'"+jcbOrgaCoo.getSelectedItem()+"'";
departement="'"+jcbDepartement.getSelectedItem()+"'";
Budget="'"+txtBudget.getText()+"'";//MMMMMMMMMMMM
//Appréciations
String req = null,req2=null,req3=null;
try {
//Execution de la requete
req="INSERT INTO Projet (IntituléProjet,[Année de soumission],Domaine,Région,OrganismeCoordonnateur,Département,[N°Responsable],Résultats,Appréciations,Résumer) VALUES ("+Intitulé+","+Année+","+Domaine+","+Région+","+OrganismeCoo+","+departement+","+Nim+","+Résultat+",'',"+Résumé+")";
st = conn.createStatement();
int rs = st.executeUpdate(req);
}
catch (SQLException ef){
System.out.println(ef.toString());
}
JOptionPane.showMessageDialog(this,
"Projet bien Enregistrer !");
//MMMMMMMMMMMMMMMMMMMMMMMMMMMMM Ajoutter MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
try {
NumNom="'"+txt.getText()+"'";
str = conn.createStatement();
ResultSet rsr = str.executeQuery("SELECT N° FROM Projet where Nom like "+NumNom);
rsr.next();
Nim=rsr.getInt(1);
System.out.print(Nim);
}
catch (SQLException g){
System.out.println(g.toString());
}
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
//MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM AUTRES MMMMMMMMMMMM EquipeInstitutionCool MMMMMMMMMMMMMMMMMMMMM
String reqr1 = null;
try {
//Execution de la requete
reqr1="INSERT INTO EquipeInstitutionCool(N°) VALUES ("+Nim+")";
st = conn.createStatement();
int rs = st.executeUpdate(reqr1);
}
catch (SQLException ef){
System.out.println(ef.toString());
}
//MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM AUTRES MMMMMMMMMMM EquipeJury MMMMMMMMMMMMMMMMMMMMM
String reqr2=null;
try {
//Execution de la requete
reqr2="INSERT INTO EquipeJury(N°) VALUES ("+Nim+")";
st = conn.createStatement();
int rs = st.executeUpdate(reqr2);
}
catch (SQLException ef){
System.out.println(ef.toString());
}
//MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM AUTRES MMMMMMMM EquipeChercheurs MMMMMMMMMMMMMMMMMMM
String reqr3=null;
try {
//Execution de la requete
reqr3="INSERT INTO EquipeChercheurs(N°) VALUES ("+Nim+")";
st = conn.createStatement();
int rs = st.executeUpdate(reqr3);
}
catch (SQLException ef){
System.out.println(ef.toString());
}
//MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM AUTRES MMMMMMMMMMMMM MotsClés MMMMMMMMMMMMMMMMMM
String reqr4=null;
try {
//Execution de la requete
reqr4="INSERT INTO MotsClés(N°) VALUES ("+Nim+")";
st = conn.createStatement();
int rs = st.executeUpdate(reqr4);
}
catch (SQLException ef){
System.out.println(ef.toString());
}
//MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM AUTRES MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
Si qulque peut m'aider ?
ca sera shouet