8 spring JdbcDaoSupport的使用示范

1.建一个表，包括name,password
2.导包

3.创建dao

public class Dao extends JdbcDaoSupport {
  
   public  void add(){
       String sql="insert into user(name,password) values ('jiang','1234')";
       this.getJdbcTemplate().update(sql);
   }

}

4.配置beans.xml

<?xml version="1.0" encoding="UTF-8"?>
<!--xmlns xml namespace:xml命名空间-->
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:p ="http://www.springframework.org/schema/p"
       xmlns:context ="http://www.springframework.org/schema/context"

       xsi:schemaLocation="http://www.springframework.org/schema/beans
                           http://www.springframework.org/schema/beans/spring-beans.xsd
                           http://www.springframework.org/schema/context
                           http://www.springframework.org/schema/context/spring-context.xsd
                          ">

    <context:property-placeholder location="classpath:db.properties"></context:property-placeholder>
<bean id="datasource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    <property name="driverClass" value="${driverClass}"></property>
    <property name="jdbcUrl" value="${jdbcUrl}"></property>
    <property name="user" value="${user}"></property>
    <property name="password" value="${password}"></property>
</bean>
    <bean id="dao" class="spring.dao.Dao">
        <property name="dataSource" ref="datasource"></property>
    </bean>

</beans>

5.test

public class test2 {
    @Test
    public  void test1(){
        ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("beans01.xml");
        Dao dao = (Dao) context.getBean("dao");
        dao.add();
    }
}

6.结果完美

7.感想
（1）如果遇到错误多换包，要么版本太高，要么版本太低
（2）导包一定要齐全，不然就是抓瞎