try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:voice"; String user="system";
String pwd ="manager"; Connection conn = DriverManager.getConnection(url,user,pwd);
Statement ment = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql ="select * from user_info"; ResultSet rSet = ment.executeQuery(sql);
int t=0;
if(rSet.next()){
rSet.absolute(3);
rSet.deleteRow();
}这是代码段。。为什么会出现这种错误了。。我已经Statement ment = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
这样了。。怎么解决啊?
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:voice"; String user="system";
String pwd ="manager"; Connection conn = DriverManager.getConnection(url,user,pwd);
Statement ment = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql ="select * from user_info"; ResultSet rSet = ment.executeQuery(sql);
int t=0;
if(rSet.next()){
rSet.absolute(3);
rSet.deleteRow();
}这是代码段。。为什么会出现这种错误了。。我已经Statement ment = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
这样了。。怎么解决啊?
System.out.println(rSet.getConcurrency());你用这两句打印出来实际的类型出来看看就知道了
直接conn.createStatement()就行,sqlserver就得这么写了