app开发技术分享HarmonyOS 鸿蒙Next 兑换商品数据插入

app开发技术分享HarmonyOS 鸿蒙Next 兑换商品数据插入

技术栈

Appgallery connect

开发准备

上一节我们实现了积分列表的展示，我们可以更直观的查看当前用户积分的收支情况，但是现在我们只有积分收入并没有消费的地方，所以现在我们开始着手积分兑换相关的内容。这一节我们来实现积分兑换商品的内容

功能分析

首先我们需要创建对应的积分商品表、实体类、db类，现在我们的表是空的，在进行数据展示之前我们先要添加数据，我们创建一个空页面，在生命周期方法中先添加数据，方便我们等会儿使用

代码实现

首先创建对应的表

{
  "objectTypeName": "points_product",
  "fields": [
    {"fieldName": "id", "fieldType": "Integer", "notNull": true, "belongPrimaryKey": true},
    {"fieldName": "url", "fieldType": "String"},
    {"fieldName": "name", "fieldType": "Text"},
    {"fieldName": "points", "fieldType": "Double"},
    {"fieldName": "amount", "fieldType": "Integer"},
    {"fieldName": "text_message", "fieldType": "String"},
    {"fieldName": "parameter", "fieldType": "String"},
    {"fieldName": "delivery_time", "fieldType": "String"},
    {"fieldName": "sales_volume", "fieldType": "Integer"},
    {"fieldName": "spec_str", "fieldType": "String"},
    {"fieldName": "max_loop_amount", "fieldType": "Integer"}
  ],
  "indexes": [
    {"indexName": "field1Index", "indexList": [{"fieldName":"id","sortType":"ASC"}]}
  ],
  "permissions": [
    {"role": "World", "rights": ["Read"]},
    {"role": "Authenticated", "rights": ["Read", "Upsert"]},
    {"role": "Creator", "rights": ["Read", "Upsert", "Delete"]},
    {"role": "Administrator", "rights": ["Read", "Upsert", "Delete"]}
  ]
}

实体类的创建

class PointsProduct {
  id: number;
  url: string;
  name: string;
  points: number;
  amount: number;
  text_message: string;
  parameter: string;
  delivery_time: string;
  sales_volume: number;
  spec_str: string;
  max_loop_amount: number;

  constructor() {}

  setId(id: number): void {
    this.id = id;
  }

  getId(): number {
    return this.id;
  }

  setUrl(url: string): void {
    this.url = url;
  }

  getUrl(): string {
    return this.url;
  }

  setName(name: string): void {
    this.name = name;
  }

  getName(): string {
    return this.name;
  }

  setPoints(points: number): void {
    this.points = points;
  }

  getPoints(): number {
    return this.points;
  }

  setAmount(amount: number): void {
    this.amount = amount;
  }

  getAmount(): number {
    return this.amount;
  }

  setText_message(text_message: string): void {
    this.text_message = text_message;
  }

  getText_message(): string {
    return this.text_message;
  }

  setParameter(parameter: string): void {
    this.parameter = parameter;
  }

  getParameter(): string {
    return this.parameter;
  }

  setDelivery_time(delivery_time: string): void {
    this.delivery_time = delivery_time;
  }

  getDelivery_time(): string {
    return this.delivery_time;
  }

  setSales_volume(sales_volume: number): void {
    this.sales_volume = sales_volume;
  }

  getSales_volume(): number {
    return this.sales_volume;
  }

  setSpec_str(spec_str: string): void {
    this.spec_str = spec_str;
  }

  getSpec_str(): string {
    return this.spec_str;
  }

  setMax_loop_amount(max_loop_amount: number): void {
    this.max_loop_amount = max_loop_amount;
  }

  getMax_loop_amount(): number {
    return this.max_loop_amount;
  }
}

export { PointsProduct };

db类

import { cloudDatabase } from '@kit.CloudFoundationKit';

class points_product extends cloudDatabase.DatabaseObject {
  public id: number;
  public url: string;
  public name: string;
  public points: number;
  public amount: number;
  public text_message: string;
  public parameter: string;
  public delivery_time: string;
  public sales_volume: number;
  public spec_str: string;
  public max_loop_amount: number;

  public naturalbase_ClassName(): string {
    return 'points_product';
  }
}

export { points_product };

都创建完成之后我们新建一个页面，在页面加载时新增数据

import { points_product } from '../../clouddb/points_product'
import { cloudDatabase } from '@kit.CloudFoundationKit';
import showToast from '../../utils/ToastUtils';

@Entry
@Component
struct PointsProductPage {
  async aboutToAppear(): Promise<void> {
    let databaseZone = cloudDatabase.zone('default');
    let product = new points_product()
    product.id = Math.floor(Math.random() * 1000000)
    product.url = "在线图片链接"
    product.name = "拉布布"
    product.points = 300000
    product.amount = 1
    product.text_message = "典藏版拉布布"
    product.parameter = "常温存放"
    product.delivery_time = "兑换后立马发货"
    product.sales_volume = 9999
    product.spec_str = "典藏款"
    product.max_loop_amount = 1
    let points_nums = await databaseZone.upsert(product);
    if (points_nums > 0) {
      showToast("添加成功")
    }
  }

  build() {
    RelativeContainer() {

    }
    .height('100%')
    .width('100%')
  }
}

我们新建的页面，通过积分兑换按钮进入

case "积分兑换":
  router.pushUrl({url:'pages/points/PointsProductPage'})
  break;

到这里我们就实现了数据的插入