node.js 连接mysql

原创于 2014-09-25 15:56:37 发布 · 221 阅读

CC 4.0 BY-SA版权

本文介绍了一个使用Node.js和Express框架与MySQL数据库进行交互的简单示例。该示例展示了如何设置基本的服务器环境、连接到MySQL数据库并执行查询操作来获取数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

var express = require('express');
var mysql = require('mysql');
var app = express();

app.use(function(req, res, next){
console.log('%s %s', req.method, req.url);
next();
});

var conn = mysql.createConnection({
host:'localhost',
user:'root',
database:'order',
password:'123456',
port:3306,
});

insertSQLString = 'insert into teachers SET id = ?, name = ? , pwd = ?',

selectSQLString = 'select * from teachers',

updateSQLString = "update teachers set NAME='ipone' where ID=4",

deleteSQLString = 'delete from teachers where ID=10';

conn.connect();
app.get('/', function(req, res){

conn.query('SELECT * from user', function(err, rows, fields) {
if (err) throw err;
var data = '';
for(var i = 0; i < rows.length; i++){
data += '' + 'ID:' + rows[i].id + '';
data += '' + 'title:' + rows[i].name + '';
data += '' + 'contents:' + rows[i].password + '';
data += '<hr>';

}
res.send(data);

});
});

app.listen(3000);