Using Java and the Database provided: Modify 1.) from above. Add a new Method ca
ID: 3704549 • Letter: U
Question
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 Student’s 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
----------------------------------------------------------------------------------------
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 75213Explanation / Answer
public void selectDB(int SidInput){
Student s =[SELECT SID, firstName, lastName, street, city, state, zip, EMail, GPA FROM Student WHERE SID =: SidInput];
}
Please let me know in case of doubt.
instanceName.(fieldName) will give value.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.