一站式网上办事大厅

// 示例代码：用户注册接口

const express = require('express');

const router = express.Router();

router.post('/register', (req, res) => {

const { username, password } = req.body;

if (!username || !password) {

return res.status(400).send({ error: 'Missing fields' });

}

// 模拟数据库操作

db.query('INSERT INTO users(username, password) VALUES(?, ?)', [username, password], (err, result) => {

if (err) {

return res.status(500).send({ error: 'Database error' });

}

res.send({ message: 'User registered successfully!' });

});

});

]]>

// 创建用户表

CREATE TABLE users (

id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(50) NOT NULL UNIQUE,

password VARCHAR(255) NOT NULL,

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);

]]>