mysql数据库的第二个q1wery出错

x6yk4ghg  于 2021-06-21  发布在  Mysql
关注(0)|答案(1)|浏览(238)

当我在启动服务器后发送第一个请求时，一切正常。但是在更新页面（重新查询）后，您会收到一个错误：

  1. app.get('/images', function(req, res, next) {
  3.  if (connection.state === 'disconnected'){
  4.     connection.connect();}
  5.         else {
  7.     }
  8.             var DATABASE='nodejsImage';
  9.             var results;
  10.             connection.query('use ' + DATABASE);
  11.             connection.query('SELECT `id`, `imagename`, `filename`, `speed`, `move` FROM `images` WHERE 1',
  12.                 function (err, results, fields) {
  13.                     if (err) return console.log("Error test")  //throw err;
  14.                     else {
  15.                         console.log('Images list');
  16.                         console.log('----------------------------------');
  17.                         for (var i in results) {
  18.                             var gadget = results[i];
  19.                             console.log(gadget.id +': '+ gadget.imagename+': '+gadget.speed+': '+gadget.move);
  21.                         }
  22.                         res.render('imagelist', { title: 'Imagelist',listImages:results });
  23.                     }
  24.                 });
  26.             connection.end();           //разобраться с ошибкой позже!!!
  27.         });

错误消息：
events.js:165抛出器；//未处理的“错误”事件^

  1. Error: Cannot enqueue Handshake after invoking quit.
  2.     at Protocol._validateEnqueue (E:\Dropbox\untitled5-upload-3\untitled5\node_modules\mysql\lib\protocol\Protocol.js:204:16)
  3.     at Protocol._enqueue (E:\Dropbox\untitled5-upload-3\untitled5\node_modules\mysql\lib\protocol\Protocol.js:139:13)
  4.     at Protocol.handshake (E:\Dropbox\untitled5-upload-3\untitled5\node_modules\mysql\lib\protocol\Protocol.js:52:23)
  5.     at Connection.connect (E:\Dropbox\untitled5-upload-3\untitled5\node_modules\mysql\lib\Connection.js:118:18)
  6.     at E:\Dropbox\untitled5-upload-3\untitled5\app.js:48:16
  7.     at Layer.handle [as handle_request] (E:\Dropbox\untitled5-upload-3\untitled5\node_modules\express\lib\router\layer.js:95:5)
  8.     at next (E:\Dropbox\untitled5-upload-3\untitled5\node_modules\express\lib\router\route.js:137:13)
  9.     at Route.dispatch (E:\Dropbox\untitled5-upload-3\untitled5\node_modules\express\lib\router\route.js:112:3)
  10.     at Layer.handle [as handle_request] (E:\Dropbox\untitled5-upload-3\untitled5\node_modules\express\lib\router\layer.js:95:5)
  11.     at E:\Dropbox\untitled5-upload-3\untitled5\node_modules\express\lib\router\index.js:281:22
  12. Emitted 'error' event at:
  13.     at Connection._handleProtocolError (E:\Dropbox\untitled5-upload-3\untitled5\node_modules\mysql\lib\Connection.js:425:8)
  14.     at Protocol.emit (events.js:180:13)
  15.     at Protocol._delegateError (E:\Dropbox\untitled5-upload-3\untitled5\node_modules\mysql\lib\protocol\Protocol.js:392:10)
  16.     at Handshake.<anonymous> (E:\Dropbox\untitled5-upload-3\untitled5\node_modules\mysql\lib\protocol\Protocol.js:221:10)
  17.     at Handshake.emit (events.js:180:13)
  18.     at Handshake.Sequence.end (E:\Dropbox\untitled5-upload-3\untitled5\node_modules\mysql\lib\protocol\sequences\Sequence.js:83:12)
  19.     at E:\Dropbox\untitled5-upload-3\untitled5\node_modules\mysql\lib\protocol\Protocol.js:225:14
  20.     at process._tickCallback (internal/process/next_tick.js:112:11)
mysqlnode.jsexpress

1条答案

按热度按时间
hmtdttj4

hmtdttj41#

这是一个简单的方法来添加通行证项目，以查看。

  1. var imageList = [];
  3.         // Connect to MySQL database.
  4.         var connection = getMySQLConnection();
  5.         connection.connect();
  7.         // Do the query to get data.
  8.         connection.query('SELECT * FROM images', function(err, rows, fields) {
  9.             if (err) {
  10.                 res.status(500).json({"status_code": 500,"status_message": "internal server error"});
  11.             } else {
  12.                 // Loop check on each row
  13.                 for (var i = 0; i < rows.length; i++) {
  15.                     // Create an object to save current row's data
  16.                     var person = {
  17.                         'id':rows[i].id,
  18.                         'imagename':rows[i].imagename,
  19.                         'filename':rows[i].filename,
  20.                         'speed':rows[i].speed,
  21.                         'move':rows[i].move
  22.                     }
  23.                     // Add object into array
  24.                     imageList.push(person);
  25.                 }
  27.                 // Render index.pug page using array
  28.                 res.render('imagelist', { title: 'Imagelist',listImages:imageList });
  29.             }
  30.         });
  32.         // Close the MySQL connection
  33.         connection.end();
展开查看全部
赞(0）分享  回复(0）举报  2021-06-21
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com