舉個例子:我資料庫里有用戶賬號1234,12345,123456(三個),而我的代碼只判定第一個,而不繼續判定,究竟錯在哪里?
app.post('/register', function (req, res, next){
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : '',
port: '3306',
database: 'test'
});
connection.connect();
var users = 'select * from users';
connection.query(users, function(err, rows){
if(err) throw err;
for(var i = 0; i < rows.length; i++){
if(req.body.zhanghao == rows[i].zhanghao){
console.log('注冊失敗');
res.send(404,'<script>alert("賬號已被注冊");window.history.back();</script>');
break;
}
if(req.body.nicheng == rows[i].nicheng){
console.log('注冊失敗');
res.send(404,'<script>alert("昵稱已被占用");window.history.back();</script>');
break;
}
if(req.body.shouji == rows[i].shouji){
console.log('注冊失敗');
res.send(404,'<script>alert("手機已被注冊");window.history.back();</script>');
break;
}
if(req.body.youxiang == rows[i].youxiang){
console.log('注冊失敗');
res.send(404,'<script>alert("郵箱已被注冊");window.history.back();</script>');
break;
}
else{
console.log('準備注冊');
next();
break;
}
}
})
connection.end();
})
轉載請註明出處,本文鏈接:https://www.uj5u.com/qianduan/95517.html
標籤:JavaScript
上一篇:請教一下maven應該怎么學?
下一篇:CSS選擇器的問題,求解
