xy.asp

一对一校友录多班级而且非常漂亮http://free.cnyys.com/my/yhe/DEFAULT.ASP

<!--#include file="bjhead.asp"-->
<TABLE style="BORDER-RIGHT: #cccccc 1px solid; BORDER-LEFT: #cccccc 1px solid" 
cellSpacing=0 cellPadding=0 width=778 align=center bgColor=#ffffff>
  <TBODY>
  <TR vAlign=top>
    <TD width=200 bgColor=#f4f4f4>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR borderColor=#999999>
          <TD vAlign=center align=middle><IMG height=8 alt="" 
            src="../image/stu.htm" width=1 name=""></TD></TR>
        <TR>
          <TD vAlign=top height=350>
            <TABLE 
            style="BORDER-RIGHT: #cccccc 1px solid; BORDER-TOP: #cccccc 1px solid; BORDER-LEFT: #cccccc 1px solid; BORDER-BOTTOM: #cccccc 1px solid" 
            cellSpacing=0 cellPadding=0 width="90%" align=center 
bgColor=#ffffff>
              <TBODY>
              <TR>
                <TD>
                  <DIV align=center><IMG height=40 
                  src="../image/vxyfl.gif" width=180></DIV></TD></TR>
              <TR>
                <TD class=6>
                  <TABLE cellSpacing=6 cellPadding=0 width="100%" 
                    align=center><TBODY>
                    <TR>
                      <TD>
                       <TABLE id=AutoNumber2 style="BORDER-COLLAPSE: collapse" 
                        cellSpacing=0 cellPadding=3 width="100%" border=0>
                          <TBODY>
                          <TR>
                            <TD colSpan=2 height=22><IMG height=11 
                              src="../image/arrow00.gif" width=9> <A 
                              href="xy.asp?type=1">学校老师</A></TD>
                          </TR></TBODY></TABLE>
                        <TABLE id=AutoNumber2 style="BORDER-COLLAPSE: collapse" 
                        cellSpacing=0 cellPadding=3 width="100%" border=0>
                          <TBODY>
                          <TR>
                            <TD colSpan=2 height=22><IMG height=11 
                              src="../image/arrow00.gif" width=9><A 
                              href="xy.asp?type=2"> 学校同学</A></TD>
                          </TR></TBODY></TABLE>
                        <TABLE id=AutoNumber2 style="BORDER-COLLAPSE: collapse" 
                        cellSpacing=0 cellPadding=3 width="100%" border=0>
                          <TBODY>
                          <TR>
                            <TD colSpan=2 height=22><IMG height=11 
                              src="../image/arrow00.gif" width=9><A 
                              href="xy.asp?type=3"> 网站客人</A></TD>
                          </TR></TBODY></TABLE>
                        </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
            <TABLE id=AutoNumber4 cellSpacing=0 cellPadding=0 width="90%" 
            align=center border=0>
              <TBODY>
              <TR>
                <TD align=middle width="100%"><IMG height=8 alt="" 
                  src="../image/stu.htm" width=1 name=""></TD></TR></TBODY></TABLE>
            <TABLE id=AutoNumber4 
            style="BORDER-RIGHT: #cccccc 1px solid; BORDER-TOP: #cccccc 1px solid; BORDER-LEFT: #cccccc 1px solid; BORDER-BOTTOM: #cccccc 1px solid" 
            cellSpacing=0 cellPadding=0 width="90%" align=center 
bgColor=#ffffff>
              <TBODY>
              <TR>
                <TD align=middle width="100%"><IMG height=40 
                  src="../image/vxycx.gif" width=180></TD>
              </TR>
              <TR>
                <TD align=middle><IMG height=8 alt="" src="../image/stu.htm" 
                  width=1 name=""></TD></TR>
              <TR><form name="form1" method="post" action="">
                <TD align=middle>                  <div align="left">类别:
                        <select name="stype" size="1">
                          <option value="name" selected>姓名</option>
                          <option value="username">用户名</option>
                          <option value="userclass">班级</option>
                          <option value="userbirthday">生日</option>
