[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 is oriented point of view, the API is as a set of classes in the java.sql package. To use JDBC with a particular database, we need a JDBC driver for that database. 2 About MySQL database MySQL is a leading open source and running Java programs. Finally, we need the MySQL Connector/J driver. If you are using Netbeans IDE, than you have already the driver at hand. Inside the Projects tab, right click on the Libraries node

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166 7.11.4. Spring Data JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 255 Auto-configured JDBC Tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 257 Auto-configured Data JDBC Tests . . . . . . . . search and analytics engine and Spring Data Elasticsearch spring-boot-starter-data-jdbc Starter for using Spring Data JDBC spring-boot-starter-data-jpa Starter for using Spring Data JPA with Hibernate 22

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167 7.11.4. Spring Data JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 256 Auto-configured JDBC Tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 258 Auto-configured Data JDBC Tests . . . . . . . . search and analytics engine and Spring Data Elasticsearch spring-boot-starter-data-jdbc Starter for using Spring Data JDBC spring-boot-starter-data-jpa Starter for using Spring Data JPA with Hibernate 23

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167 7.11.4. Spring Data JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 256 Auto-configured JDBC Tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 258 Auto-configured Data JDBC Tests . . . . . . . . search and analytics engine and Spring Data Elasticsearch spring-boot-starter-data-jdbc Starter for using Spring Data JDBC spring-boot-starter-data-jpa Starter for using Spring Data JPA with Hibernate 23

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167 7.11.4. Spring Data JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 256 Auto-configured JDBC Tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 258 Auto-configured Data JDBC Tests . . . . . . . . search and analytics engine and Spring Data Elasticsearch spring-boot-starter-data-jdbc Starter for using Spring Data JDBC spring-boot-starter-data-jpa Starter for using Spring Data JPA with Hibernate 23

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 7.11.4. Spring Data JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 253 Auto-configured JDBC Tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 255 Auto-configured Data JDBC Tests . . . . . . . . search and analytics engine and Spring Data Elasticsearch spring-boot-starter-data-jdbc Starter for using Spring Data JDBC spring-boot-starter-data-jpa Starter for using Spring Data JPA with Hibernate 23

163 Auto-configured JDBC Tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166 Auto-configured Data JDBC Tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294 9.1.4. Spring Data JDBC. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . search and analytics engine and Spring Data Elasticsearch spring-boot-starter-data-jdbc Starter for using Spring Data JDBC spring-boot-starter-data-jpa Starter for using Spring Data JPA with Hibernate

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 7.11.4. Spring Data JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 248 Auto-configured JDBC Tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 250 Auto-configured Data JDBC Tests . . . . . . . . search and analytics engine and Spring Data Elasticsearch spring-boot-starter-data-jdbc Starter for using Spring Data JDBC spring-boot-starter-data-jpa Starter for using Spring Data JPA with Hibernate 23

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 7.11.4. Spring Data JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 248 Auto-configured JDBC Tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 250 Auto-configured Data JDBC Tests . . . . . . . . search and analytics engine and Spring Data Elasticsearch spring-boot-starter-data-jdbc Starter for using Spring Data JDBC spring-boot-starter-data-jpa Starter for using Spring Data JPA with Hibernate 23

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 7.11.4. Spring Data JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 248 Auto-configured JDBC Tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 250 Auto-configured Data JDBC Tests . . . . . . . . search and analytics engine and Spring Data Elasticsearch spring-boot-starter-data-jdbc Starter for using Spring Data JDBC spring-boot-starter-data-jpa Starter for using Spring Data JPA with Hibernate 23