因?yàn)橹笆亲?net后臺(tái)，后來(lái)轉(zhuǎn)做前端了，又不想放棄自己后端的一些技能，尤其是api都是調(diào)用其他同事的api，于是就想自己寫api自己調(diào)用。把node服務(wù)裝好后就可以開始下一步了

1.第一步先搭建一個(gè)express項(xiàng)目吧。中文網(wǎng)站 http://www.expressjs.com.cn/starter/installing.html

express myappapi //自己隨便命名吧
  warning: the default view engine will not be jade in future releases
  warning: use `--view=jade' or `--help' for additional options
   create : myapidemo\
   create : myapidemo\public\
   create : myapidemo\public\javascripts\
   create : myapidemo\public\images\
   create : myapidemo\public\stylesheets\
   create : myapidemo\public\stylesheets\style.css
   create : myapidemo\routes\
   create : myapidemo\routes\index.js
   create : myapidemo\routes\users.js
   create : myapidemo\views\
   create : myapidemo\views\error.jade
   create : myapidemo\views\index.jade
   create : myapidemo\views\layout.jade
   create : myapidemo\app.js
   create : myapidemo\package.json
   create : myapidemo\bin\
   create : myapidemo\bin\www

目錄結(jié)構(gòu)

image.png

2.進(jìn)入這個(gè)目錄，在文件路徑上cmd，安裝依賴

地址欄

輸入cmd

F:\dingyuan>cd myapidemo
F:\dingyuan\myapidemo>
√ All packages installed (102 packages installed from npm registry, used 2s(network 2s), speed 296.22kB/s, json 90(715.97kB), tarball 0B)
F:\dingyuan\myapidemo>

3.用編輯器打開項(xiàng)目

項(xiàng)目目錄

4.重點(diǎn)來(lái)了，配置數(shù)據(jù)庫(kù)了，因?yàn)槲易?net出身的，所以會(huì)一些sqlserver，百度了一些連接數(shù)據(jù)庫(kù)的方案
還是npm npm npm cnpm install mssql

√ Installed 1 packages
√ Linked 21 latest versions
√ Run 0 scripts
√ All packages installed (19 packages installed from npm registry, used 2s(network 2s), speed 128.9kB/s, json 22(296.07kB), tarball 0B)

F:\dingyuan\myappapi>npm start

5.創(chuàng)建db.js

var mssql = require('mssql');

var db = {};
var config = {
  user: 'sa',
  password: '123456',
  server: 'xxxxx', 
  database: '數(shù)據(jù)庫(kù)名',
  port:1433,
  options: {
    encrypt: true // Use this if you're on Windows Azure
  },
  pool: {
    min: 0,
    max: 10,
    idleTimeoutMillis: 3000
  }
};
 
//執(zhí)行sql,返回?cái)?shù)據(jù).
db.sql = function (sql, callBack) {
  console.log("sql", sql)
  var connection = new mssql.ConnectionPool(config, function (err) {
    if (err) {
      console.log(err);
      return;
    }
    var ps = new mssql.PreparedStatement(connection);
    ps.prepare(sql, function (err) {
      if (err){
        console.log(err);
        return;
      }
      ps.execute('', function (err, result) {
        if (err){
          console.log(err);
          return;
        }
 
        ps.unprepare(function (err) {
          if (err){
            console.log(err);
            callback(err,null);
            return;
          }
            callBack(err, result);
        });
      });
    });
  });
};
 
module.exports = db;

6.就使用express創(chuàng)建好的user.js

var express = require('express');
var router = express.Router();
var db = require('./db');shu
/* GET user listing. */
router.get('/', function(req, res, next) {
    db.sql('select * from A_AdminUser', function(err, result) {
        if(err) {
            console.log("sql錯(cuò)誤", err);
            return;
        }
        res.send(result);
    });
});

module.exports = router;

瀏覽器地址里直接local:3000里面去/user
看看數(shù)據(jù)是不是出來(lái)了，so easy.花了兩天時(shí)間百度和同事都詢問(wèn)才弄個(gè)出來(lái)。