var mysql = require("mysql");

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

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

var sqlInsert = "insert into personTable (id,name,gender,age) values (?,?,?,?)";
var sqlValues = [1002,'uiChen','female',26];
connection.query(sqlInsert, sqlValues, function(error,result){
	if (error) {
		console.log("insert error:", error.message);
		return;
	};

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

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