📄 jxxyquanbu.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="../../Connections/jiazheng.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_jiazheng_STRING
Recordset1.Source = "SELECT * FROM 教员详细资料"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = 6
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<%
Dim MM_paramName
%>
<%
' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters
Dim MM_keepNone
Dim MM_keepURL
Dim MM_keepForm
Dim MM_keepBoth
Dim MM_removeList
Dim MM_item
Dim MM_nextItem
' create the list of parameters which should not be maintained
MM_removeList = "&index="
If (MM_paramName <> "") Then
MM_removeList = MM_removeList & "&" & MM_paramName & "="
End If
MM_keepURL=""
MM_keepForm=""
MM_keepBoth=""
MM_keepNone=""
' add the URL parameters to the MM_keepURL string
For Each MM_item In Request.QueryString
MM_nextItem = "&" & MM_item & "="
If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item))
End If
Next
' add the Form variables to the MM_keepForm string
For Each MM_item In Request.Form
MM_nextItem = "&" & MM_item & "="
If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item))
End If
Next
' create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL & MM_keepForm
If (MM_keepBoth <> "") Then
MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1)
End If
If (MM_keepURL <> "") Then
MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1)
End If
If (MM_keepForm <> "") Then
MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)
End If
' a utility function used for adding additional parameters to these strings
Function MM_joinChar(firstItem)
If (firstItem <> "") Then
MM_joinChar = "&"
Else
MM_joinChar = ""
End If
End Function
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.style1 {
font-size: 16px;
font-family: "幼圆";
color: #006699;
}
.style2 {font-size: 16px}
.style3 {color: #000033}
a:link {
color: #003366;
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #003366;
}
a:hover {
text-decoration: underline;
}
a:active {
text-decoration: none;
}
-->
</style>
</head>
<body>
<div align="center">
<table width="800" border="0" cellspacing="1" bgcolor="#006699">
<tr>
<td bgcolor="#FFFFFF"><img src="../../image/a0001.jpg" alt="" width="800" height="138"></td>
</tr>
<tr>
<td height="400" align="center" valign="top" bgcolor="#FFFFFF"><p> </p>
<table width="750" border="0">
<tr>
<td><div align="right" class="style1"><a href="ziliaochaxun_fenlei.asp">返回</a></div></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<div align="right"></div>
<div align="right"></div> <div align="center">
<table width="760" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC">
<tr bgcolor="#FFFFFF" class="style1">
<td><div align="center" class="style1">教员姓名</div></td>
<td><div align="center">性别</div></td>
<td><div align="center">年龄</div></td>
<td><div align="center">职业</div></td>
<td><div align="center">学历</div></td>
<td><div align="center">教授科目１</div></td>
<td><div align="center">教授科目２</div></td>
<td><div align="center">聘用状态</div></td>
<td width="60"><div align="center">更新</div></td>
</tr>
<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
<tr bgcolor="#FFFFFF">
<td><div align="center"><span class="style2"><span class="style2"><%=(Recordset1.Fields.Item("姓名").Value)%></span></span></div></td>
<td><div align="center"><span class="style2"><span class="style2"><%=(Recordset1.Fields.Item("性别").Value)%></span></span></div></td>
<td><div align="center"><span class="style2"><span class="style2"><%=(Recordset1.Fields.Item("年龄").Value)%></span></span></div></td>
<td><div align="center"><span class="style2"><span class="style2"><%=(Recordset1.Fields.Item("职业").Value)%></span></span></div></td>
<td><div align="center"><span class="style2"><span class="style2"><%=(Recordset1.Fields.Item("学历").Value)%></span></span></div></td>
<td><div align="center"><span class="style2"><span class="style2"><%=(Recordset1.Fields.Item("教授科目1").Value)%></span></span></div></td>
<td><div align="center"><span class="style2"><span class="style2"><%=(Recordset1.Fields.Item("教授科目2").Value)%></span></span></div></td>
<td><div align="center"><span class="style2"><span class="style2"><%=(Recordset1.Fields.Item("聘用状态").Value)%></span></span></div></td>
<td width="60"><span class="style2"><A HREF="xinxigengxin.asp?<%= Server.HTMLEncode(MM_keepURL) & MM_joinChar(MM_keepURL) & "教员编号=" & Recordset1.Fields.Item("教员编号").Value %>">更新</A></span></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
</table>
</div>
<div align="right"></div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
</tr>
</table>
</div>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -