//------------------------------------------------------------------------------
// ExJDBC12Curseur.java
//------------------------------------------------------------------------------

import java.sql.*;

class ExJDBC12Curseur {
    public static void main(String[] args)
	throws SQLException, ClassNotFoundException {

	Class.forName("oracle.jdbc.driver.OracleDriver");
	Connection c = DriverManager.getConnection(
            "jdbc:oracle:thin:waller_a/AQWzsx34@servora:1521:dbinfo");

	String texte = "select nom, age from personne where age > "+25;
	System.out.println(texte);
	Statement s = c.createStatement();
	ResultSet r = s.executeQuery(texte);
	while (r.next())
	    System.out.println(r.getString(1)+", "+r.getInt(2)+" ans");
	r.close();
	s.close();

	texte = "select nom, age from personne where age > ?";
	PreparedStatement p = c.prepareStatement(texte);

	p.setInt(1, 25);
	r = p.executeQuery();
	while (r.next())
	    System.out.println(r.getString(1)+", "+r.getInt(2)+" ans");

	p.setInt(1, 26);
	r = p.executeQuery();
	while (r.next())
	    System.out.println(r.getString(1)+", "+r.getInt(2)+" ans");

	r.close();
	p.close();

	c.close();
    }
}

//------------------------------------------------------------------------------