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

* upgraded to Hibernate 3.3.0 (while retaining compatibility with Hibernate 3.1/3.2) * upgraded to iBATIS SQL Maps 2.3.2 (while retaining compatibility with iBATIS 2.3.0) Package org.springframework replacement values Package org.springframework.beans * revised GenericTypeAwarePropertyDescriptor for compatibility with IBM's JDK 1.6 (avoiding NPE) * TypeMismatchException shows type description for mismatching interfaces) * CustomNumberEditor explicitly removes all inline whitespace from input Strings (for compatibility with French locales) * added "getDescription()" method to BeanDefinition interface (exposing the

Build an executable archive with Ant How to use Java 6 Embedded servlet container compatibility JTA API compatibility 74. Traditional deployment Create a deployable war file Create a deployable war file executable jar file structure The executable war file structure Spring Boot’s “JarFile” class Compatibility with the standard Java “JarFile” Launching executable jars Launcher manifest Exploded archives Changing the Java version The spring-boot-starter-parent chooses fairly conservative Java compatibility. If you want to follow our recommendation and use a later Java version you can add a java.version

Build an executable archive with Ant How to use Java 6 Embedded servlet container compatibility JTA API compatibility 74. Traditional deployment Create a deployable war file Create a deployable war file executable jar file structure The executable war file structure Spring Boot’s “JarFile” class Compatibility with the standard Java “JarFile” Launching executable jars Launcher manifest Exploded archives Changing the Java version The spring-boot-starter-parent chooses fairly conservative Java compatibility. If you want to follow our recommendation and use a later Java version you can add a java.version

Build an executable archive with Ant How to use Java 6 Embedded servlet container compatibility JTA API compatibility 74. Traditional deployment Create a deployable war file Create a deployable war file executable jar file structure The executable war file structure Spring Boot’s “JarFile” class Compatibility with the standard Java “JarFile” Launching executable jars Launcher manifest Exploded archives Changing the Java version The spring-boot-starter-parent chooses fairly conservative Java compatibility. If you want to follow our recommendation and use a later Java version you can add a java.version

Build an executable archive with Ant How to use Java 6 Embedded servlet container compatibility JTA API compatibility 74. Traditional deployment Create a deployable war file Create a deployable war file executable jar file structure The executable war file structure Spring Boot’s “JarFile” class Compatibility with the standard Java “JarFile” Launching executable jars Launcher manifest Exploded archives Changing the Java version The spring-boot-starter-parent chooses fairly conservative Java compatibility. If you want to follow our recommendation and use a later Java version you can add a java.version

Build an executable archive with Ant How to use Java 6 Embedded servlet container compatibility JTA API compatibility 74. Traditional deployment Create a deployable war file Create a deployable war file executable jar file structure The executable war file structure Spring Boot’s “JarFile” class Compatibility with the standard Java “JarFile” Launching executable jars Launcher manifest Exploded archives Changing the Java version The spring-boot-starter-parent chooses fairly conservative Java compatibility. If you want to follow our recommendation and use a later Java version you can add a java.version

(2008-04-28) ------------------------------------- General * upgraded to AspectJ 1.6 (while retaining compatibility with AspectJ 1.5.x) * fixed spring-core.jar's manifest to contain correct OSGi Import-Package PathMatchingResourcePatternResolver resolves encoded jar URIs before creating JarFiles (for WebSphere compatibility) * PathMatchingResourcePatternResolver catches NoClassDefFoundError when looking for presence SimpleMetadataReaderFactory uses ResourceLoader's ClassLoader for loading annotation classes (for OSGi compatibility) Package org.springframework.jdbc * JdbcTemplate explicitly detects and skips null ResultSets

2 (retaining compatibility with AspectJ 1.5.x and 1.6.x) * upgraded to EHCache 1.5.0 (retaining compatibility with EHCache 1.2 and higher) * upgraded to TestNG 5.8 (retaining compatibility with TestNG 5 5.5 and higher) * upgraded to OpenJPA 1.1.0 (retaining compatibility with OpenJPA 1.0.x as well as 1.2.0) * upgraded to EclipseLink 1.0.1 (EclipseLinkJpaVendorAdapter requires EclipseLink 1.0.0+ now) HibernateJpaDialect checks "EntityManager.getDelegate()" as well to find Hibernate Session (for Seam compatibility) * added "persistenceXmlLocation" property to DefaultPersistenceUnitManager, as alternative to