统一消息系统

npm install express bcrypt jsonwebtoken mysql

const { Sequelize, DataTypes } = require('sequelize');

const sequelize = new Sequelize('database', 'username', 'password', {

host: 'localhost',

dialect: 'mysql'

});

const User = sequelize.define('User', {

username: {

type: DataTypes.STRING,

allowNull: false,

unique: true

},

password: {

type: DataTypes.STRING,

allowNull: false

}

}, {

hooks: {

beforeCreate: (user) => {

user.password = bcrypt.hashSync(user.password, 10);

}

}

});

module.exports = User;

const express = require('express');

const router = express.Router();

const jwt = require('jsonwebtoken');

const User = require('./models/User');

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

try {

const user = await User.findOne({ where: { username: req.body.username } });

if (!user || !bcrypt.compareSync(req.body.password, user.password)) {

return res.status(400).send('Invalid credentials.');

}

const token = jwt.sign({ id: user.id }, 'your_jwt_secret', { expiresIn: '1h' });

res.json({ token });

} catch (error) {

res.status(500).send('Server error');

}

});

module.exports = router;