JdbcTemplate查询值

    @Override
    public Long getCount() {
        String sql = "select count(*) from customers";
        Integer count = jdbcTemplate.queryForObject(sql, Integer.class);
        return Long.valueOf(count);
    }

    @Override
    public Date getMaxBirth() {
        String sql = "select max(birth) from customers";
        Date date = jdbcTemplate.queryForObject(sql, Date.class);
        return date;
    }

    @Override
    public String getCustomerName(int id) {
        String sql = "select name from customers where id = ?";
        Object[] args = {id};
        String name = jdbcTemplate.queryForObject(sql, String.class,args);
        return name;
    }

 

posted on 2022-04-08 09:25  金满仓  阅读(397)  评论(0)    收藏  举报

导航