COMP 3421 PDA #6

(35 Points)

Due Mar 8, 2016, noon

Step 6 of Your PDA

Note: this assignment is a modification of material developed by the Stanford Database Group

JDBC (35 points)

For this part you need to downlaod and install: JDBC for MySQL

For a Mac, after uncompressing the tar file, just copy/move the mysql-connector-java-5.1.29-bin.jar file to /Library/Java/Extensions.

For Windows it should just work after installing. If you have problems please email the TA.

If you are using Eclipse with Java THIS TUTORIAL is useful.

Good (but more than you need) tutorial/documentation

Especially helpful section

Here are some examples of using JDBC as shown in class:

Note, these examples assume you have created a user account and granted permission to the user for the database being accessed. SQL command line commands to do this are:

create user 'leut'@'localhost' identified by 'pigpig' ;
grant ALL on sailors3.* to 'leut'@'localhost' ;

where you replace "leut" with the user-id you want and "pigpig" with the password you want.

You are to create a java application using JDBC that makes sense for your PDA. Your application must have two or more SQL commands and user input that allows you to complete a "higher level" problem. Submit a pdf file that includes: (1) a description (in English) of what your application does; (2) your java/sql code; and (3) a script file of the execution of your code that demonstrates that it works.