allmem.jsp
来自「database connection, database connection」· JSP 代码 · 共 295 行
JSP
295 行
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="top.jsp"%>
<TABLE id=Table1 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TR id=main_section vAlign=top>
<TD>
<TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0>
<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>
<TR>
<TD valign=top>
<%@ include file="msg_mainmenu.jsp"%>
</TD>
</TR>
</TABLE>
</TD>
<TD id=right_pane>
<!------------------------------>
<LINK href="../images/main.css" type="text/css" rel="stylesheet">
<TABLE cellSpacing="0" cellPadding="0" width="95%" align="center" border="0" class="article-page"style="MARGIN-LEFT: 5px">
<tr>
<td height="5"><img src=../images/xun.jpg> 员工通讯录</td>
</tr>
<TR>
<td class="article-page-tab"> </td>
</TR>
<tr>
<td class="article-page-body" height="100%" colspan="2">
<TABLE height="100%" cellSpacing="0" cellPadding="0" width="100%" border="0">
<TR height="2">
<TD colspan="2">
<table class="multiple-tool" height="0" cellSpacing="0" cellPadding="0" width="100%" align="left"border="0">
<tr>
<td noWrap width="1%">
<table cellSpacing="0" cellPadding="0" border="0" class="tool-item">
<tr>
<td nowrap class="tool-item-image" onclick="javascript:location.reload()" ><img id="uctrlList_itemRefresh_imgItem" src="../images/tool-recur.gif" border="0" style="height:16px;width:16px;" />
</td>
<td nowrap><span id="uctrlList_itemRefresh_labItem" onclick="javascript:location.reload()" >刷新</span>
</td>
</tr>
</table>
</td>
<td> </td>
</tr>
</table>
</td>
</tr>
<TR height="2">
<TD style="PADDING-RIGHT: 5px" vAlign="top" noWrap align="left" width="131">
<table class="form-header" cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td class="header-title"><img src=../images/view-sortup.gif> 部门列表</td>
</tr>
</table>
</TD>
<TD vAlign="top" noWrap align="left" width="100%">
<table class="form-header" cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td class="open-and-pack" noWrap width="1%" childPanel="user" nodeState="minus"> </td>
<td class="header-title">用户列表</td>
</tr>
</table>
</TD>
</TR>
<tr>
<td style="PADDING-RIGHT: 5px" vAlign="top" noWrap align="left" width="131" valign="top">
<TABLE class="form-body" id="organization" height="100%" cellSpacing="0" width="100%" align="left" border="0">
<tr>
<td height="100%" valign="top"><SPAN id="uctrlList_SPAN1" style="BORDER-RIGHT: silver 1px solid; BORDER-TOP: silver 1px solid; PADDING-LEFT: 5px; OVERFLOW: auto; BORDER-LEFT: silver 1px solid; WIDTH: 100%; BORDER-BOTTOM: silver 1px solid">
<table class="Grid" cellspacing="1" cellpadding="1" rules="all" border="0" height=200 style="border-width:0px;width:100%;">
<tr class="Grid_Item">
<td nowrap="nowrap">
<TABLE cellSpacing="0" cellPadding="0" width="100%" border="0" valign=top>
<tr valign=top>
<TD><a href=""><input class=buttonlinear onClick="location='allmem.jsp?space=4.3'" type=button value="公司组织架构"></a>
</TD>
</TR>
<tr valign=top>
<TD> </TD>
</TR>
<tr valign=top>
<TD><a href=""><input class=buttonlinear onClick="location='#'" type=button value="- 总经理室 -"></a>
</TD>
</TR>
<tr valign=top>
<TD> </TD>
</TR>
<%
rs=stmt.executeQuery("SELECT * from bumen");
while(rs.next()){%>
<tr valign=top>
<TD><a href=""><input class=buttonlinear onClick="location='?bumen=<%=rs.getString("bumenname")%>&space=<%=request.getParameter("space")%>'" type=button value="- <%=rs.getString("bumenname")%> -"></a>
</TD>
</TR>
<tr valign=top>
<TD> </TD>
</TR>
<%}%>
</TABLE>
</td>
</tr>
</table>
</SPAN>
</td>
</tr>
</TABLE>
</td>
<td valign="top" align="left" width="100%" nowrap>
<TABLE class="form-body" id="user" cellSpacing="0" align="left" border="0" height="200"width="100%">
<tr>
<td height="100%" valign="top">
<%%>
<table height="100%" cellSpacing="0" cellPadding="0" border="0">
<tr>
<td vAlign="top">
<table cellSpacing="0" align="left" border="0">
<tr height="250">
<td vAlign="top" noWrap width=600>
<table class="multiple-grid" cellspacing="0" rules="all" border="1"style="border-collapse:collapse;" width=650>
<tr>
<td class="header" width=25%>部 门:</td>
<td width=25%>
<table>
<tr>
<td nowrap><img src="../images/view-sortup.gif" border="0" ><span >总经理室</span>
</td>
</tr>
</table>
</td>
<td nowrap="nowrap" width=25% class="header">
<table cellSpacing="0" cellPadding="2" border="0" class="tool-item">
<tr><td nowrap >部门领导</td></tr>
</table>
</td>
<%rs=stmt.executeQuery("SELECT * from member where bumen='总经理'");
rs.next();%>
<td nowrap="nowrap" width=25%>
<table cellSpacing="0" cellPadding="2" border="0" class="tool-item">
<tr>
<td nowrap><%if(((rs.getString("sex")).compareTo("男")==0)||((rs.getString("sex")).compareTo("")==0)){%><img src=../images/man.gif><%}else{%><img src=../images/womem.gif><%}%> <a href=user.jsp?username=<%=rs.getString("username")%>><b><%=rs.getString("username")%></b></a></td>
</tr>
</table>
</td>
</tr>
</table>
<%
if(request.getParameter("bumen")==null){
rs=stmt.executeQuery("SELECT * from bumen");
}else{
rs=stmt.executeQuery("SELECT * from bumen where bumenname='"+request.getParameter("bumen")+"'");
}%>
<%while(rs.next()){%>
<table class="multiple-grid" cellspacing="0" rules="all" border="1"style="border-collapse:collapse;" width=650>
<tr>
<td class="header" width=25%>部 门:</td>
<td width=25%>
<table cellSpacing="0" cellPadding="2" border="0" class="tool-item">
<tr>
<td nowrap><img src="../images/view-sortup.gif" border="0" ><span ><%=rs.getString("bumenname")%></span></td>
</tr>
</table>
</td>
<td nowrap="nowrap" width=25% class="header" height=30>
<table cellSpacing="0" cellPadding="2" border="0" class="tool-item">
<tr><td nowrap >部门领导</td></tr>
</table>
</td>
<td nowrap="nowrap" width=25%>
<table cellSpacing="0" cellPadding="2" border="0" class="tool-item">
<tr>
<td nowrap>
<%if((rs.getString("bumenleader")).compareTo("未定")==0){%><a href=#>
<%}else{%>
<%stmt = con.createStatement() ;
String sql1="select * from member where username='"+rs.getString("bumenleader")+"' ";
ResultSet rs1=stmt.executeQuery(sql1);
rs1.next();
%>
<%if((rs1.getString("sex")).compareTo("男")==0){%><img src=../images/man.gif><%}else{%><img src=../images/womem.gif><%}%>
<a href=user.jsp?username=<%=rs.getString("bumenleader")%>><%}%><b><%=rs.getString("bumenleader")%></b></a>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<%int mm=0;
stmt = con.createStatement() ;
String sql2="select * from member where bumen='"+rs.getString("bumenname")+"' and flag=1 and username<>'"+rs.getString("bumenleader")+"' order by id desc";
ResultSet rs2=stmt.executeQuery(sql2);
while(rs2.next()){%>
<td width=25% height=30><span ><%if((rs2.getString("sex")).compareTo("男")==0){%><img src=../images/man.gif><%}else{%><img src=../images/womem.gif><%}%> <a href=user.jsp?username=<%=rs2.getString("username")%>><%=rs2.getString("username")%> [职员]</a></span></td>
<%if(mm==3){%>
</tr>
<%m=0;}else{mm++;}%>
<%}%>
</tr>
<br>
</table>
<%}%>
</td>
</tr>
</table>
</td>
</tr>
</TABLE>
</td>
</tr>
</TABLE>
<%%>
</td>
</tr>
</TABLE>
</form>
</body>
</HTML>
<!------------------------------>
</TD></TR></TBODY></TABLE>
</TBODY>
</table>
<%@ include file="end.jsp"%>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?