import java.sql.*;

public class SimpleQuery {
    static final String CONN_URL = "jdbc:oracle:thin:@ensibm.imag.fr:1521:ensi2";
    static final String USER = "leroyo"; // A remplacer pour votre compte
    static final String PASSWD = "leroyo";
    static final String STMT = "select * from resto";

    public SimpleQuery() {
        try{
            // Enregistrement du driver Oracle
            System.out.print("Loading Oracle driver... ");
            DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
            System.out.println("loaded");
            // Etablissement de la connection
            System.out.print("Connecting to the database... ");
            Connection conn = DriverManager.getConnection(CONN_URL, USER, PASSWD);
            System.out.println("connected");
            // Creation de la requete
            Statement stmt = conn.createStatement();
            // Execution de la requete
            ResultSet rset = stmt.executeQuery(STMT);
            // Affichage du resultat
            System.out.println("Results:");
            dumpResultSet(rset);
            System.out.println();
            // Fermeture
            rset.close();
            stmt.close();
            conn.close();
        }
        catch (SQLException e) {
            System.err.println("failed");
            e.printStackTrace(System.err);
        }
    }

    private void dumpResultSet(ResultSet rset) throws SQLException {
        ResultSetMetaData rsetmd = rset.getMetaData();
        int i = rsetmd.getColumnCount();
        for (int k=1;k<=i;k++){
            System.out.print(rsetmd.getColumnName(k) + "\t");
            System.out.println();
        }
        while (rset.next()) {
            for (int j = 1; j <= i; j++) {
                System.out.print(rset.getString(j) + "\t");
            }
        System.out.println();
        }
    }
}