webstorm 连接mysql

来源:互联网 发布:matlab非线性最优化 编辑:程序博客网 时间:2024/06/08 08:07
var mysql=require('mysql');var options={    url:'localhost',    port:'3306',    database:'school',    user:'root',    password:'123456'};var client=mysql.createConnection(options);var age=50;try{    client.query('select * from student',function(err,result,fields){        if(err){            //一定去处理            console.log('内部'+err.message);        }for(var i=0;i<result.length;i++){            console.log(result[i].sname);        }    });}catch (e){    console.log('外部'+e.message);}finally{    client.end(function(){        console.log('client is closed')    });}//销毁连接//client.destroy();
0 0