聊聊uniapp下多组合条件查询的实现方法

<template>  <view class="container">    <input v-model="name" placeholder="请输入商品名称" />    <select v-model="brand">      <option value="">请选择品牌</option>      <option value="huawei">华为</option>      <option value="xiaomi">小米</option>      <option value="oppo">OPPO</option>    </select>    <input v-model="price" placeholder="请输入价格范围" />    <button @click="search">搜索</button>    <view class="result">      <view v-for="(item,index) in list" :key="index">{{item.name}} {{item.brand}} {{item.price}}</view>    </view>  </view></template><script>export default {  data() {    return {      name: "",      brand: "",      price: "",      list: []    };  },  methods: {    search() {      let sql = "SELECT * FROM product WHERE 1=1 ";      if (this.name) {        sql += `AND name LIKE '%${this.name}%' `;      }      if (this.brand) {        sql += `AND brand = '${this.brand}' `;      }      if (this.price) {        let priceArr = this.price.split("-");        sql += `AND price >= ${priceArr[0]} AND price <= ${priceArr[1]} `;      }      //在这里使用框架或者API进行数据查询操作    }  }};</script>