import java.sql.*;

public class Test {
	public static void main(String args[]) 
	{
		String username="root";
		String password="";
		String url="jdbc:mysql:http://127.0.0.1/test";
		String query="SELECT * FROM tabdetest";
		try {
			Class.forName("com.mysql.jdbc.Driver").newInstance(); //org.gjt.mm.mysql.Driver
		} catch(Exception e) { //java.lang.ClassNotFoundException e
			System.err.print("ClassNotFoundException :");
			System.err.println(e.getMessage());
		}
		try {
			Connection con;
			Statement stmt;
			con=DriverManager.getConnection(url,username,password);
			System.out.println("Connexion réussie !");
			System.out.println("Déterminons ce que fournie la requète "+query);
						System.out.println("ok");
			stmt=con.createStatement();
			ResultSet rs= stmt.executeQuery(query);
			while (rs.next()) 
			{
				int n=rs.getInt("entier");
				String s=rs.getString("chaine");
				float f=rs.getFloat("reel");
				System.out.println(n + " " + s + " " + f);
			}
			stmt.close();
			con.close();
		} catch(SQLException ex) {
			System.err.println(" --> SQLException :");
			while (ex!=null) 
			{
				System.out.println("Message   : " + ex.getMessage());
				System.out.println("SQLState  : " + ex.getSQLState());
				System.out.println("ErrorCode : " + ex.getErrorCode());
				ex=ex.getNextException();
				System.out.println("");
			}
		}
	}
}