Using Java and the database provided:

Modify 2.) from above. This time we are add another method called insertDB(). This method will take all 9 data elements as arguments. This method will then Insert this information into the Student table, as well as fill up the object with the data provided. (Hint: You will use an SQL Insert statement here.)

Testing Code in Main() method

Student s2=new Student();

s2.insertDB(33, Frank, Mayes, 123 Main street, Atlanta, GA, 30100,fmayes@yahoo.com,3.3f);

s2.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

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(); } }

public void selectDB(int SidInput){

Student s =[SELECT SID, firstName, lastName, street, city, state, zip, EMail, GPA FROM Student WHERE SID =: SidInput];

 this.SID = SidInput; this.FirstName = s.firstName; this.LastName = s.lastName; this.Street = s.street; this.City = s.city; this.State = s.state; this.Zip = s.zip; this.EMail = s.EMail; this.GPA = s.GPA;

}