node.js的mysql连接一：直接连数据库的增删改查

最新推荐文章于 2024-07-26 15:36:22 发布

enjoy_sun_moon

最新推荐文章于 2024-07-26 15:36:22 发布

阅读量339

点赞数

分类专栏： node

本文链接：https://blog.csdn.net/enjoy_sun_moon/article/details/80482905

版权

node 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

var mysql = require("mysql");//mysql是需要npm安装的
var connection= mysql.createConnection({
  host:'localhost',
  user:'root',
  password:'mysql',
  database:'cms',
  port:'3306',
})
connection.connect(function(err){
  if(err){
    console.log("mysql connect:"+err)
    return;
  }
  console.log("mysql connect链接成功")
})
//增
var userAddSql = "insert into wp_user(nickname,mobile) values(?,?)";
var param = ['tom','18201262635'];
connection.query(userAddSql,param,function(err,res){
  if(err){
      console.log("错误是"+err.message)
  }else{
      console.log(res)
  }
})
// 查
var select  =  "select nickname,mobile from wp_user";
connection.query(select,function(err,res){
  if(err){
      console.log("错误是"+err.message)
      return;
  }
  console.log(res)
})
// 改
var update  =  "update wp_user set nickname=?,mobile=? where uid=2";
var param = ['bob','13492458551'];
connection.query(update,param,function(err,res){
  if(err){
      console.log("错误是"+err.message)
      return;
  }
  console.log(res)
})
// 删
var select  =  "delete from wp_user where uid = 5";
connection.query(select,function(err,res){
  if(err){
      console.log("错误是"+err.message)
      return;
  }
  console.log(res)
})