mini project using jdbc
Database Management Systems
This is a DBMS project - Employee detail management system -follows DAO -POJO architecture and the code is fairly organized and optimized.
instructions are available here - http://suchadummyprogrammer.blogspot.com/2018/07/the-emp-management-appwith-5.html
Features -
Allows you to
1 Add employee in Db.
2 Show all employees in Db.
3 Update employee details in Db.
4 Delete employee details in Db.
5 Search employee details in Db.
6 Exception handling in all screens.
Connection class and Dao class is created separately for editing
HOW TO RUN THE CODE -
1 install net beans
2 download oracle SQL 11g version
3 Download OJDBC8 (you may have to create an account - link given in step 4)
4 OJDBC you can download from Oracle official site - (https://www.oracle.com/database/technologies/jdbcdriver-ucp-downloads.html)- try any version for now, if shows exception use 11g specified version compatible to your java version
5 Paste OJDBC8.jar file in C:\Program Files\Java\jdk1.8.0_112\jre\lib\ext
6 make you copy jar file in correct location (wherever you installed your java)
7 that should do it
8 run the app in netbeans
troubleshoot in netbeans using youtube (try solving some problems)
Kindly star my repository if you like it. \__(* *)__/