摘要:本篇教程介绍了Node.js教程之使用Node.js的mysql模块连接MySql数据库出现错误,希望阅读本篇文章以后大家有所收获,帮助大家对Node.js的理解更加深入。
本篇教程介绍了Node.js教程之使用Node.js的mysql模块连接MySql数据库出现错误,希望阅读本篇文章以后大家有所收获,帮助大家对Node.js的理解更加深入。
<
C:\Users\horn1\Desktop\node.js\39>node express.js
{ Error: Handshake inactivity timeout
at Handshake.<anonymous> (C:\Users\horn1\Desktop\node.js\39\node_modules\mysql\lib\protocol\Protocol.js:164:17)
at emitNone (events.js:105:13)
at Handshake.emit (events.js:207:7)
at Handshake._onTimeout (C:\Users\horn1\Desktop\node.js\39\node_modules\mysql\lib\protocol\sequences\Sequence.js:129:8)
at ontimeout (timers.js:469:11)
at tryOnTimeout (timers.js:304:5)
at Timer.listOnTimeout (timers.js:264:5)
--------------------
at Protocol._enqueue (C:\Users\horn1\Desktop\node.js\39\node_modules\mysql\lib\protocol\Protocol.js:145:48)
at Protocol.handshake (C:\Users\horn1\Desktop\node.js\39\node_modules\mysql\lib\protocol\Protocol.js:52:23)
at PoolConnection.connect (C:\Users\horn1\Desktop\node.js\39\node_modules\mysql\lib\Connection.js:130:18)
at Pool.getConnection (C:\Users\horn1\Desktop\node.js\39\node_modules\mysql\lib\Pool.js:48:16)
at IncomingMessage.<anonymous> (C:\Users\horn1\Desktop\node.js\39\express.js:29:8)
at emitOne (events.js:115:13)
at IncomingMessage.emit (events.js:210:7)
at IncomingMessage.Readable.read (_stream_readable.js:478:10)
at flow (_stream_readable.js:849:34)
at resume_ (_stream_readable.js:831:3)
code: ‘PROTOCOL_SEQUENCE_TIMEOUT‘,
fatal: true,
timeout: 10000 }
代码如下:
‘use strict‘;
var express=require(‘express‘);
var fs=require(‘fs‘);
var querystring=require(‘querystring‘);
var http=require(‘http‘);
var app=express();
var mysql=require(‘mysql‘);
var pool=mysql.createPool({
host:‘192.168.80.129‘,// 数据库在本地虚拟机上,能用mysql-front连通
port:‘3306‘,
database:‘test‘,
user:‘root‘,
password:‘12345678‘,
timeout:1000000000,
connectTimeout:1000000000,
});
app.get(‘/index.html‘,function(req,res){
res.writeHead(200,{‘Content-type‘:‘text/html‘});
var file=fs.createReadStream(‘index.html‘);
file.pipe(res);
});
app.post(‘/index.html‘,function(req,res){
req.on(‘data‘,function(data){
var obj=querystring.parse(data.toString());
pool.getConnection(function(err,connection){
if(err){
res.send(‘Can not connect to MySql DB‘);
console.log(err);
}else{
var str;
connection.query(‘insert into emp set ?‘,{name:obj.name},function(err,result){
if(err){
str=‘Insert failed‘;
}else{
str="Insert succeed";
}
connection.release();
res.send(str);
})
}
});
});
});
app.listen(3333,"127.0.0.1");
本文由职坐标整理并发布,希望对同学们有所帮助。了解更多详情请关注WEB前端Node.js频道!
您输入的评论内容中包含违禁敏感词
我知道了
请输入正确的手机号码
请输入正确的验证码
您今天的短信下发次数太多了,明天再试试吧!
我们会在第一时间安排职业规划师联系您!
您也可以联系我们的职业规划师咨询:
版权所有 职坐标-一站式IT培训就业服务领导者 沪ICP备13042190号-4
上海海同信息科技有限公司 Copyright ©2015 www.zhizuobiao.com,All Rights Reserved.
沪公网安备 31011502005948号