Example With JdbcDaoSupport

最新推荐文章于 2025-09-06 22:56:13 发布

weixin_33786077

最新推荐文章于 2025-09-06 22:56:13 发布

阅读量63

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/MarchThree/p/6128463.html

本文介绍如何使用 Spring 的 JdbcDaoSupport 类简化 JDBC 操作。通过继承 JdbcDaoSupport，可以避免直接设置 DataSource 和 JdbcTemplate。只需注入正确的 DataSource 到 JdbcCustomerDAO 中，并通过 getJdbcTemplate() 方法获取 JdbcTemplate 实例。示例展示了 Customer 的插入操作及 Spring 配置。

By extended the JdbcDaoSupport, set the datasource and JdbcTemplate in your class is no longer required, you just need to inject the correct datasource into JdbcCustomerDAO. And you can get the JdbcTemplate by using a getJdbcTemplate() method.

public class JdbcCustomerDAO extends JdbcDaoSupport implements CustomerDAO
{
   //no need to set datasource here
   public void insert(Customer customer){

    String sql = "INSERT INTO CUSTOMER " +
        "(CUST_ID, NAME, AGE) VALUES (?, ?, ?)";

    getJdbcTemplate().update(sql, new Object[] { customer.getCustId(),
            customer.getName(),customer.getAge()
    });

}

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">

    <bean id="dataSource"
         class="org.springframework.jdbc.datasource.DriverManagerDataSource">

        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/mkyongjava" />
        <property name="username" value="root" />
        <property name="password" value="password" />
    </bean>

</beans>

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">

    <bean id="customerDAO" class="com.mkyong.customer.dao.impl.JdbcCustomerDAO">
        <property name="dataSource" ref="dataSource" />
    </bean>

</beans>