ValueType:用于表示允许的数据字段类型,接口参数具体类型根据其功能而定。其类型支持bigint(值类型为任意长度的整数),使用bigint时需注意以下几点:
完整示例参考如下:
import { relationalStore } from "@kit.ArkData"; import { common } from "@kit.AbilityKit"; import { BusinessError, systemDateTime } from "@kit.BasicServicesKit"; @Entry @Component struct BigintRdbDemo { @State message: string | undefined = undefined; private context = this.getUIContext().getHostContext() as common.UIAbilityContext; private promptAction = this.getUIContext().getPromptAction(); private storeConfig: relationalStore.StoreConfig = { name: "BigintRdbDemo.db", securityLevel: relationalStore.SecurityLevel.S1, }; store: relationalStore.RdbStore | undefined = undefined; build() { Column({ space: 20 }) { Text(this.message || 'Hello World!'); Button('初始化数据库表') .width(150) .type(ButtonType.ROUNDED_RECTANGLE) .backgroundColor('#0a59f7') .onClick(() => { relationalStore.getRdbStore(this.context, this.storeConfig, (err, store) => { if (err) { console.error(`Failed to get RdbStore. Code:${err.code}, message:${err.message}`); this.promptAction.showToast({ message: '初始化数据库失败' }); return; } console.info('Succeeded in getting RdbStore.'); this.store = store; // step1:建表时声明BigInt数据类型为:UNLIMITED INT const sqlCreateTable = 'CREATE TABLE IF NOT EXISTS EMPLOYEE (ID INTEGER PRIMARY KEY AUTOINCREMENT, IDENTITY UNLIMITED INT)'; store.executeSql(sqlCreateTable) // 创建数据表,以便后续调用insert接口插入数据 .then(() => { this.promptAction.showToast({ message: '初始化数据库表成功' }); }) .catch((err: BusinessError) => { this.promptAction.showToast({ message: '初始化数据库表失败' }); console.error(`Failed to executeSql. Code:${err.code}, message:${err.message}`); }); }); }); Button('插入bigInt类型数据') .width(150) .type(ButtonType.ROUNDED_RECTANGLE) .backgroundColor('#0a59f7') .onClick(() => { let time = systemDateTime.getTime(true); let dataList = new Array<relationalStore.ValuesBucket>(); for (let index = 0; index < 10; index++) { let data: relationalStore.ValuesBucket = { // step2:构造数据插入表中,使用BigInt()生成bigInt类型数据 "IDENTITY": BigInt(time * 10000 + index) }; dataList.push(data); } this.store?.batchInsert("EMPLOYEE", dataList, (err, ret) => { if (err) { this.promptAction.showToast({ message: '数据插入失败' }); console.error(`insertData() failed, err.message: ${err.message}, err.code: ${err.code}`); return; } this.promptAction.showToast({ message: '数据插入成功' }); console.info(`insertData() finished: ${ret}`); }); }); Button('查询bigInt类型数据') .width(150) .type(ButtonType.ROUNDED_RECTANGLE) .backgroundColor('#0a59f7') .onClick(() => { this.store?.querySql("select * from EMPLOYEE limit 1", (err, resultSet) => { if (err) { this.promptAction.showToast({ message: '数据查询失败' }); console.error(`Query failed, code is ${err.code},message is ${err.message}`); return; } // resultSet是一个数据集合的游标,默认指向第-1个记录,有效的数据从0开始。 while (resultSet.goToNextRow()) { const id = resultSet.getLong(resultSet.getColumnIndex("ID")); // step3:查询数据库,使用resultSet.getValue()获取BigInt型数据。 const identity = resultSet.getValue(resultSet.getColumnIndex("IDENTITY")); this.message = identity?.toString(); console.info(`id=${id}, identity=${identity}`); } this.promptAction.showToast({ message: '数据查询成功' }); // 释放数据集的内存 resultSet.close(); }); }); } .justifyContent(FlexAlign.Center) .height('100%') .width('100%'); } }