Spring JDBC
Spring 对JDBC技术规范做了进一步封装,它又叫Spring JDBCTemplate(jdbc模板技术)
纯JDBC:代码清晰的、效率最高、代码是最烦的、
Spring JDBCTemplate:代码相对来说就不那么清晰,效率要低一点,代码相对简单
如何进行Spring和jdbc的集合?(数据库的连接池)
(1) 导入jar 包:spring-jdbc.jar 驱动类 连接池 DruidUtil2(框架的原型)
(2) 配置类:@Configuration
(3) @Spring IOC + JDBC 实现
JdbcConfig: a.配置属性 b.配置DataSource Bean
(4) 配置JdbcTemplate Bean @Bean
1.pom.xml 所需要的jar包
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>${spring.version}</version> </dependency> <!-- MySQL数据库连接池 --> <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.48</version> </dependency> <!-- Druid --> <!-- https://mvnrepository.com/artifact/com.alibaba/druid --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.20</version> </dependency>
2. 一个实体类:Account.java
public class Account { private int id; private String name; private Double balance;