#HarmonyOS NEXT 体验官#本地数据库实现《菜谱大全》app（三） 原创

//food_meau ：表的名称
/**
 *
 * @param store 数据库实例
 * @param onGetFoods 获取数据成功后的回调，返回菜谱数组
 * @param onError
 * @param limit 每次获取数量限制
 * @param skip 
 */
getFoods(store: relationalStore.RdbStore, onGetFoods: (res: Array<Food>) => void, onError?: (err: string) => void,
  limit?: number, skip?: number) {
  // let predicates = new relationalStore.RdbPredicates("food_meau")
  let lim = ` limit 10`
  if (limit && skip) {
    lim = `limit ${limit} skip ${skip}`
  }


  let sql = `Select * from food_meau order By RANDOM() ${lim}`
  store.querySql(sql, (err: BusinessError, resultSet) => {
    if (err == undefined) {
      let foods = Array<Food>()
      while (resultSet.goToNextRow()) {
        foods.push(this.parseFood(resultSet))
      }
      onGetFoods(foods)
    } else
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.

/**
 * 菜谱数据实体类
 */
export class Food {
  meauID: number = 0
  name: string = ''
  tags: string = ''
  method: string = ''
  img: string = ''
  url: string = ''
  level: string = ''
  peopleNum: string = ''
  taste: string = ''
  prepareTime: string = ''
  cookTime: string = ''
  mainIngredient: string = '' //主料
  accessories: string = '' //辅料
  measure: string = '' //步骤
  techniques: string = '' //技巧
  scrapyTime: string = ''
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.

parseFood(resultSet: relationalStore.ResultSet): Food {
  let food = new Food()
  food.meauID = this.parseLong("meauID", resultSet)
  food.name = this.parseString("name", resultSet);
  food.tags = this.parseString("tags", resultSet);
  food.method = this.parseString("method", resultSet);
  food.img = this.parseString("img", resultSet);
  food.url = this.parseString("url", resultSet);
  food.level = this.parseString("level", resultSet);
  food.peopleNum = this.parseString("peopleNum", resultSet);
  food.taste = this.parseString("taste", resultSet);
  food.prepareTime = this.parseString("prepareTime", resultSet);
  food.cookTime = this.parseString("cookTime", resultSet);
  food.mainIngredient = this.parseString("mainIngredient", resultSet); //主料
  food.accessories = this.parseString("accessories", resultSet); //辅料
  food.measure = this.parseString("measure", resultSet); //步骤
  food.techniques = this.parseString("techniques", resultSet); //技巧
  food.scrapyTime = this.parseString("scrapyTime", resultSet);
  return food
}
parseLong(column: string, resultSet: relationalStore.ResultSet): number {
  if (resultSet.getColumnIndex(column) != -1) {
    return resultSet.getLong(resultSet.getColumnIndex(column));
  }
  return 0
}

parseString(column: string, resultSet: relationalStore.ResultSet): string {
  if (resultSet.getColumnIndex(column) != -1) {
    return resultSet.getString(resultSet.getColumnIndex(column));
  }
  return ""
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.

/**
 *
 * @param store
 * @param keyword 关键字
 * @param onGetFoods
 * @param onError
 * @param limit
 * @param skip
 */
getFoodsByKeyword(store: relationalStore.RdbStore, keyword: string, onGetFoods: (res: Array<Food>) => void,
  onError?: (err: string) => void, limit?: number, skip?: number) {
  let lim = ` limit 10`//限制每次取10条数据
  if (limit && skip) {
    lim = `limit ${limit} skip ${skip}`
  }
  let sql = `Select * from food_meau where name like ("%${keyword}%") order By RANDOM() ${lim}`
  store.querySql(sql, (err: BusinessError, resultSet) => {
    if (err == undefined) {
      let foods = Array<Food>()
      while (resultSet.goToNextRow()) {
        //解析数据
        foods.push(this.parseFood(resultSet))
      }
      onGetFoods(foods)
    } else
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.

/**
 * 获取指定烹饪方法下的菜谱列表
 * @param store
 * @param method
 * @param onGetFoods
 * @param onError
 * @param limit
 * @param skip
 */
getFoodsByMethod(store: relationalStore.RdbStore, method: string, onGetFoods: (res: Array<Food>) => void,
  onError?: (err: string) => void, limit?: number, skip?: number) {
  // let predicates = new relationalStore.RdbPredicates("food_meau")
  // store.query(predicates, (err: BusinessError, resultSet) => {
  let lim = ` limit 10`
  if (limit && skip) {
    lim = `limit ${limit} skip ${skip}`
  }

  let sql = `Select * from food_meau where method like ("%${method}%") ${lim}`
  store.querySql(sql, (err: BusinessError, resultSet) => {
    if (err == undefined) {
      let foods = Array<Food>()
      while (resultSet.goToNextRow()) {
        foods.push(this.parseFood(resultSet))
      }
      onGetFoods(foods)
    } else
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.

/**
 * 获取所有烹饪方法
 * @param store
 * @param onGetMethods
 * @param onError
 */
getAllCookMethods(store: relationalStore.RdbStore, onGetMethods: (res: Array<string>) => void,
  onError?: (err: string) => void) {
  let sql = "Select * from food_meau group by method ORDER BY method DESC"
  store.querySql(sql, (err: BusinessError, resultSet) => {
    if (err == undefined) {
      let arr: Array<string> = new Array();
      while (resultSet.goToNextRow()) {
        let food = this.parseFood(resultSet)
        arr.push(food.method)
      }
      onGetMethods(arr)
    } else
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.

/**
 * 获取所有口味
 * @param store
 * @param onGetTaste
 * @param onError
 */
getAllTastes(store: relationalStore.RdbStore, onGetTaste: (res: Array<string>) => void,
  onError?: (err: string) => void) {
  let sql = "Select * from food_meau group by taste order by taste desc"
  store.querySql(sql, (err: BusinessError, resultSet) => {
    if (err == undefined) {
      let arr: Array<string> = new Array();
      while (resultSet.goToNextRow()) {
        let food = this.parseFood(resultSet)
        arr.push(food.taste)
      }
      onGetTaste(arr)
    } else
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.

/**
 * 根据难度获取菜谱列表
 * @param store
 * @param level
 * @param onGetFoods
 * @param onError
 * @param limit
 * @param skip
 */
getFoodsByLevel(store: relationalStore.RdbStore, level: string, onGetFoods: (res: Array<Food>) => void,
  onError?: (err: string) => void, limit?: number, skip?: number) {
  let lim = ` limit 10`
  if (limit && skip) {
    lim = `limit ${limit} skip ${skip}`
  }

  let sql = `Select * from food_meau where level like ("%${level}%") ${lim}`
  store.querySql(sql, (err: BusinessError, resultSet) => {
    if (err == undefined) {
      let foods = Array<Food>()
      while (resultSet.goToNextRow()) {
        foods.push(this.parseFood(resultSet))
      }
      onGetFoods(foods)
    } else
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.