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 32 33 34 35 36 37 38 39 40 41 42 43 44 45
|
try{
PreparedStatement i =con.getcon().prepareStatement("SELECT CODECLIE FROM CLIENT WHERE LOGUTIL like '"+numutiisateur+"'");
ResultSet r=i.executeQuery();
while(r.next())
{
clie=r.getString("CODECLIE");
System.out.println(clie);
}
} catch (Exception e)
{
e.printStackTrace();
}
try{
PreparedStatement i =con.getcon().prepareStatement("SELECT CODETYPEREGAB FROM TYPE_REGLEMENT_ABONNEMENT WHERE LIBTYPREGAB like '"+paiement+"'");
ResultSet r=i.executeQuery();
while(r.next())
{
reg=r.getString("CODETYPEREGAB");
System.out.println(reg);
}
} catch (Exception e)
{
e.printStackTrace();
}
try{
PreparedStatement i =con.getcon().prepareStatement("SELECT CODETYPEDEMAB FROM TYPE_DEMANDE_ABONNEMENT WHERE LIBTYPEDEAB like '"+abon+"'");
ResultSet r=i.executeQuery();
while(r.next())
{
ab=r.getString("CODETYPEDEMAB");
System.out.println(ab);
}
} catch (Exception e)
{
e.printStackTrace();
}
try{
PreparedStatement i =con.getcon().prepareStatement("INSERT INTO DEMANDE_ABONNEMENT(NUMDEMABON,ADRESLOCALAB,VILLELOCALAB, CODETYPEREGAB,CODETYPEDEMAB,CODECLIE)values('"+appeler masequenceici+"','"+adresse+"','"+ville+"','"+reg+"','"+ab+"','"+clie+"')WHERE LOGUTIL like '"+numutiisateur+"'");
ResultSet r=i.executeQuery();
} catch (Exception e)
{
e.printStackTrace();
} |
Partager