基于Python实现的青海地区就业实习管理系统

# 导入必要的库

import sqlite3

from flask import Flask, request, jsonify

# 初始化Flask应用

app = Flask(__name__)

# 连接到SQLite数据库

conn = sqlite3.connect('qinhai_job.db', check_same_thread=False)

cursor = conn.cursor()

# 创建用户表

cursor.execute('''

CREATE TABLE IF NOT EXISTS users (

id INTEGER PRIMARY KEY AUTOINCREMENT,

username TEXT UNIQUE NOT NULL,

password TEXT NOT NULL,

email TEXT UNIQUE NOT NULL,

role TEXT DEFAULT 'student'

);

''')

# 注册新用户

@app.route('/register', methods=['POST'])

数据共享平台

def register():

data = request.get_json()

username = data['username']

password = data['password']

email = data['email']

role = data['role'] if 'role' in data else 'student'

try:

cursor.execute("INSERT INTO users (username, password, email, role) VALUES (?, ?, ?, ?)",

(username, password, email, role))

conn.commit()

return jsonify({'message': 'User registered successfully!'}), 201

except Exception as e:

return jsonify({'error': str(e)}), 400

# 启动服务器

if __name__ == '__main__':

app.run(debug=True)

]]>