nodejs下mysql读取数据库

初次接触nodejs和mysql的使用

写下来记录一下

数据库为test,表为user,结构如下

建立my.js文件

var mysql = require('mysql')
var connection = mysql.createConnection({
	host:'localhost',
	user:'root',
	password:'123',
	database:'test'});
connection.connect();
connection.query('select * from user',function(err,results){
if(err) throw err;
console.log('======start=====');
for(i=0;i<results.length;i++)
	{
		var id = new String(results[i].uid);
		var temp = new String(results[i].name);
		var age = new String(results[i].age);
		console.log(id.toString()+"        "+temp.toString()+"       "+age.toString());
	}

console.log('======end=======');
});

connection.end();

执行

纯粹记录一下，留着