var mysql = require("mysql");

var connection = mysql.createConnection({
	host:'localhost',
	user:'root',
	password:'zsy0123456.',
	port:'3306',
	database:'personDatabase'
});

connection.connect();
console.log("连上数据库");

var sqlUpdate = "update personTable set name=? where id=?";
var sqlValues = ['testLuo',1002];
connection.query(sqlUpdate, sqlValues, function(error,result){
	if (error) {
		console.log("update error:", error.message);
		return;
	};

	console.log("update success:", result);
});

connection.end();
console.log("断开数据库连接");