⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 modify_tcinfo.asp

📁 功能不是很全面,需要自己修改和添加.尊重作者版权,希望大家相互学习,提出意见和建议.
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!-- #include file="conn.asp" -->
<%
if session("admin")="" then
response.Write "<script language='javascript'>alert('网络超时或您还没有登陆!');window.location.href='login.html';</script>"
response.End
else
dim id,TcPost,TcDepart,TcEdu,TcPol
id=request.QueryString("id")
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Tc_Info where id="&id,conn,1,1
end if
%>
<!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 rel="stylesheet" type="text/css" href="main.css">
<title>管理教师信息</title>
<style type="text/css">
<!--
body {
	background-image: url(images/5.jpg);
}
-->
</style></head>

<body>
<div>
  <form id="form1" name="form1" method="post" action="saveTcinfo.asp">
    <strong>教师姓名</strong>    
    <input type="text" name="TcName" id="TcName" value="<%=rs("TcName")%>" />
    <br />
    <strong>教师性别 
    </strong>
    <select name="TcSex" id="TcSex">
  <% 
  if rs("TcSex")="男" then 
  %>
    <option value="男" selected="selected">男</option>
    <option value="女">女</option>
    <%else%>
    <option value="男">男</option>
    <option value="女" selected="selected">女</option>
    <%end if%>
  </select>
<br />
<strong>教师年龄</strong>
<input type="text" name="TcAge" id="TcAge" value="<%=rs("TcAge")%>" />
<br />
<strong>教师职称</strong>
<input name="TcPost" type="text" id="TcPost" size="20" value="<%=rs("TcPost")%>" />
 <%
	set rspost=server.CreateObject("adodb.recordset")
	rspost.open "select * from Post",conn,1,1
	%>
    <select name="select" onChange="(document.form1.TcPost.value)=this.options[this.selectedIndex].value">
      <option selected>请选择</option>
  <% do while not rspost.EOF %>
  <option value="<%=rspost("PostName")%>"><%=rspost("PostName")%></option>
  <%
    rspost.movenext
	loop
	rspost.close
	set rspost=nothing
	%>
</select>
<br />
<strong>所属部门</strong>
<input name="DepartName" type="text" id="DepartName" size="20" value="<%=rs("DepartName")%>" />
 <%
   set rsdep=server.CreateObject("adodb.recordset")
   rsdep.open "select Departid,DepartName from Depart",conn,1,1
   %>
   <select name="select1" onChange="(document.form1.DepartName.value)=this.options[this.selectedIndex].value">
      <option selected>请选择</option>
  <% do while not rsdep.EOF %>
  <option value="<%=rsdep("DepartName")%>"><%=rsdep("DepartName")%></option>
  <%
    rsdep.movenext
	loop
	rsdep.close
	set rsdep=nothing
	%>
</select>
<br />
<strong>教师学历</strong>
<input name="TcEdu" type="text" id="TcEdu" size="20" value="<%=rs("TcEdu")%>"/>
<%
   set rsedu=server.CreateObject("adodb.recordset")
   rsedu.open "select EduID,EduName from Edu",conn,1,1
   %>
   <select name="select2" onChange="(document.form1.TcEdu.value)=this.options[this.selectedIndex].value">
      <option selected>请选择</option>
      <% do while not rsedu.EOF %>
  
  <option value="<%=rsedu("EduName")%>"><%=rsedu("EduName")%></option>
  <%
    rsedu.movenext
	loop
	rsedu.close
	set rsedu=nothing
	%>
</select>
<br />
<strong>政治面貌</strong>
<input name="TcPolitical" type="text" id="TcPolitical" size="20" value="<%=rs("TcPolitical")%>"/>
 <%
   set rspol=server.CreateObject("adodb.recordset")
   rspol.open "select PolID,PolName from Political",conn,1,1 
   %>
   <select name="select3" onChange="(document.form1.TcPolitical.value)=this.options[this.selectedIndex].value">
      <option selected>请选择</option>
  <% do while not rspol.EOF %>
  <option value="<%=rspol("PolName")%>"><%=rspol("PolName")%></option>
  <%
    rspol.movenext
	loop
	rspol.close
	set rspol=nothing
	%>
</select>
<br />
<strong>入职时间</strong>
<input type="text" name="Add_Time" readonly="readonly" id="Add_Time" value="<%=rs("TcAddTime")%>" />
<br />
<input type="submit" name="add_TcInfo" id="add_TcInfo" value="确认修改" /><br />
<input type="hidden" name="id" value="<%=request.querystring("id")%>">
</form>
</div>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -