springboot JdbcTemplate

jdbc 将结果集映射到list实体类

    @Autowired
    private JdbcTemplate jdbcTemplate;
    @RequestMapping("/test")
    public Object test() {
        return jdbcTemplate.query("select * from  shop_usercoupon",new BeanPropertyRowMapper<Usercoupon>(Usercoupon.class));
    }

jdbc 将结果集映射到单个实体类

    @Autowired
    private JdbcTemplate jdbcTemplate;
    @RequestMapping("/test")
    public Object test() {
        return jdbcTemplate.queryForObject("select * from  shop_usercoupon limit 1",new BeanPropertyRowMapper<Usercoupon>(Usercoupon.class));
    }