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
| import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class UnJoueur{
Connection maConnection=null;
void execRequete(){
int monInt;
String maString=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String filename="jdbc:odbc:supernet.mdb";
String database="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
database+=filename.trim()+";DriverID=22;READONLY=true}";
maConnection = DriverManager.getConnection(database,"","");
Statement stmt=maConnection.createStatement();
ResultSet resultSet=stmt.executeQuery("Select nom client FROM Client");
while(resultSet.next()){
monInt=resultSet.getInt(1);
maString=resultSet.getString(2);
System.out.println("Mon INT = " + monInt );
System.out.println("Ma String = " + maString );
}
}
catch(Exception e){ System.out.println("Error:"+e);
}
public static void main(String[] args){
UnJoueur monJoueur = new UnJoueur();
monJoueur.execRequete();
} |
