import java.beans.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
// run using this: java -cp "C:\Users\traip\OneDrive\Desktop\CSEstuff\CSE_132A_Database_System_Principle\PA_2\postgresql-42.5.1.jar;." Sample jdbc:postgresql://localhost/sample postgres Kirito15961992*
public class Sample {
    public static void main(String[] args){

        String connURL = args[0]; // jdbc:postgresql://localhost/sample
        String userName = args[1]; // postgres
        String password = args[2];

        connectAndTest(connURL, userName, password);
    }
    public static void connectAndTest(String connURL, String userName, String password){
        try{
            Connection conn = DriverManager.getConnection(connURL, userName, password);
            System.out.println("connected!");

            java.sql.Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM student");

            while(rs.next()){
                System.out.println("id: " + rs.getInt("id"));
                System.out.println("age: " + rs.getInt("age"));
                System.out.println("name: " + rs.getString("name"));
                System.out.println();
            }
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}