jimmy.txt

学生类：Student 教师类：Teacher 主任：AdminTeacher 班主任：MasterTeacher 授课老师： PrelectTeacher 班级类：classTeam 班

foreign key(stuGrade1) references ClassInfo(claID),	--一期班级编号
	stuGrade2 varchar(10) default '0000' constraint FK_StudentInfo_stuGrade2
foreign key(stuGrade2) references ClassInfo(claID),	--二期班级编号
	stuGrade3 varchar(10) default '0000' constraint FK_StudentInfo_stuGrade3
foreign key(stuGrade3) references ClassInfo(claID),	--三期班级编号
	stuAt_School bit not null default 1,		--是否在校 0：已毕业或离校  1：在校学习（默认）
	stuRemark text default '',			--备注
	stuID int identity(10001,1) primary key 	--学生编号
)
go



------------------------------输入学生基本信息表数据----------------------------------------
--插入一条公共学生信息，其本身并不存在，作为必要时的默认值是用
insert studentinfo values('北大青鸟',0,'北京市','中华民族','13800000000','北京市西城区复兴门','100000',default,default,default,1,'模拟学生')
----输入实际学生信息
----S150班成员学生信息----
insert studentinfo values('郑春',1,'河北高邑','维吾尔族','13800000565','北京市海淀区西山旗一街','100085','S150','S231',default,1,default)
insert studentinfo values('龚卫星',0,'河北高邑','陕西扶风','13800000002','陕西省扶风县揉谷乡新集村1组','100085','S150','S231',default,1,default)
insert studentinfo values('赵方国',1,'甘肃甘谷','维吾尔族','13800077003','甘肃省甘谷县金谷乡蒲家山村东组','100085','S150','S231',default,1,'全国十佳杰出青年')
insert studentinfo values('赵小华',1,'江西萍乡','维吾尔族','13800000004','江西省萍乡市湘东区湘东镇稻田村五组','100085','S150','S231',default,1,default)
insert studentinfo values('杨俊',1,'江苏响水','维吾尔族','13800000005','江苏响水县七套乡亭泉村八组','100085','S150','S231',default,1,default)
insert studentinfo values('胡开建',0,'江苏响水','维吾尔族','13800000006','江苏响水县运河镇三套村安国组','100085','S150','S231',default,1,default)
insert studentinfo values('郭耀军',1,'山东泰安','维吾尔族','13800000007','山东泰安市岱岳区良庄镇南关庄村','100085','S150','S231',default,1,default)
insert studentinfo values('沈华君',1,'甘肃张掖','维吾尔族','13800000008','甘肃张掖市甘州区大满镇平顺村十四社','100085','S150','S231',default,1,default)
insert studentinfo values('陈仕飞',0,'江苏滨海','维吾尔族','13800000009','江苏滨海市大套乡岭山村一组22号','100085','S150','S231',default,1,default)
insert studentinfo values('袁勇',1,'陕西西安','维吾尔族','13800000010','陕西西安市西电公司家属楼','100085','S150','S231',default,1,'蒙牛牛奶代言人')
insert studentinfo values('王亮',1,'江苏溧阳','土家族','13800000011','江苏溧阳经济开发区夏庄村278号','520685','S150','S231',default,1,default)
insert studentinfo values('谭金龙',0,'江苏阜宁','土家族','13800000012','江苏阜宁县石字新村','520685','S150','S231',default,1,default)
insert studentinfo values('王长在',1,'山西晋城','土家族','13800000013','山西晋城城区西上庄办事处西上庄村','520685','S150','S231',default,1,default)
insert studentinfo values('王科',1,'四川富顺','土家族','13800000014','四川富顺东湖镇观塘村2组','520685','S150','S231',default,1,default)
insert studentinfo values('卫东东',0,'四川自贡','土家族','13800000015','四川自贡大安区大山铺镇大山村8组','520685','S150','S231',default,1,default)
insert studentinfo values('钟毅',1,'四川富顺','土家族','13800000016','四川富顺代寺镇李子村三组','520685','S150','S230',default,0,default)
insert studentinfo values('宋晓龙',1,'四川自贡','土家族','13800000017','四川自贡大安区周家冲小区12号楼','520685','S150','S230','Y210',0,default)
insert studentinfo values('张永峰',0,'山西晋城','土家族','13800000018','山西晋城泽州县巴公镇','520685','S150','S230','Y210',0,default)
insert studentinfo values('明成龙',1,'江苏盐城','土家族','13800000019','江苏省盐城市食品公司宿舍116幢','520685','S150','S230','Y210',0,default)
insert studentinfo values('李建辉',1,'河南新野','土家族','13800000020','河南省新野县前高庙乡河北村','520685','S150','S230','Y210',0,default)
insert studentinfo values('赵蓬军',0,'四川蓬安','布衣族','13800000021','四川蓬安县马回乡三村','487600','S150','S230','Y210',0,'全国劳模')
insert studentinfo values('刘国强',1,'甘肃武山','布衣族','13800000022','甘肃省武山县桦林乡兰沟村','487600','S150','S230','Y210',0,default)
insert studentinfo values('李栓',1,'安徽颍上','布衣族','13800000023','安徽颍上县六十铺镇潘家楼村','487600','S150','S230','Y210',0,default)
insert studentinfo values('侯彦达',0,'山东滕州','布衣族','13800000024','山东滕州城郊乡东北坦村','487600','S150','S230','Y210',0,default)
insert studentinfo values('张旭',1,'江苏盐城','布衣族','13800000025','江苏省盐城市响水县海安集乡合兴村八组','487600','S150','S230','Y210',0,default)
insert studentinfo values('蔡灿',1,'甘肃天水','布衣族','13800000026','甘肃天水市麦积区元龙镇元子村三组8号','487600','S150','S230','Y210',0,default)
insert studentinfo values('赵瑞刚',0,'江苏阜宁','布衣族','13800000027','江苏阜宁吴滩镇董滩村8组','487600','S150','S230','Y210',0,default)
insert studentinfo values('韦勇',1,'甘肃天水','布衣族','13800000028','甘肃天水市麦积区渭南镇杨赵村','487600','S150','S230','Y210',0,default)
insert studentinfo values('段俊鹏',1,'陕西西安','布衣族','13800000029','陕西西安长安区太乙宫东升村2组','487600','S150','S230','Y210',0,default)
insert studentinfo values('康志勇',0,'湖南慈利','布衣族','13800000030','湖南省慈利县广福桥镇10村','487600','S150','S230','Y210',0,default)
insert studentinfo values('李鹏',1,'山西晋城','回族','13800000031','山西晋城城区北街东仓巷69号','546721','S150','S230','Y210',0,default)
insert studentinfo values('丁玉兵',1,'陕西西安','回族','13800000032','陕西西安长安区太乙宫新南村','546721','S150','S230','Y210',0,default)
insert studentinfo values('何喜喜',1,'山西晋城','回族','13800000033','山西晋城沁水县土沃乡夕阳村帅家村','546721','S150','S230','Y210',0,default)
insert studentinfo values('康高辉',1,'山西晋城','回族','13800000034','山西晋城电视台家属院','546721','S150','S230','Y210',0,default)
insert studentinfo values('张丙辉',1,'陕西扶风','回族','13800000035','陕西省扶风县午井镇九家村冯家塬组','546721','S150','S230','Y210',0,default)

----S151班成员学生信息----
insert into studentinfo values('王大雷',1,'河南社旗','回族','13800000035','河南省社旗县桥头镇何营张庄5村','546721','S151', 'S230','Y210' ,0,default )
insert into studentinfo values('庞来新',1,'河南社旗','回族','13800000036','河南省社旗县桥头镇何营张庄6村','546721','S151', 'S230','Y210' ,0,default )
insert into studentinfo values('岳翠雨',1,'河南社旗','回族','13800000037','河南省社旗县桥头镇何营张庄7村','546721','S151', 'S230','Y210' ,0,default )
insert into studentinfo values('冯波',1,'河南社旗','回族','13800000038','河南省社旗县桥头镇何营张庄8村','546721','S151', 'S230','Y210' ,0,default )
insert into studentinfo values('杨海',1,'河南社旗','回族','13800000039','河南省社旗县桥头镇何营张庄9村','546721','S151', 'S230','Y210' ,0,default )
insert into studentinfo values('潘飞飞',1,'河南社旗','回族','13800000040','河南省社旗县桥头镇何营张庄10村','546721','S151', 'S230','Y210',0,default )
insert into studentinfo values('李海龙',1,'河北唐山','藏族','13800000041','河北省唐山市迁安市扣庄乡吉王庄1村','200065','S151', 'S230','Y210' ,0,default )
insert into studentinfo values('黄臻超',1,'河北唐山','藏族','13800000042','河北省唐山市迁安市扣庄乡吉王庄2村','200065','S151', 'S230','Y210' ,0,default )
insert into studentinfo values('乔玲昌',1,'河北唐山','藏族','13800000043','河北省唐山市迁安市扣庄乡吉王庄3村','200065','S151', 'S230','Y210' ,0,default )
insert into studentinfo values('王洋',1,'河北唐山','藏族','13800000044','河北省唐山市迁安市扣庄乡吉王庄4村','200065','S151', 'S230','Y210' ,0,default )
insert into studentinfo values('王小兵',1,'河北唐山','藏族','13800000045','河北省唐山市迁安市扣庄乡吉王庄5村','200065','S151', 'S230','Y210' ,0,default )
insert into studentinfo values('徐以祥',1,'河北唐山','藏族','13800000046','河北省唐山市迁安市扣庄乡吉王庄6村','200065','S151', 'S230','Y210' ,0,default )
insert into studentinfo values('沈华',1,'河北唐山','藏族','13800000047','河北省唐山市迁安市扣庄乡吉王庄7村','200065','S151', 'S231',default ,1,default )
insert into studentinfo values('杨绍云',1,'河北唐山','藏族','13800000048','河北省唐山市迁安市扣庄乡吉王庄8村','200065','S151', 'S231',default ,1,default )
insert into studentinfo values('谢建敏',1,'河北唐山','藏族','13800000049','河北省唐山市迁安市扣庄乡吉王庄9村','200065','S151', 'S231',default ,1,default )
insert into studentinfo values('曹文超',1,'河北唐山','藏族','13800000050','河北省唐山市迁安市扣庄乡吉王庄10村','200065','S151', 'S231',default ,1,default )
insert into studentinfo values('李雪城',1,'辽宁抚顺','汉族','13800000051','辽宁抚顺市清原县红透山矿黄泥1岭','808583','S151','S231' ,default ,1,default )
insert into studentinfo values('张富太',1,'辽宁抚顺','汉族','13800000052','辽宁抚顺市清原县红透山矿黄泥2岭','808583','S151','S231' ,default ,1,default )
insert into studentinfo values('黄林',1,'辽宁抚顺','汉族','13800000053','辽宁抚顺市清原县红透山矿黄泥3岭','808583','S151','S231' ,default ,1,default )
insert into studentinfo values('苏月堃',1,'辽宁抚顺','汉族','13800000054','辽宁抚顺市清原县红透山矿黄泥4岭','808583','S151','S231' ,default ,1,default )
insert into studentinfo values('郑刚',1,'辽宁抚顺','汉族','13800000055','辽宁抚顺市清原县红透山矿黄泥5岭','808583','S151','S231' ,default ,1,default )
insert into studentinfo values('李军',1,'辽宁抚顺','汉族','13800000056','辽宁抚顺市清原县红透山矿黄泥6岭','808583','S151','S231' ,default ,1,default )
insert into studentinfo values('鲁晋云',1,'辽宁抚顺','汉族','13800000057','辽宁抚顺市清原县红透山矿黄泥7岭','808583','S151','S231' ,default ,1,default )
insert into studentinfo values('王雷雷',1,'辽宁抚顺','汉族','13800000058','辽宁抚顺市清原县红透山矿黄泥8岭','808583','S151','S231' ,default ,1,default )
insert into studentinfo values('宋李杰',1,'辽宁抚顺','汉族','13800000059','辽宁抚顺市清原县红透山矿黄泥9岭','808583','S151','S231' ,default ,1,default )
insert into studentinfo values('罗鹏武',1,'辽宁抚顺','汉族','13800000060','辽宁抚顺市清原县红透山矿黄泥10岭','808583','S151','S231' ,default ,1,default )
insert into studentinfo values('李晓东',1,'山东济南','汉族','13800000061','山东省济南市1村','800820','S151','S231',default ,1,default )
insert into studentinfo values('王大林',1,'山东济南','汉族','13800000062','山东省济南市1村','800820','S151','S231',default,1,default )
insert into studentinfo values('王智鹏',0,'山东济南','汉族','13800000063','山东省济南市1村','800820','S151','S231',default,1,default )
insert into studentinfo values('吴扬平',1,'山东济南','汉族','13800000064','山东省济南市1村','800820','S151','S231',default ,1,default )
insert into studentinfo values('周厚胜',1,'山东济南','汉族','13800000065','山东省济南市2村','800820','S151',default,default ,0,default )
insert into studentinfo values('韩晓强',1,'山东济南','汉族','13800000066','山东省济南市1村','800820','S151',default,default ,0,default )
insert into studentinfo values('郭成贵',1,'山东济南','汉族','13800000067','山东省济南市1村','800820','S151',default,default ,0,default )

----S152班成员学生信息----
insert into studentinfo values('徐海勇',1,'河南社旗','回族','13889009035','河南省社旗县桥头镇何营张庄5村','546721','S152', default ,default ,1,default )
insert into studentinfo values('罗代华',1,'河南社旗','回族','13889000036','河南省社旗县桥头镇何营张庄6村','546721','S152', default ,default ,1,default )
insert into studentinfo values('王性台',1,'河南社旗','回族','13889000037','河南省社旗县桥头镇何营张庄7村','546721','S152', default ,default ,1,default )
insert into studentinfo values('陶云峰',1,'河南社旗','回族','13889000038','河南省社旗县桥头镇何营张庄8村','546721','S152', default ,default ,1,default )
insert into studentinfo values('张博',1,'河南社旗','回族','13889000039','河南省社旗县桥头镇何营张庄9村','546721','S152', default ,default ,1,default )
insert into studentinfo values('高立平',1,'河北唐山','藏族','13889000041','河北省唐山市迁安市扣庄乡吉王庄1村','200065','S152', default ,default ,1,default )
insert into studentinfo values('李章顺',1,'河北唐山','藏族','13889000042','河北省唐山市迁安市扣庄乡吉王庄2村','200065','S152', default ,default ,1,default )
insert into studentinfo values('刘超',1,'河北唐山','藏族','13889000043','河北省唐山市迁安市扣庄乡吉王庄3村','200065','S152', default ,default ,1,default )
insert into studentinfo values('杨涛',1,'河北唐山','藏族','13889000044','河北省唐山市迁安市扣庄乡吉王庄4村','200065','S152', default ,default ,1,default )
insert into studentinfo values('罗红杰',1,'河北唐山','藏族','13889000045','河北省唐山市迁安市扣庄乡吉王庄5村','200065','S152', default ,default ,1,default )
insert into studentinfo values('杨军伟',1,'河北唐山','藏族','13889000046','河北省唐山市迁安市扣庄乡吉王庄6村','200065','S152', default ,default ,1,default )
insert into studentinfo values('孙永全',1,'河北唐山','藏族','13889000047','河北省唐山市迁安市扣庄乡吉王庄7村','200065','S152', default ,default ,1,default )
insert into studentinfo values('王振辉',1,'河北唐山','藏族','13889000048','河北省唐山市迁安市扣庄乡吉王庄8村','200065','S152', default ,default ,1,default )
insert into studentinfo values('陈勇',1,'河北唐山','藏族','13889000049','河北省唐山市迁安市扣庄乡吉王庄9村','200065','S152', default ,default ,1,default )
insert into studentinfo values('贾中',1,'辽宁抚顺','汉族','13889000051','辽宁抚顺市清原县红透山矿黄泥1岭','808583','S152',default ,default ,1,default )
insert into studentinfo values('时学辉',1,'辽宁抚顺','汉族','13889000052','辽宁抚顺市清原县红透山矿黄泥2岭','808583','S152',default ,default ,1,default )
insert into studentinfo values('张明光',1,'辽宁抚顺','汉族','13889000053','辽宁抚顺市清原县红透山矿黄泥3岭','808583','S152',default ,default ,1,default )
insert into studentinfo values('吴涛',1,'辽宁抚顺','汉族','13889000054','辽宁抚顺市清原县红透山矿黄泥4岭','808583','S152',default ,default ,1,default )
insert into studentinfo values('赵阔',1,'辽宁抚顺','汉族','13889000055','辽宁抚顺市清原县红透山矿黄泥5岭','808583','S152',default ,default ,1,default )
insert into studentinfo values('李大涛',1,'辽宁抚顺','汉族','13889000056','辽宁抚顺市清原县红透山矿黄泥6岭','808583','S152',default ,default ,1,default )
insert into studentinfo values('唐建学',1,'辽宁抚顺','汉族','13889000057','辽宁抚顺市清原县红透山矿黄泥7岭','808583','S152',default ,default ,1,default )
insert into studentinfo values('刘文豪',1,'辽宁抚顺','汉族','13889000058','辽宁抚顺市清原县红透山矿黄泥8岭','808583','S152',default ,default ,1,default )
insert into studentinfo values('苏彦东',1,'辽宁抚顺','汉族','13889000059','辽宁抚顺市清原县红透山矿黄泥9岭','808583','S152',default ,default ,1,default )
insert into studentinfo values('兰忠良',1,'山东济南','汉族','13889000061','山东省济南市1村','800820','S152',default,default ,1,default )
insert into studentinfo values('张明伦',1,'山东济南','汉族','13889000062','山东省济南市3村','800820','S152',default,default,1,default )
insert into studentinfo values('武俊',0,'山东济南','汉族','13889000063','山东省济南市4村','800820','S152',default,default,1,default )
insert into studentinfo values('石超',1,'山东济南','汉族','13889000064','山东省济南市6村','800820','S152',default,default ,1,default )
insert into studentinfo values('王刚',1,'山东济南','汉族','13889000065','山东省济南市2村','800820','S152',default,default ,1,default )
insert into studentinfo values('陈大伟',1,'山东济南','汉族','13889000066','山东省济南市5村','800820','S152',default,default ,1,default )
insert into studentinfo values('马明',1,'山东济南','汉族','13889000067','山东省济南市7村','800820','S152',default,default ,1,default )



----S153班成员学生信息----
insert studentinfo values('郑小春',1,'河北高邑','维吾尔族','13899000565','北京市海淀区西山旗1街','100085','S153',default,default,1,default)
insert studentinfo values('龚小星',0,'河北高邑','陕西扶风','13899000002','陕西省扶风县揉谷乡新集村2组','100085','S153',default,default,1,default)
insert studentinfo values('赵小国',1,'甘肃甘谷','维吾尔族','13899077003','甘肃省甘谷县金谷乡蒲家山村东组3村','100085','S153',default,default,1,'全国十佳杰出青年')
insert studentinfo values('赵华华',1,'江西萍乡','维吾尔族','13899000004','江西省萍乡市湘东区湘东镇稻田村4组','100085','S153',default,default,1,default)
insert studentinfo values('杨小俊',1,'江苏响水','维吾尔族','13899000005','江苏响水县七套乡亭泉村5组','100085','S153',default,default,1,default)
insert studentinfo values('胡小建',0,'江苏响水','维吾尔族','13899000006','江苏响水县运河镇三套村安国组','100085','S153',default,default,1,default)
insert studentinfo values('郭小军',1,'山东泰安','维吾尔族','13899000007','山东泰安市岱岳区良庄镇南关6村','100085','S153',default,default,1,default)
insert studentinfo values('沈小君',1,'甘肃张掖','维吾尔族','13899000008','甘肃张掖市甘州区大满镇平顺村7社','100085','S153',default,default,1,default)
insert studentinfo values('陈小飞',0,'江苏滨海','维吾尔族','13899000009','江苏滨海市大套乡岭山村一组8号','100085','S153',default,default,1,default)
insert studentinfo values('袁小勇',1,'陕西西安','维吾尔族','13899000010','陕西西安市西电公司家属楼','100085','S153',default,default,1,'蒙牛牛奶代言人')
insert studentinfo values('王小亮',1,'江苏溧阳','土家族','13899000011','江苏溧阳经济开发区夏庄村9号','520685','S153',default,default,1,default)
insert studentinfo values('谭小龙',0,'江苏阜宁','土家族','13899000012','江苏阜宁县石字新村','520685','S153',default,default,1,default)
insert studentinfo values('王小在',1,'山西晋城','土家族','13899000013','山西晋城城区西上庄办事处西上10村','520685','S153',default,default,1,default)
insert studentinfo values('王小科',1,'四川富顺','土家族','13899000014','四川富顺东湖镇观塘村11组','520685','S153',default,default,1,default)
insert studentinfo values('卫小东',0,'四川自贡','土家族','13899000015','四川自贡大安区大山铺镇大山村12组','520685','S153',default,default,1,default)
insert studentinfo values('宋小龙',1,'四川自贡','土家族','13899000017','四川自贡大安区周家冲小区14号楼','520685','S153',default,default,1,default)
insert studentinfo values('张小峰',0,'山西晋城','土家族','13899000018','山西晋城泽州县巴公镇15村','520685','S153',default,default,1,default)
insert studentinfo values('明小龙',1,'江苏盐城','土家族','13899000019','江苏省盐城市食品公司宿舍16幢','520685','S153',default,default,1,default)
insert studentinfo values('李小辉',1,'河南新野','土家族','13899000020','河南省新野县前高庙乡河北17村','520685','S153',default,default,1,default)
insert studentinfo values('赵小军',0,'四川蓬安','布衣族','13899000021','四川蓬安县马回乡18村','487600','S153',default,default,1,'全国劳模')
insert studentinfo values('刘小强',1,'甘肃武山','布衣族','13899000022','甘肃省武山县桦林乡兰19沟村','487600','S153',default,default,1,default)
insert studentinfo values('李小栓',1,'安徽颍上','布衣族','13899000023','安徽颍上县六十铺镇潘家20楼村','487600','S153',default,default,1,default)
insert studentinfo values('侯小达',0,'山东滕州','布衣族','13899000024','山东滕州城郊乡东北坦27村','487600','S153',default,default,1,default)
insert studentinfo values('张小旭',1,'江苏盐城','布衣族','13899000025','江苏省盐城市响水县海安集乡合兴村28组','487600','S153',default,default,1,default)
insert studentinfo values('蔡小灿',1,'甘肃天水','布衣族','13899000026','甘肃天水市麦积区元龙镇元子村三组29号','487600','S153',default,default,1,default)
insert studentinfo values('赵小刚',0,'江苏阜宁','布衣族','13899000027','江苏阜宁吴滩镇董滩村30组','487600','S153',default,default,1,default)
insert studentinfo values('韦小勇',1,'甘肃天水','布衣族','13899000028','甘肃天水市麦积区渭南镇杨赵31村','487600','S153',default,default,1,default)
insert studentinfo values('段小鹏',1,'陕西西安','布衣族','13899000029','陕西西安长安区太乙宫东升村32组','487600','S153',default,default,1,default)
insert studentinfo values('康小勇',0,'湖南慈利','布衣族','13899000030','湖南省慈利县广福桥镇33村','487600','S153',default,default,1,default)
insert studentinfo values('李小鹏',1,'山西晋城','回族','13899000031','山西晋城城区北街东仓巷34号','546721','S153',default,default,1,default)
insert studentinfo values('丁小兵',1,'陕西西安','回族','13899000032','陕西西安长安区太乙宫新南35村','546721','S153',default,default,1,default)

----S232班成员学生信息----
insert into studentinfo values('刘勇强',1,'河南社旗','回族','13889009035','河南省社旗县桥头镇何营张庄5村','546721',default,'S232',default ,1,default )
insert into studentinfo values('王威',1,'河南社旗','回族','13889000036','河南省社旗县桥头镇何营张庄6村','546721',default,'S232',default ,1,default )
insert into studentinfo values('戴鑫智',1,'河南社旗','回族','13889000037','河南省社旗县桥头镇何营张庄7村','546721',default,'S232',default ,1,default )
insert into studentinfo values('王礼勇',1,'河南社旗','回族','13889000038','河南省社旗县桥头镇何营张庄8村','546721',default,'S232',default ,1,default )
insert into studentinfo values('徐向阳',1,'河南社旗','回族','13889000039','河南省社旗县桥头镇何营张庄9村','546721',default,'S232',default ,1,default )
insert into studentinfo values('唐荣荣',1,'河南社旗','回族','13889000040','河南省社旗县桥头镇何营张庄10村','546721',default,'S232',default ,1,default )
insert into studentinfo values('黄波',1,'河北唐山','藏族','13889000041','河北省唐山市迁安市扣庄乡吉王庄1村','200065',default,'S232',default ,1,default )
insert into studentinfo values('潘国标',1,'河北唐山','藏族','13889000042','河北省唐山市迁安市扣庄乡吉王庄2村','200065',default,'S232',default ,1,default )
insert into studentinfo values('吴刚',1,'河北唐山','藏族','13889000043','河北省唐山市迁安市扣庄乡吉王庄3村','200065',default,'S232',default ,1,default )
insert into studentinfo values('马瑜',1,'河北唐山','藏族','13889000044','河北省唐山市迁安市扣庄乡吉王庄4村','200065',default,'S232',default ,1,default )
insert into studentinfo values('薛俊',1,'河北唐山','藏族','13889000045','河北省唐山市迁安市扣庄乡吉王庄5村','200065',default,'S232',default ,1,default )
insert into studentinfo values('季东',1,'河北唐山','藏族','13889000046','河北省唐山市迁安市扣庄乡吉王庄6村','200065',default,'S232',default ,1,default )
insert into studentinfo values('赵彦刚',1,'河北唐山','藏族','13889000047','河北省唐山市迁安市扣庄乡吉王庄7村','200065',default,'S232',default ,1,default )
insert into studentinfo values('吴雪峰',1,'河北唐山','藏族','13889000048','河北省唐山市迁安市扣庄乡吉王庄8村','200065',default,'S232',default ,1,default )
insert into studentinfo values('顾再飞',1,'河北唐山','藏族','13889000049','河北省唐山市迁安市扣庄乡吉王庄9村','200065',default,'S232',default ,1,default )
insert into studentinfo values('董明明',1,'河北唐山','藏族','13889000050','河北省唐山市迁安市扣庄乡吉王庄10村','200065',default,'S232',default ,1,default )
insert into studentinfo values('刘自保',1,'辽宁抚顺','汉族','13889000051','辽宁抚顺市清原县红透山矿黄泥1岭','808583',default,'S232',default ,1,default )
insert into studentinfo values('郑文泽',1,'辽宁抚顺','汉族','13889000052','辽宁抚顺市清原县红透山矿黄泥2岭','808583',default,'S232',default ,1,default )
insert into studentinfo values('赵小虎',1,'辽宁抚顺','汉族','13889000053','辽宁抚顺市清原县红透山矿黄泥3岭','808583',default,'S232',default ,1,default )
insert into studentinfo values('孙育乐',1,'辽宁抚顺','汉族','13889000054','辽宁抚顺市清原县红透山矿黄泥4岭','808583',default,'S232',default ,1,default )
insert into studentinfo values('贺君涛',1,'辽宁抚顺','汉族','13889000055','辽宁抚顺市清原县红透山矿黄泥5岭','808583',default,'S232',default ,1,default )
insert into studentinfo values('田小卫',1,'辽宁抚顺','汉族','13889000056','辽宁抚顺市清原县红透山矿黄泥6岭','808583',default,'S232',default ,1,default )
insert into studentinfo values('唐建学',1,'辽宁抚顺','汉族','13889000057','辽宁抚顺市清原县红透山矿黄泥7岭','808583',default,'S232',default ,1,default )
insert into studentinfo values('窦镱坤',1,'辽宁抚顺','汉族','13889000058','辽宁抚顺市清原县红透山矿黄泥8岭','808583',default,'S232',default ,1,default )
insert into studentinfo values('郑涛',1,'辽宁抚顺','汉族','13889000059','辽宁抚顺市清原县红透山矿黄泥9岭','808583',default,'S232',default ,1,default )
insert into studentinfo values('席永飞',1,'辽宁抚顺','汉族','13889000060','辽宁抚顺市清原县红透山矿黄泥10岭','808583',default,'S232',default ,1,default )
insert into studentinfo values('殷贺',1,'山东济南','汉族','13889000061','山东省济南市1村','800820',default,'S232',default ,1,default )
insert into studentinfo values('李新浩',1,'山东济南','汉族','13889000062','山东省济南市3村','800820',default,'S232',default,1,default )
insert into studentinfo values('李俊',0,'山东济南','汉族','13889000063','山东省济南市4村','800820',default,'S232',default,1,default )
insert into studentinfo values('马杰',1,'山东济南','汉族','13889000064','山东省济南市6村','800820',default,'S232',default ,1,default )
insert into studentinfo values('辛明明',1,'山东济南','汉族','13889000065','山东省济南市2村','800820',default,'S232',default ,1,default )
insert into studentinfo values('钟国华',1,'山东济南','汉族','13889000066','山东省济南市5村','800820',default,'S232',default ,1,default )
insert into studentinfo values('刘旭',1,'山东济南','汉族','13889000067','山东省济南市7村','800820',default,'S232',default ,1,default )
insert into studentinfo values('丁兵',1,'陕西西安','回族','13899000032','陕西西安长安区太乙宫新南35村','546721',default,'S232',default,1,default)

----Y211班成员学生信息----
insert into studentinfo values('刘晓强',1,'河南社旗','回族','13889009035','河南省社旗县桥头镇何营张庄5村','546721',default,default, 'Y211' ,1,default )
insert into studentinfo values('王晓威',1,'河南社旗','回族','13889000036','河南省社旗县桥头镇何营张庄6村','546721',default,default, 'Y211' ,1,default )
insert into studentinfo values('戴晓智',1,'河南社旗','