You will need your SQL Server space and
Visual J++ and JDBC.
The database available is the same one that you used for Homework 3. You
will create applications written in Java that will access this database and
query it.
Homework specifications
You will write application using Java and jdbc to query the same database
used for Homework 3.
In order to see an example of how to use Java on the cse undergrad machines
and to query our database, please click here.
This assignment has two parts.
Part I
50 points.
For all the queries in assignment 3, write a Java application that runs the
query against the SQL Server ISQL01. This application should output
the results in nicely formatted way.
We do not require you a certain format, but you should put some effort into
formatting the results of the query in an acceptable way.
Part II
45 points.
Write a Java application that produces a report of each theater in the
database along with the movies it shows. The report is to be in an XML
format. You will carefully design an appropriate DTD for this report. The
results of your application should follow the DTD specifications. Your
application does not have to check the validity of the report against the
DTD.
Part III
5 points.
- How long did it take you to complete this assignment?
- What did you like the best about this assignment?
- What did you like the least about this assignment?
- What helped you learn the best in this assignment?
- What distracted from your learning in this assignment?
What to Hand In ?
You will e-mail the entire assignment. This is a requirement. We will run
your code to make sure it works.
Part I
E-mail the TA a single
Java program along with instructions of how to execute your
application.
You will e-mail these programs as an attachement to the body of the e-mail
and not inside the body of the e-mail.
Part II
In the same e-mail, include the application for Part II of this
assignment. Please type in a DTD and e-mail it along with your code.
Both these will be provided as attachements to the e-mail.
Part III
In the same e-mail, type in answers to all five questions. Either include
this in a file attached to the body of the e-mail, or provide this inside
the main body of the e-mail.
NOTE Submit only one e-mail with the entire homework. You should add
yourself to the CC: list on that e-mail so that you get a copy of the
submission. We will accept e-mails until 1:30pm on the due date.