📄 allmem.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="top.jsp"%>
<TABLE cellSpacing=0 cellPadding=0 width=778 border=0>
<TBODY>
<TR>
<TD vAlign=top align=middle width=150 background=images/leftmanu_bg.gif>
<%@ include file="left.jsp"%>
</TD>
<TD style="BACKGROUND-POSITION: right 50%; BACKGROUND-IMAGE: url(images/bg1.gif); BACKGROUND-REPEAT: repeat-y; BACKGROUND-COLOR: #ffffff" vAlign=top align=middle width=628>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align=center>
<tr>
<td height="30"> </td>
</tr>
<tr>
<td><div align="center">
<table width="610" border="0" cellspacing="0" cellpadding="0" align=center>
<tr>
<td height="24" background="images/del_6.gif"><table width="285" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="102"><div align="center">
<p class="zl"></p>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="610" border="0" cellpadding="3" cellspacing="1" bgcolor="97C5E4">
<tr>
<td height="610" valign="top" bgcolor="#FFFFFF"><div align="center">
<table width="610" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20"> </td>
</tr>
<tr>
<td>
<div align=center>
<table width="521" border="0" cellspacing="0" cellpadding="0">
<form action="searchmem.jsp">
<tr>
<td height="24" bgcolor="E4E6E7"><table width="521" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30"><img src="../images/pointi.gif" ></td>
<td class="zl"><strong><font color="#1F69A0">所有注册会员</font></strong>
</td>
<td align=right><input name=txt ><input type=submit value=查找></td>
</tr>
</table></td>
</tr>
<tr>
<td height="18"> </td>
</tr>
</form>
<tr>
<td height="18" valign="top">
<form name="form1" method="post" action="cfsj.jsp">
<table width="521" border="0" cellpadding="3" cellspacing="1" bgcolor="A8A8A9">
<tr bgcolor="EAECED" class="zl">
<td width="60"><div align="center"><strong><font color="#333333">状态</font></strong></div></td>
<td width="60"><div align="center"><strong><font color="#333333">会员帐号</font></strong></div></td>
<td width="191"><div align="center"><strong><font color="#333333">会员企业</font></strong></div></td>
<td width="70" bgcolor="EAECED">
<div align="center"><strong><font color="#333333">申请时间</font></strong></div></td>
<td width="50" bgcolor="EAECED"><div align="center"><strong><font color="#333333">编辑</font></strong></div></td>
<td width="50" bgcolor="EAECED"><div align="center"><strong><font color="#333333">TO</font></strong></div></td>
<td width="50" bgcolor="EAECED"><div align="center"><strong><font color="#333333">TO</font></strong></div></td>
<td width="50" bgcolor="EAECED"><div align="center"><strong><font color="#333333">冻结</font></strong></div></td>
</tr>
<%
String dlid=(String) session.getAttribute("dlid");
stmt = con.createStatement() ;
rs=stmt.executeQuery("SELECT * from qyml where dlid='"+dlid+"' order by id desc");
String pages = request.getParameter("page") ;
int pageInt = 1 ,i=0 ;
if(pages==null){}else{pageInt = Integer.parseInt(pages);}
while(i<20*(pageInt-1)&&rs.next()){i++ ;}
i=0;
while(rs.next()&i<20){
i++ ;
%>
<tr bgcolor="#FFFFFF">
<td class="zl">
<div align="center"><font color="red">
<%if(Integer.parseInt((String)rs.getString("yue"))==0){%><font color=red>新会员</font><%}%> <%if(Integer.parseInt((String)rs.getString("yue"))==1){%>
<%if(Integer.parseInt((String)rs.getString("frocen"))==1){%><font color=cccccc>冻结会员</font><%}else{
if(Integer.parseInt((String)rs.getString("vip"))==0){out.print("<font color=blue>普通会员</font>");}else{
out.print("<font color=orange>企富通会员</font>");}%><%}%><%}%>
</font></a></div></td>
<td class="zl">
<div align="center"><a href="../info/renzheng.jsp?id=<%=rs.getString("username")%>" target="_blank" class="zllink"><font color="#333333">
<%=rs.getString("username")%>
</font></a></div></td>
<td class="zl">
<div align="center"><a href="../web/index.jsp?id=<%=rs.getString("id")%>" target="_blank" class="zllink"><font color="#333333">
<%=rs.getString("qymc")%>
</font></a></div></td>
<td class="zl">
<div align="center"><font color="#333333"><%=rs.getString("regtime")%></font></div></td>
<td class="zl"><div align="center"><a href="xgmem.jsp?id=<%=rs.getString("id")%>" class="zllink"><font color="#333333">修改</font></a></div></td>
<td class="zl"><div align="center"><a href="to.jsp?id=<%=rs.getString("id")%>&yue=1&comeon=0&vip=0&frocen=0" class="zllink"><font color="#333333">普通</font></a></div></td>
<td class="zl"><div align="center"><a href="to.jsp?id=<%=rs.getString("id")%>&yue=1&comeon=1&vip=1&frocen=0" class="zllink"><font color="#333333">企富通</font></a></div></td>
<td class="zl"> <div align="center"><a href="to.jsp?id=<%=rs.getString("id")%>&yue=1&comeon=0&vip=0&frocen=1" class="zllink"><font color="#333333">冻结</font></a></div></td>
</tr>
<%
}
%>
<tr bgcolor="#FFFFFF">
<td height="30" colspan="7" bgcolor="#FFFFFF" class="zl">
<div align="center">
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="39"><div align="right">
</div></td>
</tr>
</table>
</div></td>
</tr>
<%
rs=stmt.executeQuery("SELECT count(*) from qyml where dlid='"+dlid+"' order by id desc");
while(rs.next()) i = rs.getInt(1) ;
%>
<tr bgcolor="#FFFFFF">
<td height="30" colspan="7" bgcolor="#FFFFFF" class="zl"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" align=right><font size="2">
<font color="#000000">总共</font><font color="#FF0000"><%=i%></font><font color="#000000">条信息</font>
共<font color="#000000"><%=(i+20)/20%>页</font> 当前为<font color="#000000">第</font><font color="#FF0000"><%=pageInt%></font><font color="#000000">页</font> 转到第 <%for(int j=1;j<(i+40)/20;j++){%><a href="allmem.jsp?page=<%=j%>"><font color=red><%=j%></font></a> <%}%>页
</font></div></td>
</tr>
</table></td>
</tr>
</table> </td>
</tr>
</table>
<%
rs.close();
stmt.close();
con.close();
%>
</td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td height="25"> </td>
</tr>
</table>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td height="40"> </td>
</tr>
</table>
</div></td>
</tr>
</table>
</div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</div>
</TD></TR></TBODY></TABLE><IMG
height=10 src="images/bottom.gif" width=778><BR>
<%@ include file="end.jsp"%>
</BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -