nodejs mysql前后端数据_如何用nodejs操作MySql数据？

转载自品略图书馆 http://www.pinlue.com/article/2019/12/2423/469854736040.html

如何用nodejs操作MySql数据呢？

其实写法还是简单的：

1.开始在你的node项目中 npm install mysql --save

2.在你的新建项目中 引入代码

//引入数据库var mysql=require("mysql");//实现本地链接var connection = mysql.createConnection({ host: "localhost", user: "yf", password: "123456", database: "yf"})

最好不好是用root 会产生冲突

3. 之后就是增删改查啦，附上代码

查询

// 查找function select() { connection.connect(function (err) { if (err) { console.error("error connecting:" + err.stack) } console.log("connected as id " + connection.threadId); }) connection.query("SELECT * FROM demo", function (error, results, fields) { if (error) throw error; console.log("The solution is:", results); }); connection.end();}

添加

//添加function add() { let post = { id: 1, name: "Hello MySql", age: 20, time: Date.now(), temp: "deom" }; let query = connection.query("INSERT INTO demo SET ?", post, function (error, results, fields) { if (error) throw error; }) console.log(query.sql); //INSERT INTO posts "id"=1, "title"="Hello MySQL"}

修改

//修改function updeate() { connection.connect(function (err) { if (err) { console.error("error connecting:" + err.stack); } console.log("connected as id " + connection.threadId); }); connection.query("UPDATE demo SET name=?where id?", ["update", 1], function (error, results, fields) { if (error) throw error; console.log("changed:" + results.changeRows + "rows"); }); connection.end();}

删除

//删除function deletes() { connection.connect(function (err) { if (err) { console.error("error connecting:" + err.stack); return; } connection.query("DELETE FROM demo SET where id=?", [ 1], function (error, results, fields) { if (error) throw error; console.log("deleted:" + results.affectedRows + "rows"); }); console.log("connected as id " + connection.threadId); connection.end(); });}

是不是很简单啊，只要在你需要的地方添加方法名和对应的参数 ，就可以了