GitHub - ruy16/1555-project: A java application that provides info about Olympics games based on a database written in oracle-SQL

ruy16 / 1555-project Public

Notifications You must be signed in to change notification settings
Fork 0
Star 1

A java application that provides info about Olympics games based on a database written in oracle-SQL

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 11 Commits
Driver.java		Driver.java
Olympics.java		Olympics.java
Readme.txt		Readme.txt
Schema.sql		Schema.sql
init.sql		init.sql
ojdbc7.jar		ojdbc7.jar
project.pdf		project.pdf
queries.sql		queries.sql
trigger.sql		trigger.sql

Repository files navigation

Instructions for running Olympics.java

Compiling:
Make sure ojdbc.jar is ready in the same directory
Then compile with:
	javac -cp ojdbc7.jar Olympics.java

Running:
	java -cp ojdbc7.jar:. Olympics
	
Interface:
You will be asked to enter a num to login or exit the system upon running, enter your option and hit enter.
Once you have logged in based on the user level, list of options will be shown, enter an option and hit enter.
All inputs are case sensitive! 

Notes:
The driver is just a test program with some predefined inputs.
The current server is based on class3@pitt.cs.edu which is no longer in use, please change the server info in the ojdbc.java.
You must populate the database by running Schema.sql, trigger.sql,and init.sql first!
You can run it on oracle with any valid server, since the clss3 server is no longer available.

Some predefined accounts to use in the app:
Username:Hu Jintao Passkey:Beijing
Username:Ricky Passkey:GUEST
Username:Junhong Passkey:JJ