Spring 对JDBC的支持

Spring对JDBC的支持

1. 导入配置文件

<context:property-placeholder location="classpath:db.properties"/>

2.配置数据源

 <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
      <property name="user" value="${user}"/>
      <property name="driverClass" value="${driverClass}"/>
      <property name="password" value="${password}"/>
      <property name="jdbcUrl" value="${jdbcUrl}"/>
</bean>

3.配置jdbc模板

<bean id="template"
     class="org.springframework.jdbc.core.JdbcTemplate" >
     <property name="dataSource" ref="dataSource"/>
</bean>

4.编写测试类

public class BookDaoImp implements BookDao {
    @Autowired
    private JdbcTemplate template;

    @Override
    public double queryMoneyByName(String name) {
    String sql = "SELECT MONEY FROM t_book where name=?";
    double money = template.queryForObject(sql, Double.class, name);
    return money;
    }
 }