guanmem.jsp

JSP+MYSQL能飞网络办公OA系统

<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="top.jsp"%>

<TABLE id=Table1 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR id=main_section vAlign=top>
<TD>

      <TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR >
          <TD   class=welcomeleft id=left_pane vAlign=top width=155 >
            <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0  background=../images/back.gif height=586>
              <TBODY>
               <TR>
                <TD   valign=top>


<%@ include file="tool_mainmenu.jsp"%>





             </TD></TR>
             </TBODY></TABLE>

</TD><TD id=right_pane   background=../images/adminbodybg8.gif>



<!-- ### Right Pane Position ### -->

<div 
      style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 6px; WIDTH: 100%; PADDING-TOP: 6px; HEIGHT: 100%" 
      >
      <TABLE id="Table2" cellSpacing="0" cellPadding="0" width="100%" border="0" >
        <TBODY>
        <TR>
          <TD>
          
</td></TR></TABLE><div id="ContentPanel">
	
<div id="ColumnTitlePanel">
<span id="ColumnTitle" style="font-size:Medium;font-weight:bold;">帐号管理</span>


<BR>
<span id="ItemDescription1_Label1" class="description"></span>
<FONT 
      face="宋体"><BR></FONT>
	</div>



<TABLE cellSpacing="0" cellPadding="0" width="98%" align="center" border="0" class="article-page" bordercolor=red>

	<tr>
		<td class="article-page-body" height="100%" colspan="2" width="100%">
			<TABLE cellSpacing="0" cellPadding="0" width="100%" border="0" height="100%" bordercolor=blue>

				<TR>
					<TD valign="top">
						
<TABLE width="100%" border="0">
  <TR>
    <TD><FONT color="red">
</FONT><FONT color="blue">
</FONT></TD></TR></TABLE>
<table class="Grid" cellspacing="1" cellpadding="1" rules="cols" ItemCount="13" border="0" Style="border-width:0px;width:100%;">
			<tr class="Grid_Header">
				<td width=20%>
用名称

</td><td width=16%>
					<U>性别</U>
				
</td><td width=16%>
					<U>部门</U>
				
</td><td width=16%>
					<U>注册时间</U>
				
</td><td width=16%>
					<U>当前状态</U>
				
</td>
			</tr>








<%
rs=stmt.executeQuery("select * from member  order by id desc");
String pages = request.getParameter("page") ;
int pageInt =  1 ,i=0,mm=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 class="datalist<%if(mm==0){%>1<%mm++;}else{%>2<%mm=0;}%>">

<td><%if (rs.getString("systemop").compareTo("1")==0){%><img src=../images/admin.gif title="系统管理员"><%}else{%>
<%if(((rs.getString("sex")).compareTo("男")==0)||((rs.getString("sex")).compareTo("")==0)){%><img src=../images/man.gif><%}else{%><img src=../images/womem.gif><%}%>
<%}%>
<a href="modimem.jsp?username=<%=rs.getString("username")%>"><%=rs.getString("username")%></a></td>

<td><%=rs.getString("sex")%></td>

<td><%=rs.getString("bumen")%></td>

<td><%=rs.getString("regtime")%></td>

<td align=center><%if (rs.getString("flag").compareTo("1")==0){%><a href=to.jsp?id=<%=rs.getString("id")%>&flag=0><font color=cccccc>正常</font></a><%}else{%><a href=to.jsp?id=<%=rs.getString("id")%>&flag=1><font color=red>未能使用</font></a><%}%></td>
</tr>





<%}%>


<%
rs=stmt.executeQuery("SELECT count(*) from member");
while(rs.next()) i = rs.getInt(1) ;
%>

<tr class="pagemark" align="right">
<td colspan="4"><%@ include file="page.jsp"%>
</td>
</tr>
		</table>

	</div>
</TD>
				</TR>
			</TABLE>
		</td>
	</tr>
</TABLE>




</div></DIV>

<!-- ### Right Pane Position ### -->





</TD></TR></TBODY></TABLE></TD></TR>
</TBODY>
</table>






<%@ include file="end.jsp"%>
</BODY>
</HTML>