notecon.asp

一路飞扬在线同学录单班级版,主要用于个人系统中的同学录,不过对于学习有帮助!

<!--#include file="inc/DB.INC"-->
<%

userid=session("myuserid")
password=session("mypwd")
if userid="" then
%>
<script language="Javascript">
alert("你还没有登录，无权进入!");
parent.location.href="index.asp";
</script>
<%
end if
id=request("flag")
content=request.form("content")
content=replace(content,"'","''",1)
content=replace(content,"<","〈",1)
content=replace(content,">","〉",1)
if id="add" then
posttime=now()
set rs=server.createobject("ADODB.Recordset")
	sql="select truename from txluser where userid='"&userid&"'"
	rs.open sql,conn,1,1
truename=rs("truename")
rs.close
set rs=nothing
sql="insert into classnote(userid,posttime,content,truename) values('"
sql=sql&userid&"','"&posttime&"','"&content&"','"&truename&"')"
conn.execute(sql)
response.redirect "note.asp" 
else
conn.execute "update classnote set content='"&content&"' where id="&id
conn.close
set conn=nothing
response.redirect "note.asp" 
end if%>