<!--#include file="conn.asp"-->
<%
classno=request.form("classno")
if classno="--選擇班級--" then
   response.write "<script language='javascript'>"
   response.write "alert('請選擇班級');"
   response.write "history.back(1);"
   response.write "</script>"
   response.end
end if

set rs=server.createobject("ADODB.Recordset")
sqlstr="select * from 班級 where classno='"&request.form("classno")&"'"
rs.open sqlstr,conn,1,1
if not rs.eof then
  zhuanye=rs("zhuanye")
  xiname=rs("xiname")
  jino=rs("jino")
  banno=rs("banno")
end if
%>
<%
lessonname=request.form("lessonname")
xueqi=request.form("xueqi")
set rs=server.createobject("ADODB.Recordset")
sqlstr="select * from 上課"
rs.open sqlstr,conn,3,3
rs.addnew
if lessonname="" then
   response.write "<script language='javascript'>"
   response.write "alert('請輸入課程名');"
   response.write "history.back(1);"
   response.write "</script>"
   response.end
   end if
rs("xiname")=xiname
rs("zhuanye")=zhuanye
rs("jino")=jino
rs("banno")=banno
rs("lessonname")=lessonname
rs("xueqi")=xueqi
rs("classno")=classno
rs.update
rs.close
response.redirect "scoreaddke.asp"
%>