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行 没有错误!
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行 没有错误!
解决方案 »
- 求助一个JSP的问题 求大神
- 请问大家,为什么直接修改了数据库里的值,如果不重起应用服务器的话,就不会显示修改后的值呢,还是显示以前的值
- 为什么在root目录下取得的结果是正确的,但是在虚拟目录下取得的结果是错误的?
- 关于Tomcat+Oracle 8i, 9i & 10g 连接池配置的个人笔记
- 怎么样让WEB服务器自动运行一些任务?
- 最新体验,sun creator,一个基于jsf的webapp的可视化开发环境,
- 数据的传递问题!!!!!!!!救我!!!!!!
- 用图片提交表单的问题
- ODBC
- 一个很简单的地址转换问题?奉送100分
- 大家帮帮忙.我急要.谢谢.
- 一个接口只有一个类实现,这样又必要用接口吗?
ResultSet rs2 = stmt.executeQuery("select @@IDENTITY as num");
rs2.last();//换成rs2.next()也一样
int dd_id=rs2.getInt("num");
为什么读出来的都是0呢