62,635
社区成员




String sql = "insert into communityGTTitle values(?)";
String sql2 = "SELECT SCOPE_IDENTITY() as temp";
String username = "username";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=A_Hospital","hello","hello");
PreparedStatement ps = null;
PreparedStatement ps2 = null;
ResultSet rs = null;
try{
ps = con.prepareStatement(sql);
ps.setString(1, username );
ps.execute();
ps2 = con.prepareStatement(sql2);
rs = ps2.executeQuery();
rs.next();
System.out.println(rs.getInt("temp"));
}catch(Exception exception){
exception.printStackTrace();
}
pstat = con.prepareStatement(insertSQ, Statement.RETURN_GENERATED_KEYS); // 这句的参数是关键
setPreparedStatementValue(pstat, base);
if (pstat.executeUpdate() == 1) {
rs = pstat.getGeneratedKeys(); // 用来获得生成的数值
if (rs.next()) {
long newId = Long.parseLong(rs.getString(1)); // 拿到数值
}
}