const mysql = require("mysql");

var conn = mysql.createConnection({

host:"127.0.0.1",

user:'root',

password:'',

database:'jd',

port:3306

});

//2:发送sql

//conn.query("INSERT INTO jd_user VALUES(null,?,?)",['tom','123'],(err,result)=>{

//if(err){

//console.log(err);

//}else{

//console.log(result);

//}

//});

//部门表

//conn.query("INSERT INTO jd_dept VALUES(null,?,?)",['软件部','上海'],(err,result)=>{

//if(err){

//console.log(err);

//}else{

//console.log(result);

//}

//});

 

//雇员表

conn.query("INSERT INTO jd_emp VALUES(null,?,?,now(),?)",['kk',20000,1],(err,result)=>{

if(err){

console.log(err);

}else{

console.log(result);

}

});

 

//3:关闭

conn.end();