[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]

rkspace_Docker/Images$ docker search mysql NAME DESCRIPTION STARS OFFICIAL AUTOMATED mysql MySQL is a widely used, open-source relati [OK] mysql/mysql-server Optimized MySQL Server Docker images. Crea... 41 [OK] xiaodong@ubuntu:~/Workspace_Docker/Images$ docker pull mysql Using default tag: library/mysql …… Run a Container from a Image xiaodong@ubuntu:~/Workspace_Docker$ docker images REPOSITORY TAG IMAGE ID CREATED VIRTUAL SIZE mysql latest

接口才能判断服务是否可用。例如部署了数据库的主备，数据库的主备可能会在某些情况下切换， 73 > Nacos 架构 需要通过服务名对外提供访问，保证当前访问的库是主库。此时的健康检查接口，可能就是⼀个检 查数据库是否是主库的 MYSQL 命令了。 客户端健康检查和服务端健康检查有⼀些不同的关注点。客户端健康检查主要关注客户端上报心跳 的方式、服务端摘除不健康客户端的机制。而服务端健康检查，则关注探测客户端的方式、灵敏度 及 整体功能链路的⼀ 环中。 79 > Nacos 架构 那么这样的扩展性是否是有必要的呢？举⼀个上文提到过的例子，假如要添加⼀种新的健康检查方 式，连接数据库执行⼀条 MySQL 命令，通常的方式是在代码里增加 MySQL 类型的健康检查方法、 构建、测试然后最终发布。但是如果允许用户上传⼀个 jar 包放到 Server 部署目录下的某个位置， Server 就会自动扫描并识别到这张新的 定义集群 在 Nacos 中，集群中主要保存了有关健康检查的⼀些信息和数据：  健康检查类型（HealthCheckType）：使用哪种类型的健康检查方式，目前支持：TCP，HTTP， MySQL；设置为 NONE 可以关闭健康检查。  健康检查端口（HealthCheckPort）：设置用于健康检查的端口。  是否使用实例端口进行健康检查（UseInstancePort）：如果使用实例端口进行健康检查，将会

properties: spring.datasource.url=jdbc:mysql://localhost/test spring.datasource.username=dbuser spring.datasource.password=dbpass spring.datasource.driverClassName=com.mysql.jdbc.Driver See DataSourceProperties so we check for that before doing anything. I.e. if you set spring.datasource.driverClassName=com.mysql.jdbc.Driver then that class has to be loadable. Using JdbcTemplate Spring’s JdbcTemplate and Na jdbc:mysql://${OPENSHIFT_MYSQL_DB_HOST}:${OPENSHIFT_MYSQL_DB_PORT}/ ${OPENSHIFT_APP_NAME} spring.datasource.username: ${OPENSHIFT_MYSQL_DB_USERNAME} spring.datasource.password: ${OPENSHIFT_MYSQL_DB_PASSWORD}

properties: spring.datasource.url=jdbc:mysql://localhost/test spring.datasource.username=dbuser spring.datasource.password=dbpass spring.datasource.driverClassName=com.mysql.jdbc.Driver See DataSourceProperties so we check for that before doing anything. I.e. if you set spring.datasource.driverClassName=com.mysql.jdbc.Driver then that class has to be loadable. 26.2 Using JdbcTemplate Spring’s JdbcTemplate and jdbc:mysql://${OPENSHIFT_MYSQL_DB_HOST}:${OPENSHIFT_MYSQL_DB_PORT}/ ${OPENSHIFT_APP_NAME} spring.datasource.username: ${OPENSHIFT_MYSQL_DB_USERNAME} spring.datasource.password: ${OPENSHIFT_MYSQL_DB_PASSWORD}

properties: spring.datasource.url=jdbc:mysql://localhost/test spring.datasource.username=dbuser spring.datasource.password=dbpass spring.datasource.driverClassName=com.mysql.jdbc.Driver See DataSourceProperties so we check for that before doing anything. I.e. if you set spring.datasource.driverClassName=com.mysql.jdbc.Driver then that class has to be loadable. Using JdbcTemplate Spring’s JdbcTemplate and Na jdbc:mysql://${OPENSHIFT_MYSQL_DB_HOST}:${OPENSHIFT_MYSQL_DB_PORT}/ ${OPENSHIFT_APP_NAME} spring.datasource.username: ${OPENSHIFT_MYSQL_DB_USERNAME} spring.datasource.password: ${OPENSHIFT_MYSQL_DB_PASSWORD}

properties: spring.datasource.url=jdbc:mysql://localhost/test spring.datasource.username=dbuser spring.datasource.password=dbpass spring.datasource.driverClassName=com.mysql.jdbc.Driver See DataSourceProperties so we check for that before doing anything. I.e. if you set spring.datasource.driverClassName=com.mysql.jdbc.Driver then that class has to be loadable. 26.2 Using JdbcTemplate Spring’s JdbcTemplate and jdbc:mysql://${OPENSHIFT_MYSQL_DB_HOST}:${OPENSHIFT_MYSQL_DB_PORT}/ ${OPENSHIFT_APP_NAME} spring.datasource.username: ${OPENSHIFT_MYSQL_DB_USERNAME} spring.datasource.password: ${OPENSHIFT_MYSQL_DB_PASSWORD}

properties: spring.datasource.url=jdbc:mysql://localhost/test spring.datasource.username=dbuser spring.datasource.password=dbpass spring.datasource.driverClassName=com.mysql.jdbc.Driver See DataSourceProperties so we check for that before doing anything. I.e. if you set spring.datasource.driverClassName=com.mysql.jdbc.Driver then that class has to be loadable. 26.2 Using JdbcTemplate Spring’s JdbcTemplate and jdbc:mysql://${OPENSHIFT_MYSQL_DB_HOST}:${OPENSHIFT_MYSQL_DB_PORT}/ ${OPENSHIFT_APP_NAME} spring.datasource.username: ${OPENSHIFT_MYSQL_DB_USERNAME} spring.datasource.password: ${OPENSHIFT_MYSQL_DB_PASSWORD}

properties: spring.datasource.url=jdbc:mysql://localhost/test spring.datasource.username=dbuser spring.datasource.password=dbpass spring.datasource.driverClassName=com.mysql.jdbc.Driver See DataSourceProperties so we check for that before doing anything. I.e. if you set spring.datasource.driverClassName=com.mysql.jdbc.Driver then that class has to be loadable. Using JdbcTemplate Spring’s JdbcTemplate and Na jdbc:mysql://${OPENSHIFT_MYSQL_DB_HOST}:${OPENSHIFT_MYSQL_DB_PORT}/ ${OPENSHIFT_APP_NAME} spring.datasource.username: ${OPENSHIFT_MYSQL_DB_USERNAME} spring.datasource.password: ${OPENSHIFT_MYSQL_DB_PASSWORD}