module_hw5/src/main/java/example/org/Main.java - hw5 - caleb412/SberJavaCourseBeginner

module_hw5/src/main/java/example/org/Main.java
155 строк7 KB
Caleb Chanda
Created hw5 and completed work
27 апр 2025, 15:33
27 апр 2025, 15:33cff7cba
package example.org;
import java.sql.*;
import java.util.Scanner;

public class Main {
    static Scanner sc = new Scanner(System.in);

    public static void main(String[] args) throws SQLException {
        try {
            boolean isRunning = true;
            while (isRunning) {
                System.out.println("Choose a repository to work with:\n1. Students\n2. Teachers\n3. Courses\n4. Classes\n5. Show Course Info\n Press 'e' to end program");
                String table = (sc.nextLine());
                switch (table) {
                    case "1":
                        StudentsRepository sr = new StudentsRepository();
                        System.out.println("Enter operation:\n 1. Insert record to table\n 2. Show records\n 3. Update value\n 4. Delete value\n Press 'e' to end program");
                        String studentOperation = sc.nextLine();
                        switch (studentOperation) {
                            case "1":
                                sr.insertRecord();
                                break;
                            case "2":
                                sr.readRecord();
                                break;
                            case "3":
                                sr.updateRecord();
                                break;
                            case "4":
                                sr.deleteRecord();
                                break;
                            case "e":
                                isRunning = false;
                                break;
                            default:
                                System.out.println("Wrong Input!");
                                break;
                        }
                        break;
                    case "2":
                        TeachersRepository tr = new TeachersRepository();
                        System.out.println("Enter operation:\n 1. Insert record to table\n 2. Show records\n 3. Update value\n 4. Delete value\n Press 'e' to end program");
                        String teachersOperation = sc.nextLine();
                        switch (teachersOperation) {
                            case "1":
                                tr.insertRecord();
                                break;
                            case "2":
                                tr.readRecord();
                                break;
                            case "3":
                                tr.updateRecord();
                                break;
                            case "4":
                                tr.deleteRecord();
                                break;
                            case "e":
                                isRunning = false;
                                break;
                            default:
                                System.out.println("Wrong Input!");
                                break;
                        }

                        break;
                    case "3":
                        CoursesRepository cr = new CoursesRepository();
                        System.out.println("Enter operation:\n 1. Insert record to table\n 2. Show records\n 3. Update value\n 4. Delete value\n Press 'e' to end program");
                        String coursesOperation = sc.nextLine();
                        switch (coursesOperation) {
                            case "1":
                                cr.insertRecord();
                                break;
                            case "2":
                                cr.readRecord();
                                break;
                            case "3":
                                cr.updateRecord();
                                break;
                            case "4":
                                cr.deleteRecord();
                                break;
                            case "e":
                                isRunning = false;
                                break;
                            default:
                                System.out.println("Wrong Input!");
                                break;

                        }
                        break;
                    case "4":
                        ClassesRepository classrepo = new ClassesRepository();
                        System.out.println("Enter operation:\n 1. Insert record to table\n 2. Show records\n 3. Update value\n 4. Delete value\n Press 'e' to end program");
                        String classesOperation = sc.nextLine();
                        switch (classesOperation) {
                            case "1":
                                classrepo.insertRecord();
                                break;
                            case "2":
                                classrepo.readRecord();
                                break;
                            case "3":
                                classrepo.updateRecord();
                                break;
                            case "4":
                                classrepo.deleteRecord();
                                break;
                            case "e":
                                isRunning = false;
                                break;
                        }
                        break;
                    case "5":
                        showCourseInformation();
                        break;
                    case "e":
                        isRunning = false;
                        break;
                    default:
                        System.out.println("Enter valid Input");
                        break;
                }
            }
            sc.close();
        } catch (Exception e) {
            throw new SQLException("Something went wrong!" + e);
        }
    }

    public static void showCourseInformation() throws SQLException {
        String sql = "Select c.course_name,t.surname, t.name,t.middle_name,count(cs.studentid) from courses c\n" +
                "join teachers t \n" +
                "on c.teacherid = t.teacherid\n" +
                "join classes cs \n" +
                "on c.courseid = cs.courseid\n" +
                "group by c.course_name,t.surname, t.name,t.middle_name\n";
        try{
            Connection connection = DatabaseConnect.getConnection();
            assert connection !=null;
            PreparedStatement ps = connection.prepareStatement(sql);
            ResultSet rs = ps.executeQuery();
            System.out.printf("| %-20s || %-20s || %-20s || %-20s ||%-5s %n","COURSE NAME","SURNAME","NAME","MIDDLE NAME", "№ STUDENTS");
            System.out.printf("------------------------------------------------------------------------------------------------------ %n");
            while (rs.next()){
                System.out.printf("| %-20s || %-20s || %-20s || %-20s ||%-5s%n",
                        rs.getString("course_name"),rs.getString("surname"),rs.getString("name")
                ,rs.getString("middle_name"),rs.getInt("count"));
            }
            connection.close();
        }catch (SQLException e){
            System.out.println("Something went wrong " + e);
        }
    }
}