//------------------------------------------------------------------------------
// ExJDBC6Prepared.java
//------------------------------------------------------------------------------
// Utilise la table suivante.
/*
drop table personne;
create table personne(nom varchar2(10), age integer);
insert into personne values('Riton', 23);
insert into personne values('Rita', 22);
insert into personne values('Jeanne', 22);
select * from personne;
*/
//------------------------------------------------------------------------------

import java.sql.*;

class ExJDBC6Prepared {
    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 = "update personne set age = age + 1 where nom = ?"; 

	PreparedStatement p = c.prepareStatement(texte);
	p.setString(1, "Riton");
	p.executeUpdate();

	p.setString(1, "Rita");
	p.executeUpdate();

	p.close();
	c.close();
    }
}

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