Given records from the Player table:
and given the code fragment: try {
Connection conn = DriverManager.getConnection(URL, username, password);
Statement st= conn.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
st.execute ("SELECT * FROM Player");
st.setMaxRows(2);
ResultSet rs = st.getResultSet();
rs.absolute(3);
while (rs.next ()) {
System.out.println(rs.getInt(1) + " " + rs.getString(2));
}
} catch (SQLException ex) {
System.out.print("SQLException is thrown.");
}
Assume that:
The required database driver is configured in the classpath.
The appropriate database is accessible with URL, username, and password.
The SQL query is valid.
What is the result?
jduarte
Highly Voted 3 years, 3 months agoshivkumarx
Most Recent 2 weeks, 3 days agoiSnover
2 months, 4 weeks agosteefaand
2 months, 4 weeks agoHuim
2 years, 11 months agoHuim
2 years, 11 months ago