public List<Movie> findAll() { List<Movie> movieList = (List<Movie>) EhcacheUtil.get("movieList"); if (movieList == null) { String sql = "SELECT * FROM movie"; movieList = DbHelp.query(sql, new BeanListHandler<>(Movie.class)); EhcacheUtil.set("movieList", movieList); } return movieList; }
public Movie findById(Integer id) { Movie movie = (Movie) EhcacheUtil.get("movie:" + id); if (movie == null) { String sql = "select * from movie where id=?"; movie = DbHelp.query(sql, new BeanHandler<>(Movie.class), id); EhcacheUtil.set("movie:" + id, movie); } else { logger.debug("load movie from cache"); } return movie; }