📄 expert_modify.asp
字号:
<!--#include file="../Include/TimeOut.asp"-->
<!--#include file="../Include/AdoConn.asp"--><!--引入数据库连接模块-->
<%
set rst=server.createobject("ADODB.recordset")
ExpertCode=session("usercode")
Strsql="select * from xt_tc_Expert where 专家编码='"&ExpertCode&"'"
rst.open Strsql,strconn
%>
<%
submit=request("submit")
if not submit="" then
password1=request("password1")
question=request("question")
answer=request("answer")
strsql="update XT_TC_Expert set 密码='"&password1&"',查询密码问题='"&question&"',查询密码答案='"&answer&"' where 专家编码='"&Expertcode&"'"
conn.Execute strsql,1
Response.Write "已修改成功!<br>专家编码为:"&ExpertCode
response.end
end if
%>
<html>
<head>
<title>专家注册</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../CssLib/Cssbutton.css">
<link rel="stylesheet" href="../CssLib/Csslink.css">
</head>
<body text="#000000" bgcolor="#ffffff">
<img src="Images/title_edit_expert.gif" width="200" height="27"><font color="#00CCFF" size="1">★★★★★<font color="#00CCFF" size="1">★★★★★</font><font color="#00CCFF" size="1">★★★★★</font><font color="#00CCFF" size="1">★★★★★</font>★★</font><br>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="22" height="20"><img src="../public/images/edit_bg_zs.gif" width="21" height="20"></td>
<td background="../public/images/bg_left.gif" bgcolor="#0099FF">
<div align="center"></div>
</td>
<td width="10"><img src="../public/images/edit_bg_ys.gif" width="21" height="20"></td>
</tr>
<tr>
<td background="../public/images/bg_left.gif"> </td>
<td bgcolor="#FFFFFF" height="200">
<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
<form name="conlist" method="post" action="expert_modify.asp?Expertcode=<%=rst("专家编码")%>&submit=submit" >
<tr>
<td height="20" width="6%" bgcolor="#ffffff"> </td>
<td height="20" width="20%" bgcolor="#ffffff">
<div align="left"></div>
</td>
<td height="20" width="65%" bgcolor="#ffffff"> </td>
<td height="20" width="9%" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td height="20" width="6%" bgcolor="#eaeaea"> </td>
<td height="20" width="20%" bgcolor="#eaeaea">
<div align="left">专家编码</div>
</td>
<td height="20" width="65%" bgcolor="#eaeaea"><%=rst("专家编码")%></td>
<td height="20" width="9%" bgcolor="#eaeaea"> </td>
</tr>
<tr>
<td height="20" width="6%" bgcolor="white"> </td>
<td height="20" width="20%" bgcolor="white">
<div align="left"></div>
</td>
<td height="20" width="65%" bgcolor="white"> </td>
<td height="20" width="9%" bgcolor="white"> </td>
</tr>
<tr>
<td height="20" width="6%" bgcolor="#eaeaea"> </td>
<td height="20" width="20%" bgcolor="#eaeaea">
<div align="left">专家姓名</div>
</td>
<td height="20" width="65%" bgcolor="#eaeaea">
<%=rst("专家姓名")%>
<font color="#ff0000">**</font> （**为必填项，下同）</td>
<td height="20" width="9%" bgcolor="#eaeaea"> </td>
</tr>
<tr>
<td height="20" width="6%" bgcolor="white"> </td>
<td height="20" width="20%" bgcolor="white">
<div align="left"></div>
</td>
<td height="20" width="65%" bgcolor="white"> </td>
<td height="20" width="9%" bgcolor="white"> </td>
</tr>
<tr>
<td height="20" width="6%" bgcolor="#eaeaea"> </td>
<td height="20" width="20%" bgcolor="#eaeaea">
<div align="left">密码</div>
</td>
<td height="20" width="65%" bgcolor="#eaeaea">
<% if submit="" then %>
<input type="password" name="password1" maxlength=6 value="<%=rst("密码")%>">
<% else %>
<input type="password" name="Password1" maxlength=6>
<%end if%>
<font color="#ff0000">** </font> </td>
<td height="20" width="9%" bgcolor="#eaeaea"> </td>
</tr>
<tr>
<td height="20" width="6%" bgcolor="white"> </td>
<td height="20" width="20%" bgcolor="white">
<div align="left"></div>
</td>
<td height="20" width="65%" bgcolor="white"> </td>
<td height="20" width="9%" bgcolor="white"> </td>
</tr>
<tr>
<td height="20" width="6%" bgcolor="#eaeaea"> </td>
<td height="20" width="20%" bgcolor="#eaeaea">
<div align="left">确认密码</div>
</td>
<td height="20" width="65%" bgcolor="#eaeaea">
<input type="password" name="Password2" maxlength=6 value="<%=rst("密码")%>">
<font color="#ff0000">**</font> </td>
<td height="20" width="9%" bgcolor="#eaeaea"> </td>
</tr>
<tr>
<td height="20" width="6%" bgcolor="white"> </td>
<td height="20" width="20%" bgcolor="white">
<div align="left"></div>
</td>
<td height="20" width="65%" bgcolor="white"> </td>
<td height="20" width="9%" bgcolor="white"> </td>
</tr>
<tr>
<td height="20" width="6%" bgcolor="#eaeaea"> </td>
<td height="20" width="20%" bgcolor="#eaeaea">
<div align="left">查询密码问题</div>
</td>
<td height="20" width="65%" bgcolor="#eaeaea">
<input name="Question" size="30" maxlength=200 value="<%=rst("查询密码问题")%>">
<font color="#ff0000">**</font> </td>
<td height="20" width="9%" bgcolor="#eaeaea"> </td>
</tr>
<tr>
<td height="20" width="6%" bgcolor="white"> </td>
<td height="20" width="20%" bgcolor="white">
<div align="left"></div>
</td>
<td height="20" width="65%" bgcolor="white"> </td>
<td height="20" width="9%" bgcolor="white"> </td>
</tr>
<tr>
<td height="55" width="6%" bgcolor="#eaeaea"> </td>
<td height="55" width="20%" bgcolor="#eaeaea">查询密码问题答案</td>
<td height="55" width="65%" bgcolor="#eaeaea">
<input name="Answer" size="30" maxlength=200 value="<%=rst("查询密码答案")%>">
<font color="#ff0000">**</font> </td>
<td height="55" width="9%" bgcolor="#eaeaea"> </td>
</tr>
<tr>
<td height="20" width="6%" bgcolor="#ffffff"> </td>
<td height="20" width="20%" bgcolor="#ffffff"> </td>
<td height="20" width="65%" bgcolor="#ffffff"> </td>
<td height="20" width="9%" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td height="20" width="6%" bgcolor="#FFFFFF"> </td>
<td height="20" width="20%" bgcolor="#FFFFFF"> </td>
<td height="20" width="65%" bgcolor="#FFFFFF"> </td>
<td height="20" width="9%" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="20" colspan="4" bgcolor="#ffffff">
<div align="center">
<input class="button" type="submit" name="Submit" value="提交" onclick="return checkfun()">
<input class="button" type="reset" name="Submit2" value="重填">
<input class="button" type="button" name="Submit3" value="返回"onClick="back()">
</div>
</td>
</tr>
<tr>
<td height="20" width="6%" bgcolor="#ffffff"> </td>
<td height="20" width="20%" bgcolor="#ffffff"> </td>
<td height="20" width="65%" bgcolor="#ffffff"> </td>
<td height="20" width="9%" bgcolor="#ffffff"> </td>
</tr>
</form>
</table>
</td>
<td bgcolor="#FFFFFF" background="../public/images/bg_left.gif"> </td>
</tr>
<tr>
<td width="22"><img src="../public/images/edit_bg_zx.gif" width="21" height="20"></td>
<td bgcolor="#FFFFFF" background="../public/images/bg_left.gif" height="20"> </td>
<td width="10">
<div align="right"><img src="../public/images/edit_bg_yx.gif" width="21" height="20"></div>
</td>
</tr>
</table>
</body>
</html>
<script language="vbscript">
function checkfun() '校验表单
checkfun=true
if ConList.Password1.value <>ConList.Password2.value then
checkfun=false
window.alert "两次密码输入不一致，请重新输入！"
exit function
end if
if ConList.Password1.value ="" then
checkfun=false
window.alert "密码不能为空，请重新输入！"
exit function
end if
if ConList.Question.value ="" then
checkfun=false
window.alert "密码查询问题不能为空，请重新输入！"
exit function
end if
if ConList.Answer.value ="" then
checkfun=false
window.alert "查询问题答案不能为空，请重新输入！"
exit function
end if
end function
function back()
history.back
end function
</script>
<script language=javascript>
function open1()
{
window.open("../public/major_CodeHelp.asp?Table_name=Xt_TC_Major&Pname=major","帮助","height=220,width=330,toolbar=no,menubar=no,scrollbar=0,resizable=no,status=no,location=no")
}
</script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -