如何在Java Derby中获取最后一次插入

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

public class DerbyExample {
    public static void main(String[] args) {
        try {
            // 连接到Derby数据库
            Connection conn = DriverManager.getConnection("jdbc:derby:myDB");

            // 创建表
            Statement stmt = conn.createStatement();
            stmt.executeUpdate("CREATE TABLE myTable (id INT GENERATED ALWAYS AS IDENTITY, name VARCHAR(50))");

            // 插入数据并获取自动生成的ID
            String insertQuery = "INSERT INTO myTable (name) VALUES (?)";
            PreparedStatement pstmt = conn.prepareStatement(insertQuery, Statement.RETURN_GENERATED_KEYS);
            pstmt.setString(1, "John");
            pstmt.executeUpdate();

            // 获取自动生成的ID
            ResultSet rs = pstmt.getGeneratedKeys();
            if (rs.next()) {
                int lastInsertId = rs.getInt(1);
                System.out.println("Last inserted ID: " + lastInsertId);
            }

            // 关闭连接
            rs.close();
            pstmt.close();
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}