📄 复件 index.jsp
字号:
<%@ page contentType="text/html;charset=GBK" language="java" %><%@ page import="java.sql.*,java.util.*,java.io.*" %><%@ include file="conn.jsp"%><%@ include file="config.jsp"%><% int i=0,x=0;//计数器 int showrow=20;//每页显示条数 int pages=0;//当前页数 int start; //本页开始条数 String sql="select * from unit order by id desc"; java.sql.ResultSet rs = st.executeQuery(sql); //rs.next(); String strp=(String)request.getParameter("pages"); String pass=null; pass=(String)session.getAttribute("pass"); int sig=1,alt; if(strp==null){sig=1;}else{ for(int i1=0;i1<strp.length();i1++){ alt=strp.charAt(i1); if(alt<48||alt>57){ sig=1;break; }else{sig=2;} } } if(sig==1){pages=1;}else{pages=Integer.parseInt(strp);} rs.last(); int count=rs.getRow(); int laspc; int pa=count/showrow; if(count%showrow>0){pa=pa+1;laspc=count%showrow;}else{laspc=showrow;} if(pages<0)pages=1; if(pages>pa)pages=pa; start=(pages-1)*showrow+1;%><html><head><meta http-equiv="Content-Type" content="text/html; charset=GBK"><!--link href='css/main.css' rel='stylesheet' type='text/css'--><title></title><SCRIPT> function isHidden(oDiv){ var vDiv = document.getElementById(oDiv); vDiv.style.display = (vDiv.style.display == 'none')?'block':'none'; }</SCRIPT><STYLE type=text/css>INPUT { FONT-SIZE: 9pt}TD { FONT-SIZE: 9pt}BR { FONT-SIZE: 9pt}FONT { FONT-SIZE: 9pt}LI { FONT-SIZE: 9pt}P { FONT-SIZE: 9pt}OPTION { FONT-SIZE: 9pt}BODY { FONT-SIZE: 9pt}BODY { SCROLLBAR-FACE-COLOR: #a8cac7; SCROLLBAR-HIGHLIGHT-COLOR: #ffffff; SCROLLBAR-SHADOW-COLOR: #ffffff; SCROLLBAR-3DLIGHT-COLOR: #a8cac7; SCROLLBAR-ARROW-COLOR: #ffff00; SCROLLBAR-TRACK-COLOR: #deebea; SCROLLBAR-DARKSHADOW-COLOR: #a8cac7}SELECT { FONT-SIZE: 9pt; COLOR: #000000; FONT-FAMILY: 宋体, verdana, Arial, Helvetica, sans-serif; BACKGROUND-COLOR: #cfcfcf}TEXTAREA { FONT-SIZE: 9pt; COLOR: #000000; FONT-FAMILY: 宋体, verdana, Arial, Helvetica, sans-serif; BACKGROUND-COLOR: #cfcfcf}.bginput { FONT-SIZE: 9pt; COLOR: #000000; FONT-FAMILY: 宋体, verdana, Arial, Helvetica, sans-serif; BACKGROUND-COLOR: #cfcfcf}.style1 { font-size: x-large; font-weight: bold;}</STYLE></head><body topmargin="0" bgcolor="#ffffff"> <div align="center"> <p class="style1">测试</p> </div> <table width="100%" align="center" border="1" cellpadding="0" cellspacing="0" bordercolor="#bdbcbc" bordercolordark="#FFFFFF"> <% rs.absolute(start); rs.previous(); if(count==0) { out.print("<center><font color='#528e31'>没有找到记录！！</font></center>"); } while(rs.next()){ %> <tr> <td height="25" bgcolor="#f6fafa" class="nrzt" align="center"><%=rs.getString(2)%></td> <td bgcolor="#deebea"></td> <td bgcolor="#f6fafa" ></td> </tr> <% i++; if(i==showrow)break; } %></table> <p> </p> <p> </p> <table width="605" height="23" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="7"> </td> <td width="591"><div align="right"> <% if(pa<=5){ for(int j=1;j<pa+1;j++){ if(j==pages){%> <font color=#ff0000>第<%=pages%>页</font> <% }else{%> <a href="index.jsp?pages=<%=j%>">第<%=j%>页</a> <% } } }else if(pages<4){ for(int k=1;k<pages+3;k++){ if(k==pages){%> <font color=#ff0000>第<%=k%>页</font> <% }else{ %> <a href="index.jsp?pages=<%=k%>">第<%=k%>页</a> <% } } }else if((pa-pages)<4){ for(int l=pa-5;l<=pa;l++){if(l==pages){ %> <font color="#FF0000">第<%=l%>页</font> <% }else{ %> <a href="index.jsp?pages=<%=l%>">第<%=l%>页</a> <% }} }else{ for(int m=pages-3;m<pages+3;m++){if(m==pages){ %> <font color="#FF0000">第<%=m%>页</font> <% }else{ %> <a href="index.jsp?pages=<%=m%>">第<%=m%>页</a> <% }} }%> <span class="inp_set1">共<%=pa%>页 <%=count%>条</span> </div></td> <td width="10"> </td> </tr> </table></td> </tr> <tr> <td> </td> </tr> <tr> <td><div align="center"> <table width="304" height="16" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="19"> </td> <td width="148" class="copyright"></td> <td width="117"></td> <td width="20"> </td> </tr> </table> </div></td> </tr></table></body></html><%rs.close();st.close();con.close();%> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -