Java FXML ATM with SQL

Java FX/FXML and SQL Database The ATM uses Java FXML, and I have provided majority of the code in the files. I've been trying to figure out how to implement the SQL database but I have had no luck. Due date is May 8th at 11:59pm, also the Account class can be ignored since the assignment CANNOT use any file I/O (aka the whole Accounts class). I have also provided a connection class code that might be of some use to whoever codes this. Create a dialog box-based ATM program. The dialog will have some UI features: Your ATM will link to a MySQL database stored on the local computer. All transactions and account verification will take place through the database. No file I/O. Your ATM must duplicate all the functionality from the atm using the database. The Account class will not be needed as all the information for the account will be stored in the database. The accounts will be stored in a table called CheckingAccount. The table will have the following columns and attributes: accountNo char(6) not null, primary key firstName varchar(25) not null mi char(1) lastName varchar(25) not null phone char(10) not null email varchar(50) openDate date closeDate date lastTransaction date balance double currentRate double You will need to use the SQL select and update commands for account verification and transactions. You will use the following JDBC driver to connect to the database: com.mysql.jdbc.Driver. The connection will be made using the following: Database: jdbc:mysql://localhost/javabook User: scott Password: tiger All transactions will take place using CheckingAccount table created and populated at the end of the [login to view URL] file provided

Project ID: 19470825