kechengxgz.asp

教务系统主要是老师和学生的一个平台

<!--#include file="connection.asp"-->
<%
oldlessonno=trim(request.form("oldlessonno"))
lessonno=trim(request.form("lessonno"))
lessonname=trim(request.form("lessonname"))
xino=trim(request.form("xino"))
zhuanyeno=trim(request.form("zhuanyeno"))
xueqi=trim(request.form("xueqi"))
teacherno=trim(request.form("teacherno"))

sqlstr="select * from 课程 where lessonno='" & oldlessonno &"'"
set rs1=server.createobject("ADODB.Recordset")
rs1.open sqlstr,CN ,3,3

if not rs1.eof then
rs1("lessonno")=lessonno
rs1("lessonname")=lessonname
rs1("xino")=xino
rs1("zhuanyeno")=zhuanyeno
rs1("xueqi")=xueqi
rs1("teacherno")=teacherno
rs1.update
rs1.close

response.write "<script language='javascript'>"
response.write "alert('修改成功！');"
response.write "history.back(1);"
response.write "</script>"
response.end
end if 
%>