<!--#include file="../SQLconn.asp"-->
<%

years=request.cookies("nowxueqi")
grade = Request.Form("grade")
sclass = Request.Form("tclass")
tongyibianhao=Request.Form("tongyibianhao")
sNumber = Request.Form("tNumber")
Uname = Request.Form("Uname")
strsex = Request.Form("sex")
strjiazhang = Request.Form("jiazhangxingming")
strjiatingdizhi = Request.Form("jiatingdizhi")
strbirthday = Request.Form("bdate")
strhujiszd = Request.Form("hjszd")
strhujitype = Request.Form("hjtype")
strhujixingzhi = Request.Form("huxingzhi")
strxslaiyuan = Request.Form("slaiyuan")

strmemo = Request.Form("memoa")

stroldschool = Request.Form("oldschool")
strminzu = Request.Form("mingz")
strzhengzhi = Request.Form("zhengzh")
strjiudufangshi = Request.Form("stype")
strjiankang = Request.Form("jiank")
strhukou = Request.Form("hk")
strmailNo = Request.Form("mail")
strphoneNo = Request.Form("phone")
strtechang = Request.Form("tc")
ruxueyear = Request.Form("ruxueyear")
shengfenzhenghao = Request.Form("shengfenzhenghao")
jiazhangguanxi = Request.Form("jiazhangguanxi")
jiazhangdanwei = Request.Form("jiazhangdanwei")
zhengzhidate = Request.Form("zhengzhidate")
shifouhuaqiao = Request.Form("shifouhuaqiao")


strsql="insert into students(years,grade,class,tongyibianhao,Number,Uname,sex,jiazhangxingming,jiatingdizhi,birthday,hujiszd,hujitype,hujixingzhi,xslaiyuan,OldSchool,minzu,zhengzhi,jiudufangshi,jiankang,hukou,mailNo,phoneNo,techang,memo,入学年份,身份证号码,加入政治面貌日期,是否华侨,和家长关系,家长工作单位)  values('"&years& "','"&grade& "','"&sclass& "','"&tongyibianhao& "','"&sNumber& "','"&Uname& "','"&strsex& "','"&strjiazhang& "','"&strjiatingdizhi& "','"&strbirthday& "','"&strhujiszd& "','"&strhujitype& "','"&strhujixingzhi& "','"&strxslaiyuan& "','"&stroldschool& "','"&strminzu& "','"&strzhengzhi& "','"&strjiudufangshi& "','"&strjiankang& "','"&strhukou& "','"&strmailNo& "','"&strphoneNo& "','"&strtechang& "','"&strmemo& "','"&ruxueyear& "','"&shengfenzhenghao& "','"&zhengzhidate& "','"&shifouhuaqiao& "','"&jiazhangguanxi& "','"&jiazhangdanwei& "')"

conn.execute(strsql)
response.redirect   "student.asp?years="&years&"&selgrade="&grade&"&selclass="&sclass
                
%>
