package ca.etsmtl.log720.tutorielDependancies;

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 )
    {
        Connection c = null;
        Statement stmt = null;
        try {
            Class.forName("org.postgresql.Driver");
            c = DriverManager
                .getConnection("jdbc:postgresql://log720.logti.etsmtl.ca:5432/log720_20183_6", "ak93480", "Log7203");
            c.setAutoCommit(false);

            stmt = c.createStatement();

            String sql = "INSERT INTO TEST (ID,NAME) "
            + "VALUES (1, 'Test 1' );";
            stmt.executeUpdate(sql);
            c.commit();

            ResultSet rs = stmt.executeQuery("SELECT * FROM TEST;");

            while ( rs.next() ) {
                int id = rs.getInt("id");
                String  name = rs.getString("name");
                System.out.println( "ID = " + id );
                System.out.println( "NAME = " + name );
                System.out.println();
            }

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