skillsave.asp
来自「一个不错的人才管理系统」· ASP 代码 · 共 47 行
ASP
47 行
<!--#include file="../conndb.asp"-->
<!--#include file="isUser.asp"-->
<html>
<head>
<title>保存技能信息</title>
</head>
<body>
<%
Function changechr(str)
changechr = Replace(str," "," ")
changechr = Replace(changechr,Chr(13),"<br>")
changechr = Replace(changechr,"'","‘")
End Function
Set rs = Server.CreateObject("ADODB.RECORDSET")
'判断是否存在此用户名技能信息
sql="Select * from Skill Where UserName='" &bb&"'"
rs.Open sql,Conn,1,3
If rs.EOF Then
rs.Close
'在数据库表Skill中插入新记录
sql="Select * from Skill"
rs.Open sql,Conn,1,3
rs.AddNew
rs("UserName")= Session("user_id")
rs("AppTitle") = Request("title")
rs("English") = Request("english")
rs("Computer") = Request("computer")
rs("Main") = changechr(Request("main"))
rs.Update
Else
'更改此技能信息
rs("AppTitle") = Request("title")
rs("English") = Request("english")
rs("Computer") = Request("computer")
rs("Main") = changechr(Request("main") )
rs.Update
End If
Response.Write "<h3>技能信息成功保存</h3>"
Set rs = Nothing
Response.Redirect "main.asp?flag=1"
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?