node.js同步mysql查询 [英] node.js sync mysql queries

问题描述

如何在node.js中使用mysql？我想得到这样的东西：

How can I use mysql in node.js ? I want to get something like this:

userData = db.query "SELECT * FROM users WHERE id=1"
form.bind(userData)
res.render 'user/edit', {'form' : form}

b $ b

什么插件？任何例子的代码？

What plugin ? Any examples of code ?

推荐答案

通过标题我认为你的意思是以同步的方式。答案是你不能。这是因为NodeJS是单线程的，并且由于I / O（即与数据库的通信）在单独的线程（由NodeJS内部使用，它不能用于程序员）中处理，I / O的结果被推送到事件循环的顶部。但是NodeJS不能跳到事件循环中的另一个事件，而不会离开当前事件。

By the title I assume that you mean in a synchronous way. The answer is you can't. This is because NodeJS is single-threaded and since I/O (i.e. communication with database) is handled in a separate thread (which is used internally by NodeJS, it is not available for programmers) the result of I/O is pushed to the top of the event loop. But NodeJS can't jump to another event in the event loop without leaving current event.

无论你喜欢还是不喜欢异步模式。

Whether you like it or not you have to stick with asynchronous patterns.

这篇关于node.js同步mysql查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！