Java Basepeer -获取上次插入的记录的ID

import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.ScalarHandler;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Main {
    public static void main(String[] args) {
        // 配置数据库连接信息
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";

        // 创建数据库连接
        Connection connection = null;
        try {
            connection = DriverManager.getConnection(url, username, password);

            // 创建Basepeer对象
            Basepeer basepeer = new Basepeer(connection);

            // 执行插入记录的SQL语句
            String insertSql = "INSERT INTO mytable (name, age) VALUES (?, ?)";
            Object[] params = {"John", 25};
            basepeer.execute(insertSql, params);

            // 获取上次插入的记录的ID
            long lastInsertId = basepeer.getLastInsertId();
            System.out.println("Last Insert ID: " + lastInsertId);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 关闭数据库连接
            DbUtils.closeQuietly(connection);
        }
    }
}