<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="login.jdbc.*,java.util.*,java.sql.*" %><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><script type="text/javascript">function del(){//删除var obj=document.getElementsByName("in1");//获取值check_val=[];for(i=0;i<obj.length;i++){if(obj[i].checked){check_val.push(obj[i].value);//将所有选中的值传入数组中}}if(check_val.length<1){alert("您未选择删除对象，请选择至少一条");}else{//判断没有选中的情况location.href="../servlet/LoginServlet?name="+check_val+"&method=del"}//跳转到servlet中处理}//全选var a=0;function sel(){var obj=document.getElementsByName("in1");check_val=[];if(a%2==0){for(i=0;i<obj.length;i++){obj[i].checked=true;}}else{for(i=0;i<obj.length;i++){obj[i].checked=false;}}a++;}//跟新function update(){var obj=document.getElementsByName("in1");var check_val="";var check_val=[];for(i=0;i<obj.length;i++){ if(obj[i].checked){ check_val.push(obj[i].value); }}if(check_val.length>1||check_val.length<1){//当没有选或者选择多个是，重新选，将选定的取消alert("一次只能修改1条记录，请重新选择1条记录");for(i=0;i<obj.length;i++){obj[i].checked=false;}}else{location.href="../servlet/LoginServlet?name="+check_val+"&method=sele"}}function add(){location.href="add.jsp";}
<% List<Login> list2 = new LoginManage().queryAll();int pages;//当前页String pageStr=request.getParameter("pageStr");int count=list2.size();//数据长度int pageCount=3;//每页展示数据条数int lastPageCount = count%pageCount;int lastPage;int end;if(pageStr==null)//初始化{pages=1;}else{pages=Integer.parseInt(pageStr);//强制转换}if(lastPageCount==0){lastPage=count/pageCount;}else{lastPage=count/pageCount+1;}if(pages<1){pages=1;}if(pages>=lastPage){pages=lastPage;end=count-1;}else{end=pages*pageCount-1;}int begin=(pages-1)*pageCount;
%>
function firstpage()//首页{location.href="select.jsp?pageStr=1";}function prepage()//前一页{location.href="select.jsp?pageStr=<%=pages-1 %>";}function nextpage()//下一页{location.href="select.jsp?pageStr=<%=pages+1 %>";}function lastpage()//尾页{location.href="select.jsp?pageStr=<%=lastPage %>";}
</script>
<%--遍历数据库中的值，打印在表格中，同过连接字符串方式在for循环中 --%><body>
<TABLE border=1 align=center >
<TR><TD><input type="button" value="全选" οnclick="sel()"></TD><TD> NAME</TD> <TD>PASSWORD</TD><TD>SEX</TD><TD>CHARACTER</TD><TD>INTRO</TD></TR> <% List<Login> list = new LoginManage().queryAll(); for(int i=begin;i<=end;i++) { Login login = list.get(i); String na = login.getName(); String psw = login.getPassword(); String se = login.getSex(); String ch=login.getCharacter(); String in=login.getIntro(); %> <TR><TD><input type=checkbox name=in1 value=<%=na %>></TD><TD><%=na%></TD><TD><%=psw%></TD><TD><%=se%></TD><TD><%=ch%></TD><TD><%=in%></TD></TR> <% } %> </TABLE><br><div align=center><input type="button" name="method" value=DEL οnclick="del()"><input type="button" name=dete value=UPDATE οnclick="update()"><input type="button" name=dete value=ADD οnclick="add()"><br><br><a href="#" οnclick=firstpage()>首页</a><%if(pages>1){ %><a href="#" οnclick=prepage()>上一页</a> <%}else { %><a>上一页</a> <%} %><%if(pages<lastPage) {%><a href="#" οnclick=nextpage()>下一页</a><%} else{%><a>下一页</a><%} %><a href="#" οnclick=lastpage()>尾页</a><br><br>跳转到第<%--给定name是pageStr才能取到value，跳转到本页 --%><form action="select.jsp"><input type="text" name="pageStr" value=<%=pages %> /> <br><input type=submit name=submit value=提交 /></form></div></body></html>
转载于:https://www.cnblogs.com/yaer/p/5282558.html
