📄 upok.asp
字号:
<%
if session("password")<>"" then '判断session会话
%>
<html>
<head>
<title>修改简历</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="site.css">
<style type="text/css">
<!--
body {
background-color: #99CC00;
}
body,td,th {
color: #666666;
font-size: 14px;
font-weight: bold;
}
-->
</style></head>
<body leftmargin="0" topmargin="5">
<!--#include file="conn.asp"-->
<%
'将update.asp中提交的数据保存在变量中
c_id = Request("id")
c_name = Request.Form("name") '取得个人信息
c_sex= Request.Form("sex")
c_nl= Request.Form("nl")
c_csny= Request.Form("csny")
c_tel= Request.Form("tel")
c_email= Request.Form("email")
c_byyx= Request.Form("byyx")
c_jtdz= Request.Form("jtdz")
c_zy= Request.Form("zy")
c_xlxx= Request.Form("xlxx")
c_qzyx= Request.Form("qzyx")
c_tc = Request.Form("tc") '取得特长信息
c_tc = Server.HTMLEncode(Request.Form("tc"))
c_tc = Replace( c_tc, vbCrLf, "<br>")
c_tc = Replace( c_tc, "'", "''")
c_gzjy = Request.Form("gzjy") '取得工作经验
c_gzjy = Server.HTMLEncode(Request.Form("gzjy"))
c_gzjy = Replace( c_gzjy, vbCrLf, "<br>")
c_gzjy = Replace( c_gzjy, "'", "''")
c_shjx = Request.Form("shjx") '取得获奖信息
c_shjx = Server.HTMLEncode(Request.Form("shjx"))
c_shjx = Replace( c_shjx, vbCrLf, "<br>")
c_shjx = Replace( c_shjx, "'", "''")
c_qt = Request.Form("qt") '取得其他技能信息
c_qt = Server.HTMLEncode(Request.Form("qt"))
c_qt = Replace( c_qt, vbCrLf, "<br>")
c_qt = Replace( c_qt, "'", "''")
c_mb= Request.Form("mb") '取得模板信息
'更新数据表
SQLcmd = "update qzjl set "
SQLcmd = SQLcmd & "name='" & c_name & "',sex='" & c_sex & "',nl='" & c_nl & "',csny='" & c_csny & "',jtdz='" & c_jtdz & "', byyx='" & c_byyx & "',tel='" & c_tel & "',email='" & c_email & "',qzyx='" & c_qzyx & "',zy='" & c_zy & "',tc='" & c_tc & "',qt='" & c_qt & "',xlxx='" & c_xlxx & "',gzjy='" & c_gzjy & "',mb='" & c_mb & "',shjx='" & c_shjx & "' where id="& c_id
'生成提示页面
response.write "<table width='100%' border=0 cellspacing=0 cellpadding=0 height='100%'><tr><td>"
response.write "<br><br><table width=250 border=1 cellspacing=2 cellpadding=2 align=center bordercolorlight=7285CF bordercolordark=7285CF height=90 bgcolor=F2F2F2>"
response.write "<tr bordercolor=F2F2F2 bgcolor=F2F2F2 align=center> "
response.write "<td>修改成功！</td>"
response.write "</tr>"
response.write "<tr bordercolor=F2F2F2 bgcolor=F2F2F2 align=center> "
response.write "<td>您修改的记录已成功加入数据库！</td>"
response.write "</tr>"
response.write "</table>"
response.write "</td></tr></table>"
conn.Execute SQLcmd
%>
</body>
</html>
<%
else
Response.Redirect "login.asp" '否则转换到login.asp页面
end if
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -