[JavaSE实验] JDBC and MySQL 1 JDBC JDBC is an API for the Java programming language that defines how a client may access a database. It provides methods for querying and updating data in a database. JDBC driver for that database. 2 About MySQL database MySQL is a leading open source database management system. It is a multi user, multithreaded database management system. MySQL is especially popular on the Apache, MySQL, PHP. Currently MySQL is owned by Oracle. MySQL database is available on most important OS platforms. It runs under BSD Unix, Linux, Windows or Mac. Wikipedia and YouTube use MySQL. These

MySQL ZIP Archive版本安装说明 1 系统环境 硬件 Surface Pro 4； 操作系统 Windows 10专业版 16299.19 64bit； MySQL MySQL Community Server 5.7.20，Windows (x86,64bit) ZIP Archive； MySQL安装路径 C:\MySQL，请视自己计算机情况选择安装目录。 2 2 软件下载 MySQL下载地址：https://dev.mysql.com/downloads/mysql/ 下载版本：Windows (x86, 64-bit), ZIP Archive，mysql-5.7.20-winx64.zip 3 软件安装 使用管理员权限打开命令提示符，步骤：开始菜单选择Windows系统 - 命令提示符 - 在其上点击右键选择 - 更多 - 以管 理员身份运行。 理员身份运行。 定位到C盘根目录，创建MySQL目录。 将所下载的MySQL软件压缩包mysql-5.7.20-winx64.zip放在MySQL目录下，并使用解压缩工具（WinRAR等）解压 缩；cd到解压目录内，新建my.ini文件，并将以下内容拷贝到my.ini文件内。 [mysql] # 设置mysql客户端默认字符集 default-character-set=utf8 [mysqld]

MySQL �� ����⼤大 • ��能�������� • ���能������������� • ����������⼤大��Oracle为也� • �����了�不������ • �����都�������� ���DBA��� ��MySQL�� �� id name age gender dept phone 1 �� 25 � ��� 137XXX 2 ��� 135XXX 3 �� 24 � ��� 130XXX 4 多� 25 � ��� 151XXX 2009�����的�Oracle�� 2008����Sun�� �� MySQL AB�� SQL: Structured Query Language Data Definition Language Data Manipulation Language Data Control 24 � ��� 130XXX 4 多� 25 � ��� 151XXX ����⼤大��������������� 3000+⼀一� ��MySQL����� ��� (����) ����phpMyAdmin为 ��� (���) mysql -h127.0.0.1 -P3306 -uroot -p123456 IP���host为 ���Port为 �

development � testing � prodution 3 ��������������������� ���������������������������������� ThinkJS �� mysql � mongodb � sqlite �������������������������� ���� SQL ���������� SQL ������������������������� [HTTP] GET /static/css/reset.css 200 3ms Socket ���� [2015-10-12 14:13:54] [SOCKET] Connect mysql with mysql://root:root@127.0.0.1:3306 ���� [2015-10-12 14:15:32] [Error] Error: ER_ACCESS_DENIED_ERROR: 0.0.1:8360/ [2015-09-21 20:21:09] [THINK] ThinkJS Version: 2.0.0 [2015-09-21 20:21:09] [THINK] Cluster Status: closed [2015-09-21 20:21:09] [THINK] WebSocket Status: closed [2015-09-21 20:21:09] [THINK]

support different requests. You can also custom and extend them in your projects. ThinkJS supports MySQL , MongoDB and SQLite . It encapsulates many APIs of the database operations, without having to manually /static/css/reset.css 200 3ms Socket connection log [2015-10-12 14:13:54] [SOCKET] Connect mysql with mysql://root:root@127.0.0.1:3306 Error log [2015-10-12 14:15:32] [Error] Error: ER_ACCESS_DENIED_ERROR: 0.0.1:8360/ [2015-09-21 20:21:09] [THINK] ThinkJS Version: 2.0.0 [2015-09-21 20:21:09] [THINK] Cluster Status: closed [2015-09-21 20:21:09] [THINK] WebSocket Status: closed [2015-09-21 20:21:09] [THINK]

