1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| String query1="select idExemplaire from Pret where Etat=1" ;
ResultSet r1=st.executeQuery(query1);
String query2="select idExemplaire from Reservation " ;
ResultSet r2=st.executeQuery(query2);
String query3="select idExemplaire from Exemplaire where idOuvrage='"+T2.getText()+"' " ;
ResultSet r3=st.executeQuery(query3);
boolean b=false;String s="";
ResultSet t,j;
while(r1.next()){
boolean c=false;
j=r3;
while(j.next()){
if(j.getString("idExemplaire").equals(r1.getString("idExemplaire"))){
c=true;break;
}}
if(c==true){
t=r2;
while(t.next()){
if(r1.getString("idExemplaire").equals(t.getString("idExemplaire"))){
b=true;break;
}}}
if(b==false){
s=r1.getString("idExemplaire");break;} |
Partager