Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=guolv";
Connection conn2= DriverManager.getConnection(url,"sa","");
Statement stmt2=conn2.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs1=stmt2.executeQuery("SELECT * FROM [dd_names] ");
rs1.next();
rs1.moveToInsertRow(); 
rs1.updateString("tuanhao",tuanhao);
rs1.updateString("bumen",bumen);
rs1.updateString("xs",xs);
rs1.updateString("telphone",telphone);
rs1.insertRow();
rs1 =  stmt.executeQuery("select  @@IDENTITY as num");
int dd_id=rs1.getInt("num");
rs1.close();
rs1=null;想取得自增量(要存入另外表)   但是错误:Invalid   operation   for   the   current   cursor   position 
在rs1   =     stmt.executeQuery("select     @@IDENTITY   as   num");前面一行加入rs1.next()错误:Column   index   0   is   out   of   range 
去掉rs1 =  stmt.executeQuery("select  @@IDENTITY as num");
int dd_id=rs1.getInt("num");
这2行 没有错误!