Using Java and the Database provided:

Modify 1.) from above. Add a new Method called selectDB() that takes only one argument, SID. When a user calls this method, it should SELECT from the database that Student and get all the Students data from the database, and put this data into the appropriate properties. (Hint: You will use an SQL Select statement here.) Test out this method in the main.

Testing Code in Main() method

Student s1 = new Student();

s1.selectDB(4); //accessing DB

s1.display(); //displays all data from DB for student with id=4

----------------------------------------------------------------------------------------

public class Student { private int SID; private String FirstName, LastName, Street, City, State; private int Zip; private String EMail; private double GPA; public Student() { } public Student(int SID, String firstName, String lastName, String street, String city, String state, int zip, String EMail, double GPA) { this.SID = SID; FirstName = firstName; LastName = lastName; Street = street; City = city; State = state; Zip = zip; this.EMail = EMail; this.GPA = GPA; } public void display() { System.out.println("ID: " + SID); System.out.println("Name: " + FirstName + " " + LastName); System.out.println("Street: " + Street); System.out.println("City: " + City); System.out.println("State: " + State); System.out.println("Zip: " + Zip); System.out.println("Email: " + EMail); System.out.println("GPA: " + GPA); } public static void main(String[] args) { Student s1 = new Student(4,"Frank", "Jones", "123 Main", "Atlanta", "GA", 30133, "fj@yahoo.com", 3.2); s1.display(); } }

Students

ID	FirstName	LastName	Street	City	State	Zip	EMail	GPA
1	Larry	Jones	200 Larue St.	Denver	CO	89721	larry@yahoo.com	3.2
2	Debbie	Gibson	101 Cambell St.	Chicago	IL	61721	debra@hotmail.com	2.9
3	James	Henry	9019 Par Ln.	Atlanta	GA	30981	jh@yahoo.com	3.5
4	Tony	Danza	100 Main St	San Diego	CA	90890	tony@yahoo.com	3.4
5	Marie	Baker	313 Mockingbid Lane	Seattle	WA	98711	mbaker@hotmail.com	2.2
6	Mary	Weathers	10 King St	Denver	CO	65334	maryw@bellsouth.net	2.1
7	Biily	Wagner	777 Blake St	Chicago	IL	61900	billyw@comcast.net	2.9
8	Tim	Allen	200 South St	Detroit	MI	54123
9	Gary	Stevens	112 Plymouth Ln	Ann Arbor	MI	54123	garys@hotmail.com	3.2
10	Betsy	Cook	101 Freeport St	Atlanta	GA	31010	bcook@yahoo.com	3.3
11	Susan	Jones	200 West Ave	Marietta	GA	30060	sujones@hotmail.com	2.2
12	Frank	Peters	3845 Beckford Ave	San Diego	CA	95123	frankperters@comcast.net	3.9
13	Terri	March	9516 Hale Dr	St Louis	MO	63321	tmarch@bellsouth.net	3.1
14	Jack	Hines	2222 Morningside Dr	Marietta	GA	30090	jhines@yahoo.com	2.8
15	Phil	Gecko	45 East St	Montgomery	AL	41231	pgecko@yahoo.com	2.7
16	Tony	Peters	200 Central Ave	Miami	FL	75213