Given the records from the Employee table:
and given the code fragment: try {
Connection conn = DriverManager.getConnection (URL, userName, passWord);
Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
st.execute("SELECT*FROM Employee");
ResultSet rs = st.getResultSet();
while (rs.next()) {
if (rs.getInt(1) ==112) {
rs.updateString(2, "Jack");
}
}
rs.absolute(2);
System.out.println(rs.getInt(1) + " " + rs.getString(2));
} catch (SQLException ex) {
System.out.println("Exception is raised");
}
Assume that:
The required database driver is configured in the classpath.
The appropriate database accessible with the URL, userName, and passWord exists.
What is the result?
JME_CHG
Highly Voted 3 years, 9 months ago6c84cb9
Most Recent 4 months agoasdfjhfgjuaDCV
10 months, 2 weeks agosteefaand
11 months, 2 weeks ago9641
3 years agolaura_lu93
3 years, 10 months agosansay61
4 years agopul26
4 years, 1 month ago