JDBCPostgres.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.Scanner;

/*
 * This code works fine on any PC! We use Java + JDBC + Postgres DB from Supabase. 
*/

public class JDBCPostgres {
    
    static final synchronized public void main(String... abc) throws Exception {

        // Take value from console
        Scanner s = new Scanner(System.in);

        System.out.print("Enter ID: ");
        int id = s.nextInt();

        System.out.print("Enter Name: ");
        String name = s.next();

        s.nextLine();

        System.out.print("Enter Address: ");
        String address = s.nextLine();

        System.out.print("Enter Mobile Number: ");
        long mobile = s.nextLong();

        // JDBC connection!

        // Step0 : Import Packages
        // Step1 : Load the Driver 
        Class.forName("org.postgresql.Driver"); // PostgreSQL driver
        System.out.println("Driver loaded successfully!");

        // Step2 : Conn Establishment (Supabase connection string)
        String url = "jdbc:postgresql://aws-0-ap-south-1.pooler.supabase.com:6543/postgres?user=postgres.yshxqhzwcekhvudlkaju&password=root";
        Connection con = DriverManager.getConnection(url);

        System.out.println("Connection Established!");

        // Step3: Create PreparedStatement
        PreparedStatement ps = con.prepareStatement("INSERT INTO student (id, name, address, mobile) VALUES (?, ?, ?, ?)");

        ps.setInt(1, id);
        ps.setString(2, name);
        ps.setString(3, address);
        ps.setLong(4, mobile);

        // Step4: Execute the query
        int ch = ps.executeUpdate();

        System.out.println(ch + " row(s) affected");

        // Step5: Release the resources
        ps.close();
        con.close();
    }
}