24.Node-连接MySQL

题记

        node.js连接mysql

安装驱动

        npm install mysql

连接数据库 

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : '123456',
  database : 'test'
});
 
connection.connect();
 
connection.query('SELECT 1 + 1 AS solution', function (error, results, fields) {
  if (error) throw error;
  console.log('The solution is: ', results[0].solution);
});

查询数据 

var mysql  = require('mysql');  
 
var connection = mysql.createConnection({     
  host     : 'localhost',       
  user     : 'root',              
  password : '123456',       
  port: '3306',                   
  database: 'test' 
}); 
 
connection.connect();
 
var  sql = 'SELECT * FROM websites';
//查询
connection.query(sql,function (err, result) {
        if(err){
          console.log('[查询错误] - ',err.message);
          return;
        }
 
       console.log('--------------------------查询----------------------------');
       console.log(result);
       console.log('------------------------------------------------------------\n\n');  
});
 
connection.end();

增加数据 

var mysql  = require('mysql');  
 
var connection = mysql.createConnection({     
  host     : 'localhost',       
  user     : 'root',              
  password : '123456',       
  port: '3306',                   
  database: 'test' 
}); 
 
connection.connect();
 
var  addSql = 'INSERT INTO websites(Id,name,url,alexa,country) VALUES(0,?,?,?,?)';
var  addSqlParams = ['ngxe', 'ngxe','99', 'CN'];
//增加
connection.query(addSql,addSqlParams,function (err, result) {
        if(err){
         console.log('[增加错误] - ',err.message);
         return;
        }        
 
       console.log('--------------------------增加----------------------------');
       //console.log('增加ID:',result.insertId);        
       console.log('增加ID:',result);        
       console.log('-----------------------------------------------------------------\n\n');  
});
 
connection.end();

修改数据 

var mysql  = require('mysql');  
 
var connection = mysql.createConnection({     
  host     : 'localhost',       
  user     : 'root',              
  password : '123456',       
  port: '3306',                   
  database: 'test' 
}); 
 
connection.connect();
 
var modSql = 'UPDATE websites SET name = ?,url = ? WHERE Id = ?';
var modSqlParams = ['ng', 'ng',6];
//修改
connection.query(modSql,modSqlParams,function (err, result) {
   if(err){
         console.log('[修改错误] - ',err.message);
         return;
   }        
  console.log('--------------------------修改----------------------------');
  console.log('修改行数',result.affectedRows);
  console.log('-----------------------------------------------------------------\n\n');
});
 
connection.end();

删除数据

var mysql  = require('mysql');  
 
var connection = mysql.createConnection({     
  host     : 'localhost',       
  user     : 'root',              
  password : '123456',       
  port: '3306',                   
  database: 'test' 
}); 
 
connection.connect();
 
var delSql = 'DELETE FROM websites where id=6';
//删除
connection.query(delSql,function (err, result) {
        if(err){
          console.log('[删除错误] - ',err.message);
          return;
        }        
 
       console.log('--------------------------DELETE----------------------------');
       console.log('删除行数',result.affectedRows);
       console.log('-----------------------------------------------------------------\n\n');  
});
 
connection.end();

 后记

        觉得有用可以点赞或收藏！