[Spring]Druid连接池+JdbcTemplate增删改查+批量增删改查

---

JdbcTemplate

1 什么是JdbcTemplate
1.1 Spring框架对JDBD进行封装,使用JdbcTemplate方便实现对数据库操作
1.2 引入maven坐标
1.3 application.xml 数据库连接池Druid配置
1.4 application.xml 配置JdbcTemplate对象,注入DataSource
1.5 pojo类Book–BookDao接口–BookDaoImpl(注入jdbctemplate对象)–BookService(注入BookDaoImpl对象)

---

实现功能

• 增删改查
• 批量增删改查

编码步骤
1 创建项目目录;配置application.xml或者配置类
1.1 application.xml
复制约束–开启包扫描–开启注释–druild数据连接池注册–jdbc注册

• 注意
  druid的dataSource路径: com.alibaba.druid.pool.DruidDataSource
  driver的路径: com.mysql.jdbc.Driver
  jdbc的路径: org.springframework.jdbc.core.JdbcTemplate

2 entity类(此处我命名为pojo差不多)–dao类–service类–test类 使用注解开发(ioc)部分
编写pojo类 多写了bind()和parse()； 注解编程了多例模式 @Scope(“prototype”)
编写Dao接口和DaoImpl – 编写Service – test类调用

pom.xml

   <dependencies>
      <!--  此处引入坐标添加依赖  -->
      <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
      </dependency>


      <!--数据库连接池-->
      <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.2.9</version>
      </dependency>
      <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.47</version>
      </dependency>




      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>5.3.16</version>
      </dependency>

      <dependency>
        <groupId>org.testng</groupId>
        <artifactId>testng</artifactId>
        <version>RELEASE</version>
        <scope>compile</scope>
      </dependency>

      <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-nop</artifactId>
        <version>1.7.2</version>
        <type>jar</type>
      </dependency>

      <dependency>
        <groupId>javax.annotation</groupId>
        <artifactId>javax.annotation-api</artifactId>
        <version>1.3.2</version>
      </dependency>

      <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>1.8.13</version>
      </dependency>

      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>5.3.15</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>5.3.15</version>
      </dependency>

      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>5.1.7.RELEASE</version>
      </dependency>

    </dependencies>

application.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns="http://www.springframewor