Node.js连接数据库总结

女爷i 2022-08-07 04:44 187阅读 0赞

**node.js连接mysql数据库**

在node中输入npm install mysql（注意安装路径）

电脑必须安装mysql数据库（这是前提），创建一个数据库，建立一个表，本教程中用的是nodesmaple，表名是t\_user

新建a.js代码：

var mysql = require('mysql');
    var conn = mysql.createConnection({
        host: 'localhost',
        user: 'root',
        password: '',
        database: 'nodesmaple',
        port: 3306
    });
    conn.connect();
    conn.query('SELECT 1 + 1 AS solution',
    function(err, rows, fields) {
        if (err) throw err;
        console.log('The solution is: ', rows[0].solution)
    });
    conn.end();

运行a.js  node a.js  完成，ok！

[Node.js连接数据库总结][Node.js]，原文：[http://blog.csdn.net/billfeller/article/details/41580413][Node.js]

## 1. 连接MySQL ##

*  mysql:  [https://www.npmjs.org/package/mysql][https_www.npmjs.org_package_mysql]
 *  使用说明： [node.js之mysql包使用说明][node.js_mysql]

## 2. 连接Redis ##

*  redis:  [https://www.npmjs.org/package/redis][https_www.npmjs.org_package_redis]
 *  使用说明： [基于express+redis快速实现实时在线用户数统计][express_redis]

## 3. 连接MongoDB ##

*  mongodb:  [https://www.npmjs.org/package/mongodb][https_www.npmjs.org_package_mongodb]
 *  mongoose:  [https://www.npmjs.org/package/mongoose][https_www.npmjs.org_package_mongoose]
 *  安装说明： [Mongodb入门——安装与配置][Mongodb]
 *  代码： [https://github.com/billfeller/mongodb-demo.git][https_github.com_billfeller_mongodb-demo.git]

## 4. 连接CouchDB ##

*  nano:  [https://www.npmjs.org/package/nano][https_www.npmjs.org_package_nano]

## 5. 参考文章 ##

*  \[Wrox\]Professional Node.js

[Node.js]: http://blog.csdn.net/billfeller/article/details/41580413
[https_www.npmjs.org_package_mysql]: https://www.npmjs.org/package/mysql
[node.js_mysql]: http://blog.csdn.net/billfeller/article/details/41175081
[https_www.npmjs.org_package_redis]: https://www.npmjs.org/package/redis
[express_redis]: http://blog.csdn.net/billfeller/article/details/40960613
[https_www.npmjs.org_package_mongodb]: https://www.npmjs.org/package/mongodb
[https_www.npmjs.org_package_mongoose]: https://www.npmjs.org/package/mongoose
[Mongodb]: http://blog.csdn.net/billfeller/article/details/40904825
[https_github.com_billfeller_mongodb-demo.git]: https://github.com/billfeller/mongodb-demo.git
[https_www.npmjs.org_package_nano]: https://www.npmjs.org/package/nano