Lab 7 - Database - Due: 15-Dec-2012


1.  Add public static void listAll() that will select all data from the Person table.
2.  Add public static void listAll(String name) that will select all data from the Person table for that name.
3.  Add public boolean save() to Update the Person in the Person table.
4.  Add public boolean read(int id) to Select from the Person table based on the id.
5.  Add public boolean delete() Delete the current Person row.

CREATE TABLE Person (id int primary key auto_increment,
    lastName VARCHAR(50), fistName VARCHAR(50), email VARCHAR(99), phone_nr VARCHAR(50));

Database.java w/Examples