node.js使用restify开发REST web services_nodejs restifyserver

touch app.js

var restify = require('restify');
 
function respond(req, res, next) {
  res.send('hello ' + req.params.name);
  next();
}
 
var server = restify.createServer({
   
   name: 'ds_api',
  version: '1.0.0'
});
 
server.get('/hello/:name', respond);
server.head('/hello/:name', respond);
 
server.listen(8081, function() {
  console.log('%s listening at %s', server.name, server.url);
});

node app.js

listening at http://[::]:8081

curl -is http://localhost:8081/hello/mark
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: 12
Date: Mon, 22 Feb 2016 06:57:42 GMT
Connection: keep-alive

"hello mark"

npm install felixge/node-mysql

// 连接mysql
var mysql = require('mysql');
var conn = mysql.createConnection({
    host: ‘ip’,
    user: ‘user’,
    password: ‘pasw’,
    database:'ds_video',
    port: 3306
});

server.get('queryListVideo/:vid/:count/:type/:userId',function respond(req, res, next) {
 
 	conn.query( {
 
		 sql: 'select distinct v.title as title,v.id,v.url as videoUrl ,v.pic,v.type,v.createTime as pushTime ,'+
		
		'(select count(*) from `tb_user_video` tub WHERE tub.`status` = 1 AND tub.userId = ? AND tub.videoId = v.id) as isCollectStatus'+
		
		' from `tb_video` v where'+
		' v.title != ""   AND v.title not like "%#%" AND v.title not like "%@%" AND v.title not like "%微%"  '+
		' AND v.title not like "%秒拍%"  AND v.title not like "%号%" '+
		' AND v.title not like "%美拍%"   '+
		
		' AND type = ? '+
 
		'ORDER BY id DESC LIMIT ?' ,
		values: [req.params.userId,req.params.type,parseInt(req.params.count)]
	},
 
	 function(err, rows, fields) {
    if (err) throw err; 
        console.log('The title is: ', title = rows[0].title); 
    	res.send(200, res.json(rows));
 
	});  
   return next();
 });

conn.query( { 
     sql:  ’sql语句 ？’,
     values: [] // ? 填充值
   },
   
   function(err, rows, fields) { //数据库返回数据
   if (err) throw err;  
       res.send(200, res.json(rows));
   });

[
  {
    "title": "我也是醉了",
    "id": 37729,
    "videoUrl": "http://mvvideo2.meitudata.com/56c8a0c08e10d5457.mp4",
    "pic": "http://mvimg1.meitudata.com/56c8a0bfef7c11168.jpg!thumb320",
    "type": 2,
    "pushTime": "2016-02-20T18:11:33.000Z",
    "isCollectStatus": 0
  },
  {
    "title": "女神如此难追",
    "id": 37727,
    "videoUrl": "http://mvvideo2.meitudata.com/56c7de946f8bb3420.mp4",
    "pic": "http://mvimg11.meitudata.com/56c8150c4fe9d9762.jpg!thumb320",
    "type": 2,
    "pushTime": "2016-02-20T18:11:32.000Z",
    "isCollectStatus": 0
  },
  {
    "title": "一个疯子+一个傻子=两张大饼脸️精彩活动️问：视频中我说了几个啥玩意儿完全即兴某人还不知道规则",
    "id": 37726,
    "videoUrl": "http://mvvideo1.meitudata.com/56c8a0186f59d9869.mp4",
    "pic": "http://mvimg2.meitudata.com/56c8a10eaa5394719.jpg!thumb320",
    "type": 2,
    "pushTime": "2016-02-20T18:11:32.000Z",
    "isCollectStatus": 0
  },
  {
    "title": "爆笑歌词梗",
    "id": 37704,
    "videoUrl": "http://mvvideo1.meitudata.com/56c0438416f2a3712.mp4",
    "pic": "http://mvimg10.meitudata.com/56c832793e9705833.jpg!thumb320",
    "type": 2,
    "pushTime": "2016-02-20T17:14:14.000Z",
    "isCollectStatus": 0
  },
  {
    "title": "情感专线-拜金女的那些事儿",
    "id": 37701,
    "videoUrl": "http://gslb.miaopai.com/stream/Lqn~dQ1tbuJ5KNkc~LAG1A__.m3u8",
    "pic": "http://wsacdn3.miaopai.com/stream/Lqn~dQ1tbuJ5KNkc~LAG1A___m.jpg",
    "type": 2,
    "pushTime": "2016-02-20T17:14:13.000Z",
    "isCollectStatus": 0
  },
  {
    "title": "一网友说她家鹦鹉笑起来好像她奶奶[笑cry]",
    "id": 37696,
    "videoUrl": "http://gslb.miaopai.com/stream/59hdWRg61qsMMwvT5BXPNg__.mp4?vend=miaopai&59hdWRg61qsMMwvT5BXPNg__.mp4miaopai",
    "pic": "http://wsacdn1.miaopai.com/stream/59hdWRg61qsMMwvT5BXPNg___tmp_11_363_.png",
    "type": 2,
    "pushTime": "2016-02-20T17:14:11.000Z",
    "isCollectStatus": 0
  },
  {
    "title": "捉迷藏1 这当爹的心太大了吧！这不摆明了坑儿子么？！",
    "id": 37681,
    "videoUrl": "http://gslb.miaopai.com/stream/fKPmQViX6eytWcD6XxR2Yw__.mp4?vend=miaopai&fKPmQViX6eytWcD6XxR2Yw__.mp4miaopai",
    "pic": "http://wsqncdn.miaopai.com/stream/fKPmQViX6eytWcD6XxR2Yw___m.jpg",
    "type": 2,
    "pushTime": "2016-02-20T16:12:51.000Z",
    "isCollectStatus": 0
  },
  {
    "title": "聚会上最装逼的人",
    "id": 37664,
    "videoUrl": "http://mvvideo1.meitudata.com/56c7fbce28caf6036.mp4",
    "pic": "http://mvimg1.meitudata.com/56c703002a0dc7724.jpg!thumb320",
    "type": 2,
    "pushTime": "2016-02-20T15:22:30.000Z",
    "isCollectStatus": 0
  },
  {
    "title": "现在的女生真的很现实",
    "id": 37659,
    "videoUrl": "http://mvvideo2.meitudata.com/56c87dd4057812379.mp4",
    "pic": "http://mvimg2.meitudata.com/56c87ded57b056131.jpg!thumb320",
    "type": 2,
    "pushTime": "2016-02-20T15:22:26.000Z",
    "isCollectStatus": 0
  },
  {
    "title": "断奶篇-唱回到过去",
    "id": 37658,
    "videoUrl": "http://gslb.miaopai.com/stream/aeNf6EQmnzUo4J22Ms~Tfg__.mp4?vend=miaopai&aeNf6EQmnzUo4J22Ms~Tfg__.mp4miaopai",
    "pic": "http://wsqncdn.miaopai.com/stream/aeNf6EQmnzUo4J22Ms~Tfg___m.jpg",
    "type": 2,
    "pushTime": "2016-02-20T15:22:25.000Z",
    "isCollectStatus": 0
  }
]