import { relationalStore } from '@kit.ArkData';
export class DBUtil {
private static rdbStore: relationalStore.RdbStore | null = null;
private static context: Context;
static readonly createTableSql: string = `
CREATE TABLE IF NOT EXISTS Employee (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL
)`;
static async init(context: Context) {
DBUtil.context = context;
if (!DBUtil.rdbStore) {
let config: relationalStore.StoreConfig = {
name: 'RdbTest.db',
securityLevel: relationalStore.SecurityLevel.S1
};
relationalStore.getRdbStore(DBUtil.context, config).then(rdbStore => {
DBUtil.rdbStore = rdbStore;
try {
rdbStore.executeSync(DBUtil.createTableSql);
} catch (error) {
console.error(JSON.stringify(error));
}
});
}
}
static testData() {
let emps: relationalStore.ValuesBucket[] = [];
for (let i = 0; i < 20; i++) {
emps.push({
id: i,
name: `test${i}`
});
}
DBUtil.rdbStore?.batchInsertSync('Employee', emps);
}
static getRdbStore() {
return DBUtil.rdbStore!;
}
static queryData() {
let emps: Employee[] = [];
let predicates = new relationalStore.RdbPredicates('Employee');
let resultSet = DBUtil.rdbStore!.querySync(predicates);
while (resultSet.goToNextRow()) {
let emp: Employee = {
id: resultSet.getLong(resultSet.getColumnIndex('id')),
name: resultSet.getString(resultSet.getColumnIndex('name'))
};
emps.push(emp);
}
return emps;
}
static deleteData() {
let predicates = new relationalStore.RdbPredicates('Employee');
DBUtil.rdbStore?.deleteSync(predicates);
}
}
export interface Employee {
id: number,
name: string
} try {
await DBUtil.getRdbStore().backup('RdbTestBackup.db');
let dbDir = this.getUIContext().getHostContext()!.databaseDir;
let backDir = `${this.getUIContext().getHostContext()!.filesDir}/backup`;
if (!fileIo.accessSync(backDir)) {
fileIo.mkdirSync(backDir);
}
if (fileIo.accessSync(`${backDir}/RdbTestBackup.db`)) {
fileIo.unlinkSync(`${backDir}/RdbTestBackup.db`);
}
fileIo.moveFileSync(`${dbDir}/rdb/RdbTestBackup.db`, `${backDir}/RdbTestBackup.db`);
} catch (error) {
const err = error as BusinessError;
console.error(`backup failed, code is ${err.code},message is ${err.message}`);
} 完整示例参考如下:
import { fileIo } from '@kit.CoreFileKit';
import { BusinessError } from '@kit.BasicServicesKit';
import { DBUtil, Employee } from './DBUtil';
@Entry
@Component
struct DataBackupPage {
@State emps: Employee[] = [];
aboutToAppear(): void {
DBUtil.init(this.getUIContext().getHostContext()!);
}
build() {
Scroll() {
Column({ space: 20}) {
Button('添加测试数据')
.onClick(() => {
DBUtil.testData();
})
Button('查询所有数据')
.onClick(() => {
this.emps = DBUtil.queryData();
})
Button('删除所有数据')
.onClick(() => {
DBUtil.deleteData();
this.emps = DBUtil.queryData();
})
Button('备份数据到指定目录')
.onClick(async () => {
try {
await DBUtil.getRdbStore().backup('RdbTestBackup.db');
let dbDir = this.getUIContext().getHostContext()!.databaseDir;
let backDir = `${this.getUIContext().getHostContext()!.filesDir}/backup`;
if (!fileIo.accessSync(backDir)) {
fileIo.mkdirSync(backDir);
}
if (fileIo.accessSync(`${backDir}/RdbTestBackup.db`)) {
fileIo.unlinkSync(`${backDir}/RdbTestBackup.db`);
}
fileIo.moveFileSync(`${dbDir}/rdb/RdbTestBackup.db`, `${backDir}/RdbTestBackup.db`);
} catch (error) {
const err = error as BusinessError;
console.error(`backup failed, code is ${err.code},message is ${err.message}`);
}
})
Button('恢复数据')
.onClick(() => {
let backDir = `${this.getUIContext().getHostContext()!.filesDir}/backup`;
let dbDir = this.getUIContext().getHostContext()!.databaseDir;
try {
if (!fileIo.accessSync(`${backDir}/RdbTestBackup.db`)) {
return;
}
fileIo.copyFileSync(`${backDir}/RdbTestBackup.db`, `${dbDir}/rdb/RdbTestBackup.db`);
DBUtil.getRdbStore().restore('RdbTestBackup.db').catch((err: BusinessError) => {
console.error(`Restore failed, code is ${err.code},message is ${err.message}`);
});
} catch (error) {
const err = error as BusinessError;
console.error(`backup failed, code is ${err.code},message is ${err.message}`);
}
})
Column() {
if (this.emps.length > 0) {
ForEach(this.emps, (emp: Employee) => {
Row() {
Text(`${emp.id}---${emp.name}`)
}
.width('80%')
.padding(5)
.borderWidth(1)
})
} else {
Text('没有数据!')
}
}
.width('100%')
.padding(10)
.backgroundColor('#d0e6fb')
}
.height('100%')
.width('100%')
}.height('100%')
.width('100%')
}
}