{"trustable":false,"sections":[{"title":"题目描述与输入输出格式","value":{"format":"MD","content":"编写一个成绩管理系统(SPMS)。最多100个学生,每个学生有如下属性:\n+ CID:学生编号,10位数字。\n+ SID:班级编号,不超过20的正整数。\n+ 姓名:不超过10的字母和数字(?)组成,第一个是大写。不能出现大写字符。\n+ 四门课程的成绩,均不超过100。\n\n---\n进入系统后,应显示主菜单:\n```plaintext\nWelcome to Student Performance Management System (SPMS).\n\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\n```\n选择1以后,输出以下添加学生记录的提示消息:\n```plaintext\nPlease enter the SID, CID, name and four scores. Enter 0 to finish.\n```\n然后等待输入。保证输入是合法的,但是当输入的SID重复时,输出\n```plaintext\nDuplicated SID.\n```\n不过可以名字重复。你的程序应该不停地打印前置信息,直到用户输入0后再次显示主菜单。\n\n选择2之后,应输出以下提示信息:\n```plaintext\nPlease enter SID or name. Enter 0 to finish.\n```\n然后等待输入,删除在数据库中匹配输入的SID或名字的所有学生后打印如下信息(xx可以等于0):\n```plaintext\nxx student(s) removed.\n```\n你的程序应当不停打印前述提示信息,直到用户输入单个0然后再次打印主菜单。\n\n选择3后,会出现如下信息:\n```plaintext\nPlease enter SID or name. Enter 0 to finish.\n```\n输入SID或名字。如果数据库中没有匹配结果,则啥也不要干;否则输出匹配到的所有满足条件的学生,但是增加3列:年级排名(第一列),总分和平均分(最后两列)。年级第一名为1;如果两个年级第2并列,则下一个学生的排名为4。你的程序同上打印前述提示信息,直到用户输入单个0后再次打印主菜单。\n\n选择4以后,输出下面信息后返回主菜单:\n```plaintext\nShowing the ranklist hurts students\u0027 self-esteem. Don\u0027t do that.\n```\n输入5以后,出现如下提示信息:\n```plaintext\nPlease enter class ID, 0 for the whole statistics.\n```\n当用户输入CID时(0代表全年级),显示如下信息(及格就是分数大于等于60,xx代表数字)后返回主菜单:\n```plaintext\nChinese\nAverage Score: xx.xx\nNumber of passed students: xx\nNumber of failed students: xx\nMathematics\nAverage Score: xx.xx\nNumber of passed students: xx\nNumber of failed students: xx\nEnglish\nAverage Score: xx.xx\nNumber of passed students: xx\nNumber of failed students: xx\nProgramming\nAverage Score: xx.xx\nNumber of passed students: xx\nNumber of failed students: xx\nOverall:\nNumber of students who passed all subjects: xx\nNumber of students who passed 3 or more subjects: xx\nNumber of students who passed 2 or more subjects: xx\nNumber of students who passed 1 or more subjects: xx\nNumber of students who failed all subjects: xx\n```\n选择0之后,程序结束。\n\n**注意:单科成绩与总分应格式化为整数,但平均分保留两位小数。**"}},{"title":"样例输入","value":{"format":"MD","content":"```plaintext\n1\n0011223344 1 John 79 98 91 100\n0022334455 1 Tom 59 72 60 81\n0011223344 2 Alice 100 100 100 100\n2423475629 2 John 60 80 30 99\n0\n3\n0022334455\nJohn\n0\n5\n1\n2\n0011223344\n0\n5\n0\n4\n0\n```"}},{"title":"样例输出","value":{"format":"MD","content":"```plaintext\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\nPlease enter the SID, CID, name and four scores. Enter 0 to finish.\nPlease enter the SID, CID, name and four scores. Enter 0 to finish.\nPlease enter the SID, CID, name and four scores. Enter 0 to finish.\nDuplicated SID.\nPlease enter the SID, CID, name and four scores. Enter 0 to finish.\nPlease enter the SID, CID, name and four scores. Enter 0 to finish.\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\nPlease enter SID or name. Enter 0 to finish.\n2 0022334455 1 Tom 59 72 60 81 272 68.00\nPlease enter SID or name. Enter 0 to finish.\n1 0011223344 1 John 79 98 91 100 368 92.00\n3 2423475629 2 John 60 80 30 99 269 67.25\nPlease enter SID or name. Enter 0 to finish.\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\nPlease enter class ID, 0 for the whole statistics.\nChinese\nAverage Score: 69.00\nNumber of passed students: 1\nNumber of failed students: 1\nMathematics\nAverage Score: 85.00\nNumber of passed students: 2\nNumber of failed students: 0\nEnglish\nAverage Score: 75.50\nNumber of passed students: 2\nNumber of failed students: 0\nProgramming\nAverage Score: 90.50\nNumber of passed students: 2\nNumber of failed students: 0\nOverall:\nNumber of students who passed all subjects: 1\nNumber of students who passed 3 or more subjects: 2\nNumber of students who passed 2 or more subjects: 2\nNumber of students who passed 1 or more subjects: 2\nNumber of students who failed all subjects: 0\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\nPlease enter SID or name. Enter 0 to finish.\n1 student(s) removed.\nPlease enter SID or name. Enter 0 to finish.\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\nPlease enter class ID, 0 for the whole statistics.\nChinese\nAverage Score: 59.50\nNumber of passed students: 1\nNumber of failed students: 1\nMathematics\nAverage Score: 76.00\nNumber of passed students: 2\nNumber of failed students: 0\nEnglish\nAverage Score: 45.00\nNumber of passed students: 1\nNumber of failed students: 1\nProgramming\nAverage Score: 90.00\nNumber of passed students: 2\nNumber of failed students: 0\nOverall:\nNumber of students who passed all subjects: 0\nNumber of students who passed 3 or more subjects: 2\nNumber of students who passed 2 or more subjects: 2\nNumber of students who passed 1 or more subjects: 2\nNumber of students who failed all subjects: 0\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\nShowing the ranklist hurts students’ self-esteem. Don’t do that.\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\n```"}},{"title":"你在键盘上运行的样子","value":{"format":"MD","content":"---\n上面的分割表示输入与输出的分割。\n```plaintext\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\n```\n---\n```\n1\n```\n---\n```plaintext\nPlease enter the SID, CID, name and four scores. Enter 0 to finish.\n```\n---\n```plaintext\n0011223344 1 John 79 98 91 100\n```\n---\n```plaintext\nPlease enter the SID, CID, name and four scores. Enter 0 to finish.\n```\n---\n```plaintext\n0022334455 1 Tom 59 72 60 81\n```\n---\n```plaintext\nPlease enter the SID, CID, name and four scores. Enter 0 to finish.\n```\n---\n```plaintext\n0011223344 2 Alice 100 100 100 100\n```\n---\n```plaintext\nDuplicated SID.\nPlease enter the SID, CID, name and four scores. Enter 0 to finish.\n```\n---\n```plaintext\n2423475629 2 John 60 80 30 99\n```\n---\n```plaintext\nPlease enter the SID, CID, name and four scores. Enter 0 to finish.\n```\n---\n```plaintext\n0\n```\n---\n```plaintext\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\n```\n---\n```plaintext\n3\n```\n---\n```plaintext\nPlease enter SID or name. Enter 0 to finish.\n```\n---\n```plaintext\n0022334455\n```\n---\n```plaintext\n2 0022334455 1 Tom 59 72 60 81 272 68.00\n```\n---\n```plaintext\nPlease enter SID or name. Enter 0 to finish.\n```\n---\n```plaintext\nJohn\n```\n---\n```plaintext\n1 0011223344 1 John 79 98 91 100 368 92.00\n3 2423475629 2 John 60 80 30 99 269 67.25\nPlease enter SID or name. Enter 0 to finish.\n```\n---\n```plaintext\n0\n```\n---\n```plaintext\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\n```\n---\n```plaintext\n5\n```\n---\n```plaintext\nPlease enter class ID, 0 for the whole statistics.\n```\n---\n```plaintext\n1\n```\n---\n```plaintext\nChinese\nAverage Score: 69.00\nNumber of passed students: 1\nNumber of failed students: 1\nMathematics\nAverage Score: 85.00\nNumber of passed students: 2\nNumber of failed students: 0\nEnglish\nAverage Score: 75.50\nNumber of passed students: 2\nNumber of failed students: 0\nProgramming\nAverage Score: 90.50\nNumber of passed students: 2\nNumber of failed students: 0\nOverall:\nNumber of students who passed all subjects: 1\nNumber of students who passed 3 or more subjects: 2\nNumber of students who passed 2 or more subjects: 2\nNumber of students who passed 1 or more subjects: 2\nNumber of students who failed all subjects: 0\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\n```\n---\n```plaintext\n2\n```\n---\n```plaintext\nPlease enter the SID, CID, name and four scores. Enter 0 to finish.\n```\n---\n```plaintext\n0011223344\n```\n---\n```plaintext\n1 student(s) removed.\nPlease enter SID or name. Enter 0 to finish.\n```\n---\n```plaintext\n0\n```\n---\n```plaintext\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\n```\n---\n```plaintext\n5\n```\n---\n```plaintext\nPlease enter class ID, 0 for the whole statistics.\n```\n---\n```plaintext\n0\n```\n---\n```plaintext\nChinese\nAverage Score: 59.50\nNumber of passed students: 1\nNumber of failed students: 1\nMathematics\nAverage Score: 76.00\nNumber of passed students: 2\nNumber of failed students: 0\nEnglish\nAverage Score: 45.00\nNumber of passed students: 1\nNumber of failed students: 1\nProgramming\nAverage Score: 90.00\nNumber of passed students: 2\nNumber of failed students: 0\nOverall:\nNumber of students who passed all subjects: 0\nNumber of students who passed 3 or more subjects: 2\nNumber of students who passed 2 or more subjects: 2\nNumber of students who passed 1 or more subjects: 2\nNumber of students who failed all subjects: 0\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\n```\n---\n```plaintext\n4\n```\n---\n```plaintext\nShowing the ranklist hurts students\u0027 self-esteem. Don\u0027t do that.\nWelcome to Student Performance Management System (SPMS).\n1 - Add\n2 - Remove\n3 - Query\n4 - Show ranking\n5 - Show Statistics\n0 - Exit\n```\n---\n```plaintext\n0\n```\n---\n程序结束。"}}]}