nodejs原始连接mysql 古城微笑少年丶 2022-09-09 04:59 129阅读 0赞 连接支持:cmd运行 > npm install mysql ![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5pyI55av_size_20_color_FFFFFF_t_70_g_se_x_16][] mysql.js var mysql = require('mysql');//导入mysql //建立一个connection var connection = mysql.createConnection({ host:'******', //主机 user:'********', //用户名 password:'********', //密码 database:'users', //数据库名字 port:'70115' //端口号 }); //创建一个connection connection.connect(function(err){ if(err){ console.log('[query] - :'+err); return; } console.log('[connection connect] succeed!'); }); //关闭connection connection.end(function(err){ if(err){ console.log(err.toString()); return; } console.log('[connection end] succeed!'); }); 运行项目: ![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5pyI55av_size_20_color_FFFFFF_t_70_g_se_x_16 1][] 插入和查询: var mysql = require('mysql');//导入mysql //建立一个connection var connection = mysql.createConnection({ host:'*.*.89.198', //主机 user:'####', //用户名 password:'#####', //密码 database:'users', //数据库名字 port:'70115' //端口号 }); //创建一个connection connection.connect(function(err){ if(err){ console.log('[query] - :'+err); return; } console.log('[connection connect] succeed!'); }); //数据的插入 var userAddSql='insert into users(uname,pwd) values (?,?)'; //要插入的用户名和密码 var param = ['htt','123']; connection.query(userAddSql,param,function(err,rs){ if(err){ console.log('insert err:',err,message); return; } console.log('insert success'); }); //执行查询rs查询结果,[2]传进sql的参数 connection.query('SELECT * from users where uid=?',[2],function(err,rs){ if(err){ console.log('[query] - :'+err); return; } console.log('The solution is:',rs[0].uname); }); //关闭connection connection.end(function(err){ if(err){ console.log(err.toString()); return; } console.log('[connection end] succeed!'); }); [watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5pyI55av_size_20_color_FFFFFF_t_70_g_se_x_16]: /images/20220829/f0265cdb803e439199e4d8960bddaebc.png [watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5pyI55av_size_20_color_FFFFFF_t_70_g_se_x_16 1]: /images/20220829/1c86b3bf2ace48ba9101f8f193d4d75e.png
还没有评论,来说两句吧...