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
|
import java.sql.*;
class JdbcDB2 {
static Connection con;
public static void main (String[] args) {
try {
Class.forName("com.ibm.db2.jcc.DB2Driver");
}
catch(Exception e){
System.out.println("Erreur lors du chargement du driver:"+ e.getMessage());
}
try{
con = DriverManager.getConnection("jdbc:db2://cordemais:50100/dppe","iapploc","iapploc");
}
catch(Exception e){
System.out.println("echec d'ouverture:"+e.getMessage());
}
String strQuery = "SELECT * FROM Data.Candidats";
PreparedStatement stmt;
ResultSet rsUsers;
try {
stmt = con.prepareStatement(strQuery);
rsUsers = stmt.executeQuery();
while(rsUsers.next()) {
System.out.print(rsUsers.getString("nom_can"));
}
rsUsers.close();
}
catch(Exception e){
System.out.println("Erreur lors du parcours de la table:"+ e.getMessage());
}
}
} |
