Category: Tools Views : 1379 Comments : 0 Posted on : 2019-06-13

Install express first

 $ cnpm install express --save

Then paste the code

 var express = require('express'); var app = express(); var mysql = require('mysql'); //Get the parameters under post var bodyParser = require('body-parser') app.use(bodyParser.urlencoded({ extended: false })) app.use(bodyParser.json()) //Database configuration var connection = mysql.createConnection({ host: 'localhost', user: 'root', password: 'zxc123', database: 'test' }); //Connect Database connection.connect(); //Allow all cross domain requests app.all("*", function (req, res, next) { res.header("Access-Control-Allow-Origin", "*");           next(); }) //Registration method function registered(username, password,res) { var sql = 'INSERT INTO test (username,password) VALUES(?,?)'; var sqlParams = [username, password] connection.query(sql, sqlParams, function (err, result) { if (err) { console.log('[SELECT ERROR] - ', err.message); return; } else { res.send({ code: 200 }); } }); } //Login method function login(username, password,res) { var sql = 'SELECT * FROM test where username = ?  and password = ?'; var sqlParams = [username, password] //Check connection.query(sql, sqlParams, function (err, result) { if (err) { console.log('[SELECT ERROR] - ', err.message); return; } if (result.length == 0) { Res.send ({mag: "no data"}); } else { res.send(JSON.stringify(result)); } }); } app.post('/registered', function (req, res) { registered(req.body.username, req.body.password,res); }) app.post('/login', function (req, res) { login(req.body.username, req.body.password,res); }) //Set service port var server = app.listen(8081)

Finally, node xxx.js runs the node service
If you use the pm2 manager in the pagoda panel, be sure to run it first or you may not find the port number. By the way, remember to open the port number

Posted by : lyhq Tags: No tag is set in this article

All original articles adopt Creative Commons Attribution - Noncommercial Use 4.0 International License Agreement Licensing.
You can reprint and modify freely, but please note the source of the article and do not use it for commercial purposes.
Part of the content of this website is collected on the Internet. If there is any infringing content or improper content, please contact us to delete it. Please understand!

Previous post File Renamer Turbo

Next post Google Browser remembers the password and changes the background color of the input box

Add a new comment

About bloggers

Down and out front, eating dirt online

Node.js server login registration

Add a new comment