Week

4 Individual: JDBC Program

Write a Java program (non-GUI preferred) to demonstrate

the use of JDBC.

The program should allow a user to do the

following:

• Write a list of animal and its characteristics to a

  database using JDBC

• Display the characteristics of an animal when that

  animal is selected.

Include a brief documentation (in the code or in a separate document) to explain

the input (if any), processing and output of the program.

Submit your assignment using the Assignment Files tab above.

Note from Instructor:

To assist, I have included a demo file

“JavaDB week 4 Demo code” of a database and installation

instructions.

PLEASE USE THIS DEMO DATABASE.  I have had

students want to use other database engines and it makes it very difficult when

that happens.  This is not a class in different databases, but just how to

connect Java to a database, and thus we are going to use the simplest one

possible, mySQL.