• ASP分页


    <TABLE cellSpacing=0 cellPadding=0 width="96%" border=0>
                  <TBODY>
                  <TR>
                    <TD align=left>
                      <UL>
          <%
      set rs=server.CreateObject("adodb.recordset")
            sql = "select  * from Ejz_User order by P_AddDate DESC"
            rs.Open sql,conn,1,1
      If rs.eof or rs.bof Then
          %>
           <LI class=txt> 没有找到您要查找的内容......
          <%
           else
           If cint(request("page"))<1 or request("page")="" Then
          ipage=1
         Else
          ipage=cint(request("page"))
         End if
          rs.pagesize=3
          pagecount=rs.pagecount
          rs.absolutepage=ipage
          While not rs.eof and i<rs.pagesize
          P_UserId   = rs("P_UserId")
          P_Hync  = rs("P_Hync")
          P_JuZhuDi_xian  = rs("P_JuZhuDi_xian")
          P_Hyzk  =rs("P_Hyzk")
          P_AddDate  =rs("P_AddDate")
              %>
                        <LI class=txt>
                        <a href="User/Xxxx/Show_1.Asp?P_UserId=<%=rs("P_UserId")%>" target="_blank" title="查看详细信息">
    <span style="float:left;150px;"><%=Left(rs("P_Hync"),6)%>&nbsp;,<%=Age(rs("P_BirthdayTime"))%>&nbsp;,<%=rs("P_JuZhuDi_xian")%></span><span style="float:right; 40px"><%=FormatDT(rs("P_AddDate"),7)%></span>
    </a>
           <%   
                    i=i+1
                       rs.movenext
                    wend
            end if
              %>
                        </LI></UL></TD></TR>
                  <TR>
                    <TD align=right>
                     <TABLE cellSpacing=0 cellPadding=0 width="98%" align=center border=0>
                                <TBODY>
                                  <TR>
                                    <TD width=512  height=1></TD>
                                  </TR>
                               
                                  <TR>
                                    <TD width="80%" align="right" class="Aqss-honglink STYLE1">
            <div align="right">
                                    <%if ipage=1 then%>
                                      <font color="#999999">【首页】</font>
                                      <%else%>
                                    <A href="?page=1">【首页】</A>
                                    <%end if%>
                                    <%if ipage=0 or ipage=1 then%>
                                      <font color="#999999">【上一页】</font>
                                      <%else%>
                                      <A href="?page=<%=ipage-1%>">【上一页】</A>
                                    <%end if%>
                                    <%if ipage=rs.pagecount then%>
                                      <font color="#999999">【下一页】</font>
                                      <%else%>
                                      <A href="?page=<%=ipage+1%>">【下一页】</A>
                                    <%end if%>
                                    <%if ipage=pagecount then%>
                                      <font color="#999999">【尾页】</font>
                                      <%else%>
                                      <A href="?page=<%=pagecount%>">【尾页】</A>
                                    <%end if%>
                                      </div></TD>
                                  </TR>
                              </TABLE>
             <%
            rs.close
            set rs=nothing
            %>
         </TD></TR></TBODY></TABLE>

     

  • 相关阅读:
    elasticsearch(一):JAVA api操作
    elasticsearch(一):安装与配置
    Apache POI导出excel
    Java实现验证码
    Java数据库连接池原理与简易实现
    SpringMvc注解开发
    类型转换的时候,.valueOf()和.parseX(),.Xvalue()的区别
    kmp算法模板
    java 的任意进制间转换(很方便)
    海伦-秦九韶公式(利用三角形的三边求面积)
  • 原文地址:https://www.cnblogs.com/liuswi/p/2754606.html
Copyright © 2020-2023  润新知