📄 dept.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!-- #include file="const.asp" -->
<%
Dim rs
Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = dbconn
rs.Source = "SELECT dept_id, dept_name, dept_mng, dept_mngpwd, truename FROM dept ORDER BY dept_id ASC"
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 1
rs.Open()
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="img/Style.css" rel="stylesheet" type="text/css" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE2 {color: #FFFFFF; }
-->
</style>
</head>
<body>
<p><br />
</p>
<table width="80%" border="0" align="center" cellpadding="2" cellspacing="1" class="atable1">
<tr>
<td width="10%" bgcolor="#333333"><div align="center" class="STYLE2">
<div align="center">编号</div>
</div></td>
<td width="28%" bgcolor="#333333"><div align="center" class="STYLE2">
<div align="center">部门名称</div>
</div></td>
<td width="15%" bgcolor="#333333"><div align="center" class="STYLE2">
<div align="center">负责人账号</div>
</div></td>
<td width="13%" bgcolor="#333333"><div align="center" class="STYLE2">
<div align="center">负责人密码</div>
</div></td>
<td width="15%" bgcolor="#333333"><div align="center" class="STYLE2">
<div align="center">负责人姓名</div>
</div></td>
<td width="19%" bgcolor="#333333"><div align="center" class="STYLE2">
<div align="center"><a href="dept_add.asp" style="font-family:Arial, Helvetica, sans-serif; font-weight:bolder; color:#FFFFFF" title="添加部门"><strong>添加部门</strong></a></div>
</div></td>
</tr>
<%if rs.eof then%>
<tr>
<td colspan="6" class="tdmenu"><div align="center"><br />还没有部门，<a href="dept_add.asp">请添加</a><br /> <br /></div></td>
</tr>
<%else%>
<%do while not rs.eof %>
<tr>
<td class="tdmenu"><div align="center"><%=(rs.Fields.Item("dept_id").Value)%></div></td>
<td class="tdmenu"><div align="center"><%=(rs.Fields.Item("dept_name").Value)%></div></td>
<td class="tdmenu"><div align="center"><%=(rs.Fields.Item("dept_mng").Value)%></div></td>
<td class="tdmenu"><div align="center"><%=(rs.Fields.Item("dept_mngpwd").Value)%></div></td>
<td class="tdmenu"><div align="center"><%=(rs.Fields.Item("truename").Value)%></div></td>
<td class="tdmenu"><div align="center"><a href="dept_del.asp?dept_id=<%=rs.Fields.Item("dept_id").Value%>" onclick="javascript:if (!window.confirm('Are you sure to delete this department?')) return false;">删除</a> <a href="dept_update.asp?dept_id=<%=rs.Fields.Item("dept_id").Value%>">修改</a></div></td>
</tr>
<%
rs.movenext()
loop
end if
%>
</table>
</body>
</html>
<%
rs.Close()
Set rs = Nothing
dbconn.close
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -