首先安装npm模块项目npminitinstallmysqlnpminstallmysql--saveNodejsconnectmsyql//importmysqlconstmysql=require('mysql');//connectmysqlconstconnection=mysql.createConnection({host:'127.0.0.1',user:'root',password:'password',port:'3306',database:'test'});connection.connect();//结束连接connection.end();add//引入mysqlconstmysql=require('mysql');//连接myqlconstconnection=mysql.createConnection({host:'127.0.0.1',user:'root',password:'password',port:'3306',database:'test',});connection.connect();//插入语句letaddSql="insertintoarticle(title,author,date)values(?,?,now())";letaddSqlParams=['Todayisnoce','Bob'];//执行插入语句connection.query(addSql,addSqlParams,(err,result)=>{if(err){throwerr;}//插入成功输出console.log('插入成功');console.log(result);});//断开msyqlconnection.end();删除//引入mysqlconstmysql=require('mysql');//连接mysqlconstconnection=mysql.createConnection({host:'127.0.0.1',user:'root',password:'password',port:'3306',database:'test'});connection.connect();//删除语句letsql="deletefromarticlewhereid=10";//执行删除语句connection.query(sql,(err,data)=>{if(err){throwerr;}//执行成功console.log('deletesuccess!');console.log(data);});//断开msyqlconnection.end();Change//导入mysqlconstmysql=require('mysql');//连接mysqlconstconnection=mysql.createConnection({host:'127.0.0.1',user:'root',password:'password',port:'3306',database:'test'});connection.connect();//更新语句letmodSql="updatearticlesettitle=?,author=?whereidlike?";letmodSqlParams=['今晚学习nodejs','everywave',12];//执行更新语句connection.query(modSql,modSqlParams,(err,data)=>{if(err){throwerr;}console.log('上传成功！');console.log(data)});connection.end();检查//importmysqlconstmysql=require('mysql');//连接mysqlconstconnection=mysql.createConnection({host:'127.0.0.1',user:'root',password:'password',port:'3306',database:'test',});connection.connect();//查询语句letsql='SELECT*FROMarticle';//执行查询语句connection.query(sql,(err,data)=>{if(err){console.log('[SELECTERROR]-',err.message);return;}//查询成功console.log(data);});connection.end();
