上门做菜系统的Go语言开发：如何实现菜品搜索功能？

CREATE TABLE dishes (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) NOT NULL,
    ingredients VARCHAR(200) NOT NULL,
    taste VARCHAR(50) NOT NULL
);

package main

import (
    "database/sql"
    "fmt"
    "log"
    "strings"

    _ "GitHub.com/go-sql-driver/mysql"
)

type Dish struct {
    ID          int    `JSON:"id"`
    Name        string `json:"name"`
    Ingredients string `json:"ingredients"`
    Taste       string `json:"taste"`
}

func main() {
    // 连接数据库
    db, err := sql.Open("mysql", "用户名:密码@tcp(localhost:3306)/数据库名")
    if err != nil {
        log.Fatal(err)
    }
    defer db.Close()

    // 搜索菜品
    results, err := searchDish(db, "宫保鸡丁", "", "")
    if err != nil {
        log.Fatal(err)
    }

    // 打印搜索结果
    for _, dish := range results {
        fmt.Printf("ID: %d, 菜名: %s, 食材: %s, 口味: %s
", dish.ID, dish.Name, dish.Ingredients, dish.Taste)
    }
}

func searchDish(db *sql.DB, name, ingredients, taste string) ([]Dish, error) {
    query := "SELECT * FROM dishes WHERE 1=1"

    // 构建查询条件
    if name != "" {
        query += fmt.Sprintf(" AND name LIKE '%s'", "%"+name+"%")
    }
    if ingredients != "" {
        query += fmt.Sprintf(" AND ingredients LIKE '%s'", "%"+ingredients+"%")
    }
    if taste != "" {
        query += fmt.Sprintf(" AND taste = '%s'", taste)
    }

    // 执行查询
    rows, err := db.Query(query)
    if err != nil {
        return nil, err
    }
    defer rows.Close()

    // 解析查询结果
    var results []Dish
    for rows.Next() {
        var dish Dish
        err := rows.Scan(&dish.ID, &dish.Name, &dish.Ingredients, &dish.Taste)
        if err != nil {
            return nil, err
        }
        results = append(results, dish)
    }

    return results, nil
}