校友录管理系统的开发与应用

const express = require('express');

const bodyParser = require('body-parser');

const mysql = require('mysql');

const app = express();

app.use(bodyParser.json());

// 创建数据库连接

const db = mysql.createConnection({

host: 'localhost',

user: 'root',

password: 'password',

database: 'alumni_system'

});

// 连接到数据库

db.connect(err => {

if (err) throw err;

console.log('Connected to database.');

});

// 添加新用户的API

app.post('/users', (req, res) => {

const { name, graduationYear, major } = req.body;

const sql = `INSERT INTO Users (Name, GraduationYear, Major) VALUES (?, ?, ?)`;

db.query(sql, [name, graduationYear, major], (err, result) => {

if (err) throw err;

res.send('User added successfully!');

});

});

app.listen(3000, () => console.log('Server started on port 3000'));