《仿盒马》app开发技术分享-- 兑换商品数据插入（67）

## 技术栈

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;

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