<!--#include file="conn.asp"-->
<%
  if session("adminname")="" then
  response.redirect "relogin.asp"
  end if

%>
<%
exam_subject=trim(request("exam_subject"))
sql="select * from tbnianji"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
rs.addnew
rs("nianji")=exam_subject
rs.update

sql1="select * from tbpower"
set rs1=server.createobject("adodb.recordset")
rs1.open sql1,conn,3,2

sql2="select * from tbbanji"
set rs2=server.createobject("adodb.recordset")
rs2.open sql2,conn,3,2

sql3="select * from tbnianji where nianji='"&exam_subject&"'"
set rs3=server.createobject("adodb.recordset")
rs3.open sql3,conn,3,2

do while not rs2.eof
rs1.addnew
rs1("banjiid")=rs2("banjiid")
rs1("nianjiid")=rs3("nianjiid")
rs1.update
rs2.movenext
loop

response.redirect "adminnianji.asp"
%>