1.在根目录新建module文件,在文件下新建文件modelhead.js
代码如下:
var Sequelize=require("sequelize") var sequelize = new Sequelize('kameng', 'root', '228151', { host: '127.0.0.1', dialect: 'mysql', pool: { max: 5, min: 0, idle: 10000 }, }); console.log("链接成功"); module.exports = sequelize;
2.在router路由下面的index.js 文件下添加如下代码:
var express = require('express');
var router = express.Router();
var Sequelize=require("sequelize")
var sequelize = require("../module/modelhead")
/* GET home page. */
router.get('/', function(req, res, next) {
var User = sequelize.define('users', {
"id": {type:Sequelize.BIGINT, allowNull: false,primaryKey: true},
"email": {type: Sequelize.STRING, allowNull: false, primaryKey: true}, //代理商代码
"pwd": {type: Sequelize.STRING, allowNull: false}, //代理商名称
"nicheng": {type: Sequelize.STRING, allowNull: false}, //代理商二级域名
"createtime":{type:Sequelize.DATE, allowNull: true},
"updtime":{type:Sequelize.DATE, allowNull: true}
},{
timestamps: false,
//paranoid: true //获取不到id的返回值
});
User.findAll({attributes: ["email","nicheng"],where: {id: 1},raw: true }).then(function(users) {
console.log(users)
})
res.render('index', { title: 'Express' });
});
module.exports = router;
访问3000端口测试成功