nodejs串連MySQL資料庫

標籤：ber   ons   undefined   使用   save   pre   from   string   cti   

在github上搜尋orm2 https://github.com/dresende/node-orm2；

在專案檔夾使用npm install orm下載下來，然後書寫設定檔

var orm = require("orm");orm.connect("mysql://username:[email protected]/database", function (err, db) {  if (err) throw err;    var Person = db.define("person", {        name      : String,        surname   : String,        age       : Number, // FLOAT        male      : Boolean,        continent : [ "Europe", "America", "Asia", "Africa", "Australia", "Antartica" ], // ENUM type        photo     : Buffer, // BLOB/BINARY        data      : Object // JSON encoded    }, {        methods: {            fullName: function () {                return this.name + ‘ ‘ + this.surname;            }        },        validations: {            age: orm.enforce.ranges.number(18, undefined, "under-age")        }    });    // add the table to the database    db.sync(function(err) {        if (err) throw err;        // add a row to the person table        Person.create({ id: 1, name: "John", surname: "Doe", age: 27 }, function(err) {            if (err) throw err;                // query the person table by surname                Person.find({ surname: "Doe" }, function (err, people) {                    // SQL: "SELECT * FROM person WHERE surname = ‘Doe‘"                    if (err) throw err;                    console.log("People found: %d", people.length);                    console.log("First person: %s, age %d", people[0].fullName(), people[0].age);                    people[0].age = 16;                    people[0].save(function (err) {                        // err.msg = "under-age";                });            });        });    });});

具體的配置查看orm在github上的說明文檔

nodejs串連MySQL資料庫