将jdbc记录集映射到Ballerina中具有嵌套类型的记录类型

import ballerina/io;
import ballerina/jdbc;

public type Person record {
    string name;
    int age;
    Address address;
};

public type Address record {
    string city;
    string country;
};

public function main() {
    // 建立数据库连接
    jdbc:Connection conn = jdbc:createConnection("jdbc:mysql://localhost:3306/mydb", "username", "password");

    // 执行SQL查询
    jdbc:Statement stmt = conn.createStatement();
    jdbc:ResultSet rs = stmt.executeQuery("SELECT name, age, city, country FROM person");

    // 创建记录类型数组
    Person[] persons;

    // 遍历JDBC记录集
    while (rs.next()) {
        // 创建Person记录类型
        Person person;
        person.name = rs.getString("name");
        person.age = rs.getInt("age");

        // 创建Address记录类型
        Address address;
        address.city = rs.getString("city");
        address.country = rs.getString("country");

        // 将Address记录类型赋值给Person记录类型的address字段
        person.address = address;

        // 将Person记录类型添加到数组中
        persons.push(person);
    }

    // 打印结果
    io:println(persons);

    // 关闭数据库连接
    rs.close();
    stmt.close();
    conn.close();
}