Spring配置c3p0连接池

1. c3p0配置数据库信息使用java代码实现

   ComboPooledDataSource comboPooledDataSource = new ComboPooledDataSource();
           comboPooledDataSource.setDriverClass("com.mysql.jdbc.Driver");
           comboPooledDataSource.setJdbcUrl("jdbc:mysql:///web17");
           comboPooledDataSource.setUser("root");
           comboPooledDataSource.setPassword("123456");

2. c3p0使用配置形式实现（配置c3p0连接池）c3p0.xml

   <!--配置c3p0连接池-->
       <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
           <!--注入属性值-->
           <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
           <property name="jdbcUrl" value="jdbc:mysql:///web17"></property>
           <property name="user" value="root"></property>
           <property name="password" value="123456"></property>
       </bean>

3. dao使用jdbcTemplate

• 创建service和dao,配置service和dao对象，在service注入dao对象;创建jdbcTemplate对象，把模板对象注入到dao;把

  public class UserService {
      private UserDao userDao;
  
      public void setUserDao(UserDao userDao) {
          this.userDao = userDao;
      }
      public void add(){
          System.out.println("service...");
          userDao.add();
      }
  }

  public class UserDao {
      //得到JdbcTemplate模板对象
      private JdbcTemplate jdbcTemplate;
  
      public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
          this.jdbcTemplate = jdbcTemplate;
      }
  
      public void add() {
          System.out.println("add...");
          String sql = "insert into user values(?,?)";//添加操作
          jdbcTemplate.update(sql,"sqq","123456");
  
      }
  }

   <!--创建两个类的对象-->
      <bean id="userService" class="com.sun.c3p0.UserService">
          <!--service里注入dao属性-->
          <property name="userDao" ref="userDao"></property>
      </bean>
      <bean id="userDao" class="com.sun.c3p0.UserDao">
          <!--注入jdbcTemplate对象-->
          <property name="jdbcTemplate" ref="jdbcTemplate"></property>
      </bean>
      <!--创建jdbc模板对象-->
      <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
          <!--把dataSource传递到模板对象里面-->
          <property name="dataSource" ref="dataSource"></property>
      </bean>