APP搜索 11.11促销活动

// 假设使用React框架实现搜索框组件
import React, { useState } from 'react';

function SearchBar() {
  const [keyword, setKeyword] = useState('');

  const handleSearch = async () => {
    try {
      const response = await fetch(`/api/search?keyword=${encodeURIComponent(keyword)}`);
      const data = await response.json();
      // 处理搜索结果
    } catch (error) {
      console.error('搜索失败:', error);
    }
  };

  return (
    <div>
      <input
        type="text"
        value={keyword}
        onChange={(e) => setKeyword(e.target.value)}
        placeholder="请输入关键词"
      />
      <button onClick={handleSearch}>搜索</button>
    </div>
  );
}

export default SearchBar;

# 假设使用Flask框架处理搜索请求
from flask import Flask, request, jsonify
import sqlite3

app = Flask(__name__)

@app.route('/api/search')
def search():
    keyword = request.args.get('keyword', '')
    conn = sqlite3.connect('products.db')
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM products WHERE name LIKE ?", ('%' + keyword + '%',))
    results = cursor.fetchall()
    conn.close()
    return jsonify(results)

if __name__ == '__main__':
    app.run(debug=True)