Complete the following two tasks using any JDBC compliant database:
 

1) Go through the Sun JDBC tutorial available at: http://java.sun.com/products/jdbc/learning.html

Turn in a self-authored set of code that demonstrates the functionality covered in the Basic Tutorial

2) Given the following Java class:

class Book {
    String title;
    String author;
    int numCopies;
}

and the following XML file

<?xml version="1.0" encoding="ISO-8859-1" standalone="yes"?>
<Persistence>
<Component name="Book">

<Table name="BookTable">

<Attribute name="title" type="String" column="title"/>

<Attribute name="author" type="String" column="auth"/>

<Attribute name="numCopies" type="Integer" column="count"/>

</Table>

</Component>
</Persistence>

write a Java class that:

• Creates a test instance of the book class
• Reads the XML persistence descriptor
• Writes the Book instance to the database using information from the persistence descriptor