This project must be done individually. No copying is permitted. The purpose of this project is to learn how to store XML data in a relational database and how to reconstruct it back to XML.
You will do this project either: on your PC using NetBeans and JDBC on an Apache Derby database (included in NetBeans), or on Omega using JDBC on mySQL. You can find information about JDBC in the class slides (Web Programming with Servlets). See also the file mysql.java. You can run this file on Omega by editing it so that it uses your own username/password and doing:
javac mysql.java java -cp .:/opt/Wolfram/Mathematica/6.0/SystemFiles/Links/DatabaseLink/Java/mysql-connector-java-3.1.12-bin.jar SQL(make sure that the directory /opt/jdk1.6.0_03/bin/ is in your PATH).
You will use the XML file cs.xml with the DTD department.dtd. You need to parse this file and store it into a relational database and then convert the relational data back to XML.
Use the form below to submit your java files and your relational schema
Last modified: 04/15/08 by Leonidas Fegaras