为何出现这个错误:java.sql.SQLException: 对只读结果集的无效操作: updateString;code如下:
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@team1-server:1521:hims","eharbor","eharbor");
// SQL Request
//Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY ,ResultSet.CONCUR_UPDATABLE);
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = null;
rs = stmt.executeQuery("SELECT * FROM t_test WHERE file_ID='0001'");
if(rs.next()){
rs.updateString("file_name","davidtest");
rs.updateRow();
}