addc.asp

关于学生成绩的管理系统

<!--#include file="conn.asp"-->
<%
xino=request.form("xino")
zhuanyeno=request.form("zhuanyeno")
set rs=server.createobject("ADODB.Recordset")
sqlstr="select * from 系 where xino='"&request.form("xino")&"'"
rs.open sqlstr,conn,1,1
if not rs.eof then
  xiname=rs("xiname")
end if
set rs=server.createobject("ADODB.Recordset")
sqlstr="select * from 专业 where zhuanyeno='"&request.form("zhuanyeno")&"'"
rs.open sqlstr,conn,1,1
if not rs.eof then
  zhuanye=rs("zhuanye")
end if
   jino=request.form("jino")
   banno=request.form("banno")
   stnum=request.form("stnum")
   room=request.form("room")
   set rs=server.createobject("ADODB.Recordset")
   sqlstr="select * from 班级"
   rs.open sqlstr,conn,3,3
   rs.addnew
if zhuanyeno="--选择专业--" then
   response.write "<script language='javascript'>"
   response.write "alert('请输入专业');"
   response.write "history.back(1);"
   response.write "</script>"
   response.end
end if
if xino="--选择系--" then
   response.write "<script language='javascript'>"
   response.write "alert('请输入系');"
   response.write "history.back(1);"
   response.write "</script>"
   response.end
end if
if stnum="" then
   response.write "<script language='javascript'>"
   response.write "alert('请输入学生人数');"
    response.write "history.back(1);"
    response.write "</script>"
    response.end
end if
rs("classno")=xiname&zhuanye&jino&banno
rs("xino")=xino
rs("zhuanyeno")=zhuanyeno
rs("xiname")=xiname
rs("zhuanye")=zhuanye
rs("jino")=jino
rs("stnum")=stnum
rs("banno")=banno
rs("room")=room
rs.update
rs.close
response.redirect "kebiaoclass.asp"
%>