Contact
Address/Adresse
- PReCISE / LIBD
- Faculté d'informatique
- Rue Grandgagnage, 21
- B-5000 Namur - Belgium
Accès/Access: Français English
- Jean-Luc Hainaut (e-mail: jean-luc.hainaut AT unamur.be)
- Vincent Englebert (e-mail: vincent.englebert AT unamur.be)
- Anthony Cleve (e-mail: anthony.cleve AT unamur.be)
Please ignore the following section
Comparing SQLfast and Java/JDBC
The SQLfast code (here just a simple SQL query) is executed at level 0 (Learning SQL), when database ORDERS.db has been opened. Error exceptions are coped with automatically.
select NCLI,NOM from CLIENT;
|
import java.net.URL;
import java.io.*;
import ...;
import java.sql.*;
import java.util.*;
String url = "jdbc:interbase://server1/CLICOM.gdb";
String user ="myLogin";
String pw="myPassword";
Connexion conn = null;
Statement stmt = null;
ResultSet res = null;
String selectQ = "select NCLI,NOM from CLIENT";
String CiD;
String Cnom;
try {
Class.forName("interbase.interclient.Driver");
conn = DriverManager.getConnection(url,user,pw);
}
catch (Exception e) {
System.err.println( e.getClass().getName()
+ ": " + e.getMessage() );
System.exit(0);
}
try {
stmt = conn.createStatement ();
res = stmt.executeQuery (selectQ);
System.out.println("NCLI, NOM");
while (res.next()) {
CiD = res.getString("NCLI");
Cnom = res.getString("NOM");
System.out.println(CiD + ", " + Cnom);
}
res.close();
stmt.close();
conn.close();
}
catch (Exception e) {
System.err.println( e.getClass().getName()
+ ": " + e.getMessage() );
}
|
<Retour à la page d'accueil / Back>