modify_yuanxi.asp

一个基于ＡＳＰ的学生管理系统

<!--#include file="inc/conn.asp"-->

<% 
id=Trim(Request.Form("id"))
yname=Trim(Request.Form("name"))
s=Trim(Request.Form("s"))
g=Trim(Request.Form("g"))
openDB
if s="1" then
   sql="update xueyuan set xy_name='"&yname&"',xy_id='"&id&"' where id="&g
   end if
if s="0" then
    sql="update xi set x_name='"&yname&"',x_id='"&id&"' where id="&g
end if
set rs=conn.execute(sql)	
closeDB
    Response.Redirect "add_yuanxi.asp"

 %>