【nodejs】实例（1）：登录界面

最新推荐文章于 2023-03-11 16:40:04 发布

猫兮ぃCatci

最新推荐文章于 2023-03-11 16:40:04 发布

阅读量464

点赞数

分类专栏： nodejs实例文章标签： nodejs mysql bt refactoring vnc

本文链接：https://blog.csdn.net/qq_45587822/article/details/104747970

版权

nodejs实例专栏收录该内容

4 篇文章 0 订阅

订阅专栏

准备工作

1.配置了MySQL server
2.安装express和mysql库

登录界面(http://127.0.0.1:8080/form.html)

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    <form action="http://127.0.0.1:8080/process_get" method="GET">
        user:<input type="" name="name"><br>
        pass:<input type="password" name="password"><br>
        <input type="submit" value="submit">
    </form>
</body>
</html>

服务器

var express = require('express');
var mysql  = require('mysql'); 

var app = express();
 
var response={};
var Result='';
app.use(express.static('public'));
 
app.get('/form.html', function (req, res) {
   res.sendFile( __dirname + "/" + "form.html" );
})
 
app.get('/process_get', function (req, res) {
 
   // 输出 JSON 格式
   response = {
       "first_name":req.query.name,
       "last_name":req.query.password
   };
   
   var connection = mysql.createConnection({     
  host     : 'localhost',       
  user     : 'root',              
  password : '123456',       
  port: '3306',                   
  database: '226', 
}); 
 
connection.connect();
 
var  sql = 'SELECT * FROM user_table where username="'+response.first_name+'"&&password='+response.last_name;
//查
console.log(sql);
connection.query(sql,function (err, result) {
        if(err){
          console.log('[SELECT ERROR] - ',err.message);
          return;
        }
 
       console.log('--------------------------SELECT----------------------------');
       console.log(result);
       console.log('------------------------------------------------------------\n\n');  
       connection.end();
       if(result.length != 0){
       	res.end('success!')
       }else{
       	res.end('fail...')
       	console.log('result的值为',result)
});
 
// connection.end();

})
 
var server = app.listen(8080, function () {
 
  var host = server.address().address
  var port = server.address().port
 
  console.log("应用实例，访问地址为 http://%s:%s", host, port)
 
})

猫兮ぃCatci

关注

0
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
【nodejs】实例（1）：登录界面

准备工作1.配置了MySQL server2.安装express和mysql库登录界面(http://127.0.0.1:8080/form.html)<!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <meta name="viewport" ...
复制链接

扫一扫

专栏目录