|
(Due 10/11/2007) |
In this project, you will implement “GUI based isql” to execute SQL statements over Oracle database by exploiting JDBC, along with Java application. This project is designed to achieve to two goals: 1) to utilize JDBC, and 2) to experience SQL. The detailed description of this project is as follows.
1) Given the isql Java code, you will implement the connection between the Java GUI application program (“GUI based isql”) and the Oracle database in remote DB server via JDBC. In detail, when your Java application program starts to run, immediately it makes a connection with the Oracle database located in the host (srv10db.cs.wayne.edu) without any further interactions from users. Note that your system should pop up a Dialog Window to get necessary data to connect to Oracle database via JDBC, such as database name, user ID, and password.
2) You will design GUI(Graphical User Interface) to run SQL statements and display the result of the SQL executions over the Oracle database. There is no restriction on the GUI design for your system, but it should include the functionalities to execute SQL statements and display the result of the SQL executions. For this project, you might create a database and must prepare least 10 different executable SQL queries excluding SQL statements for the database creation. Note that you DON’T need to design your own database for this project. You can make use of any available database you can access.
ü
Submission
Send a zip file to TA by email(aq9320@wayne.edu) with all source codes and all necessary files included. The zip file should include “read.txt” to explain how to compile and run your system, in addition to the information that TA must know to grade. Your program should be executable by “run.bat” file without doing any other extra works. TA is not required to make your system run. So you should take all responsibilities for getting your system ready to be graded. To do so, you must include “sql.txt” to verify if the requirement (2) has been fulfilled. The zip file should be named after your name, for example, for project1 if your name is “David Smith”, then your file should be named as “david_smith_project1.zip”. The title of your email should be “CSC6710:Project Project1 Submission”.