This project manages a book library database
This is one of my first projects that managed a database.
Make sure to setup the "library" database in your localserver as shown below.
I added mysql-connector-java-5.1.46 in the project's library and set up the connection as follows:
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/library", "root", "");
The database tables should be as follows:
1- Employee(emp_id, emp_name, library_name)
2- Library(library_name, street)
3- Book(ICBN, title, publisher, author)
4- Publisher(id, name, country)
5- Author(id, name)