HarmonyOS应用开发JSAPI-js数据库dataRdb

前置：
Api：8
语言：js开发

参考地址：
文档中心

开始：
1.创建项目：

2.示例代码
test.hml

    创建数据库    
 写入数据 查询数据 修改数据 删除数据    
    
 写入姓名:{{ name }} 写入年龄:{{ age }}  查询姓名:{{ name1 }} 查询年龄:{{ age1 }}     

test.css

.container {    flex-direction: column;    justify-content: center;    align-items: center;    width: 100%;    height: 100%;}.dataRdpBtn{    flex-direction: row;    justify-content: center;    align-items: center;    width: 100%;    flex-wrap: wrap;}.btn {    font-size: 50px;    margin: 10px;}.dataRdpBox{    flex-direction: column;    justify-content: flex-start;    align-items: flex-start;    width: 90%;    height: 500px;    border: 2fp;}.text{    font-size: 50px;    width: 100%;    margin: 10px;}

test.js

export default {    data: { rdb: null, name: "", age: "", name1: "", age1: "",    },    //创建数据库    CreateRdbStore() { var that = this; dataRdb.getRdbStore({     name: "demoRdb.db", }, 1, function (err, rdbStoreData) {     if (err) {  console.log('获取失败' + err)     } else {  const SQL_CREATE_TABLE = "CREATE TABLE IF NOT EXISTS EMPLOYEE (ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT NOT NULL, AGE INTEGER)"  rdbStoreData.executeSql(SQL_CREATE_TABLE, null)  that.rdb = rdbStoreData;  console.log('dataRdb success' + that.rdb)     } })    },    //写入数据    insertData() { let that = this; const dataObj = {     "NAME": "张三",     "AGE": 20, } let promise = that.rdb.insert("EMPLOYEE", dataObj) promise.then(async (ret) => {     console.log("插入成功: " + ret)     that.name = dataObj.NAME;     that.age = dataObj.AGE; }).catch((err) => {     console.info(err) })    },    //查询数据    selectData() { let that = this; let selectData = new dataRdb.RdbPredicates("EMPLOYEE") selectData.equalTo("NAME", that.name) console.log("查询条件:" + that.name) that.rdb.query(selectData, ["ID", "NAME", "AGE"], function (err, resultSet) {     console.info(" success resultSet columnNames:" + resultSet.columnNames)     console.info(" success resultSet columnCount:" + resultSet.columnCount)     if (resultSet.rowCount > 0) {  resultSet.goToFirstRow();  const id = resultSet.getLong(resultSet.getColumnIndex("ID"))  const name = resultSet.getString(resultSet.getColumnIndex("NAME"))  const age = resultSet.getLong(resultSet.getColumnIndex("AGE"))  console.log("id:" + id + "||" + "name:" + name + "||" + "age:" + age);  that.name1 = name;  that.age1 = age;     } else {  console.log("NOT DATA");     } })    },    //修改数据    updateData() { var that = this; let updateValue = {     "NAME": "李四",     "AGE": 25, } let updateData = new dataRdb.RdbPredicates("EMPLOYEE") updateData.equalTo("NAME", that.name) console.log("查询条件:" + that.name) that.rdb.update(updateValue, updateData, function (err, ret) {     console.log("修改数据成功：" + ret)     that.name = updateValue.NAME;     that.age = updateValue.AGE; })    },    //删除数据    deleteData() { let that = this let deleteData = new dataRdb.RdbPredicates("EMPLOYEE") deleteData.equalTo("NAME", that.name) that.rdb.delete(deleteData, function (err, rows) {     if (rows.rowCount > 0) {  rows.goToFirstRow();  const name = rows.getString(rows.getColumnIndex("NAME"))  const age = rows.getLong(rows.getColumnIndex("AGE"))  console.log("name:" + name + "||" + "age:" + age);  that.name = "";  that.age = "";  that.name1 = "";  that.age1 = "";     } else {  console.log("NOT DATA");     }     console.log("删除成功: " + rows) })    }}

3.效果如图：

4、代码地址
(HarmonyOSAPP开发相关组件: 深圳市蛟龙腾飞网络科技有限公司 - Gitee.com)

医学名词百科