@Autowired
protected JdbcTemplate jdbcTemplate;
public int getRecordCount(String sql, String... args) throws Exception {
return jdbcTemplate.queryForObject(sql, args, Integer.class);
}
public int getRecordCount(String sql, Object[] args) throws Exception {
return jdbcTemplate.queryForObject(sql, args, Integer.class);
}