nodjs jugglingdb orm框架的使用

来源：互联网发布：签名设计软件免费版编辑：程序博客网时间：2024/06/11 04:53

首先配置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);  });});

0 0