黑马旅游网（四）

一、旅游线路收藏

1.分析

用户表里面有uid，线路表里面有rid，现在有一张收藏表里面有（uid，date，rid）代表那一条线路在那一天被哪一个用户收藏

2.后台代表编写

routeServlet中添加isFavorite方法

@WebServlet("/route/*")
public class RouteServlet extends BaseServlet {

    private RouteService routeService = new RouteServiceImpl();
    private FavoriteService favoriteService = new FavoriteServiceImpl();

    public void isFavorite(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //1. 获取线路id
        String rid = request.getParameter("rid");

        //2. 获取当前登录的用户 user
        User user = (User) request.getSession().getAttribute("user");
        int uid;//用户id
        if(user == null){
            //用户尚未登录
            uid = 0;
        }else{
            //用户已经登录
            uid = user.getUid();
        }

        //3. 调用FavoriteService查询是否收藏
        boolean flag = favoriteService.isFavorite(rid, uid);

        //4. 写回客户端
        writeValue(flag,response);
    }
    
}

favorite类

public class Favorite implements Serializable {
    private Route route;//旅游线路对象
    private String date;//收藏时间
    private User user;//所属用户


    public Favorite() {
    }
    
    public Favorite(Route route, String date, User user) {
            this.route = route;
            this.date = date;
            this.user = user;
    }

    public Route getRoute() {
        return route;
    }
    public void setRoute(Route route) {
        this.route = route;
    }

    public String getDate() {
        return date;
    }
    public void setDate(String date) {
        this.date = date;
    }

    public User getUser() {
        return user;
    }
    public void setUser(User user) {
        this.user = user;
    }
}

FavoriteService

public interface FavoriteService {

    public boolean isFavorite(String rid, int uid);
}

public class FavoriteServiceImpl implements FavoriteService {

    private FavoriteDao favoriteDao = new FavoriteDaoImpl();

    @Override
    public boolean isFavorite(String rid, int uid) {

        Favorite favorite = favoriteDao.findByRidAndUid(Integer.parseInt(rid), uid);

        return favorite != null;//如果对象有值，则为true，反之，则为false
    }

}

FavoriteDao

public interface FavoriteDao {


    public Favorite findByRidAndUid(int rid, int uid);
    
}

public class FavoriteDaoImpl implements FavoriteDao {

    private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());

    @Override
    public Favorite findByRidAndUid(int rid, int uid) {
        Favorite favorite = null;
        try {
            String sql = " select * from tab_favorite where rid = ? and uid = ?";
            favorite = template.queryForObject(sql, new BeanPropertyRowMapper<Favorite>(Favorite.class), rid, uid);

        } catch (DataAccessException e) {
            e.printStackTrace();
        }
        return favorite;
    }
    
}

3.前台代码的编写

route_detail.html

    $(function () {
       // 发送请求，判断用户是否收藏过该线路
        
        var rid = getParameter("rid");//获取rid
        $.get("route/isFavorite",{rid:rid},function (flag) {
            if(flag){
                // 用户已经收藏过，添加<a  class="btn already" disabled="disabled">的样式

                //设置收藏按钮的样式
                $("#favorite").addClass("already");
                $("#favorite").attr("disabled","disabled");

                //删除按钮的点击事件（这个收藏按钮就不能再被点击了）
                $("#favorite").removeAttr("onclick");
                
            }else{
                // 用户没有收藏，什么也不做，用默认样式
            }
        });
    });

4.执行结果

二、收藏次数的动态展示

改写routeServiceImpl
前期学过，routeServiceImpl里面有一个findOne（）方法就是查询一条线路的详情（图片信息，商家信息），而一条线路的收藏次数也属于一条线路的详细信息，所以要把它封装到findOne（）方法里

改写favoriteDao
在favoriteDao中添加findCountByRid（）方法

public interface FavoriteDao {
    
    /**
     * 根据rid 查询收藏次数
     * @param rid
     * @return
     */
    public int findCountByRid(int rid);
}

public class FavoriteDaoImpl implements FavoriteDao {

    private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());

    @Override
    public int findCountByRid(int rid) {
        String sql = "SELECT COUNT(*) FROM tab_favorite WHERE rid = ?";

        return template.queryForObject(sql,Integer.class,rid);
    }
    
}

前端代码添加收藏次数

三、完成点击收藏的功能

1.分析

2.后台代码的编写

在routeServlet中添加addFavorite（）方法

@WebServlet("/route/*")
public class RouteServlet extends BaseServlet {

    private RouteService routeService = new RouteServiceImpl();
    private FavoriteService favoriteService = new FavoriteServiceImpl();

    public void addFavorite(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //1. 获取线路rid
        String rid = request.getParameter("rid");
        //2. 获取当前登录的用户
        User user = (User) request.getSession().getAttribute("user");
        int uid;//用户id
        if(user == null){
            //用户尚未登录
            return ;
        }else{
            //用户已经登录
            uid = user.getUid();
        }

        //3. 调用service添加
        favoriteService.add(rid,uid);

    }
}

FavoriteService中添加add()方法

public interface FavoriteService {
    
    void add(String rid, int uid);
}

public class FavoriteServiceImpl implements FavoriteService {

    private FavoriteDao favoriteDao = new FavoriteDaoImpl();

    @Override
    public void add(String rid, int uid) {
    
        favoriteDao.add(Integer.parseInt(rid),uid);
        
    }
}

FavoriteDao中添加add()方法

public interface FavoriteDao {

    void add(int i, int uid);
}

public class FavoriteDaoImpl implements FavoriteDao {

    private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());

    @Override
    public void add(int rid, int uid) {
        String sql = "insert into tab_favorite values(?,?,?)";

        template.update(sql,rid,new Date(),uid);
    }
}

3.前台代码的编写

route_detail.html

    //点击收藏按钮触发的方法
    function addFavorite(){
        
        var rid = getParameter("rid");//获取rid
        
        //1. 判断用户是否登录
        $.get("user/findOne",{},function (user) {
           if(user){
               //用户登录了
               
                //发送Ajax请求，完成添加收藏的功能
                $.get("route/addFavorite",{rid:rid},function () {

                    
                    location.reload();//代码刷新页面
                });

           }else{
               //用户没有登录
               alert("您尚未登录，请登录");
               location.href="http://localhost/travel/login.html";//跳转到登录页码
           }
        })
    }

4.运行结果

感谢浏览和收藏