javascript - 无法/发布 - 登录验证

Question

我正在创建一个应用程序，我需要一个登录/注册功能。这是我的登录 HTML:

 <div style="padding-top:30px" class="panel-body" >
      <div style="display:none" id="login-alert" class="alert alert-danger col-sm-12"></div>

       <form action="verifySignin" method="post" id="verifySignin" class="form-horizontal" role="form">
       <div style="margin-bottom: 25px" class="input-group">
         <span class="input-group-addon"><i class="glyphicon glyphicon-user"></i></span>
       <input id="login-username" type="text" class="form-control" name="username" value="" placeholder="username" required="" autofocus="" >                                        
    </div>
  <div style="margin-bottom: 25px" class="input-group">
   <span class="input-group-addon"><i class="glyphicon glyphicon-lock"></i></span>
 <input id="login-password" type="password" class="form-control" name="password" placeholder="password">
</div>
    <div style="margin-top:10px" class="form-group">
   <!-- Button -->
    <div class="col-sm-12 controls">
      <button class="btn btn-md btn-primary btn-block" type="submit">Login</button> 
   </div>
 </div> 
 <div class="form-group">
   <div class="col-md-12 control">
      <div style="border-top: 1px solid#888; padding-top:15px; font-size:85%" > Don't have an account? 
 <a href="#" onClick="$('#loginbox').hide(); $('#signupbox').show()">
 Sign Up Here
</a>
 </div>
</div>
 </div>    
</form>     
 </div>         

我的 app.js 有以下要路由:

app.post('/verifySignin', home.verifySignin);
app.get('/verifySignin', home.verifySignin);

在routes文件夹下>我创建了一个home.js文件，其中包含以下内容:

function verifySignin(req,res)
 {

  req.session.name=req.param("username");
  var password = req.param("password");
  console.log("session name:"+req.session.name);
  var verifyUserQuery="select username, password from Users where Username='"+req.param("username")+"' and Password = '"+req.param("password")+"'";
  mysql.fetchData(function(err,results){
    if(err){
        throw err;
    }
    else 
    {
        if(results.username==req.param("username") && results.password == password){
            res.render('kanban', { name: req.param("username") });}
        else {
            res.render('ErrorPage');
        }
    }  
},verifyUserQuery);
 }
  exports.verifySignin=verifySignin;

当我单击“登录”按钮时，收到错误:无法 POST/verifySignin。任何帮助将不胜感激。谢谢。

Answer 1

尝试像这样使用它，

var users = require('./home/users');

此外，出于安全考虑，这是一种非常糟糕的做法

"select username, password from Users where Username='"+req.param("username")+"' and Password = '"+req.param("password")+"'"

将值作为参数传递或绑定(bind)它们。