Skip to content
This repository was archived by the owner on Dec 29, 2021. It is now read-only.

Latest commit

 

History

History
33 lines (26 loc) · 1.07 KB

readme.md

File metadata and controls

33 lines (26 loc) · 1.07 KB

CSCI3170 Introduction to Database Systems Project -- Library Inquiry System

This is a library inquiry system implemented in Java, using JDBC for MySQL connection.

Group 64

  • Choi Sen Ho 1155125303
  • Lau Long Ching 1155127347
  • Li Chun Lam 1155116313

Compilation

  • Navigate to the folder with the files
  • Run:javac Main.java

Running the program

Using Terminal

!(CUHK CSE VPN connection is required to run the project.)

  • Navigate to the folder with the files
  • Run: java -cp .:mysql-connector-java-5.1.47.jar Main

Using Visual Studio Code

!(CUHK CSE VPN connection is required to run the project.)

  • Put the connector jar file under "Referenced Libraries" of "Java Projects" tab
  • Right click on Main.java and run

Caution

Please delete the tables, re-create them and import sample data before trying the functions.

Cleaning up the compiled files

Run: find . -name "*.class" -type f -delete

Please refer to this link.

Final result

38/39 (-1) rating by default is null. usre functions: test case 2, test case 3.