nodjs jugglingdb orm框架的使用

首先配置package.json

{
  "name": "nodejstest",
  "version": "0.0.0",
  "private": true,
  "scripts": {
    "start": "node ./bin/www"
  },
  "dependencies": {
    "express": "~4.9.0",
    "body-parser": "~1.8.1",
    "cookie-parser": "~1.3.3",
    "morgan": "~1.3.0",
    "serve-favicon": "~2.1.3",
    "debug": "~2.0.0",
    "jade": "~1.6.0",
    "mysql":"*",
    "jugglingdb":"0.3.x",
    "jugglingdb-mysql": "latest"
  },
  "devDependencies":{
    "nodemon":"*"
  }
}

文件结构

config.js

module.exports = {
    mysql: {
        host: 'localhost',
        port: 3306,
        database: 'mywebsite',
        username: 'root',
        user:'endingocean',//事务链接取名为user
        password: 'shiping',
        collation: "utf8_unicode_ci",
        debug: true,
        pool: true,
        connectionLimit: 100
    }
};

schema.js

var jugglingdb = require('jugglingdb'),
	Schema = jugglingdb.Schema,
	config=require('../config/config');



exports.schema=function(){
	return new Schema('mysql', config.mysql);
};

Member.js

var schema=require('../utils/schema').schema();


var Member=schema.define('Member',{
	m_ID:{type:String,length:50},
	m_Account:{type:String,length:50},
	m_Pwd:{type:String,length:50},
	m_TEL:{type:String,length:255},
	m_UserID:{type:String,length:50},
	m_ChannelID:{type:String,lengt:50},
	m_Status:{type:Number,default:0},
	m_CreateTime:{ type: Date, dataType: 'datetime',default:Date.now },
	m_UpdateTime:{ type: Date, dataType: 'datetime',default:Date.now }
},{
	table:'t_member'
});


module.exports = schema.models.Member;

router.get('/t',function(req, res,next){
  Member.all({},function(err,result){
    res.send(result);
  });
});