请教JDBC连接sql server2000ResultSet 不支持first,last,previous怎么办？非常感谢！

Question

如下设置，就ok了。ps = conn.prepareStatement(sqlClause,
                                       java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
                                       java.sql.ResultSet.CONCUR_READ_ONLY);

Answer 1

String SDBDriver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
  String URL ="jdbc:microsoft:sqlserver://TVSJSHNET:1433;DatabaseName=TVS_Test";
  String USER_NAME ="sa";
  String PWD ="suuntvs";    try {
      Class.forName(SDBDriver);
    }
    catch (java.lang.ClassNotFoundException e) {
    System.err.print("In DataOperate()"+e.getMessage());
    }    Conn =DriverManager.getConnection(URL,USER_NAME,PWD);
    stmt =Conn.createStatement();
    RS =stmt.executeQuery(SQL) ; //

Answer 2

conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 这样试试看