HarmonyOS 数据库查询是否支持位运算

数据库查询支持位运算，参考示例：

import relationalStore from '@ohos.data.relationalStore';
import { BusinessError } from '@kit.BasicServicesKit';

const SQL_CREATE_TABLE =
  'CREATE TABLE IF NOT EXISTS EMPLOYEE (ID INTEGER PRIMARY KEY AUTOINCREMENT,NAME TEXT NOT NULL,AGE INTEGER,SALARY INTEGER)';

function valuesTest() {
  let valueBucketArray: Array<relationalStore.ValuesBucket> = new Array();

  for (let i = 0; i < 10; i++) {
    const valueBucket: relationalStore.ValuesBucket = {
      "name": "xbx",
      "age": 24,
      "salary": 0,
    }
    valueBucketArray.push(valueBucket);
  }
  console.log('valueBucketArray ' + JSON.stringify(valueBucketArray))
  return valueBucketArray
}


@Entry
@Component
struct Index {
  @State message: string = 'Hello World';
  rdbStore: relationalStore.RdbStore | undefined = undefined
  build() {
    RelativeContainer() {
      Text(this.message)
        .id('HelloWorld')
        .fontSize(50)
        .fontWeight(FontWeight.Bold)
        .alignRules({
          center: { anchor: '__container__', align: VerticalAlign.Center },
          middle: { anchor: '__container__', align: HorizontalAlign.Center }
        })
        .onClick(async () => {
          const STORE_CONFIG: relationalStore.StoreConfig = {
            name: 'RdbTest3.db', // 数据库文件名
            securityLevel: relationalStore.SecurityLevel.S1, // 数据库安全级别
            encrypt: false, // 可选参数，指定数据库是否加密，默认不加密

            allowRebuild: true
          };
          let RdbStore = await relationalStore.getRdbStore(getContext(), STORE_CONFIG)
          this.rdbStore = RdbStore
          console.log("Succeeded in getting RdbStore.")
          await RdbStore.executeSql(SQL_CREATE_TABLE)
          console.log("建表成功")
          try {
            RdbStore.batchInsert("EMPLOYEE", valuesTest());
            console.info(`Insert data successfully!`);
          } catch (err) {
            console.error(`Insert datae failed! err code:${err.code}, err message:${err.message}`)
          }
        })

      Button('query').onClick(async () => {

        console.info("rebuilt " + this.rdbStore?.rebuilt)

        let res = this.rdbStore?.querySqlSync('SELECT ID,NAME,AGE,SALARY FROM EMPLOYEE')
        console.info(`querySqlSync data successfully! row count:${res?.rowCount}`);
        while (res?.goToNextRow()) {
          const id = res?.getLong(res?.getColumnIndex("ID"));

          const name = res?.getString(res?.getColumnIndex("NAME"));

          const age = res?.getLong(res?.getColumnIndex("AGE"));

          const salary = res?.getDouble(res?.getColumnIndex("SALARY"));

          console.info(`id=${id}, name=${name}, age=${age}, salary=${salary}`);
        }
        // 释放数据集的内存
        res?.close();
      })

      Button('UPDATE')
        .margin({ top: 40 })
        .onClick(async () => {
          this.rdbStore?.executeSql('UPDATE EMPLOYEE SET AGE = SALARY', (err, data) => {
            if (err) {
              console.error(`executeSql error ${err.code} message ${err.message}`);
            }
            console.info(`executeSql data successfully`);
          })

        })

      Button('query1')
        .margin({ top: 100 })
        .onClick(async () => {
          await this.rdbStore?.querySql('SELECT * FROM EMPLOYEE WHERE ID = 1 AND (SALARY & 0) = 0').then((data: relationalStore.ResultSet) => {
            console.info('execute data= ' + data.rowCount)
            while (data?.goToNextRow()) {
              const id = data?.getLong(data.getColumnIndex("ID"));
              const name = data?.getString(data.getColumnIndex("NAME"));
              const age = data?.getLong(data.getColumnIndex("AGE"));
              const salary = data.getDouble(data.getColumnIndex("SALARY"));
              console.info(`id=${id}, name=${name}, age=${age}, salary=${salary}`);
            }
            // 释放数据集的内存
            data.close();
          }).catch((error: BusinessError) => {
            console.error("ERROR= " + JSON.stringify(error))
          })
        })
    }
    .height('100%')
    .width('100%')
  }
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.