result.getType() == ResultSet.TYPE_SCROLL_SENSITIVE
result.getConcurrency() == ResultSet.CONCUR_UPDATABLE
都是false呗!
你把result.getType()和result.getConcurrency()输出看看是什么东东就明白了
result.getConcurrency() == ResultSet.CONCUR_UPDATABLE
都是false呗!
你把result.getType()和result.getConcurrency()输出看看是什么东东就明白了
System.out.println(ResultSet.TYPE_SCROLL_INSENSITIVE);
System.out.println(ResultSet.TYPE_SCROLL_SENSITIVE);
System.out.println(ResultSet.CONCUR_READ_ONLY);
System.out.println(ResultSet.CONCUR_UPDATABLE);Statement stat = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet result = stat.executeQuery("select * from SCOTT.MO ");System.out.println(result.getType());
System.out.println(result.getConcurrency());打印结果:
1003
1004
1005
1007
10081004
1007问题;这个结果集为什么不支持ResultSet.TYPE_SCROLL_SENSITIVE和ResultSet.CONCUR_UPDATABLE啊?是不是jdbc驱动的问题啊?郁闷啊??
换成
PreparedStatement stat =conn.prepareStatement("select * from SCOTT.MO where DEST_ID = ?",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);stat.setString(1, "K");
ResultSet result = stat.executeQuery();
还是一样的?为什么啊?