Spring整合JDBC（dbcp，C3P0，Druid，JdbcTemplate ）

客官°小女子只卖身不卖艺 2023-10-12 09:10 33阅读 0赞

### 一、整合数据库连接池dbcp ###

#### **1.导入jar包** ####

<dependency>
          <groupId>commons-dbcp</groupId>
          <artifactId>commons-dbcp</artifactId>
          <version>1.4</version>
        </dependency>
    
        
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>8.0.31</version>
        </dependency>

#### 2.添加配置文件spring.xml ####

#### 3.**配置数据源** ####

<--DBCP连接池配置-->
        <!--<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
            <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"></property>
            <property name="url" value="jdbc:mysql://localhost:3306/ball?serverTimezone=GMT%2B8"></property>
            <property name="username" value="root"></property>
            <property name="password" value="123sa"></property>
            </bean>

#### 4.使用数据库连接池实现原生的jdbc添加用户 ####

@Repository
    public class UserDaoImpl implements UserDao {
        @Autowired
        private BasicDataSource dataSource;
        @Override
        public void aa(User user) {
            Connection connection=null;
            try {
                connection = dataSource.getConnection();
                String sql="insert into user values(null,?,?)";
                PreparedStatement ps = connection.prepareStatement(sql);
                ps.setString(1, user.getName());
                ps.setString(2, user.getPwd());
                ps.executeUpdate();
            } catch (Exception e) {
                System.out.println(e);
            }finally {
                try {
                    connection.close();
                } catch (SQLException e) {
                    throw new RuntimeException(e);
                }
            }
        }
    }

### 二、整合数据库连接池C3P0 ###

#### **1.导入jar包** ####

<dependency>
          <groupId>com.mchange</groupId>
          <artifactId>c3p0</artifactId>
          <version>0.9.5.2</version>
        </dependency>
    
        
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>8.0.31</version>
        </dependency>

#### 2.添加配置文件spring.xml ####

#### 3.**配置数据源** ####

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="driverClass" value="com.mysql.cj.jdbc.Driver"></property>
            <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/ball?serverTimezone=GMT%2B8"></property>
            <property name="user" value="root"></property>
            <property name="password" value="123sa"></property>
        </bean>

#### 4.使用数据库连接池实现原生的jdbc添加用户 ####

@Repository
    public class UserDaoImpl implements UserDao {
        @Autowired
        private ComboPooledDataSource dataSource;
        @Override
        public void aa(User user) {
            Connection connection=null;
            try {
                connection = dataSource.getConnection();
                String sql="insert into user values(null,?,?)";
                PreparedStatement ps = connection.prepareStatement(sql);
                ps.setString(1, user.getName());
                ps.setString(2, user.getPwd());
                ps.executeUpdate();
            } catch (Exception e) {
                System.out.println(e);
            }finally {
                try {
                    connection.close();
                } catch (SQLException e) {
                    throw new RuntimeException(e);
                }
            }
        }
    }

### 三、整合数据库连接池Druid ###

#### **1.导入jar包** ####

<dependency>
          <groupId>com.alibaba</groupId>
          <artifactId>druid</artifactId>
          <version>1.2.15</version>
        </dependency>
    
    
        
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>8.0.31</version>
        </dependency>

#### 2.添加配置文件spring.xml ####

#### 3.**配置数据源** ####

<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
            <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"></property>
            <property name="url" value="jdbc:mysql://localhost:3306/ball?serverTimezone=GMT%2B8"></property>
            <property name="username" value="root"></property>
            <property name="password" value="123sa"></property>
        </bean>

#### 4.使用数据库连接池实现原生的jdbc添加用户 ####

@Repository
    public class UserDaoImpl implements UserDao {
        @Autowired
        private DruidDataSource dataSource;
        @Override
        public void aa(User user) {
            Connection connection=null;
            try {
                connection = dataSource.getConnection();
                String sql="insert into user values(null,?,?)";
                PreparedStatement ps = connection.prepareStatement(sql);
                ps.setString(1, user.getName());
                ps.setString(2, user.getPwd());
                ps.executeUpdate();
            } catch (Exception e) {
                System.out.println(e);
            }finally {
                try {
                    connection.close();
                } catch (SQLException e) {
                    throw new RuntimeException(e);
                }
            }
        }
    }

### 四、整合**spring 内置数据源（**JdbcTemplate**）** ###

#### **1.导入jar包** ####

<dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-jdbc</artifactId>
          <version>5.3.24</version>
        </dependency>
    
        
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>8.0.31</version>
        </dependency>

#### 2.添加配置文件spring.xml ####

#### 3.**配置数据源** ####

<bean id="dataSource"
              class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"></property>
            <property name="url" value="jdbc:mysql://localhost:3306/ball?serverTimezone=GMT%2B8"></property>
            <property name="username" value="root"></property>
            <property name="password" value="123sa"></property>
        </bean>

#### 4.使用内置数据源实现原生的jdbc添加用户 ####

@Repository
    public class UserDaoImpl implements UserDao {
        @Autowired
        private DriverManagerDataSource dataSource;
        @Override
        public void aa(User user) {
            Connection connection=null;
            try {
                connection = dataSource.getConnection();
                String sql="insert into user values(null,?,?)";
                PreparedStatement ps = connection.prepareStatement(sql);
                ps.setString(1, user.getName());
                ps.setString(2, user.getPwd());
                ps.executeUpdate();
            } catch (Exception e) {
                System.out.println(e);
            }finally {
                try {
                    connection.close();
                } catch (SQLException e) {
                    throw new RuntimeException(e);
                }
            }
        }
    
    }