📄 updategy.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/connect.asp" -->
<%
Dim rsgy__MMColParam
rsgy__MMColParam = "1"
If (Request.QueryString("gyid") <> "") Then
rsgy__MMColParam = Request.QueryString("gyid")
End If
%>
<%
Dim rsgy
Dim rsgy_numRows
Set rsgy = Server.CreateObject("ADODB.Recordset")
rsgy.ActiveConnection = MM_connect_STRING
rsgy.Source = "SELECT * FROM guyuan WHERE guyuanid = " + Replace(rsgy__MMColParam, "'", "''") + ""
rsgy.CursorType = 0
rsgy.CursorLocation = 2
rsgy.LockType = 1
rsgy.Open()
rsgy_numRows = 0
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#6699CC">
<form action="updategydm.asp?" method="post">
<table width="607" height="129" border="0" cellspacing="1" bgcolor="#000000">
<tr bgcolor="#666699">
<td colspan="4"><div align="center"><font color="#FFCC00"><strong>更新公司雇员信息</strong></font></div></td>
</tr>
<tr>
<td width="16%" bgcolor="#6699CC"><div align="right"><font color="#FFCC00" size="2">雇员姓名</font></div></td>
<td width="33%" bgcolor="#66aadd"><font color="#000000" size="2">
<input name="name" type="text" id="name2" value="<%=(rsgy.Fields.Item("name").Value)%>" size="20">
</font></td>
<td width="16%" bgcolor="#6699CC"><div align="right"><font color="#FFCC00" size="2">性别</font></div></td>
<td width="35%" bgcolor="#66aadd"><font color="#000000" size="2">
<input name="sex" type="text" id="sex2" value="<%=(rsgy.Fields.Item("sex").Value)%>" size="20">
</font></td>
</tr>
<tr>
<td bgcolor="#6699CC"><div align="right"><font color="#FFCC00" size="2">年龄</font></div></td>
<td bgcolor="#66aadd"><font color="#000000" size="2">
<input name="age" type="text" id="age" value="<%=(rsgy.Fields.Item("age").Value)%>" size="20">
</font></td>
<td bgcolor="#6699CC"><div align="right"><font color="#FFCC00" size="2">工作电话</font></div></td>
<td bgcolor="#66aadd"><font color="#000000" size="2">
<input name="tel" type="text" id="tel2" value="<%=(rsgy.Fields.Item("tel").Value)%>" size="20">
</font></td>
</tr>
<tr>
<td bgcolor="#6699CC"><div align="right"><font color="#FFCC00" size="2">职位</font></div></td>
<td bgcolor="#66aadd"><font color="#000000" size="2">
<input name="zhiwei" type="text" id="zhiwei2" value="<%=(rsgy.Fields.Item("zhiwei").Value)%>" size="20">
</font></td>
<td bgcolor="#6699CC"><div align="right"><font color="#FFCC00" size="2">所属部门</font></div></td>
<td bgcolor="#66aadd"><font color="#000000" size="2">
<input name="telw" type="text" id="telw2" value="<%=(rsgy.Fields.Item("telw").Value)%>" size="20">
</font></td>
</tr>
<tr>
<td bgcolor="#6699CC"><div align="right"><font color="#FFCC00" size="2">Email</font></div></td>
<td bgcolor="#66aadd"><font color="#000000" size="2">
<input name="email" type="text" id="email" value="<%=(rsgy.Fields.Item("email").Value)%>" size="20">
</font></td>
<td bgcolor="#6699CC"><div align="right"><font color="#FFCC00" size="2">地址</font></div></td>
<td bgcolor="#66aadd"><font color="#000000" size="2">
<input name="address" type="text" id="address3" value="<%=(rsgy.Fields.Item("address").Value)%>" size="20">
</font></td>
</tr>
<tr>
<td bgcolor="#6699CC">
<div align="right"></div></td>
<td colspan="3" bgcolor="#66aadd"><font color="#000000" size="2">
注意：雇员的ID号生成后不可变,如果想变更请与管理员联系.</font></td>
</tr>
</table>
<p align="center">
<input name="gyid" type="hidden" id="gyid" value="<%=(rsgy.Fields.Item("guyuanid").Value)%>">
<input type="submit" name="Submit" value="更新">
<input type="reset" name="Submit2" value="取消">
</p>
</form>
</body>
</html>
<%
rsgy.Close()
Set rsgy = Nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -