addnews.asp

教师在线查分系统

<!--#include file="conn.asp"--> 
<%if session("password")<>"" then%>
<%
if request("xh1")="" then
	response.write "<script language=JavaScript>" & chr(13) & "alert('学号栏要全部填写');" & "history.back()" & "</script>" 
	Response.End
end if
if request("xh2")="" then
	response.write "<script language=JavaScript>" & chr(13) & "alert('学号栏要全部填写');" & "history.back()" & "</script>" 
	Response.End
end if
if request("xh3")="" then
	response.write "<script language=JavaScript>" & chr(13) & "alert('学号栏要全部填写');" & "history.back()" & "</script>" 
	Response.End
end if
if request("xh4")="" then
	response.write "<script language=JavaScript>" & chr(13) & "alert('学号栏要全部填写');" & "history.back()" & "</script>" 
	Response.End
end if
if request("xh5")="" then
	response.write "<script language=JavaScript>" & chr(13) & "alert('学号栏要全部填写');" & "history.back()" & "</script>" 
	Response.End
end if
if request("xh6")="" then
	response.write "<script language=JavaScript>" & chr(13) & "alert('学号栏要全部填写');" & "history.back()" & "</script>" 
	Response.End
end if
xh1=Replace(Request.Form("xh1"),"'","''") 
user1=Replace(Request.Form("user1"),"'","''")
km1=Replace(Request.Form("km1"),"'","''") 
cj1=Replace(Request.Form("cj1"),"'","''") 
xh2=Replace(Request.Form("xh2"),"'","''") 
user2=Replace(Request.Form("user2"),"'","''") 
km2=Replace(Request.Form("km2"),"'","''")
cj2=Replace(Request.Form("cj2"),"'","''") 
xh3=Replace(Request.Form("xh3"),"'","''") 
user3=Replace(Request.Form("user3"),"'","''") 
km3=Replace(Request.Form("km3"),"'","''")
cj3=Replace(Request.Form("cj3"),"'","''") 
xh4=Replace(Request.Form("xh4"),"'","''") 
user4=Replace(Request.Form("user4"),"'","''")
km4=Replace(Request.Form("km4"),"'","''") 
cj4=Replace(Request.Form("cj4"),"'","''") 
xh5=Replace(Request.Form("xh5"),"'","''") 
user5=Replace(Request.Form("user5"),"'","''")
km5=Replace(Request.Form("km5"),"'","''") 
cj5=Replace(Request.Form("cj5"),"'","''") 
xh6=Replace(Request.Form("xh6"),"'","''") 
user6=Replace(Request.Form("user6"),"'","''") 
km6=Replace(Request.Form("km6"),"'","''")
cj6=Replace(Request.Form("cj6"),"'","''") 
set savebbs1=con.execute("insert into teacher1(tnum,tname,tsc,tscore)values('"&xh1&"','"&user1&"','"&km1&"','"&cj1&"')")
set savebbs2=con.execute("insert into teacher1(tnum,tname,tsc,tscore)values('"&xh2&"','"&user2&"','"&km2&"','"&cj2&"')")
set savebbs3=con.execute("insert into teacher1(tnum,tname,tsc,tscore)values('"&xh3&"','"&user3&"','"&km3&"','"&cj3&"')")
set savebbs4=con.execute("insert into teacher1(tnum,tname,tsc,tscore)values('"&xh4&"','"&user4&"','"&km4&"','"&cj4&"')")
set savebbs5=con.execute("insert into teacher1(tnum,tname,tsc,tscore)values('"&xh5&"','"&user5&"','"&km5&"','"&cj5&"')")
set savebbs6=con.execute("insert into teacher1(tnum,tname,tsc,tscore)values('"&xh6&"','"&user6&"','"&km6&"','"&cj6&"')")
	response.write "<script language=JavaScript>" & chr(13) & "alert('信息修改成功！');"&"window.location.href = 'gl.asp'"&" </script>" 
set savebbs=nothing 
%> 
%> 
<%else
Response.Redirect "dlu.asp"
end if%>