医院科研管理系统

CREATE TABLE Student (

student_id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(50) NOT NULL,

department VARCHAR(50) NOT NULL

);

CREATE TABLE ResearchResult (

result_id INT PRIMARY KEY AUTO_INCREMENT,

title VARCHAR(100) NOT NULL,

type ENUM('Journal', 'Conference', 'Patent') NOT NULL,

publication_date DATE,

student_id INT,

FOREIGN KEY (student_id) REFERENCES Student(student_id)

);

from flask import Flask, request, jsonify

from flask_mysqldb import MySQL

app = Flask(__name__)

app.config['MYSQL_HOST'] = 'localhost'

app.config['MYSQL_USER'] = 'root'

app.config['MYSQL_PASSWORD'] = ''

app.config['MYSQL_DB'] = 'research_system'

mysql = MySQL(app)

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

def add_result():

data = request.get_json()

title = data['title']

r_type = data['type']

publication_date = data['publication_date']

student_id = data['student_id']

cur = mysql.connection.cursor()

cur.execute("INSERT INTO ResearchResult (title, type, publication_date, student_id) VALUES (%s, %s, %s, %s)",

(title, r_type, publication_date, student_id))

mysql.connection.commit()

cur.close()

return jsonify({"message": "Research result added successfully"}), 201

SELECT COUNT(*) AS paper_count FROM ResearchResult WHERE type='Journal' AND YEAR(publication_date)=2023 GROUP BY student_id;