科研信息管理系统的开发与实现

CREATE TABLE User (

UserID INT PRIMARY KEY AUTO_INCREMENT,

Username VARCHAR(50) NOT NULL,

Password VARCHAR(100) NOT NULL,

Role ENUM('Admin', 'Researcher') DEFAULT 'Researcher'

);

CREATE TABLE Project (

ProjectID INT PRIMARY KEY AUTO_INCREMENT,

Title VARCHAR(200) NOT NULL,

Description TEXT,

UserID INT,

FOREIGN KEY (UserID) REFERENCES User(UserID)

);

CREATE TABLE Literature (

LiteratureID INT PRIMARY KEY AUTO_INCREMENT,

Title VARCHAR(200) NOT NULL,

Author VARCHAR(100),

URL VARCHAR(255),

UserID INT,

FOREIGN KEY (UserID) REFERENCES User(UserID)

);

from flask import Flask, request, jsonify

app = Flask(__name__)

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

def create_project():

data = request.get_json()

title = data['title']

description = data['description']

user_id = data['user_id']

# 这里省略数据库插入逻辑

return jsonify({"message": "Project created successfully"}), 201

大学融合门户

import React, { useEffect, useState } from 'react';

function ProjectList() {

const [projects, setProjects] = useState([]);

useEffect(() => {

fetch('/api/projects')

.then(response => response.json())

.then(data => setProjects(data));

}, []);

return (

{projects.map(project => (

• {project.title}

))}

);

}