ResultSet的问题,指教
代码如下:
package aaa;
import java.sql.*;
public class aaaa{
public static void main(String[] args) throws Exception{
String url = "jdbc:odbc:NorthwindSQLServer";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url, "sa", "");
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );
String sql = "select * from Shippers";
ResultSet rs= stmt.executeQuery(sql);
rs.moveToInsertRow() ;
rs.updateInt(1,4) ;
rs.updateString(2,"sdfsdfs");
rs.updateString(3,"ddddddd");
rs.insertRow() ;
rs.close();
conn.close();}
}
报错如下:
D:\JBuilder9\jdk1.4\bin\javaw -classpath "E:\jb\aaa\classes;D:\JBuilder9\jdk1.4\jre\lib\rt.jar;D:\JBuilder9\jdk1.4\jre\lib\i18n.jar;D:\JBuilder9\jdk1.4\jre\lib\sunrsasign.jar;D:\JBuilder9\jdk1.4\jre\lib\jsse.jar;D:\JBuilder9\jdk1.4\jre\lib\jce.jar;D:\JBuilder9\jdk1.4\jre\lib\charsets.jar;D:\JBuilder9\jdk1.4\jre\classes;D:\JBuilder9\jdk1.4\lib\tools.jar" aaa.aaaa
java.sql.SQLException: General error
at sun.jdbc.odbc.JdbcOdbcResultSet.setPos(JdbcOdbcResultSet.java:5135)
at sun.jdbc.odbc.JdbcOdbcResultSet.insertRow(JdbcOdbcResultSet.java:4050)
at aaa.aaaa.main(aaaa.java:15)
Exception in thread "main"