基于C语言实现（控制台）学生管理系统【100010726】

# 学生管理系统 ## 一、设计目标 通过本次较为完整的项目开发，更加理解其项目开发的流程。 通过本次代码设计，理解其模块化程序设计的理念。利用其子程序实现“概念层”与“实现层”的分离。 理解应用设计时将其设计流程抽象为单独的子程序，分为“概念层”。实际的功能细节时分为“实现层”。 ## 二、总体设计 ### 2.1 设计框图  ### 2.2 设计流程图          ## 三、详细设计 ### 3.1 主函数 ```c++ int main(int argc, char *argv[]) { InitializationStudentSystem(); Handle_argv(argc, argv); int selectFun; while (true) { ret: selectFun = getchar(); //选择的功能序号 ClearInputBuffer(selectFun); switch (selectFun) { case '1': /*录入学生信息*/ InputStudentInfo(g_studentDB); break; case '2': /*排序学生信息*/ ShowSortStudentInfoTable(g_studentDB); break; case '3': /*搜索学生信息*/ ShowSearchStudent(g_studentDB); break; case '4': /*删除学生信息*/ DeleteStudent(g_studentDB); break; case '5': /*显示学生信息*/ ShowStudentInfoTable(g_studentDB); break; case '6': /*导入csv学生信息*/ ImportStudent(g_studentDB, NULL); break; case '7': /*导出csv学生信息*/ ExportStudent(g_studentDB, NULL); break; case '8': /*编辑学生信息*/ EditStudent(g_studentDB); break; case '0': exit(EXIT_SUCCESS); break; default: ShowMenu(); goto ret; //序号错误，在返回重新输入 break; } ShowMenu(); } return 0; } ``` ### 3.2 录入 ```c++ void InputStudentInfo(sqlite3 *_studentDB) { ClearCconsoleScreen; student info; do { inputStudent_st(&info); if (info.no <= 0) { //输入0则退出。 break; } int rc; rc = sqlite3_exec(_studentDB, GetInstertSQL(info), NULL, NULL, NULL); if (rc != SQLITE_OK) { printf_s("\n\t学号%"PRId64"的学生已有。", info.no); } else { printf_s("\n\t"); } } while (IsContinueKeyChar("回车键继续录入，'0'退出：", '\n', false)); } ``` ### 3.3 排序 ```c++ void ShowSortStudentInfoTable(sqlite3 *_studentDB) { ClearCconsoleScreen; do { printf_s( " 1、学号\n" " 2、姓名\n" " 3、课程编号\n" " 4、课程名称\n" " 5、学分\n" " 6、平时成绩\n" " 7、实验成绩\n" " 8、考试成绩\n" " 9、综合成绩\n" "10、重修\n" "输入 (以上序号)[asc|desc] 组合，会以指定的组合方式排序。\n" "asc升序（从小到大），desc降序（从大到小）。\n" "例如输入 6desc 则按照平时成绩降序排序。\n\n" "请输入排序组合，'0'退出：" ); int selectNumber; char selectOrder; scanf_s("%d%c", &selectNumber, &selectOrder, 1); if ('\n' != selectOrder) { ClearInputBuffer(getchar()); } if (0 == selectNumber) { return; } if (selectNumber < 1 || selectNumber > 10) { //确保序号在范围内 selectNumber = 1; } char *fieldName[] = { "no", "name", "courseNumber", "courseName", "credit", "peacetime", "experiment", "examination", "comprehensive", "repair" }; char sql[SQL_SIZE]; sprintf_s( sql, SQL_SIZE, "SELECT * FROM `"STUDENT_INFOTABLE_NAME"` ORDER BY `%s` %s", fieldName[selectNumber - 1], 'd' == tolower(selectOrder) ? "DESC" : "ASC" ); QueryShowStudentInfoPaging(_studentDB, sql); } while (IsContinueKeyChar("回车键继续排序，'0'退出：", '\n', false)); } ``` ## 3.4 搜索 ```c++ void ShowSearchStudent(sqlite3 *_studentDB) { ClearCconsoleScreen; do { printf_s( "支持精确/模糊搜索。\n" "通配符'%%'或'_'，%%匹配多个字符，_匹配单个字符。\n" "请输入搜索的关键字（学号|姓名|综合成绩）：" ); char searchKey[NAME_SIZE]; scanf_s("%s", searchKey, NAME_SIZE); ClearInputBuffer(getchar()); char sql[SQL_SIZE]; sprintf_s( sql, SQL_SIZE, "SELECT * FROM `"STUDENT_INFOTABLE_NAME"` WHERE `no` LIKE '%s' OR `name` LIKE '%s' OR `comprehensive` LIKE '%s'", searchKey, searchKey, searchKey ); QueryShowStudentInfoPaging(_studentDB, sql); } while (IsContinueKeyChar("回车键继续搜索，'0'退出搜索：", '\n', false)); } ``` ### 3.5 删除 ```c++ void DeleteStudent(sqlite3 *_studentDB) { ClearCconsoleScreen; do { printf_s( "支持精确/模糊搜索。\n" "通配符'%%'或'_'，%%匹配多个字符，_匹配单个字符。\n" "请输入要删除学生的关键字：" ); char searchKey[NAME_SIZE]; scanf_s("%s", searchKey, NAME_SIZE); ClearInputBuffer(getchar()); char sql[SQL_SIZE]; sprintf_s( sql, SQL_SIZE, "SELECT * FROM `"STUDENT_INFOTABLE_NAME"` WHERE `no` LIKE '%s' OR `name` LIKE '%s' OR `comprehensive` LIKE '%s'", searchKey, searchKey, searchKey ); QueryShowStudentInfoPaging(_studentDB, sql); if (IsContinueKeyChar("确认删除以上学生？'Y'删除，'0'取消：", 'Y', true)) { sprintf_s( sql, SQL_SIZE, "DELETE FROM `"STUDENT_INFOTABLE_NAME"` WHERE `no` LIKE '%s' OR `name` LIKE '%s' OR `comprehensive` LIKE '%s';", searchKey, searchKey, searchKey ); sqlite3_exec(_studentDB, ANSIToUTF8_static(sql), NULL, NULL, NULL); printf_s("删除成功。\n"); } else { printf_s("已取消删除操作。\n"); } } while (IsContinueKeyChar("回车键继续删除，'0'退出：", '\n', false)); } ``` ### 3.6 显示 ```c++ void ShowStudentInfoTable(sqlite3 *_studentDB) { ClearCconsoleScreen; QueryShowStudentInfoPaging(_studentDB, "SELECT * FROM `"STUDENT_INFOTABLE_NAME"`"