# mysql
[![NPM Version][npm-version-image]][npm-url]
[![NPM Downloads][npm-downloads-image]][npm-url]
[![Node.js Version][node-image]][node-url]
[![Linux Build][travis-image]][travis-url]
[![Windows Build][appveyor-image]][appveyor-url]
[![Test Coverage][coveralls-image]][coveralls-url]
## Table of Contents
- [Install](#install)
- [Introduction](#introduction)
- [Contributors](#contributors)
- [Sponsors](#sponsors)
- [Community](#community)
- [Establishing connections](#establishing-connections)
- [Connection options](#connection-options)
- [SSL options](#ssl-options)
- [Terminating connections](#terminating-connections)
- [Pooling connections](#pooling-connections)
- [Pool options](#pool-options)
- [Pool events](#pool-events)
- [Closing all the connections in a pool](#closing-all-the-connections-in-a-pool)
- [PoolCluster](#poolcluster)
- [PoolCluster options](#poolcluster-options)
- [Switching users and altering connection state](#switching-users-and-altering-connection-state)
- [Server disconnects](#server-disconnects)
- [Performing queries](#performing-queries)
- [Escaping query values](#escaping-query-values)
- [Escaping query identifiers](#escaping-query-identifiers)
- [Preparing Queries](#preparing-queries)
- [Custom format](#custom-format)
- [Getting the id of an inserted row](#getting-the-id-of-an-inserted-row)
- [Getting the number of affected rows](#getting-the-number-of-affected-rows)
- [Getting the number of changed rows](#getting-the-number-of-changed-rows)
- [Getting the connection ID](#getting-the-connection-id)
- [Executing queries in parallel](#executing-queries-in-parallel)
- [Streaming query rows](#streaming-query-rows)
- [Piping results with Streams](#piping-results-with-streams)
- [Multiple statement queries](#multiple-statement-queries)
- [Stored procedures](#stored-procedures)
- [Joins with overlapping column names](#joins-with-overlapping-column-names)
- [Transactions](#transactions)
- [Ping](#ping)
- [Timeouts](#timeouts)
- [Error handling](#error-handling)
- [Exception Safety](#exception-safety)
- [Type casting](#type-casting)
- [Connection Flags](#connection-flags)
- [Debugging and reporting problems](#debugging-and-reporting-problems)
- [Security issues](#security-issues)
- [Contributing](#contributing)
- [Running tests](#running-tests)
- [Todo](#todo)
## Install
This is a [Node.js](https://nodejs.org/en/) module available through the
[npm registry](https://www.npmjs.com/).
Before installing, [download and install Node.js](https://nodejs.org/en/download/).
Node.js 0.6 or higher is required.
Installation is done using the
[`npm install` command](https://docs.npmjs.com/getting-started/installing-npm-packages-locally):
```sh
$ npm install mysql
```
For information about the previous 0.9.x releases, visit the [v0.9 branch][].
Sometimes I may also ask you to install the latest version from Github to check
if a bugfix is working. In this case, please do:
```sh
$ npm install mysqljs/mysql
```
[v0.9 branch]: https://github.com/mysqljs/mysql/tree/v0.9
## Introduction
This is a node.js driver for mysql. It is written in JavaScript, does not
require compiling, and is 100% MIT licensed.
Here is an example on how to use it:
```js
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'me',
password : 'secret',
database : 'my_db'
});
connection.connect();
connection.query('SELECT 1 + 1 AS solution', function (error, results, fields) {
if (error) throw error;
console.log('The solution is: ', results[0].solution);
});
connection.end();
```
From this example, you can learn the following:
* Every method you invoke on a connection is queued and executed in sequence.
* Closing the connection is done using `end()` which makes sure all remaining
queries are executed before sending a quit packet to the mysql server.
## Contributors
Thanks goes to the people who have contributed code to this module, see the
[GitHub Contributors page][].
[GitHub Contributors page]: https://github.com/mysqljs/mysql/graphs/contributors
Additionally I'd like to thank the following people:
* [Andrey Hristov][] (Oracle) - for helping me with protocol questions.
* [Ulf Wendel][] (Oracle) - for helping me with protocol questions.
[Ulf Wendel]: http://blog.ulf-wendel.de/
[Andrey Hristov]: http://andrey.hristov.com/
## Sponsors
The following companies have supported this project financially, allowing me to
spend more time on it (ordered by time of contribution):
* [Transloadit](http://transloadit.com) (my startup, we do file uploading &
video encoding as a service, check it out)
* [Joyent](http://www.joyent.com/)
* [pinkbike.com](http://pinkbike.com/)
* [Holiday Extras](http://www.holidayextras.co.uk/) (they are [hiring](http://join.holidayextras.co.uk/))
* [Newscope](http://newscope.com/) (they are [hiring](https://newscope.com/unternehmen/jobs/))
## Community
If you'd like to discuss this module, or ask questions about it, please use one
of the following:
* **Mailing list**: https://groups.google.com/forum/#!forum/node-mysql
* **IRC Channel**: #node.js (on freenode.net, I pay attention to any message
including the term `mysql`)
## Establishing connections
The recommended way to establish a connection is this:
```js
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'example.org',
user : 'bob',
password : 'secret'
});
connection.connect(function(err) {
if (err) {
console.error('error connecting: ' + err.stack);
return;
}
console.log('connected as id ' + connection.threadId);
});
```
However, a connection can also be implicitly established by invoking a query:
```js
var mysql = require('mysql');
var connection = mysql.createConnection(...);
connection.query('SELECT 1', function (error, results, fields) {
if (error) throw error;
// connected!
});
```
Depending on how you like to handle your errors, either method may be
appropriate. Any type of connection error (handshake or network) is considered
a fatal error, see the [Error Handling](#error-handling) section for more
information.
## Connection options
When establishing a connection, you can set the following options:
* `host`: The hostname of the database you are connecting to. (Default:
`localhost`)
* `port`: The port number to connect to. (Default: `3306`)
* `localAddress`: The source IP address to use for TCP connection. (Optional)
* `socketPath`: The path to a unix domain socket to connect to. When used `host`
and `port` are ignored.
* `user`: The MySQL user to authenticate as.
* `password`: The password of that MySQL user.
* `database`: Name of the database to use for this connection (Optional).
* `charset`: The charset for the connection. This is called "collation" in the SQL-level
of MySQL (like `utf8_general_ci`). If a SQL-level charset is specified (like `utf8mb4`)
then the default collation for that charset is used. (Default: `'UTF8_GENERAL_CI'`)
* `timezone`: The timezone configured on the MySQL server. This is used to type cast server date/time values to JavaScript `Date` object and vice versa. This can be `'local'`, `'Z'`, or an offset in the form `+HH:MM` or `-HH:MM`. (Default: `'local'`)
* `connectTimeout`: The milliseconds before a timeout occurs during the initial connection
to the MySQL server. (Default: `10000`)
* `stringifyObjects`: Stringify objects instead of converting to values. See
issue [#501](https://github.com/mysqljs/mysql/issues/501). (Default: `false`)
* `insecureAuth`: Allow connecting to MySQL instances that ask for the old
(insecure) authentication method. (Default: `false`)
* `typeCast`: Determines if column values should be converted to native
JavaScript types. (Default: `true`)
* `queryFormat`: A custom query format function. See [Custom format](#custom-format).
* `supportBigNumbers`: When dealing with big numbers (BIGINT and DECIMAL columns) in the database,
you should enable this
没有合适的资源?快使用搜索试试~ 我知道了~
基于以太坊平台的笔记管理系统
共1339个文件
js:615个
md:147个
html:126个
需积分: 10 17 下载量 8 浏览量
2019-06-24
17:15:55
上传
评论 5
收藏 7.32MB ZIP 举报
温馨提示
结合了区块链技术的特点,设计了一个笔记管理系统。主要实现了两大功能:1.通过手机客户端实现以太坊账户的查询、创建以及转账功能。2.用户可通过客户端对笔记进行增删改查,每次操作将被记录到以太坊区块链上。客户端采用基于Android系统的手机客户端,服务器端采用node.js设计,启动方式为npm start。区块链采用geth客户端,数据库使用的是mysql5.7。 代码中包含了服务端代码和客户端代码,供学习者参考。
资源推荐
资源详情
资源评论
收起资源包目录
基于以太坊平台的笔记管理系统 (1339个子文件)
resources.ap_ 402KB
ClientApp.apk 1.02MB
bootstrap 207B
.bowerrc 64B
jarlist.cache 365B
R$styleable.class 16KB
R$styleable.class 15KB
R$style.class 15KB
R$style.class 15KB
R$attr.class 7KB
R$attr.class 7KB
MyNote.class 5KB
LoginActivity.class 5KB
NoteShow.class 5KB
CreateNote.class 5KB
R$id.class 4KB
Transfer.class 4KB
NoteShow$UpdateThread.class 4KB
CreateNote$MyThread.class 4KB
R$color.class 3KB
R$color.class 3KB
MyAccount.class 3KB
R$drawable.class 3KB
R$drawable.class 3KB
AccountsListAdapter.class 3KB
R$dimen.class 3KB
CreateAccount.class 3KB
R$dimen.class 3KB
R$id.class 3KB
PostService.class 3KB
Transfer$MyThread.class 2KB
NoteShow$VerifyThread.class 2KB
NotesListAdapter.class 2KB
MyNote$MyThread.class 2KB
LoginActivity$MyThread.class 2KB
GetService.class 2KB
MyAccount$MyThread.class 2KB
CreateAccount$MyThread.class 2KB
NoteShow$1.class 2KB
MyNote$1.class 2KB
MyNote$2.class 2KB
R$layout.class 2KB
MyNote$DeleteThread.class 2KB
R$layout.class 2KB
MyAccount$1.class 2KB
CreateAccount$1.class 1KB
CreateAccount$2.class 1KB
LoginActivity$1.class 1KB
R$string.class 1KB
R$string.class 1KB
Transfer$1.class 1KB
CreateNote$1.class 1KB
R.class 1015B
R.class 966B
R$bool.class 758B
R$bool.class 737B
R$anim.class 629B
AccountsListAdapter$ViewHolder.class 620B
R$anim.class 608B
VerifyBean$SQLInfo.class 608B
NotesBean$NoteInfo.class 588B
NotesListAdapter$ViewHolder.class 586B
AccountsBean$AccountInfo.class 559B
VerifyBean.class 541B
LoginBean$LoginInfo.class 532B
AccountsBean.class 519B
NotesBean.class 492B
LoginBean.class 450B
R$integer.class 445B
R$integer.class 424B
MainAvtivity.class 423B
R$menu.class 397B
BuildConfig.class 351B
TransferBean.class 351B
.classpath 475B
mime.cmd 170B
server.coffee 3KB
wangEditor.css 17KB
wangEditor.min.css 15KB
iphone.css 5KB
base.css 5KB
stakelist.css 3KB
stake.css 3KB
login.css 3KB
register.css 2KB
index.css 2KB
test.css 1KB
prettify.css 676B
common.css 282B
classes.dex 2.43MB
.DS_Store 12KB
.DS_Store 6KB
.DS_Store 6KB
.DS_Store 6KB
.DS_Store 6KB
.DS_Store 6KB
.DS_Store 6KB
.DS_Store 6KB
.DS_Store 6KB
.DS_Store 6KB
共 1339 条
- 1
- 2
- 3
- 4
- 5
- 6
- 14
资源评论
程序-源
- 粉丝: 25
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功