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 46 47 48 49 50
|
String requete = "SELECT comptaN FROM donnees_comptable WHERE num_devis = '"+numDevis+"'";
float compta = 0f;
java.sql.ResultSet res = null ;
/****************/
System.out.println("REQUETE getCOmpta :"+requete);
try {
Class.forName(Constantes.piloteBase);
String connectionString = Constantes.urlBase;
conn = DriverManager.getConnection(connectionString);
} catch (Exception e) {
System.out.println(e.getMessage());
e.printStackTrace();
}
try{
stmt = conn.createStatement();
try{
rs = stmt.executeQuery(query);
try {
while ( res.next() )
{
compta = res.getFloat(1);
}
finally{
if (rs != null){
try { rs.close(); } catch (Exception e) { }
}
}
finally{
if (stmt != null) {
try { stmt.close(); } catch (Exception e) { }
}
}
}
}
finally{
if (conn != null){
try { conn.close(); } catch (Exception e) { }
}
} |