pip install bottle pip install <database_driver> python from bottle import Bottle, route, run, request import <database_driver> python db = <database_driver>.connect(host='<host>', user='<username>', password='<password>', database='<database_name>') cursor = db.cursor() python app = Bottle() @app.route('/users') def get_users(): cursor.execute("SELECT * FROM users") result = cursor.fetchall() return {'users': result} @app.route('/users/<id:int>') def get_user(id): cursor.execute(f"SELECT * FROM users WHERE id = {id}") result = cursor.fetchone() return {'user': result} @app.route('/users', method='POST') def create_user(): name = request.forms.get('name') age = request.forms.get('age') cursor.execute(f"INSERT INTO users (name, age) VALUES ('{name}', {age})") db.commit() return {'message': 'User created successfully'} python if __name__ == '__main__': run(app, host='<host>', port=<port>)


上一篇:
下一篇:
切换中文