黑马旅游网案例学习之旅游线路的详情展示(八)

(一)需求分析

效果

(二)后台代码:

RouteImgDaoImpl

public class RouteImgDaoImpl implements RouteImgDao {
   
    private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());
    @Override
    public List<RouteImg> findByRid(int rid) {
   
        String sql = "select * from tab_route_img where rid = ? ";
        return template.query(sql,new BeanPropertyRowMapper<RouteImg>(RouteImg.class),rid);

    }
}

RouteDaoImpl

public class RouteDaoImpl implements RouteDao {
   
    private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());
    /**
     * 根据cid查询总记录数
     *
     * @param cid
     * @return
     */
    @Override
    public int findTotalCount(int cid) {
   
        String sql = "select count(*) from tab_route where cid = ?";
        return template.queryForObject(sql,Integer.class,cid);
    }

    @Override
    public List