?

1. 安裝 node.js 環(huán)境

node.js 官網:?http://nodejs.cn/download/

從node.js官網下載安裝包，打開一直執(zhí)行下一步下一步，不要太簡單～。

?

2. 安裝編輯器IDE

首推 vscode, 免費、輕便且強大。

VSCode 官網：https://code.visualstudio.com/

?

3. 使用 node.js 寫api接口

安裝依賴包：npm install express --save

安裝post請求依賴包：npm install body-parse

在文件中導入依賴包：

? ? ? ? ? ? ? ?const express = require('express')

? ? ? ? ? ? ? ?const bodyParser = require('body-parser')

?

Example code:

main.js

/** @Descripttion: * @version: * @Author: CK * @Date: 2019-11-06 20:34:19* @LastEditors: CK * @LastEditTime: 2019-11-06 20:42:41*/ const express = require('express') const app = express() const bodyParser = require('body-parser') const db = require('./plug/db'); app.use(bodyParser.urlencoded({ extended: false })); //設置URLapp.get('/test')app.post('/insExchange',(req,res)=>{var req_data = req.body;var mt_exchange_id = req.body.exchange_idvar exchange_name = req.body.exchange_namevar exchange_alias = req.body.exchange_aliasvar pair_one = req.body.pair_onevar pair_one_name = req.body.pair_one_namevar pair_two = req.body.pair_twovar price_pair = req.body.price_pairvar price_usd =req.body.price_usdvar price_cny = req.body.price_cnyvar price_change = req.body.price_changevar volume_24h = req.body.volume_24hvar volume_24h_usd = req.body.volume_24h_usdvar market_cap_cny = req.body.market_cap_cnyvar market_cap_usd = req.body.market_cap_usd// let sql = "SELECT `id` FROM exchange WHERE m_id='"+req_data.exchange_id+"'";let sql = "SELECT `id`, `logo` FROM exchange WHERE m_id=?;"db.query(sql, [mt_exchange_id], function(err, rows){console.log(rows)if (rows.length > 0){// 如果exchange存在,查詢判斷交易對是否存在，存在update, 不存在insertvar exchange_id = rows[0].idvar cover_pic = rows[0].logo// let sql = "SELECT `id` FROM exchanges_pair WHERE pair_one='"+req_data.pair_one+"'and pair_two='"+req_data.pair_two+"' and exchange_id="+rows[0].idlet sql = "SELECT `id` FROM exchanges_pair WHERE pair_one=? and pair_two=? and exchange_id=?;"let sql_param = [req_data.pair_one, req_data.pair_two, rows[0].id]console.log('sql_param:', sql_param)db.query(sql, sql_param, function (err, rows) {console.log('--2:', rows)if (rows.length > 0){// let update_sql = "UPDATE exchanges_pair SET price_pair='"+price_pair+"', price_usd='"+price_usd+"', price_cny='"+price_cny+"', price_change='"+price_change+"',volume_24h='"+volume_24h+"', volume_24h_usd='"+volume_24h_usd+"', market_cap_usd='"+market_cap_usd+"', market_cap_cny='"+market_cap_cny+"' WHERE pair_one='"+pair_one+"', and pair_two='"+pair_two+"' and exchange_id='"+exchange_id+"'"let update_sql = "UPDATE exchanges_pair SET price_pair=?, price_usd=?, price_cny=?, price_change=?,volume_24h=?, volume_24h_usd=?, market_cap_usd=?, market_cap_cny=? WHERE pair_one=? and pair_two=? and exchange_id=?;"let sql_param = [price_pair, price_usd, price_cny, price_change, volume_24h, volume_24h_usd, market_cap_usd, market_cap_cny, pair_one, pair_two, exchange_id]db.query(update_sql, sql_param, function(err, rows){console.log('update_sql:', update_sql, sql_param)if (err){console.log('err update sql:', err)res.send({'code': 500, 'err': err})return;}res.send({'code': 200})return;})}else{// insert sqllet insert_sql = "INSERT INTO exchanges_pair(exchange_id, pair_one, pair_one_name, pair_two, exchange_name, exchange_alias, price_pair, price_usd, price_cny, price_change, volume_24h, volume_24h_usd, market_cap_usd, market_cap_cny, cover_pic) VALUE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);"let sql_param = [exchange_id, pair_one, pair_one_name, pair_two, exchange_name, exchange_alias, price_pair, price_usd, price_cny, price_change, volume_24h, volume_24h_usd, market_cap_usd, market_cap_cny, cover_pic]db.query(insert_sql, sql_param, function(err, rows){if (err){console.log('err update sql:', err)res.send({'code': 500, 'err': err})return;}res.send({'code': 200})return;})}})}else{res.send({'code': 200})}})// console.log(req_data)// res.send(req_data); })app.listen(3000, () => console.log('Example app listening on port 3000!'))

?

4. 啟動程序

測試： node main.js

部署：pm2 start main.js? ? (pm2 安裝命令： npm?install -g pm2)

?

?

--- END ---

?

總結

以上是生活随笔為你收集整理的node.js 从入门到？的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。