9.2JavaEE——JDBCTemplate的常用方法（一）excute()方法

execute()方法用于执行SQL语句，其语法格式如下：

jdTemplate.execute("SQL 语句");

下面以创建数据表的SQL语句为例，来演示excute()方法的使用，具体步骤如下。

1、创建数据库

        在MySQL中，创建一个名为spring的数据库。 

mysql> create database spring;
Query OK, 1 row affected (0.02 sec)mysql> use spring;
Database changed
mysql> show tables;
Empty set (0.01 sec)

2、创建项目并引入依赖

        在IDEA中创建一个名为chapter09的Maven项目，然后在pom.xml文件中加载使用到的Spring 基础包、Spring依赖包、MySQL数据库的驱动JAR包、Spring JDBC的JAR包和Spring事务处理的JAR包。

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0http://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>com.itheima</groupId><artifactId>chapter09</artifactId><version>1.0-SNAPSHOT</version><dependencies><dependency><groupId>org.springframework</groupId><artifactId>spring-core</artifactId><version>5.2.8.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-beans</artifactId><version>5.2.8.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-aop</artifactId><version>5.2.8.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>5.2.8.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-expression</artifactId><version>5.2.8.RELEASE</version></dependency><dependency><groupId>commons-logging</groupId><artifactId>commons-logging</artifactId><version>1.2</version></dependency><!-- jdbc包 --><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>5.2.10.RELEASE</version></dependency><!-- spring-tx包 --><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId><version>5.2.10.RELEASE</version></dependency><!-- MySQL数据库驱动 --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.11</version><scope>runtime</scope></dependency><!-- aspectjweaver依赖 --><dependency><groupId>org.aspectj</groupId><artifactId>aspectjweaver</artifactId><version>1.9.6</version><scope>runtime</scope></dependency><!-- aopalliance依赖包 --><dependency><groupId>aopalliance</groupId><artifactId>aopalliance</artifactId><version>1.0</version></dependency></dependencies>
</project>

3、编写配置文件

        在chapter09项目的src/main/resources目录下，创建配置文件applicationContext.xml，在该文件中配置数据源Bean和JDBC模板Bean，并将数据源注入到JDBC模板中。

<!-- 1. 配置数据源 -->
<bean id="dataSource" class= "org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName" value="com.mysql.jdbc.Driver" /><property name="url" value="jdbc:mysql://localhost/spring" /><property name="username" value="root" /><property name="password" value="root" /></bean>
<!-- 2. 配置 JDBC 模板 -->
<bean id="jdbcTemplate" 	   class="org.springframework.jdbc.core.JdbcTemplate"><property name="dataSource" ref="dataSource" /></bean>

4、编写测试类

        创建测试类TestJdbcTemplate，在该类的main()方法中获取JdbcTemplate实例，然后调用execute()方法执行创建数据表的SQL语句。 

public class TestJdbcTemplate {public static void main(String[] args) {ApplicationContext applicationContext = newClassPathXmlApplicationContext("applicationContext.xml");JdbcTemplate jdTemplate =(JdbcTemplate) applicationContext.getBean("jdbcTemplate");jdTemplate.execute("create table account(" +"id int primary key auto_increment," +“username varchar(50)," + 	"balance double)");System.out.println("账户表account创建成功！");}
}

5、查看运行结果

        在IDEA中启动TestJdbcTemplate类，再次查询spring数据库。 

mysql> show tables;
Empty set (0.01 sec)mysql> show tables;
+--------------------+
| Tables_in_spring   |
+--------------------+
| account            |
+--------------------+
1 rows in set (0.00 sec)

9.2JavaEE——JDBCTemplate的常用方法（二）update()方法

9.2JavaEE——JDBCTemplate的常用方法（三）query()方法