HarmonyOS 关系型数据库获取数据，如何将valueBucket类型转化为object类型？

Question

目前实现了关系型数据库的存储，通过query方法获取到了ResultSet结果集，其中ResultSet方法有一个getRow(): ValuesBucket方法，如图中的方法封装，我想讲ValueBucket转为IMMessage，应该如何做呢，如何方便的将数据库查询到的数据，转为我需要的格式呢？

Answer 1

可以试下三方库的转换，参考如下链接

https://ohpm.openharmony.cn/\#/cn/detail/@pura%2Fharmony-utils

https://gitee.com/tongyuyan/harmony-utils/blob/master/entry/src/main/ets/pages/utils/JSONUtilPage.ets

Button("测试 @pura/harmony-utils").onClick(() => {
  class User {
    id: string = '';
    name: string = '';
    age: number = 0;
    addr: string = '';
    work: string = '';
    state: string = '';
    user?: User;

    constructor() {
    }
    getName(): string {
      return this.name
    }
  }

  let objStr: string =
    '{"id":"No_1060701","name":"张三","age":20,"addr":"乌市天山区","work":"工程师","user":{"id":"No_1060701","name":"张三","age":20,"addr":"乌市天山区","work":"工程师"}}';
  let user = JSONUtil.jsonToBean(User, objStr);
  console.log(user?.getName())
})