webstorm 连接mysql

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();