统一消息系统

id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(50) NOT NULL UNIQUE,

password VARCHAR(255) NOT NULL,

email VARCHAR(100),

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);

const bcrypt = require('bcryptjs');

const app = express();

app.use(express.json());

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

const { username, password } = req.body;

const user = await getUserByUsername(username);

if (user && bcrypt.compareSync(password, user.password)) {

res.status(200).json({ message: '登录成功' });

} else {

res.status(401).json({ message: '用户名或密码错误' });

}

});

async function getUserByUsername(username) {

// 这里应该是从数据库获取用户信息

return { id: 1, username: 'testUser', password: '$2a$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi' };

}