旅游线路查询

旅游线路查询—参数传递

header.html页面：

//给搜索按钮绑定单击事件，获取搜索输入框的内容
        $("#search-button").click(function () {
            var rname = $("#search_input").val();
            var cid = getParameter("cid");
            //跳转路径
            location.href = "http://localhost/travel/route_list.html?cid="+cid+"&rname="+rname;
        });

route_list.html页面：

$(function () {
            /*var search = location.search;
            //切割字符串，拿到第二个值
            var cid = search.split("=")[1];*/
            //获取cid的参数值
            var cid = getParameter("cid");
            //获取rname的参数值
            var rname = getParameter("rname");
            //判断rname不为null 或者 ""
            if (rname){
                rname = window.decodeURIComponent(rname);
            }
            alert(cid);
            alert(rname);

            //当页面加载完成后，调用laod方法，发送ajax请求加载数据
            laod(cid)

        });

 

 

 

 

后台代码

RouteServlet类：

@WebServlet("/route/*")
public class RouteServlet extends BaseServlet {
    private RouteService routeService = new RouteServiceImpl();
    /**
     * 分页查找
     * @param request
     * @param response
     * @throws ServletException
     * @throws IOException
     */
    public void pageQuery(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //接收参数
        String currentPageStr = request.getParameter("currentPage");
        String pageSizeStr = request.getParameter("pageSize");
        String cidstr = request.getParameter("cid");

        //接收rname线路名称
        String rname = request.getParameter("rname");
        rname = new String(rname.getBytes("iso-8859-1"),"utf-8");

        int cid = 0;
        //2、处理参数
        if (cidstr != null && cidstr.length()>0){
            cid = Integer.parseInt(cidstr);
        }
        int currentPage = 0;//当前页码，如果不传递，则默认为第一页
        if (currentPageStr!=null && currentPageStr.length()>0){
            currentPage = Integer.parseInt(currentPageStr);
        }else {
            currentPage = 1;
        }
        int pageSize = 0;//每页显示条数，如果不传递，默认每页显示5条记录
        if (pageSizeStr != null && pageSizeStr.length()==0){
            pageSize = Integer.parseInt(pageSizeStr);
        }else {
            pageSize = 5;
        }

        //3、调用service查询pageBean对象
        PageBean<Route> pb = routeService.pageQuery(cid, currentPage, pageSize,rname);
        //4、将pageBean对象序列化为json，返回
        writeValue(pb,response);
    }
}

RouteService：

 

 RouteServiceImpl：

public class RouteServiceImpl implements RouteService {
    private RouteDao routeDao = new RouteDaoImpl();

    @Override
    public PageBean<Route> pageQuery(int cid, int currentPage, int pageSize, String rname) {
        //封装PageBean
        PageBean<Route> pb = new PageBean<>();
        //设置当前页码
        pb.setCurrentPage(currentPage);
        //设置每页显示条数
        pb.setPageSize(pageSize);

        //设置总记录数
        int totalCount = routeDao.findTotalCount(cid,rname);
        pb.setTotalCount(totalCount);
        //设置当前页显示的数据集合
        int start = (currentPage-1)*pageSize;
        List<Route> list = routeDao.findByPage(cid, start, pageSize,rname);
        pb.setList(list);

        //设置总页数 = 总记录数/每页显示条数
        int totalPage = totalCount%pageSize==0 ? totalCount/pageSize : (totalCount/pageSize)+1;
        pb.setTotalPage(totalPage);

        return pb;
    }
}

 

 

RouterDao：

 

 RouteDaoImpl：

public class RouteDaoImpl implements RouteDao {
    private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());
    @Override
    public int findTotalCount(int cid, String rname) {
//        String sql = "select count(*) from tab_route where cid = ?";
        //定义sql模板
        String sql = "select count(*) from tab_route where 1=1";
        StringBuilder sb = new StringBuilder(sql);
        List params = new ArrayList();
        //判断参数是否有值
        if (cid!=0){
            sb.append(" and cid = ? ");
            params.add(cid);
        }
        if (rname!=null && rname.length()>0){
            sb.append(" and rname like ? ");
            params.add("%"+rname+"%");
        }
        sql = sb.toString();
        System.out.println(sql);
        return template.queryForObject(sql, Integer.class, params.toArray());
    }

    @Override
    public List<Route> findByPage(int cid, int start, int pageSize, String rname) {
        //String sql = "select * from tab_route where cid = ? limit ?,?";

        //定义sql模板
        String sql = "select * from tab_route where 1=1";
        StringBuilder sb = new StringBuilder(sql);
        List params = new ArrayList();
        //判断参数是否有值
        if (cid!=0){
            sb.append(" and cid = ? ");
            params.add(cid);
        }
        if (rname!=null && rname.length()>0){
            sb.append(" and rname like ? ");
            params.add("%"+rname+"%");
        }
        sb.append(" limit ?,? ");//分页条件
        sql = sb.toString();
        params.add(start);
        params.add(pageSize);

        return template.query(sql, new BeanPropertyRowMapper<>(Route.class), params.toArray());
    }
}

 

 

 

 

 

 

