[OCPJP]資料庫的用法

Given:

Item table

And given the code fragment:

try {
    Connection conn = DriverManager.getConnection(dbURL, username, password);
    String query = "Select * FROM Item WHERE ID = 110";
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery(query);
    while (rs.next()) {
        System.out.println("ID:" + rs.getInt("Id"));
        System.out.println("Description:" + rs.getString("Descrip"));
        System.out.println("Price:" + rs.getDouble("Price"));
        System.out.println("Quantity:" + rs.getInt("Quantity"));
    }
} catch (SQLException se) {
    System.out.println("Error");
}

Assume that:

The required database driver is configured in the classpath.
The appropriate database is accessible with the dbURL, userName, and passWord exists.
The SQL query is valid.

What is the result?

A. An exception is thrown at runtime.
B. Compilation fails.
C. The code prints Error.
D. The code prints information about Item 110.

題解

ResultSet物件的getX方法所傳入的欄位名稱參數是不區分大小寫的，所以如果ID = 110的Item資料列存在的話，就會輸出該列的資訊。