Question: Assume that the following code is used to retrieve data from the CoffeeDB databases Coffee table. Write the code that should appear inside the loop
Assume that the following code is used to retrieve data from the CoffeeDB database’s Coffee table. Write the code that should appear inside the loop to display the contents of the result set.
String sql = "SELECT * FROM Coffee";
Connection conn = DriverManager.getConnection(DB_URL);
Statement stmt = conn.createStatement();
ResultSet result = stmt.executeQuery(sql);
while (result.next())
{
// Finish this code!!
}
Stmt.close();
Conn.close();
Step by Step Solution
3.34 Rating (163 Votes )
There are 3 Steps involved in it
SystemoutprintlnCoffee ID resultgetStringCoffeeID Systemoutprin... View full answer
Get step-by-step solutions from verified subject matter experts
