## 持久層總圖  ## 概述 JDBCTemplate就是spring提供的dao層用來和數據庫交互的技術.是spring對JDBC+C3P0的封裝. 1. jdbc+c3p0. 2. DBUtils:apache組織提供的對JDBC+C3P0的封裝. 3. hibernate:對JDBC+C3P0的封裝. 4. JDBCTemplate:spring對JDBC+C3P0的封裝. 5. HibernateTemplate:spring對hibernate又封裝一次. 6. MyBatis:對JDBC+C3P0的封裝. 7. SqlMapClientTemplate:spring對MyBatis又封裝一次. ## 步驟 ~~~ <dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>5.0.2.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>5.0.2.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>5.0.2.RELEASE</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.6</version> </dependency> </dependencies> ~~~ ## 快速入門 ~~~ public static void main(String[] args) { //準備數據源,spring內置的數據源 DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUrl("jdbc:mysql://192.168.10.10:3306/jdbc"); dataSource.setUsername("homestead"); dataSource.setPassword("secret"); JdbcTemplate jt = new JdbcTemplate(dataSource); jt.execute("insert into account values (3,'richard',1000)"); } ~~~