涵盖医院全部科研活动的全方位科研项目管理系统
CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(100) ); ]]>
CREATE TABLE projects ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(100) NOT NULL, description TEXT, start_date DATE, end_date DATE, user_id INT, FOREIGN KEY (user_id) REFERENCES users(id) ); ]]>
CREATE TABLE results ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(100) NOT NULL, abstract TEXT, publication_date DATE, project_id INT, FOREIGN KEY (project_id) REFERENCES projects(id) ); ]]>
const express = require('express'); const app = express(); const port = 3000; app.get('/api/users', (req, res) => { // 这里可以查询数据库获取用户信息 res.send({ message: 'Users list' }); }); app.listen(port, () => { console.log(`Server running at http://localhost:${port}/`); }); ]]>
Copyright © 医院科研管理系统