东北大学计算机软件基础实验报告,东北大学软件技术基础实验报告.doc

东北大学软件技术基础实验报告.doc

实验一代码INCLUDE“IOSTREAM“INCLUDE//定义一个线性表CONSTINTNMAXSIZE15//最大值INTNLEN0//表中元素个数INTNLINEARLISTNMAXSIZE//定义操作VOIDLSORTVOIDLOUTVOIDLINSERTINTNVOIDLDELETEINTNVOIDMAIN{//输入数据并放入线性表中PRINTF“PLEASEDATA\N“//STDCOUTNINNLINEARLISTININNLEN}LSORT//排序线性表LOUT//输出结果PRINTF“PLEASEADATATOINSERT\N“SCANF“D“,LINSERTNIN//输入一个数字，并插入到线性表中LOUTLSORTPRINTF“SORTED\N“LOUTWHILE1{PRINTF“PLEASEANUMBEROFDATATODELETE\N“SCANF“D“,IFNINNLENPRINTF“NUMBERMUSTLESSTHAND\N“,NLENELSEBREAK}LDELETENIN//输入一个数字，并从线性表中删除LOUTCHARCHTMPPRINTF“PLEASEACHARTOFINISHTHISPROGRAM“CHTMPGETCH}VOIDLSORT//冒泡排序,由大到小{INTI,J,TEMPFORJ0JNLENPRINTF“PLACENUMBERMUSTLESSTHAND\N“,NLENELSEBREAK}FORINLENIJINLINEARLISTINLINEARLISTI1NLINEARLISTJ1KNLEN}VOIDLDELETEINTM{INTIFORIMIINCLUDEINCLUDEINCLUDECONSTINTMAX_LEN10//字符串的长度CONSTINTMAX_SIZE30//栈或队的最大元素个数//定义一个队列的结构STRUCTQUEUE{INTNMAXSIZE//最大值INTNCOUNT//个数INTNFRONT//头INTNREAR//尾CHARSZQUEUEMAX_SIZEMAX_LEN}//定义一个栈的结构STRUCTSTACK{INTNMAXSIZE//最大值INTNTOP//栈顶CHARSZSTACKMAX_SIZEMAX_LEN}//队列的操作VOIDINITQUEUEQUEUEQ,INTNMAXSIZE{QNMAXSIZENMAXSIZEQNCOUNT0QNFRONT0QNREAR0QSZQUEUEMAX_SIZEMAX_LEN0}VOIDINQUEUEQUEUEQ,CHARPITEM{IFQNCOUNTQNMAXSIZE{PRINTF“QUEUEISFULL\N“RETURN}STRCPYQSZQUEUEQNREAR,PITEMIFQNREARMAX_SIZEQNREAR0QNCOUNT}VOIDOUTQUEUEQUEUEQ,CHARPITEM{IFQNCOUNT0{PRINTF“QUEUEISEMPTY\N“RETURN}STRCPYPITEM,QSZQUEUEQNFRONTIFQNFRONTMAX_SIZEQNFRONT0QNCOUNT}//栈的操作VOIDINITSTACKSTACKS,INTNMAXSIZE{SNMAXSIZENMAXSIZESNTOP0SSZSTACKMAX_SIZEMAX_LEN0}VOIDPUSHSTACKSTACKS,CHARPITEM{CHARPIFSNTOPNMAXSIZE{PSSZSTACKSNTOPSTRCPYP,PITEMSNTOP}ELSE{PRINTF“STACKOVERFLOW\N“RETURN}}VOIDPOPSTACKSTACKS,CHARPITEM{CHARPIFSNTOP0{PRINTF“STACKISEMPTY\N“RETURN}ELSE{PSSZSTACKSNTOPSTRCPYPITEM,P}}VOIDGETTOPSTACKSTACKS,CHARPITEM{CHARPCHARA10{0}IFSNTOP0{A0 STRCPYPITEM,A}ELSE{PSSZSTACKSNTOP1STRCPYPITEM,P}}//字符判断INTISDIGITCHARX{IFX 0 PRINTF“S“,X}IFISDIGITX0//是数PUSHSTACKN,XELSE//认为是运算符，没有考虑空格等{GETTOPSTACKO,OP//获得OS栈顶运算符IFX0 //扫描结束{PRINTF“\NRESULTIS“BREAK}IFPRIORITYXPRIORITYOP//运算符的优先级〉栈顶运算符{PUSHSTACKO,XCONTINUE}WHILEPRIORITYX85分的学生SNAME,CLASS；SELECTDISTINCTSTUBSNO,SNAME,CLASSFROMSTUB,SCOREBWHERESTUBSNOSCOREBSNOANDGRADE857、将课程号为“01”的课程名称修改为“软件技术”；UPDATECOURSEBSETCNAME RJJS WHERECNO01SELECTDISTINCTFROMCOURSEB8、修改一名学生的姓名、性别、年龄；UPDATESTUBSETSNAME XUYIYANG ,SEX F ,AGE 20 WHERESNO 0101 9、将成绩为5559分的男生的成绩修改为60分；UPDATESCOREBSETGRADE60WHERESNOINSELECTSNOFROMSTUBWHERESEX M ANDGRADEBETWEEN55AND5910、删除年龄不是20的学生的所有信息包括选课和成绩；DELETESTUBWHERESNOINSELECTSNOFROMSTUBWHEREAGE20DELETESCOREBWHERESNOINSELECTSNOFROMSTUBWHEREAGE2011、删除一个班级的所有学生；DELETESTUBWHERESNOINSELECTSNOFROMSTUBWHERECLASS DZ01 DELETESCOREBWHERESNOINSELECTSNOFROMSTUBWHERECLASS DZ01 12、删除所有数据表和数据库DROPDATABASEMYDB