前台代码

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>黑马旅游-搜索</title>
    <link rel="stylesheet" type="text/css" href="css/common.css">
    <link rel="stylesheet" href="css/search.css">
    <script src="js/jquery-3.3.1.js"></script>
    <script src="js/getParameter.js"></script>
    <script>
        $(function () {
            /*var search = location.search;
            //切割字符串，拿到第二个值
            var cid = search.split("=")[1];*/
            //获取cid的参数值
            var cid = getParameter("cid");
            //获取rname的参数值
            var rname = getParameter("rname");
            //判断rname不为null 或者 ""
            if (rname){
                rname = window.decodeURIComponent(rname);
            }

            //当页面加载完成后，调用laod方法，发送ajax请求加载数据
            laod(cid,null,rname)

        });
        function laod(cid,currentPage,rname) {
            //发送ajax请求，请求route/pageQuery,传递cid
            $.get("route/pageQuery",{cid:cid,currentPage:currentPage,rname:rname},function (pb) {
                //解析pageBean的数据，展示到页面上

                //1、分页工具条数据展示
                //展示总页码和总记录数
                $("#totalPage").html(pb.totalPage);
                $("#totalCount").html(pb.totalCount);

                //展示分页页码
                var lis = "";

                var firstPage = '<li onclick="javascript:laod('+cid+',1,\''+rname+'\')"><a href="javascript:void(0)">首页</a></li>';

                //计算上一页的页码
                var beforNum = pb.currentPage-1;
                if (beforNum<=0){
                    beforNum=1;
                }
                var beforePage = '<li onclick="javascript:laod('+cid+','+beforNum+',\''+rname+'\')" class="threeword"><a href="javascript:void(0)">上一页</a></li>';

                lis+=firstPage;
                lis+=beforePage;


                /*
                    1、一共展示10个页码，能够达到前5后4的效果
                    2、如果前边不够5个，后边补齐10个
                    3、如果后边不足4个，前边补齐10个
                 */


                //定义开始位置begin ，结束位置 end
                var begin;//开始位置
                var end;//结束位置

                //1、要显示10个页码
                if (pb.totalPage<10){
                    //总页码不够10页
                    begin = 1;
                    end = pb.totalPage;
                }else {
                    //总页码超过10页
                    begin = pb.currentPage - 5;
                    end = pb.currentPage + 4;
                    //2、如果前边不够5个，后边补齐10个
                    if (begin<1){
                        begin = 1;
                        end = begin + 9;
                    }
                    //3、如果后边不足4个，前边补齐10个
                    if (end>pb.totalPage){
                        end = pb.totalPage;
                        begin = end - 9;
                    }
                }

                for (var i = begin; i <=end; i++) {
                    var li;
                    //判断当前页码是否等于i
                    if (pb.currentPage == i){
                        li = '<li class="curPage" onclick="javascript:laod('+cid+','+i+',\''+rname+'\')"><a href="javascript:void(0)">'+i+'</a></li>';
                    }else{
                        //创建页码的li
                        li = '<li onclick="javascript:laod('+cid+','+i+',\''+rname+'\')"><a href="javascript:void(0)">'+i+'</a></li>';
                    }

                    //拼接字符串
                    lis+=li;
                }


                /*for (var i = 1; i <=pb.totalPage ; i++) {
                    var li;
                    //判断当前页码是否等于i
                    if (pb.currentPage == i){
                        li = '<li class="curPage" onclick="javascript:laod('+cid+','+i+')"><a href="javascript:void(0)">'+i+'</a></li>';
                    }else{
                        //创建页码的li
                        li = '<li onclick="javascript:laod('+cid+','+i+')"><a href="javascript:void(0)">'+i+'</a></li>';
                    }

                    //拼接字符串
                    lis+=li;
                }*/

                //计算下一页的页码
                var afterNum = pb.currentPage+1;
                if (afterNum>pb.totalPage){
                    afterNum=pb.totalPage;
                }
                var nextPage = '<li onclick="javascript:laod('+cid+','+afterNum+',\''+rname+'\')" class="threeword"><a href="javascript:void(0)">下一页</a></li>';
                var lastPage = '<li onclick="javascript:laod('+cid+','+pb.totalPage+',\''+rname+'\')" class="threeword"><a href="javascript:void(0)">末页</a></li>';

                lis+=nextPage;
                lis+=lastPage;

                //将lis内容设置到ul
                $("#pageNum").html(lis);


                //2、列表数据展示
                var route_lis = "";
                for (var i = 0; i < pb.list.length; i++) {
                    var route = pb.list[i];
                    var li = '<li>\n' +
    '                            <div class="img"><img src="'+route.rimage+'" style="width: 299px;"></div>\n' +
    '                            <div class="text1">\n' +
    '                                <p>'+route.rname+'</p>\n' +
    '                                <br/>\n' +
    '                                <p>'+route.routeIntroduce+'</p>\n' +
    '                            </div>\n' +
    '                            <div class="price">\n' +
    '                                <p class="price_num">\n' +
    '                                    <span>&yen;</span>\n' +
    '                                    <span>'+route.price+'</span>\n' +
    '                                    <span>起</span>\n' +
    '                                </p>\n' +
    '                                <p><a href="route_detail.html">查看详情</a></p>\n' +
    '                            </div>\n' +
    '                        </li>';
                    route_lis+=li;
                }

                $("#route").html(route_lis);

                //定位到页面的顶部
                window.scrollTo(0,0);
            });
        }
    </script>
