Java (OOP, JDBC,MySQL)
You are required to build a Windows console application where you will be asked to read
various inputs from the keyboard.
These inputs will be used as login details and actions in order to control the internal banking
system of a cooperative company.
Each input will be used for directing the various subsystems of this private banking system.
The output of the various subsystems will be displayed to the screen or it will be written to
simple text files.
You are requested to produce a Java console application that has the following:
PS. Do not forget to open and RUN MySQL DB (MySQL Notifier)
—open Folder: “Create_Connection_Steps” and follow steps till STEPS
—OPEN WORKBENCH
—CONNECT AS ROOT TO MYSQL (STEP 0)
—RUN THE SCRIPT(afdemp_new.sql), IT IS INSIDE DB DIRECTORY (STEP 0_1)
—CLOSE WORKBENCH
—OPEN WORKBENCH
—CREATE A DB CONNECTION(STEP1)
—SETUP (STEP2)
—CLOSE WORKBENCH
THEN:
—-Just open “BankAccounts.bat” and Run the Application, it is ready and compiled :)
Credentials:1) admin
admin
2) user1
password1
3) user2
password2
--open "mysql_How_to_install.html" and follow steps!
--then return to #A)
HOW THIS PROJECT DEPLOYED
I) Message: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
1- Right click on Libraries > Click on Add Library.
2-Scroll down to find MySQL JDBC driver.
3-Press Shift + F11. (Clean and Build)
4-Run
II) in order to run :
mysql-connector.jar | Paste to : C:\Program Files\Java\jre1.8.0_151\lib\ext
IRRELEVANT to IDE(NetBeans)
III) to compile and Run (Windows):
(inside the Project’s working directory)
Compile the program using javac command:
1- javac -cp lib\mysql-connector-java-5.1.44-bin.jar -d classes src\mainapplication\*.java
Create executable JAR file using jar command:
2- jar cfm MainApplication manifest.txt -C classes mainapplication
to run the APP:
3- java -jar MainApplication
IV) to make an executable .bat file :
(inside the Project's directory)
1- Create a .txt file
2-inside write :
start java -jar MainApplication
3- save and close
4- rename the file from .txt to .bat
5- Run the file.bat
PS. Do not forget to open and RUN MySQL DB (MySQL Notifier)