zhuanyexgz.asp

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

<!--#include file="connection.asp"-->
<%
oldxino=trim(request.form("oldxino"))
oldzhuanyeno=trim(request.form("oldzhuanyeno"))
xino=trim(request.form("xino"))
xiname=trim(request.form("xiname"))
zhuanyeno=trim(request.form("zhuanyeno"))
zhuanye=trim(request.form("zhuanyename"))

sqlstr="select * from 专业 where xino='" & oldxino &"' and zhuanyeno='" & oldzhuanyeno &"'"
set rs1=server.createobject("ADODB.Recordset")
rs1.open sqlstr,CN ,3,3

if not rs1.eof then
rs1("xino")=xino
rs1("zhuanyeno")=zhuanyeno
rs1("zhuanye")=zhuanye
rs1.update
rs1.close

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