SQL Server 返回最后插入记录的自动编号ID (Java语言)

来源:互联网 发布:上交所待遇知乎 编辑:程序博客网 时间:2024/05/18 14:13
String sql="insert into Author (Name,DynastyID) values ('"+author+"',0)";conn2.createStatement().executeUpdate(sql);String sql1="Select @@identity as AuthorID";ResultSet rs2=conn2.createStatement().executeQuery(sql1);if(rs2.next()){authorID=rs2.getInt("AuthorID");}

原创粉丝点击