NO.72 Given:
Item table
* ID, INTEGER: PK
* DESCRIP, VARCHAR(100)
* PRICE, REAL
* QUANTITY< INTEGER
And given the code fragment:
9 . try {
1 0. Connection conn = DriveManager.getConnection(dbURL, username, password);
1 1. String query = “Select * FROM Item WHERE ID = 110”;
1 2. Statement stmt = conn.createStatement();
1 3. ResultSet rs = stmt.executeQuery(query);
1 4. while(rs.next()) {
1 5. System.out.println(“ID: ” + rs.getInt(“Id”));
1 6. System.out.println(“Description: ” + rs.getString(“Descrip”));
1 7. System.out.println(“Price: ” + rs.getDouble(“Price”));
1 8. System.out.println(Quantity: ” + rs.getInt(“Quantity”));
1 9. }
2 0. } catch (SQLException se) {
2 1. System.out.println(“Error”);
2 2. }
Assume that:
The required database driver is configured in the classpath.
The appropriate database is accessible with the dbURL, userName, and passWordexists.
The SQL query is valid.
What is the result?