<%@ 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>
请修改这些代码的错误
扫一扫
4970
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
