1、跨域的问题,需要安装跨域模块
npm install cors
2、app.js导入跨域模块
var cors = require('cors');
app.use(cors());
3、对数据库进行链接配置
新建dbconfig.js文件
const Sequelize = require('sequelize');
const MysqlDB = new Sequelize('dbms','root','178945688',{
host: 'localhost',
port: 3306,
dialect: 'mysql',
pool: {
max: 20,
min: 3,
idle: 10000
}
})
module.exports = MysqlDB;
4、建立模型
//创建bookModel.js
const Sequelize = require('sequelize');
const MysqlDB = require('../config/dbconfig');
const Book = MysqlDB.define('bookInfo',{
id: {
type: Sequelize.INTEGER,
autoIncrement: true, //是不是自增
primar