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
| Statement stmt,stmt1,stmt2 = null;
stmt = connection.createStatement();
ResultSet rset,rset1,rset2 ;
rset=stmt.executeQuery("SELECT COUNT(*) AS rowcount FROM VEHICULE");
while(rset.next());
s = rset.getInt("rowcount") ;
rset.close() ;
PrintWriter f = null;
f = new PrintWriter(new FileWriter("sta.txt"));
f.println("le nombre de voiture "+s);
stmt1 = connection.createStatement();
rset1=stmt1.executeQuery("SELECT COUNT(*) AS rowcount FROM VEHICULE WHERE ETAT='rêvision'");
while(rset.next())
s = rset1.getInt("rowcount") ;
rset.close() ;
f.println("le nombre de voiture "+s);
stmt2 = connection.createStatement();
rset2=stmt2.executeQuery("select count(*) AS rowcount from course group by ncin");
while(rset2.next())
s = rset2.getInt("rowcount") ;
rset2.close() ;
f.println("le nombre de course par chauffeur "+s);
f.close();
connection.close(); } |
Partager