jdbcTemplate在Dao中使用

bean.xml:

<?xml version="1.0" encoding="UTF-8"?>
<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.xsd">
    <!--配置账户的持久层-->
    <bean id="accountDao" class="com.wance.dao.impl.AccountDaoImpl">
        <property name="jdbcTemplate" ref="jdbcTemplate"/>
    </bean>
    <!--配置数据源-->
    <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/mybatis"/>
        <property name="username" value="root"/>
        <property name="password" value="123456"/>
    </bean>

    <!--配置JdbcTemplate-->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>
</beans>

AccountDao.java:

/**
 * 账户持久层接口
 */
public interface AccountDao {
    /**
     * 根据id查询账户
     * @return
     */
    Account findAccountById(Integer accountId);

    /**
     * 根据名称查询
     * @param accountName
     * @return
     */
    Account findAccountByName(String accountName);

    /**
     * 更新账户
     * @param account
     * @return
     */
    void updateAccont(Account account);
}

AccountDaoImpl.java:

/**
 * 账户持久层的实现类
 */
public class AccountDaoImpl implements AccountDao {
    private JdbcTemplate jdbcTemplate;

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    @Override
    public Account findAccountById(Integer accountId) {
        List<Account> accounts=jdbcTemplate.query("select * from account where id=?",new BeanPropertyRowMapper<Account>(Account.class),accountId);
        return accounts.isEmpty()?null:accounts.get(0);
    }

    @Override
    public Account findAccountByName(String accountName) {
        //List<Account> accounts=jdbcTemplate.query("select * from account where id=?",new BeanPropertyRowMapper<Account>(Account.class),accountId);
        return null;
    }

    @Override
    public void updateAccont(Account account) {
        jdbcTemplate.update("update account set uid=?,money=? where id=?",account.getUid(),account.getMoney(),account.getId());
    }
}

测试类：

 @Test
    public void testDao(){
        //获取容器
        ApplicationContext factory=new ClassPathXmlApplicationContext("bean.xml");
        //获取对象
        AccountDao accountDao=factory.getBean("accountDao",AccountDao.class);

        Account account=accountDao.findAccountById(2);
        System.out.println(account);

        account.setMoney(1000f);
        accountDao.updateAccont(account);
        System.out.println(account);
    }

结果：

Account{id=2, uid=34, money=567.0}
Account{id=2, uid=34, money=1000.0}