olympicDB.java

import java.util.NoSuchElementException;
import java.util.Properties;
import java.sql.*;
import java.util.Scanner;

public class olympicDB{
    private  static Connection connection;
    private static Scanner scanner = new Scanner(System.in);
    public static void main(String[] args){

        try {
            Class.forName("org.postgresql.Driver");
        } catch (ClassNotFoundException err) {
            System.err.println("Unable to detect the JDBC .jar dependency. Check that the library is correctly loaded in and try again.");
            System.exit(-1);
        }
        displayOptions();

        scanner.close();

    }
    private static void displayOptions() {
        while (true) {

            System.out.println("1. Connect to Database");
            System.out.println("2. Create Account");
            System.out.println("3. Delete Account");
            System.out.println("4. Add Participant");
            System.out.println("5. Delete Participant");
            System.out.println("6. Add Team Member");
            System.out.println("7. Remove Team Member");
            System.out.println("8. Register Team");
            System.out.println("9. Add Event");
            System.out.println("10. Add Team to Event");
            System.out.println("11. Add Event Outcome");
            System.out.println("12. Disqualify Team");
            System.out.println("13. List Venues in Olympiad");
            System.out.println("14. List Events of Olympiad");
            System.out.println("15. List Teams In Event");
            System.out.println("16. Show Placements in Event");
            System.out.println("17. List Participants on Team");
            System.out.println("18. Country Rankings");
            System.out.println("19. Top Sports");
            System.out.println("21. Exit");

            System.out.print("Enter your choice: ");
            int choice = scanner.nextInt();
            scanner.nextLine(); // Consume the newline character

            switch (choice) {
                case 1:
                    connect();
                    break;
                case 2:
                    createAccount();
                    break;
                case 3:
                    deleteAccount()
                    break;
                case 4:
                    addParticipant();
                    break;
                case 5:
                    deleteParticipant();
                    break;
                case 6:
                    addTeamMember();
                    break;
                case 7:
                    removeTeamMember();
                    break;
                case 8:
                    registerTeam();
                    break;
                case 9:
                    addEvent();
                    break;
                case 10:
                    addTeamToEvent();
                    break;
                case 11:
                    addEventOutcome();
                    break;
                case 12:
                    disqualifyTeam();
                    break;
                case 13:
                    listVenuesInOlympiad();
                    break;
                case 14:
                    listEventsInOlympiad();
                    break;
                case 15:
                    listTeamsInEvent();
                    break;
                case 16:
                    showPlacementsInEvent();
                    break;
                case 17:
                    listParticipantsOnTeam();
                    break;
                case 18:
                    countryRankings();
                    break;
                case 19:
                    topSports();
                    break;
                case 21:
                    exit();
                    break;
                default:
                    System.out.println("Invalid");
            }
        }
    }

    private static void connect(){
        String url = "jdbc:postgresql://localhost:5432/";
        Properties props = new Properties();
    
        try {
            System.out.println("Enter username ");
            String username = scanner.nextLine();
            System.out.println("Enter password: ");
            String password = scanner.nextLine();
    
            props.setProperty("user", username);
            props.setProperty("password", password);
            props.setProperty("escapeSyntaxCallMode", "callIfNoReturn");
    
        } catch (NoSuchElementException ex) {
            System.err.println("No lines were read from user input, please try again");
            System.exit(-1);
        } catch (IllegalArgumentException ex) {
            System.err.println("Error");
            System.exit(-1);
        }
    
        try {
            connection = DriverManager.getConnection(url, props);
          
            System.out.println("Successfully connected to Databse!");
        } catch (SQLException err) {
            System.out.println("SQL Error");
            while (err != null) {
                System.out.println("Message = " + err.getMessage());
                System.out.println("SQLState = " + err.getSQLState());
                System.out.println("SQL Code = " + err.getErrorCode());
                err = err.getNextException();
            }
        }
    }

    private static void createAccount(){
        System.out.println("Enter username: ");
        String user_name = scanner.nextLine();
        System.out.println("Enter passkey: ");
        String passkey = scanner.nextLine();
        System.out.println("Enter role: ");
        String role = scanner.nextLine();

        try(CallableStatement createAccount = connection.prepareCall("SELECT olympicDB.createAccount(?, ?, ?)")){
            createAccount.setString(1, user_name);
            createAccount.setString(2, passkey);
            createAccount.setString(3, role);
            
            createAccount.execute();

            System.out.println("Account added");

        }catch (SQLException e) {
            System.out.println("SQL Error: " + e);
            for (SQLException ex = e; ex != null; ex = ex.getNextException()) {
                if (ex != null) {
                        System.out.println("Message = " + ex.getMessage());
                        System.out.println("SQLState = " + ex.getSQLState());
                        System.out.println("SQL Code = " + ex.getErrorCode());
                    
                }
            }
        }
        
    }
    private static void deleteAccount(){
        
    }
    private static void addParticipant(){
        
    }
    private static void deleteParticipant(){
        
    }
    private static void addTeamMember(){
        
    }
    private static void removeTeamMember(){
        
    }
    private static void registerTeam(){
        
    }
    private static void addEvent(){
        
    }
    private static void addTeamToEvent(){
        
    }
    private static void addEventOutcome(){
        
    }
    private static void disqualifyTeam(){
        
    }
    private static void listVenuesInOlympiad(){
        
    }
    private static void listEventsInOlympiad(){
        
    }
    private static void listTeamsInEvent(){
        
    }
    private static void showPlacementsInEvent(){
        
    }
    private static void listParticipantsOnTeam(){
        
    }
    private static void countryRankings(){
        
    }
    private static void topSports(){
        
    }


}