nodejs && mysql
1.下载mysql模块
我下载了淘宝定制的npm安装器,所以安装的命令如下:
cnpm install mysql
2.使用小皮连接数据库
3.node实现数据库数据的增删改查
3.1 增加数据功能
// 2.增加数据
var mysql = require('mysql');
//进行数据的连接
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : 'root',
port: '3306',
database: 'text'
});
connection.connect();
// 这是sql语句
var addSql = 'INSERT INTO websites(Id,name,url,alexa,country) VALUES(0,?,?,?,?)';
// 这是要增加的数据
var addSqlParams = ['菜鸟工具', 'https://c.runoob.com','23453', 'CN'];
//增
connection.query(addSql,addSqlParams,function (err, result) {
if(err){
console.log('[INSERT ERROR] - ',err.message);//
return;
}
console.log('--------------------------INSERT----------------------------');
//console.log('INSERT ID:',result.insertId);
console.log('INSERT ID:',result);
console.log('-----------------------------------------------------------------\n\n');
});
connection.end();//关闭数据库
3.3 删除数据库的数据
// 4.删除数据
var mysql = require('mysql');
var connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'root',
port: '3306',
database: 'text'
});
connection.connect();
var delSql = 'DELETE FROM websites where id=6';
//删
connection.query(delSql, function(err, result) {
if (err) {
console.log('[DELETE ERROR] - ', err.message);
return;
}
console.log('--------------------------DELETE----------------------------');
console.log('DELETE affectedRows', result.affectedRows);
console.log('-----------------------------------------------------------------\n\n');
});
connection.end();
3.3更改数据
// 3.更改数据
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : 'root',
port: '3306',
database: 'text'
});
connection.connect();
var modSql = 'UPDATE websites SET name = ?,url = ? WHERE Id = ?';
var modSqlParams = ['菜鸟移动站', 'https://m.runoob.com',6];
//改
connection.query(modSql,modSqlParams,function (err, result) {
if(err){
console.log('[UPDATE ERROR] - ',err.message);
return;
}
console.log('--------------------------UPDATE----------------------------');
console.log('UPDATE affectedRows',result.affectedRows);
console.log('-----------------------------------------------------------------\n\n');
});
connection.end();
3.4查询数据
// 1.查询数据库的内容
// 引入mysql模块
var mysql = require('mysql');
// 定义数据库的连接
var connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'root',
port: '3306',
database: 'text'
});
// 进行数据库的连接
connection.connect();
var sql = 'SELECT * FROM websites';
//查
connection.query(sql, function(err, result) {//执行数据库的操作
if (err) {
console.log('[SELECT ERROR] - ', err.message);
return;
}
若
console.log('--------------------------SELECT----------------------------');
console.log(result);
console.log('------------------------------------------------------------\n\n');
});
connection.end();//关闭数据库