<%@ page import="util
.DbConnet" %>
<%@ page import="java
.sql
.ResultSet" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
//获取用户输入的查询内容
String appliance_id = request
.getParameter("appliance_id");
if(appliance_id==null) appliance_id="";
String appliance_type = request
.getParameter("appliance_type");
if(appliance_type==null) appliance_type="";
String appliance_name = request
.getParameter("appliance_name");
if(appliance_name==null) appliance_name="";
//1
.数据总数
String sql = "select count(*) as total from `living_room_appliances` " +
"where `appliance_id` like
? and `appliance_type` like
? and `appliance_name` like
?;";
Object[] params = new Object[]{
"%"+appliance_id+"%","%"+appliance_type+"%","%"+appliance_name+"%"
};
ResultSet rs = DbConnet
.select(sql, params);
rs
.next();
int total = rs
.getInt("total");
//2
.每页显示的行数
int pageSize = 5;
//3
.总页数
double result = (double)total/pageSize;
//向上取整：只要数值带有有效的小数，舍去小数，整数位加
一
int pageTotal = (int) Math
.ceil(result);
//4
.当前页码
String pageNoStr = request
.getParameter("pageNo");
pageNoStr = pageNoStr==null
?"1":pageNoStr;
int pageNo = Integer
.parseInt(pageNoStr);
//获取用户表中的数据，显示出来
sql = "select * from `living_room_appliances` " +
"where `appliance_id` like
? and `appliance_type` like
? and `appliance_name` like
?" +
"limit
?,
?;";
int start = (pageNo - 1) * pageSize;//（当前页码-1）*每页显示的行数
params = new Object[]{
"%"+appliance_id+"%","%"+appliance_type+"%","%"+appliance_name+"%",start,pageSize
};
rs = DbConnet
.select(sql, params);
%>
<html>
<head>
<title>用户列表</title>
<link rel="stylesheet"
href="
../css/common
.css">
<link rel="stylesheet"
href="
../css/list
.css">
</head>
<body>
<%--搜索区域 S--%>
<div class="search">
<form>
<label for="appliance_id">账号：</label>
<input type="text" id="appliance_id" name="appliance_id" value="<%=appliance_id%>">
<label for="appliance_type">姓名：</label>
<input type="text" id="appliance_type" name="appliance_type" value="<%=appliance_type%>">
<label for="appliance_name">姓名：</label>
<input type="text" id="appliance_name" name="appliance_name" value="<%=appliance_name%>">
<button id="btnSearch" class="primary" type="button">查询</button>
<button id="btnReset" type="button">重置</button>
</form>
</div>
<%--搜索区域 E--%>
<%--按钮区域 S--%>
<div class="btn-box">
<button id="btnAdd" class="primary" type="button">新增</button>
</div>
<%--按钮区域 E--%>
<%--表格区域 S--%>
<div class="table-box">
<table>
<tr>
<th>编号</th>
<th>账号</th>
<th>姓名</th>
<th>操作</th>
</tr>
<%
while (rs
.next()){
%>
<tr>
<td><%=rs
.getString("appliance_id")%></td>
<td><%=rs
.getString("appliance_type")%></td>
<td><%=rs
.getString("appliance_name")%></td>
<td>
<button data-id="<%=rs
.getString("id")%>" name="btnEdit" class="primary" type="button">编辑</button>
<button data-id="<%=rs
.getString("id")%>" name="btnDelete" class="danger" type="button">删除</button>
</td>
</tr>
<%
}
%>
</table>
</div>
<%--表格区域 E--%>
<%--页码区域 S--%>
<%--<div class="pager">--%>
<%-- <ul>--%>
<%-- <li>共<%=total%>条数据/每页<%=pageSize%>条</li>--%>
<%-- <% if(pageNo>1){%>--%>
<%-- <li class="page"><a
href="list
.jsp?username=<%=username%>&realname=<%=realname%>&pageNo=1">首页</a></li>--%>
<%-- <li class="page"><a
href="list
.jsp?username=<%=username%>&realname=<%=realname%>&appliance_name<%appliance_name%>&pageNo=<%=pageNo-1%>">上
一页</a></li>--%>
<%-- <% } %>--%>
<%-- <%– <li class="active">1</li>–%>--%>
<%-- <% for (int i=1;i<=pageTotal;i++){%>--%>
<%-- <li class="<%=(pageNo==i
?"active":"")%>" class="page">--%>
<%-- <a
href="list
.jsp?username=<%=username%>&realname=<%=realname%>&pageNo=<%=i%>"><%=i%></a>--%>
<%-- </li>--%>
<%-- <% } %>--%>
<%-- <% if(pageTotal>pageNo){%>--%>
<%-- <li class="page"><a
href="list
.jsp?username=<%=username%>&realname=<%=realname%>&pageNo=<%=pageNo+1%>">下
一页</a></li>--%>
<%-- <li class="page"><a
href="list
.jsp?username=<%=username%>&realname=<%=realname%>&pageNo=<%=pageTotal%>">尾页</a></li>--%>
<%-- <% } %>--%>
<%-- </ul>--%>
<%--</div>--%>
<%--页码区域 E--%>
<script src="
../js/jquery-3
.5
.1
.min
.js"></script>
<script src="
../js/common
.js"></script>
<script>
//绑定搜索按钮的点击事件
$('#btnSearch')
.on('click', function () {
//获取搜索框中的内容：账号、姓名
let username = $('#username')
.val();
let realname = $('#realname')
.val();
window.location.href="list
.jsp?username=" + username + "&realname=" + realname;
});
//绑定重置按钮的点击事件
$('#btnReset')
.on('click', function () {
window.location.href="list
.jsp";
});
//绑定新增按钮的点击事件
$('#btnAdd')
.on('click', function () {
window.location.href="add
.jsp";
});
//绑定行内的编辑按钮点击事件
$('button[name=btnEdit]')
.on('click', function () {
let id = $(this)
.attr('data-id');//从当前点击的按钮身上获取data-id的值
window.location.href = 'edit
.jsp?id='+id;
});
//绑定行内的删除按钮点击事件
$('button[name=btnDelete]')
.on('click', function () {
if(confirm("确定要删除吗？")) {
//获取删除按钮所在行的编号(id)
let id = $(this)
.attr('data-id');//从当前点击的按钮身上获取data-id的值
//无刷新方式提交删除请求
postAction('/user/delete', {id: id}, function (res) {
alert(res
.msg);
if (res
.result)
window.location.href = res
.url;
});
}
});
</script>
</body>
</html>
请修改这些代码的错误
本文分享了一种简便的JS跨页面参数传递方法，避免了复杂的字符串截取和判断。通过正确的href赋值方式和使用隐藏input标签，轻松实现参数传递，使前后端交互更加高效。
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
