<?python
# 导入必要的库
import sqlite3
from flask import Flask, request, jsonify
# 创建Flask应用实例
app = Flask(__name__)
# 连接SQLite数据库
conn = sqlite3.connect('student_worker_management.db')
c = conn.cursor()
# 创建学生表
c.execute('''
CREATE TABLE IF NOT EXISTS students (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
age INTEGER NOT NULL,
major TEXT NOT NULL
)
''')
# 创建工人表
c.execute('''
CREATE TABLE IF NOT EXISTS workers (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
job TEXT NOT NULL,
salary REAL NOT NULL
)
''')
# 插入数据
def insert_student(name, age, major):
c.execute('INSERT INTO students (name, age, major) VALUES (?, ?, ?)', (name, age, major))
conn.commit()
def insert_worker(name, job, salary):
c.execute('INSERT INTO workers (name, job, salary) VALUES (?, ?, ?)', (name, job, salary))
conn.commit()
# 查询数据
@app.route('/students', methods=['GET'])
def get_students():
c.execute('SELECT * FROM students')
students = c.fetchall()
return jsonify(students)
@app.route('/workers', methods=['GET'])
def get_workers():
c.execute('SELECT * FROM workers')
workers = c.fetchall()
return jsonify(workers)
if __name__ == '__main__':
app.run(debug=True)
?>