Would you please explain to me how we do this and give me a solution. Thank you

Question

Would you please explain to me how we do this and give me a solution.

Thank you

  Suppose you have a hockey card collection and you create a hockey database with a cards table.  You have many records already with fields for First, Last, POS, Team, 09-10Pts, and CareerPts.  For each of the following, write an SQL command to save to a String called command and then write a java command to use that String to execute your command with a Statement object called stmt.  For part b, save into a ResultSet object called rs.  You do not have to print anything and you can assume command, stmt, and rs have already been declared and properly created.  Here is what a sample record looks like:

First                                                                                                                 Last                  POS     Team                09-10Pts   CareerPts

Marian                                                                                                 Gaborik            RW      Rangers            86                    523

a.         Create a card for Brandon Dubinsky of the Rangers.  He is a C and had 44 points in 09-10 for 125 career points.            

Explanation / Answer

String command="insert into hockeydatabase('Brandon','Dubinsky','C','Rangers',44,125)";

Statement stmt=con.createStatement();

ResultSet rs=stmt.executeQuery(command);

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.