旅游线路查询—参数传递
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>¥</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>
</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>¥<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类：
标签：pb,rname,pageSize,cid,route,查询,线路,旅游,var From： https://www.cnblogs.com/xjw12345/p/16624732.html