First create the database in mysql terminal by running .sql files in the given order
Library_create.sql; Library_alter.sql; Library_data.sql;
Use the below command to run the java file in your system
java -classpath "mysql-connector-java-8.0.18.jar:." JdbcDemo
To drop the database in your system use
Library_drop.sql;