import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class App {

	public static void main(String[] args) {

		String BASEDEDONNEES_URL = "jdbc:postgresql://localhost:5433/confiserie";
		String BASEDEDONNEES_USAGER = "postgres";
		String BASEDEDONNEES_MOTDEPASSE = "testtest";		
		
		try {
			Class.forName("org.postgresql.Driver");
			Connection connexion = null;
			connexion = DriverManager.getConnection(BASEDEDONNEES_URL, BASEDEDONNEES_USAGER, BASEDEDONNEES_MOTDEPASSE);
			
			Statement requete = connexion.createStatement();
			ResultSet curseur = requete.executeQuery("SELECT * FROM chocolat");
			
			curseur.next();
			String nom = curseur.getString("nom");
			System.out.println("Nom : " + nom);

			curseur.next();
			nom = curseur.getString("nom");
			System.out.println("Nom : " + nom);
			
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}

}