<option value="qq">QQ</option>
                        </select>
                        <br>
 搜索:
                    <input name="czxy" type="text" id="czxy" size="15" value=<%=czxy%>>
                    <br>
                    <input type="submit" name="Submit" value="提交">
                   　  
                   <input type="reset" name="Submit2" value="重置">
                </div></TD>
                </form>
              </TR>
              <TR>
                <TD align=middle><IMG height=8 alt="" src="../image/stu.htm" 
                  width=1 name=""></TD></TR></TBODY></TABLE>
            </TD>
        </TR></TBODY></TABLE></TD>
    <TD bgColor=#cccccc><IMG height=1 alt="" src="../image/stu.htm" width=1 
      name=""></TD>
    <TD>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" align=center 
      bgColor=#ffffff border=0>
        <TBODY>
        <TR>
          <TD height=8 bgColor=#f4f4f4></TD></TR>
          <TD>
 <TABLE id=AutoNumber3 style="BORDER-COLLAPSE: collapse" 
            cellSpacing=0 cellPadding=0 width="100%" border=0>
              <TBODY>
              <TR>
                <TD vAlign=top height=52>
                  <TABLE id=AutoNumber5 style="BORDER-COLLAPSE: collapse" 
                  borderColor=#111111 cellSpacing=0 cellPadding=3 width="100%" 
                  border=0>
                    <TBODY>
                    <TR>
                      <TD class=6 width=463 background=../image/type_bg.gif 
                      height=30><IMG height=12 src="../image/type01.gif" width=12 
                        align=absMiddle> <span style="color: #CC3300">当前位置:</span>  <A 
            href="index.asp?clas=<%=session("clas")%>"><font color="#FF6699"><%=session("clas")%>首页</font></A> - <a href="?clas=<%=Session("clas")%>" style="color: #FF6699">班级同学</a> </TD>
                      <TD width=109 background=../image/type_bg.gif>
                        <DIV align=center><IMG src="../image/more.gif" 
                    border=0></DIV></TD></TR>
                    <TR>
                      <TD colSpan=2>
                        <DIV align=center>
                        <TABLE width="99%" border=0 align="center" cellPadding=0 cellSpacing=0 
                        background=../image/line1.gif>
                          <TR bgcolor="#FAF4E1">
                            <TD width="17%" height=20><div align="center" style="color: #CC3300">用户名</div></TD>
                            <TD width="18%" align=right><div align="center" style="color: #CC3300">姓名</div></TD>
                            <TD width="7%" align=left><div align="center" style="color: #CC3300">性别</div></TD>
                            <TD width="16%" align=left><div align="center" style="color: #CC3300">QQ</div></TD>
                            <TD width="16%" align=left><div align="center" style="color: #CC3300">班级</div></TD>
                            <TD width="16%" align=left><div align="center" style="color: #CC3300">生日</div></TD>
                            <TD width="10%" align=left><div align="center" style="color: #CC3300">用户类型</div></TD>
                          </TR>
<%
dim sql, czxy,typeid,stype,cur,rowcount,i,rs
typeid=request.QueryString("type")
czxy=request.form("czxy")
stype=request.form("stype")
 clas=Session("clas")
Set rs = Server.CreateObject("ADODB.recordset")
if typeid="" and czxy="" then
sql="select username,name,userbirthday,usersex,qq,userclass,usertype from user where userclass = '" &clas& "' order by joindate desc"
else
if czxy="" then
sql="select username,name,userbirthday,usersex,qq,userclass,usertype from user where userclass = '" &clas& "' and usertype='" & typeid &"' order by joindate desc"
else
sql="select username,name,userbirthday,usersex,qq,userclass,usertype from user where userclass = '" &clas& "' and "&stype&"='" &czxy& "' order by joindate desc"
end if
end if
cur=request.form("cur")
if cur="" then
cur=1
end if
rs.pagesize=20
rs.open sql,conn,1,1
if rs.eof then
response.write "<TR><TD>没有成员</TD></TR>"
else
rs.absolutepage=cint(cur)
rowcount=0
do while not rs.eof and rowcount<rs.pagesize%>
                          <TR>
                            <TD width="17%" height=20><div align="center"><L><FONT color=#0><a href="../datum.asp?username=<%=rs("Username")%>"><%=rs("Username")%></a></FONT></L></div></TD>
                            <TD align=right width="18%"><div align="center"><%=rs("name")%></div></TD>
                            <TD align=left><div align="center"><%=rs("usersex")%></div></TD>
                            <TD align=left> <div align="center"><%=rs("qq")%></div></TD>
                            <TD align=left> <div align="center"><%=rs("Userclass")%></div></TD>
                            <TD align=left><div align="center"><%=rs("UserBirthday")%></div></TD>
                            <TD align=left> <div align="center"><%=rs("usertype")%></div></TD>
                          </TR>
				<%rowcount=rowcount+1
				rs.movenext
      loop %>
                        </TABLE>
                        <table width="98%"  border="0">
  <tr><form name="form2" method="post" action=""><TD align=left bgcolor="#FAF4E1"><span class="style2"><span style="color: #CC3300">共<%=rs.recordcount%>人　 分<%=rs.pagecount%>页　　当前页次：<%=cur%>/<%=rs.pagecount%>　　　　　　　　　　　　　　　　　
    转到: </span>                      
          <select name="cur" size="1" onchange="javascript:submit()">
  <%for i = 1 to rs.pagecount%>              
    <option value="<%=i%>" <%if i=cint(cur) then%> selected <%end if%>>第<%=i%>页 </option>   
    <%next%>   
                      </select>
                      
    </span></td>
  </form>
  </tr>
  <%end if
  rs.close
	 set rs=nothing%>
</table> </DIV>
                    </TBODY></TABLE>
                 </TD></TR></TBODY></TABLE></TD></TR></TABLE></TD></TR></TBODY></TABLE>
<!--#include file="../bottom.asp"--></BODY></HTML>