</head>
<body>
<!--引入头部-->
<div id="header"></div>
    <div class="page_one">
        <div class="contant">
            <div class="crumbs">
                <img src="images/search.png" alt="">
                <p>黑马旅行><span>搜索结果</span></p>
            </div>
            <div class="xinxi clearfix">
                <div class="left">
                    <div class="header">
                        <span>商品信息</span>
                        <span class="jg">价格</span>
                    </div>
                    <ul id="route">
                        <li>
                            <div class="img"><img src="images/04-search_03.jpg" alt=""></div>
                            <div class="text1">
                                <p>【减100元 含除夕/春节出发】广州增城三英温泉度假酒店/自由行套票</p>
                                <br/>
                                <p>1-2月出发，网付立享￥1099/2人起！爆款位置有限，抢完即止！</p>
                            </div>
                            <div class="price">
                                <p class="price_num">
                                    <span>&yen;</span>
                                    <span>299</span>
                                    <span>起</span>
                                </p>
                                <p><a href="route_detail.html">查看详情</a></p>
                            </div>
                        </li>
                    </ul>
                    <div class="page_num_inf">
                        <i></i> 共
                        <span id="totalPage">12</span>页<span id="totalCount">132</span>条
                    </div>
                    <div class="pageNum">
                        <ul id="pageNum">
                            <li><a href="">首页</a></li>
                            <li class="threeword"><a href="#">上一页</a></li>
                            <li><a href="#">1</a></li>
                            <li><a href="#">2</a></li>
                            <li><a href="#">3</a></li>
                            <li><a href="#">4</a></li>
                            <li><a href="#">5</a></li>
                            <li><a href="#">6</a></li>
                            <li><a href="#">7</a></li>
                            <li><a href="#">8</a></li>
                            <li><a href="#">9</a></li>
                            <li><a href="#">10</a></li>
                            <li class="threeword"><a href="javascript:;">下一页</a></li>
                            <li class="threeword"><a href="javascript:;">末页</a></li>
                        </ul>
                    </div>
                </div>
                <div class="right">
                    <div class="top">
                        <div class="hot">HOT</div>
                        <span>热门推荐</span>
                    </div>
                    <ul>
                        <li>
                            <div class="left"><img src="images/04-search_09.jpg" alt=""></div>
                            <div class="right">
                                <p>清远新银盏温泉度假村酒店/自由行套...</p>
                                <p>网付价<span>&yen;<span>899</span>起</span>
                                </p>
                            </div>
                        </li>
                        <li>
                            <div class="left"><img src="images/04-search_09.jpg" alt=""></div>
                            <div class="right">
                                <p>清远新银盏温泉度假村酒店/自由行套...</p>
                                <p>网付价<span>&yen;<span>899</span>起</span>
                                </p>
                            </div>
                        </li>
                        <li>
                            <div class="left"><img src="images/04-search_09.jpg" alt=""></div>
                            <div class="right">
                                <p>清远新银盏温泉度假村酒店/自由行套...</p>
                                <p>网付价<span>&yen;<span>899</span>起</span>
                                </p>
                            </div>
                        </li>
                        <li>
                            <div class="left"><img src="images/04-search_09.jpg" alt=""></div>
                            <div class="right">
                                <p>清远新银盏温泉度假村酒店/自由行套...</p>
                                <p>网付价<span>&yen;<span>899</span>起</span>
                                </p>
                            </div>
                        </li>
                        <li>
                            <div class="left"><img src="images/04-search_09.jpg" alt=""></div>
                            <div class="right">
                                <p>清远新银盏温泉度假村酒店/自由行套...</p>
                                <p>网付价<span>&yen;<span>899</span>起</span>
                                </p>
                            </div>
                        </li>
                    </ul>
                </div>
            </div>
        </div>
    </div>

    <!--引入头部-->
    <div id="footer"></div>
    <!--导入布局js，共享header和footer-->
    <script type="text/javascript" src="js/include.js"></script>
</body>

</html>

RouteServlet类：