ArkTS如何操作关系型数据库@ohos.data.relationalStore

import { RelationalDatabase } from '@ohos.data.relationalStore';
import { DataAbilityPredicates } from '@ohos.data.dataAbility';

const database = RelationalDatabase.openDatabase('databaseName');

database.executeSql('CREATE TABLE IF NOT EXISTS tableName (column1 TEXT, column2 INTEGER)');

database.executeSql('INSERT INTO tableName (column1, column2) VALUES (?, ?)', ['value1', 123]);

const result = database.executeSql('SELECT * FROM tableName');
result.forEach((row) => {
  const column1 = row.getString(0);
  const column2 = row.getInt(1);
  // 处理数据
});

database.executeSql('UPDATE tableName SET column1 = ? WHERE column2 = ?', ['updatedValue', 123]);

database.executeSql('DELETE FROM tableName WHERE column2 = ?', [123]);

database.close();