package Database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class mark {
    public static void main(String[] args) {
        // Correct JDBC URL format for UCanAccess
        String dataBaseURL = "jdbc:ucanaccess:
StudentMarkDatabase\\src\\Database\\Marks Database.accdb";

        try {
            // Register the JDBC driver
            Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");

            // Establish the connection
            Connection conn = DriverManager.getConnection(dataBaseURL);

            // Create a statement
            Statement statement = conn.createStatement();

            // Execute the query
            String query = "SELECT * FROM tblStudents"; // Ensure correct table name case sensitivity
            ResultSet resultSet = statement.executeQuery(query);

            // Process the result set
            while (resultSet.next()) {
                int stuID = resultSet.getInt("StuID");
                String firstName = resultSet.getString("FirstName");
                String lastName = resultSet.getString("LastName");
                String userName = resultSet.getString("UserName");
                String password = resultSet.getString("Password");
                String dob = resultSet.getString("DOB");

                System.out.println("StuID: " + stuID + ", FirstName: " + firstName + ", LastName: " + lastName +
                                   ", UserName: " + userName + ", Password: " + password + ", DOB: " + dob);
            }

            // Close the resources
            resultSet.close();
            statement.close();
            conn.close();

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

package Database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class mark {
    public static void main(String[] args) {
        // Correct JDBC URL format for UCanAccess
        String dataBaseURL = "jdbc:ucanaccess:
StudentMarkDatabase\\src\\Database\\Marks Database.accdb";

        try {
            // Register the JDBC driver
            Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");

            // Establish the connection
            Connection conn = DriverManager.getConnection(dataBaseURL);

            // Create a statement
            Statement statement = conn.createStatement();

            // Execute the query
            String query = "SELECT * FROM tblStudents"; // Ensure correct table name case sensitivity
            ResultSet resultSet = statement.executeQuery(query);

            // Process the result set
            while (resultSet.next()) {
                int stuID = resultSet.getInt("StuID");
                String firstName = resultSet.getString("FirstName");
                String lastName = resultSet.getString("LastName");
                String userName = resultSet.getString("UserName");
                String password = resultSet.getString("Password");
                String dob = resultSet.getString("DOB");

                System.out.println("StuID: " + stuID + ", FirstName: " + firstName + ", LastName: " + lastName +
                                   ", UserName: " + userName + ", Password: " + password + ", DOB: " + dob);
            }

            // Close the resources
            resultSet.close();
            statement.close();
            conn.close();

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}