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 51 52 53 54 55 56 57 58 59 60 61 62
| package package1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class calcul
{
static Connection con;
static Statement stmt1,stmt2;
static ResultSet rs1,rs2;
static String rq2,rq1;
public static void main(String [] args)throws SQLException, ClassNotFoundException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:bd1";
con = DriverManager.getConnection(url);
rq1= " SELECT Count(valeur) FROM Table1;";
//rq2 = " SELECT Count (valeur) FROM Table1 where valeur is null;" ;
stmt1 = con.createStatement();
//stmt2 = con.createStatement();
rs1= stmt1.executeQuery(rq1);
//rs2=stmt2.executeQuery(rq2);
//int nombreValeurNulles = 0;
while (rs1.next())
{
System.out.println(rs1.getInt(1));
}
// while (rs2.next())
// {
// String valeur = rs2.getString(2);
// if(valeur==null || valeur.length() ==0)
// {
// nombreValeurNulles = nombreValeurNulles +1;
// }
//
// System.out.println("Le nombre de valeurs nulles est " + nombreValeurNulles);
// }
}
catch (SQLException e)
{
System.err.println("Driver non chargé");
e.printStackTrace();
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
finally
{
try {con.close();
}
catch(SQLException e) {e.printStackTrace();}
}
}
} |
Partager