Express builds a simple query server-JS Tutorial-php.cn

Express builds a simple query server

小云云

Release： 2018-02-11 09:19:02

Original

1140 people have browsed it

This article mainly introduces you to the method of using express to build a simple query server. The editor thinks it is quite good, so I will share it with you now and give it as a reference. Let’s follow the editor to take a look, I hope it can help everyone.

The technology stacks used include express and mysql.

Project structure:

service
--node_modules
--app.js
--query.js

Copy after login

app.js supports calling services , use body-parser to process the request.

query.js implements the functions of linking to the database and querying the database.

The app.js code is as follows:

var express = require(&#39;express&#39;);
var query = require(&#39;./query&#39;)
var bodyParser = require(&#39;body-parser&#39;);
var cookieParser = require(&#39;cookie-parser&#39;);
var app = express();
app.use(bodyParser.urlencoded({ extended: false }))//返回的对象是一个键值对，当extended为false的时候，键值对中的值就为&#39;String&#39;或&#39;Array&#39;形式，为true的时候，则可为任何数据类型。
app.use(bodyParser.json())
//跨域支持
app.all(&#39;*&#39;, function(req, res, next) {
  res.header("Access-Control-Allow-Origin", "*");
  res.header(&#39;Access-Control-Allow-Methods&#39;, &#39;PUT, GET, POST, DELETE, OPTIONS&#39;);
  res.header("Access-Control-Allow-Headers", "X-Requested-With");
  res.header(&#39;Access-Control-Allow-Headers&#39;, &#39;Content-Type&#39;);
  next();
});
//登录
app.post(&#39;/login&#39;,(req,res)=>{
  var opts = req.body;
  query(" SELECT *FROM `v_users` WHERE userAcount = ?",opts.userName).then((result)=>{
    var response = result[0];
    if(opts.password !== response.u_password){
      return res.send({
        errorCode:&#39;404&#39;,
        errorMsg:&#39;登录密码错误&#39;
      })
    }
    //模拟生成loginToken
    var loginToken = response.userAcount + Math.random()*Math.pow(10,16)
    res.send({
      loginToken:loginToken
    })
  })
})
var server = app.listen(3000,()=>{
  console.log(&#39;success&#39;)
})

Copy after login

query.js code is as follows:

(function() {
  var mysql = require(&#39;mysql&#39;);
  // var session = require(&#39;cookie-session&#39;);
  var query = (sql,key) => {
    var connection = mysql.createConnection({
      host: &#39;localhost&#39;,
      user: &#39;root&#39;,
      password: &#39;root123&#39;,
      database: &#39;m_users&#39;
    });
    connection.connect()
    var promise = new Promise((resolve,reject)=>{
      connection.query(sql,[key], function(error, results, fields) {
        if(error){
          reject(error)
        }else{
          resolve(results);
        }
      });
      connection.end();
    });
    return promise;
  }
  module.exports = query;
})()

Copy after login

Practice summary:

1.express Entry-level usage, as well as usage of body-parser and mysql plug-ins.

2. Try to use Inspector to debug the node program and implement debugger, by the way. Personally, I am more accustomed to using gulp for debugging.

3. The client uses post to call the interface When distinguishing the difference of Content-Type:

Content-Type:application/json;charset=UTF-8 parameter is placed in requestPayload

Content-Type: No Set or application/x-www-form-urlencoded parameters in Form Data

The above is the detailed content of Express builds a simple query server. For more information, please follow other related articles on the PHP Chinese website!