from bottle import Bottle, request, response
import sqlite3
app = Bottle()
# 数据库连接
conn = sqlite3.connect('your_database.db')
cursor = conn.cursor()
@app.route('/search')
def search():
keyword = request.query.keyword
sql = "SELECT * FROM your_table_name WHERE your_column_name LIKE ?"
cursor.execute(sql, ('%' + keyword + '%',))
results = cursor.fetchall()
return {'results': results}
if __name__ == '__main__':
app.run(host='localhost', port=8080)