express mysql写用户登录注册,校验用户名重复的接口
时间: 2023-05-27 20:02:43 浏览: 72
1. 注册接口
```javascript
app.post('/register', (req, res) => {
const username = req.body.username;
const password = req.body.password;
const sql = 'SELECT * FROM users WHERE username = ?';
conn.query(sql, [username], (err, results) => {
if (err) {
throw err;
}
if (results.length > 0) { // 如果该用户名已存在
res.json({
code: 1,
message: '该用户名已被注册'
});
} else { // 否则,进行注册
const insertSql = 'INSERT INTO users(username, password) VALUES(?, ?)';
conn.query(insertSql, [username, password], (err, result) => {
if (err) {
throw err;
}
res.json({
code: 0,
message: '注册成功'
});
});
}
});
});
```
2. 登录接口
```javascript
app.post('/login', (req, res) => {
const username = req.body.username;
const password = req.body.password;
const sql = 'SELECT * FROM users WHERE username = ? AND password = ?';
conn.query(sql, [username, password], (err, results) => {
if (err) {
throw err;
}
if (results.length > 0) { // 如果登录成功
res.json({
code: 0,
message: '登录成功'
});
} else { // 否则,登录失败
res.json({
code: 1,
message: '用户名或密码错误'
});
}
});
});
```
3. 校验用户名重复接口
```javascript
app.get('/checkUsername', (req, res) => {
const username = req.query.username;
const sql = 'SELECT * FROM users WHERE username = ?';
conn.query(sql, [username], (err, results) => {
if (err) {
throw err;
}
if (results.length > 0) { // 如果该用户名已存在
res.json({
code: 1,
message: '该用户名已被注册'
});
} else { // 否则,用户名可用
res.json({
code: 0,
message: '用户名可用'
});
}
});
});
```