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();
}