Spring整合jdbc及其crud操作即增删改查（二）

测试查询并返回主键Id

public class TestAccountDao extends TestBase {
    @Resource
    private AccountDao accountDao;
    @Test
    public void test02(){
        System.out.println(accountDao.saveAccountHasPrimaryKey(new Account("中国好男人", BigDecimal.valueOf(8000),1,new Date(),new Date(),"男儿志","1")));
    }
}

​根据指定的类型做查询操作​

@Override
    //统计账户记录-聚合查询
    public Integer countAccountsByUserId(Integer userId) {
        String sql="select count(1) from account where user_id=? ";
        return jdbcTemplate.queryForObject(sql,Integer.class,userId);
    }

//统计账户记录-聚合查询
    @Test
    public void test04(){
        System.out.println(accountDao.countAccountsByUserId());
    }

​更新账户记录​