support different requests. You can also custom and extend them in your projects. ThinkJS supports MySQL , MongoDB and SQLite . It encapsulates many APIs of the database operations, without having to manually /static/css/reset.css 200 3ms Socket connection log [2015-10-12 14:13:54] [SOCKET] Connect mysql with mysql://root:root@127.0.0.1:3306 Error log [2015-10-12 14:15:32] [Error] Error: ER_ACCESS_DENIED_ERROR: 0.0.1:8360/ [2015-09-21 20:21:09] [THINK] ThinkJS Version: 2.0.0 [2015-09-21 20:21:09] [THINK] Cluster Status: closed [2015-09-21 20:21:09] [THINK] WebSocket Status: closed [2015-09-21 20:21:09] [THINK]

testing 和 prodution 3 种项目环境，可以在不同的项目环境下进行 不同的配置，满足在不同环境下的配置需求，同时还可以基于项目需要进行扩展。 支持丰富的数据库 ThinkJS 支持 mysql ， mongodb ， sqlite 等常见的数据库，并且封装了很多操作数据库的接口， 无需手动拼接 SQL 语句，还可以自动防止 SQL 注入等安全漏洞。同时支持事务、关联模型等高级 功能。 [HTTP] GET /static/css/reset.css 200 3ms Socket 连接日志 [2015-10-12 14:13:54] [SOCKET] Connect mysql with mysql://root:root@127.0.0.1:3306 错误日志 [2015-10-12 14:15:32] [Error] Error: ER_ACCESS_DENIED_ERROR: http://127.0.0.1:8360/ [2015-09-21 20:21:09] [THINK] ThinkJS Version: 2.0.0 [2015-09-21 20:21:09] [THINK] Cluster Status: closed [2015-09-21 20:21:09] [THINK] WebSocket Status: closed [2015-09-21 20:21:09] [THINK]

support different requests. You can also custom and extend them in your projects. ThinkJS supports MySQL , MongoDB and SQLite . It encapsulates many APIs of the database operations, without having to manually [2015-10-12 14:10:11] [HTTP] GET /static/css/reset.css 200 3ms [2015-10-12 14:13:54] [SOCKET] Connect mysql with mysql://root:root@127.0.0.1:3306 [2015-10-12 14:15:32] [Error] Error: ER_ACCESS_DENIED_ERROR: Access 0.0.1:8360/ [2015-09-21 20:21:09] [THINK] ThinkJS Version: 2.0.0 [2015-09-21 20:21:09] [THINK] Cluster Status: closed [2015-09-21 20:21:09] [THINK] WebSocket Status: closed [2015-09-21 20:21:09] [THINK]

session 方法。我们支持用 多种方式存储 session，包括：cookie，mysql，file，redis 等。 支持的Session存储方式 cookie Cookie方式 mysql Mysql数据库方式 file 文件方式 redis Redis方式 Mysql session 使用 mysql 类型的 Session 需要创建对应的数据表，可以用下面的 SQL 语句创建 PRIMARY KEY (`id`), UNIQUE KEY `cookie` (`cookie`), KEY `expire` (`expire`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; redis Session 使用 redis 类型的Session需要依赖 think-redis 模块。 如何配置Session 配置文件 Session 类型，具体调用时可以传递参数改写（见“使用 session 方法”一节） * common ：配置通用的一些参数，会跟具体的 Adapter 参数合并 * cookie,file,mysql ：配置特定类型的 Adapter 参数，最终获取到的参数是 common 参数与该参 数进行合并后的结果。我们注意到，在这几个配置里面都有一个 handle 参数。 * handle ：对应类型的处理函数，一般为一个类。

Contrib: Abortable tasks - celery.contrib.abortable Events - celery.events In-memory Representation of Cluster State - celery.events.state App: Worker Node - celery.apps.worker App: Periodic Task Scheduler - Celery takes advantage of AMQPs flexible routing model. Tasks can be routed to specific servers, or a cluster of servers by binding workers to different queues. A single worker node can be bound to one or more those replies. Since there’s no central authority to know how many workers are available in the cluster, there is also no way to estimate how many workers may send a reply, so the client has a configurable