-
安装并引入mysql
var mysql = require('mysql')
npm install mysql var mysql = require('mysql');
-
创建连接配置
createConnection
var connection = mysql.createConnection({ host: 'localhost', //数据库地址 port: '3306',//端口号 user: 'root',//用户名 password: 'root',//密码 database: 'test'//数据库名称 });
3. 建立连接
connection.connect();
- 查询数据
connection.query(sql,callback(err,result))
var sql = 'SELECT * FROM websites';
var str = '';
connection.query(sql, function(err, result) {
if (err) {
console.log('[SELECT ERROR]:', err.message);
}
str = JSON.stringify(result);
console.log(result);
})
- 添加数据
websites指test数据库下面的websites表格
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);
console.log('-----------------------------------------------------------------\n\n');
})
- 输出数据
app.get('/', function(req, res) {
res.send(str)
})
connection.end();
运行 node app.js
完整代码:
//app.js
var express = require('express');
var mysql = require('mysql');
var app = express();
var connection = mysql.createConnection({
host: 'localhost',
port: '3306',
user: 'root',
password: 'root',
database: 'test'
});
connection.connect();
var sql = 'SELECT * FROM websites';
var str = '';
connection.query(sql, function(err, result) {
if (err) {
console.log('[SELECT ERROR]:', err.message);
}
str = JSON.stringify(result);
console.log(result);
})
app.get('/', function(req, res) {
res.send(str);
})
connection.end();
app.listen(3000, function() {
console.log("server runing at 30000 port")
})
//data.js
var mysql = require('mysql');
var connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'root',
port: '3306',
database: 'test'
})
connection.connect();
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);
console.log('-----------------------------------------------------------------\n\n');
})
over !