如何在swift中使用Ms SQL查询结果填充数组？

import PerfectMSSQL

let server = "your_server_address"
let database = "your_database_name"
let username = "your_username"
let password = "your_password"

let msSQL = MSSQL()
guard msSQL.connect(server: server, database: database, username: username, password: password) else {
    print("Failed to connect to the database")
    return
}

let query = "SELECT * FROM your_table"
guard let resultSet = msSQL.query(statement: query) else {
    print("Failed to execute the query")
    return
}

var resultsArray: [YourObjectType] = []

while let row = resultSet.next() {
    let result = YourObjectType()
    result.property1 = row["column1"] as? String
    result.property2 = row["column2"] as? Int
    // 继续为其他属性赋值
    
    resultsArray.append(result)
}

msSQL.close()