Node操作数据库

Node操作MySQL数据库

1，创建数据库的连接

安装MySQL的驱动模块

npm install mysql --save

安装成功后再代码块中引入：

const mysql = require('mysql')；

连接数据库

var connection = mysql.createConnection({    
host: "localhost",    
user: "root",   
 password: "1234567",    
 database: "books"
 });
 connection.connect();  //执行连接操作

操作数据库调的回调函数

connection.query(sql, data, function(error, results, fields) {  
  if (error) throw error;    
  console.log(results);  
         }});

#

增加数据

let sql = 'insert into book set ?'
let data = {       
    id: 6,        
    bookName: '明朝那些事1',        
    bookAutor: '当年明月1',       
    bookCatgory: '文学1',        
    bookDesc: '明朝的历史1'   
   }

修改数据

let sql = 'update book set bookName=?,bookAutor=?,bookCatgory=?,bookDesc=? where id=?';
let data = ["明朝那些事", "当年明月", "文学", "明朝的历史", 6];

查询数据

//查询表中全部的数据
let sql = 'select * from books.book';
let data = null;

//有条件的查询
let sql = 'select * from books.book where id=?';
let data = [5];

数据的删除

let sql = ' delete  from book  where id=?';
let data = [6];