旅游线路查询
旅游线路查询-参数传递
header.html页面
//搜索按钮绑定单击事件,获取搜索输入框的内容 $("#search-button").click(function () { //线路名称 let rname = $("#search_input").val(); alert(rname); var cid = getParameter("cid"); //跳转路径 http://localhost/travel/route_list.html?cid=5 拼接上rname=xxx location.href = "http://localhost/travel/route_list.html?cid="+cid+"&rname="+rname; });
route_list.html页面:
$(function () { // let search = location.search;// 查询参数 // //alert(search);// ?cid=5 // // 切割字符串,拿到第二个值 // let cid = search.split("=")[1];//截取 // alert(cid); //获取cid的参数值 let cid = getParameter("cid"); let rname = getParameter("rname"); //判断rname如果不为null或"" if (rname){ //url解码 rname = window.decodeURIComponent(rname); } alert(cid); alert(rname); //当页码加载完成后,调用load方法,发送ajax请求加载数据 laod(cid); });
后台代码
RouteServlet
package cn.itcast.travel.web.servlet; import cn.itcast.travel.domain.PageBean; import cn.itcast.travel.domain.Route; import cn.itcast.travel.service.RouteService; import cn.itcast.travel.service.impl.RouteServiceImpl; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; @WebServlet("/route/*") public class RouteServlet extends BaseServlet{ private RouteService routeService = new RouteServiceImpl(); /** * 分页查询 * @param request * @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); System.out.println(pb); //4、将pageBean对象序列化为json,返回 writeValue(pb,response); } }
RouteService接口
public interface RouteService { /** * 分页查询 根据类别进行分页查询 * @param cid * @param currentPage * @param pageSize * @return */ public PageBean<Route> pageQuery(int cid,int currentPage,int pageSize,String rname); }
RouteServiceImpl实体类
package cn.itcast.travel.service.impl; import cn.itcast.travel.dao.RouteDao; import cn.itcast.travel.dao.impl.RouteDaoImpl; import cn.itcast.travel.domain.PageBean; import cn.itcast.travel.domain.Route; import cn.itcast.travel.service.RouteService; import javax.servlet.annotation.WebServlet; import java.util.List; 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); System.out.println(totalPage); return pb; } }
RouteDao接口
package cn.itcast.travel.dao; import cn.itcast.travel.domain.Route; import java.util.List; /** * 分页查询 */ public interface RouteDao { /** * 根据cid查询总记录数 */ public int findTotalCount(int cid,String rname); /** * 根据cid,start,pageSize查询当前页的数据集合 */ public List<Route> findByPage(int cid,int start,int pageSize,String rname); }
RouteDaoImpl
package cn.itcast.travel.dao.impl; import cn.itcast.travel.dao.RouteDao; import cn.itcast.travel.domain.Route; import cn.itcast.travel.util.JDBCUtils; import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.JdbcTemplate; import java.util.ArrayList; import java.util.List; 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 = ? and "; //1.定义sql模板 String sql = "select count(*) from tab_route where 1 = 1 "; StringBuilder sb = new StringBuilder(sql); List params = new ArrayList(); //2.判断是否有值 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 = ? and rname limit ? , ?"; String sql = "select * from tab_route where 1=1 "; StringBuilder sb = new StringBuilder(sql); List params = new ArrayList(); //2.判断是否有值 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()); } }
前台代码
route_list.html页面
<!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 () { // let search = location.search;// 查询参数 // //alert(search);// ?cid=5 // // 切割字符串,拿到第二个值 // let cid = search.split("=")[1];//截取 // alert(cid); //获取cid的参数值 let cid = getParameter("cid"); let rname = getParameter("rname"); //判断rname如果不为null或"" if (rname){ //url解码 rname = window.decodeURIComponent(rname); } //当页码加载完成后,调用load方法,发送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.分页工具条数据展示 //1.1展示总页码和总记录数 $("#totalPage").html(pb.totalPage); $("#totalCount").html(pb.totalCount); /* <li><a href="">首页</a></li> <li class="threeword"><a href="#">上一页</a></li> <li class="curPage"><a href="#">1</a></li><!-- curPage:当前页码 --> <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> */ var lis = ""; var frisPage = '<li onclick="javascipt:laod('+cid+',1,\''+rname+'\')"><a href="javascript:void(0)">首页</a></li>'; //计算上一页的页码 var beforeNum = pb.currentPage - 1; if (beforeNum <= 0){ beforeNum = 1; } var beforePage = '<li onclick="javascipt:laod('+cid+','+beforeNum+',\''+rname+'\')" class="threeword"><a>上一页</a></li>'; lis += frisPage; lis += beforePage; //1.2展示分页页码 /* 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 (let i = begin; i <= end; i++) { var li; //判断当前页码是否等于i if (pb.currentPage == i){ li = '<li class="curPage" onclick="javascript:laod('+cid+','+i+')"><a href="javascript:vo(0)">'+i+'</a></li>'; }else { //创建一个页面li li = '<li onclick="javascript:laod('+cid+','+i+')"><a href="javascript:vo(0)">'+i+'</a></li>'; } //拼接字符串 lis += li; } // //1.2展示分页页码 // for (let 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:vo(0)">'+i+'</a></li>'; // }else { // //创建一个页面li // li = '<li onclick="javascript:laod('+cid+','+i+')"><a href="javascript:vo(0)">'+i+'</a></li>'; // } // // //拼接字符串 // lis += li; // } //计算下一页的页码 var afterNum = pb.currentPage + 1; if (afterNum > pb.totalPage){ afterNum = pb.totalPage; } var nextPage = '<li onclick="laod('+cid+','+afterNum+',\''+rname+'\')"><a href="javascript:void(0)">下一页</a></li>'; var lastPage = '<li onclick="laod('+cid+','+pb.totalPage+',\''+rname+'\')" ><a href="javascript:void(0);">末页</a></li>'; lis += nextPage; lis += lastPage; //将lis内容设置到ul页面中 $("#pageNum").html(lis); /* <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>¥</span> <span>299</span> <span>起</span> </p> <p><a href="route_detail.html">查看详情</a></p> </div> </li> */ //2.列表数据展示 遍历输出 var route_lis = ""; for (let i = 0; i < pb.list.length; i++) { //获取[rid:rname:"xxx"] var route = pb.list[i]; var li = '<li>\n' + ' <div class="img"><img src="'+route.rimage+'" style="width: 299px;height: 169px"></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>¥</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>¥</span> <span>299</span> <span>起</span> </p> <p><a href="route_detail.html">查看详情</a></p> </div> </li> <li> <div class="img"><img src="images/04-search_03.jpg" alt=""></div> <div class="text1"> <p>浪花朵朵旅行普吉岛丛林飞跃空中飞人探险游中文服务泰国旅游</p> <br/> <p>1-2月出发,网付立享¥1099/2人起!爆款位置有限,抢完即止!</p> </div> <div class="price"> <p class="price_num"> <span>¥</span> <span>899</span> <span>起</span> </p> <p><a href="route_detail.html">查看详情</a></p> </div> </li> <li> <div class="img"><img src="images/04-search_03.jpg" alt=""></div> <div class="text1"> <p>黑妞皇家旅行普吉岛攀牙湾大船星光之旅皮划艇日落休闲特色体验</p> <br/> <p>1-2月出发,网付立享¥1099/2人起!爆款位置有限,抢完即止!</p> </div> <div class="price"> <p class="price_num"> <span>¥</span> <span>999</span> <span>起</span> </p> <p><a href="route_detail.html">查看详情</a></p> </div> </li> <li> <div class="img"><img src="images/04-search_03.jpg" alt=""></div> <div class="text1"> <p>浪花朵朵旅行普吉岛皇帝岛珊瑚岛香蕉船拖拽伞水上项目</p> <br/> <p>1-2月出发,网付立享¥1099/2人起!爆款位置有限,抢完即止!</p> </div> <div class="price"> <p class="price_num"> <span>¥</span> <span>99</span> <span>起</span> </p> <p><a href="route_detail.html">查看详情</a></p> </div> </li> <li> <div class="img"><img src="images/04-search_03.jpg" alt=""></div> <div class="text1"> <p>环游记 泰国清迈Lila massage女子监狱spa 丽菈泰式按摩马杀鸡</p> <br/> <p>1-2月出发,网付立享¥1099/2人起!爆款位置有限,抢完即止!</p> </div> <div class="price"> <p class="price_num"> <span>¥</span> <span>199</span> <span>起</span> </p> <p><a href="route_detail.html">查看详情</a></p> </div> </li> <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>¥</span> <span>899</span> <span>起</span> </p> <p><a href="route_detail.html">查看详情</a></p> </div> </li> <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>¥</span> <span>1199</span> <span>起</span> </p> <p><a href="route_detail.html">查看详情</a></p> </div> </li> <li> <div class="img"><img src="images/04-search_03.jpg" alt=""></div> <div class="text1"> <p>泰国芭提雅三合一日游芭提雅蒂芬妮人妖秀成人门票bigeye含接送</p> <br/> <p>1-2月出发,网付立享¥1099/2人起!爆款位置有限,抢完即止!</p> </div> <div class="price"> <p class="price_num"> <span>¥</span> <span>1589</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 class="curPage"><a href="#">1</a></li><!-- curPage:当前页码 --> <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>¥<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>¥<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>¥<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>¥<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>¥<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
package cn.itcast.travel.web.servlet; import cn.itcast.travel.domain.PageBean; import cn.itcast.travel.domain.Route; import cn.itcast.travel.service.RouteService; import cn.itcast.travel.service.impl.RouteServiceImpl; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; @WebServlet("/route/*") public class RouteServlet extends BaseServlet{ private RouteService routeService = new RouteServiceImpl(); /** * 分页查询 * @param request * @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 && "null".equals(cidstr)){ 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); System.out.println(pb); //4、将pageBean对象序列化为json,返回 writeValue(pb,response); } }
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY