测试数据插入的sql语句.sql

C#开放的作业提交系统

--插入测试数据

--插入一个管理员记录
insert into Admin values('admin','杨文兵','snryang','showmeyang','operation','[e-mail]',0)  

--插入专业数据
insert into ZhuanYe (Mingcheng)values('WEB应用程序设计')
insert into ZhuanYe (Mingcheng)values('数据库')
insert into ZhuanYe (Mingcheng)values('图形图像一班')
insert into ZhuanYe (Mingcheng)values('图形图像二班')
insert into ZhuanYe (Mingcheng)values('计算机应用一班')
insert into ZhuanYe (Mingcheng)values('计算机应用二班')

--插入班级数据   例:学号规则(如200416140 ,2004入学年份,16专业代号,1表示一班,40表示班上第40个同学)
insert into Class (Class_Name,Class_DaiHao)values('2004级WEB应用程序设计','2004161')
insert into Class (Class_Name,Class_DaiHao)values('2004级数据库','2004171')
insert into Class (Class_Name,Class_DaiHao)values('2004级图形图像一班','2004181')
insert into Class (Class_Name,Class_DaiHao)values('2004级图形图像二班','2004182')
insert into Class (Class_Name,Class_DaiHao)values('2004级计算机应用一班','2004191')
insert into Class (Class_Name,Class_DaiHao)values('2004级计算机应用二班','2004192')

--插入教师数据
insert into Teacher (XingMing,Pw,Pw_WenTi,Pw_DaAn,Email,DengLuShu,ZuoYeShu)values('任华','snryang','1','1','12163.com',0,2)
insert into Teacher (XingMing,Pw,Pw_WenTi,Pw_DaAn,Email,DengLuShu,ZuoYeShu)values('尹华国','snryang','1','1','12163.com',0,2)
insert into Teacher (XingMing,Pw,Pw_WenTi,Pw_DaAn,Email,DengLuShu,ZuoYeShu)values('郑佳','snryang','1','1','12163.com',0,1)
insert into Teacher (XingMing,Pw,Pw_WenTi,Pw_DaAn,Email,DengLuShu,ZuoYeShu)values('雷文全','snryang','1','1','12163.com',0,0)

--插入学生数据                                                            
insert into Student (XueHao,XingMing,Pw,Pw_WenTi,Pw_DaAn,Email,DengLuShu,BanJiDaiHao)
		values('200416140','杨文兵','snryang','1','1','12163.com',0,'2004161')

insert into Student (XueHao,XingMing,Pw,Pw_WenTi,Pw_DaAn,Email,DengLuShu,BanJiDaiHao)
		values('200416109','李文','snryang','1','1','12163.com',0,'2004161')

insert into Student (XueHao,XingMing,Pw,Pw_WenTi,Pw_DaAn,Email,DengLuShu,BanJiDaiHao)
		values('200417101','XXX','snryang','1','1','12163.com',0,'2004171')

insert into Student (XueHao,XingMing,Pw,Pw_WenTi,Pw_DaAn,Email,DengLuShu,BanJiDaiHao)
		values('200418101','XXX','snryang','1','1','12163.com',0,'2004181')

--插入作业数据
insert into ZuoYe (ZY_Title,ZY_Content,ZY_XingMing,ZY_XueHao,ZY_WCDate,ZY_LuJing,ZY_WenJianLeiXing,ZY_DaXiao,ZY_Class_DaiHao,ZY_chengJi)
values('软件实用工程第一次作业','作业要求:<br>一、要求一<br>二、要求二<br>三、要求三','任华','1000','2006-12-9','任华\2004级WEB应用程序设计\软件实用工程第一次作业\','rar',1000,'2004161','杨文兵 100<br>李文 99<br>')

insert into ZuoYe (ZY_Title,ZY_Content,ZY_XingMing,ZY_XueHao,ZY_WCDate,ZY_LuJing,ZY_WenJianLeiXing,ZY_DaXiao,ZY_Class_DaiHao,ZY_chengJi)
values('软件实用工程第二次作业','作业要求:<br>一、要求一<br>二、要求二<br>三、要求三','任华','1000','2006-12-9','任华\2004级WEB应用程序设计\软件实用工程第二次作业\','rar',1000,'2004161','杨文兵 90<br>李文 80<br>')

insert into ZuoYe (ZY_Title,ZY_Content,ZY_XingMing,ZY_XueHao,ZY_WCDate,ZY_LuJing,ZY_WenJianLeiXing,ZY_DaXiao,ZY_Class_DaiHao,ZY_chengJi)
values('ASP.NET应用程序','作业要求:<br>一、要求一<br>二、要求二<br>三、要求三','尹华国','1001','2006-12-9','尹华国\2004级WEB应用程序设计\ASP.NET应用程序\','rar',1000,'2004161','未录入')

insert into ZuoYe (ZY_Title,ZY_Content,ZY_XingMing,ZY_XueHao,ZY_WCDate,ZY_LuJing,ZY_WenJianLeiXing,ZY_DaXiao,ZY_Class_DaiHao,ZY_chengJi)
values('数据库设计','作业要求:<br>一、要求一<br>二、要求二<br>三、要求三','尹华国','1001','2006-12-9','尹华国\2004级数据库\数据库设计\','rar',1000,'2004171','XXX 100')

insert into ZuoYe (ZY_Title,ZY_Content,ZY_XingMing,ZY_XueHao,ZY_WCDate,ZY_LuJing,ZY_WenJianLeiXing,ZY_DaXiao,ZY_Class_DaiHao,ZY_chengJi)
values('电子商务','作业要求:<br>一、要求一<br>二、要求二<br>三、要求三','郑佳','1002','2006-12-9','郑佳\2004级图形图像一班\电子商务\','rar',1000,'2004181','XXX 100')