鸿蒙项目实战（完结）

一、通用DB工具

完成饮食记录操作和model的开发。

在RecordModel中

//关系型数据库
import relationalStore from '@ohos.data.relationalStore'
import data from '@ohos.telephony.data'
import { ColumnInfo, ColumnType } from '../common/bean/ColumnInfo'
import RecordPO from '../common/bean/RecordPO'
import DbUtil from '../common/utils/DbUtil'
//数据库建表语句
const CREATE_TABLE_SQL: string = `
 CREATE TABLE IF NOT EXISTS record (
   id INTEGER PRIMARY KEY AUTOINCREMENT,
   type_id INTEGER NOT NULL,
   item_id INTEGER NOT NULL,
   amount DOUBLE NOT NULL,
   create_time INTEGER NOT NULL
 )
 `

const COLUMNS:ColumnInfo[]=[
 {name:'id',columnName:'id',type:ColumnType.LONG},
 {name:'typeId',columnName:'id',type:ColumnType.LONG},
 {name:'itemId',columnName:'id',type:ColumnType.LONG},
 {name:'amount',columnName:'id',type:ColumnType.DOUBLE},
 {name:'createTime',columnName:'id',type:ColumnType.LONG}
]

const TABLE_NAME = 'record'
const ID_COLUMN = 'id'
const DATE_COLUMN = 'create_time'

class RecordModel {
 getCreateTableSql():string{
  return CREATE_TABLE_SQL
 }

 insert(record:RecordPO):Promise<number>{
  return DbUtil.insert(TABLE_NAME,record,COLUMNS)
 }

 deleteById(id:number){
  //1.删除条件
  let predicates = new relationalStore.RdbPredicates(TABLE_NAME)
  predicates.equalTo('ID_COLUMN',id)
  //2.删除
  return DbUtil.delete(predicates)
 }
listByDate(date:number) :Promise<RecordPO[]>{
 //1.查询条件
 let predicates = new relationalStore.RdbPredicates(TABLE_NAME)
 predicates.equalTo('DATE_COLUMN',date)
 //2.查询
 return DbUtil.queryForList(predicates,COLUMNS)
}
}

let recordModel = new RecordModel()

export default recordMode