import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class PostgreSQLJDBC {
   public static void main( String args[] ) {
      Connection c = null;
      Statement stmt = null;
      try {
         Class.forName("org.postgresql.Driver");
         c = DriverManager
            .getConnection("jdbc:postgresql://localhost:5433/partage",
            "postgres", "1");
         c.setAutoCommit(false);
         System.out.println("Opened database successfully");

         stmt = c.createStatement();


         //SQL Insertion
         String sql = "INSERT INTO utilisateurs "
                 + "VALUES (6, 'abcd', 'abcd@gmail.com', 'abcd123456', '(52.511665, 63.694068)')";
              stmt.executeUpdate(sql);
         c.commit();


          // SQL Query
         ResultSet rs = stmt.executeQuery( "SELECT * FROM utilisateurs;" );
         while ( rs.next() ) {
            int id = rs.getInt("num_utilisateur");
            String  name = rs.getString("nom");

            System.out.println( "ID = " + id );
            System.out.println( "NAME = " + name );

            System.out.println();
         }


         // SQL Update
         sql = "UPDATE utilisateurs set nom = 'ghi' where num_utilisateur = 6;";
         stmt.executeUpdate(sql);
         c.commit();


         // SQL Query
         rs = stmt.executeQuery( "SELECT * FROM utilisateurs;" );
         while ( rs.next() ) {
            int id = rs.getInt("num_utilisateur");
            String  name = rs.getString("nom");

            System.out.println( "ID = " + id );
            System.out.println( "NAME = " + name );

            System.out.println();
         }



         //SQL Delete
         sql = "DELETE from utilisateurs where num_utilisateur = 6;";
         stmt.executeUpdate(sql);
         c.commit();


         // SQL Query
         rs = stmt.executeQuery( "SELECT * FROM utilisateurs;" );
         while ( rs.next() ) {
            int id = rs.getInt("num_utilisateur");
            String  name = rs.getString("nom");

            System.out.println( "ID = " + id );
            System.out.println( "NAME = " + name );

            System.out.println();
         }


         rs.close();
         stmt.close();
         c.close();
      } catch ( Exception e ) {
         System.err.println( e.getClass().getName()+": "+ e.getMessage() );
         System.exit(0);
      }
      System.out.println("Operation done successfully");
   }
}