Question: 1.) Create a class called Student. This class will not be tied to the Database, yet. The Student class should have the same properties as

1.) Create a class called Student. This class will not be tied to the Database, yet. The Student class should have the same properties as the Database table: SID, FirstName, LastName, etc. Include all the set and get functions as needed. Include 2 constructors, an empty constructor, and one that takes all properties. Include a display() method that prints out all properties. Use a main to instantiate and test out this Student class. (Hint: No database calls in this class, yet.) Testing Code in Main() method Student s1 = new Student(4,Frank, Jones, 123 Main, Atlanta, GA, 30133, fj@yahoo.com, 3.2); s1.display(); 2.) 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 3.) 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(); 4.) Lastly add 2 functions to Update and Delete student information. Testing Code in Main() method Student s3 = new Student(); s3.selectDB(6); s3.deleteDB(); And Student s4 = new Student (); s4.selectDB(7); s4.setZipcode(30106); s4.updateDB();

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!