来了,老弟,不收藏你就后悔吧 !****点赞👍收藏⭐️留言📝 不迷路~~~
😈「作者主页 」:鱼酱2333
😈「 B站首页 」:鱼酱2333
😈「本文录入专栏」:Qt学生管理系统
😈「本文内容」:介绍学生管理系统专栏,必看
文章目录
1.前言
😀请仔细看这段文字:为了帮助那些期末无法交作业的同学,开发了一个学生信息管理系统(垃圾版本,但是对初学者帮助大,强烈建议大家看我视频,而不是购买专栏)。
如果支持作者,也可以购买一份。你的支持是我创作的最大动力。
B站链接 https://space.bilibili.com/523392138/channel/seriesdetail?sid=1939115
2.视频教程全部(免费)
博主B站的视频教程
Qt学生管理系统1项目设计与布局开发
Qt学生管理系统2数据库设计与开发
Qt学生管理系统3界面美化
Qt学生管理系统4数据模拟与数据显示
Qt学生管理系统5增加更新删除功能开发
Qt学生管理系统6开发筛选功能
Qt学生管理系统7问题修改
Qt学生管理系统完结篇
3.专栏导航
1.【Qt学生信息管理系统】1.专栏介绍(附免费视频)
2.【Qt学生信息管理系统】2.完整版源码
4.效果图
5.【学生信息管理系统】界面设计
#mermaid-svg-djyuMyh4W7vvxmhv .label{font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family);fill:#333;color:#333}#mermaid-svg-djyuMyh4W7vvxmhv .label text{fill:#333}#mermaid-svg-djyuMyh4W7vvxmhv .node rect,#mermaid-svg-djyuMyh4W7vvxmhv .node circle,#mermaid-svg-djyuMyh4W7vvxmhv .node ellipse,#mermaid-svg-djyuMyh4W7vvxmhv .node polygon,#mermaid-svg-djyuMyh4W7vvxmhv .node path{fill:#ECECFF;stroke:#9370db;stroke-width:1px}#mermaid-svg-djyuMyh4W7vvxmhv .node .label{text-align:center;fill:#333}#mermaid-svg-djyuMyh4W7vvxmhv .node.clickable{cursor:pointer}#mermaid-svg-djyuMyh4W7vvxmhv .arrowheadPath{fill:#333}#mermaid-svg-djyuMyh4W7vvxmhv .edgePath .path{stroke:#333;stroke-width:1.5px}#mermaid-svg-djyuMyh4W7vvxmhv .flowchart-link{stroke:#333;fill:none}#mermaid-svg-djyuMyh4W7vvxmhv .edgeLabel{background-color:#e8e8e8;text-align:center}#mermaid-svg-djyuMyh4W7vvxmhv .edgeLabel rect{opacity:0.9}#mermaid-svg-djyuMyh4W7vvxmhv .edgeLabel span{color:#333}#mermaid-svg-djyuMyh4W7vvxmhv .cluster rect{fill:#ffffde;stroke:#aa3;stroke-width:1px}#mermaid-svg-djyuMyh4W7vvxmhv .cluster text{fill:#333}#mermaid-svg-djyuMyh4W7vvxmhv div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family);font-size:12px;background:#ffffde;border:1px solid #aa3;border-radius:2px;pointer-events:none;z-index:100}#mermaid-svg-djyuMyh4W7vvxmhv .actor{stroke:#ccf;fill:#ECECFF}#mermaid-svg-djyuMyh4W7vvxmhv text.actor>tspan{fill:#000;stroke:none}#mermaid-svg-djyuMyh4W7vvxmhv .actor-line{stroke:grey}#mermaid-svg-djyuMyh4W7vvxmhv .messageLine0{stroke-width:1.5;stroke-dasharray:none;stroke:#333}#mermaid-svg-djyuMyh4W7vvxmhv .messageLine1{stroke-width:1.5;stroke-dasharray:2, 2;stroke:#333}#mermaid-svg-djyuMyh4W7vvxmhv #arrowhead path{fill:#333;stroke:#333}#mermaid-svg-djyuMyh4W7vvxmhv .sequenceNumber{fill:#fff}#mermaid-svg-djyuMyh4W7vvxmhv #sequencenumber{fill:#333}#mermaid-svg-djyuMyh4W7vvxmhv #crosshead path{fill:#333;stroke:#333}#mermaid-svg-djyuMyh4W7vvxmhv .messageText{fill:#333;stroke:#333}#mermaid-svg-djyuMyh4W7vvxmhv .labelBox{stroke:#ccf;fill:#ECECFF}#mermaid-svg-djyuMyh4W7vvxmhv .labelText,#mermaid-svg-djyuMyh4W7vvxmhv .labelText>tspan{fill:#000;stroke:none}#mermaid-svg-djyuMyh4W7vvxmhv .loopText,#mermaid-svg-djyuMyh4W7vvxmhv .loopText>tspan{fill:#000;stroke:none}#mermaid-svg-djyuMyh4W7vvxmhv .loopLine{stroke-width:2px;stroke-dasharray:2, 2;stroke:#ccf;fill:#ccf}#mermaid-svg-djyuMyh4W7vvxmhv .note{stroke:#aa3;fill:#fff5ad}#mermaid-svg-djyuMyh4W7vvxmhv .noteText,#mermaid-svg-djyuMyh4W7vvxmhv .noteText>tspan{fill:#000;stroke:none}#mermaid-svg-djyuMyh4W7vvxmhv .activation0{fill:#f4f4f4;stroke:#666}#mermaid-svg-djyuMyh4W7vvxmhv .activation1{fill:#f4f4f4;stroke:#666}#mermaid-svg-djyuMyh4W7vvxmhv .activation2{fill:#f4f4f4;stroke:#666}#mermaid-svg-djyuMyh4W7vvxmhv .mermaid-main-font{font-family:"trebuchet ms", verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-djyuMyh4W7vvxmhv .section{stroke:none;opacity:0.2}#mermaid-svg-djyuMyh4W7vvxmhv .section0{fill:rgba(102,102,255,0.49)}#mermaid-svg-djyuMyh4W7vvxmhv .section2{fill:#fff400}#mermaid-svg-djyuMyh4W7vvxmhv .section1,#mermaid-svg-djyuMyh4W7vvxmhv .section3{fill:#fff;opacity:0.2}#mermaid-svg-djyuMyh4W7vvxmhv .sectionTitle0{fill:#333}#mermaid-svg-djyuMyh4W7vvxmhv .sectionTitle1{fill:#333}#mermaid-svg-djyuMyh4W7vvxmhv .sectionTitle2{fill:#333}#mermaid-svg-djyuMyh4W7vvxmhv .sectionTitle3{fill:#333}#mermaid-svg-djyuMyh4W7vvxmhv .sectionTitle{text-anchor:start;font-size:11px;text-height:14px;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-djyuMyh4W7vvxmhv .grid .tick{stroke:#d3d3d3;opacity:0.8;shape-rendering:crispEdges}#mermaid-svg-djyuMyh4W7vvxmhv .grid .tick text{font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-djyuMyh4W7vvxmhv .grid path{stroke-width:0}#mermaid-svg-djyuMyh4W7vvxmhv .today{fill:none;stroke:red;stroke-width:2px}#mermaid-svg-djyuMyh4W7vvxmhv .task{stroke-width:2}#mermaid-svg-djyuMyh4W7vvxmhv .taskText{text-anchor:middle;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-djyuMyh4W7vvxmhv .taskText:not([font-size]){font-size:11px}#mermaid-svg-djyuMyh4W7vvxmhv .taskTextOutsideRight{fill:#000;text-anchor:start;font-size:11px;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-djyuMyh4W7vvxmhv .taskTextOutsideLeft{fill:#000;text-anchor:end;font-size:11px}#mermaid-svg-djyuMyh4W7vvxmhv .task.clickable{cursor:pointer}#mermaid-svg-djyuMyh4W7vvxmhv .taskText.clickable{cursor:pointer;fill:#003163 !important;font-weight:bold}#mermaid-svg-djyuMyh4W7vvxmhv .taskTextOutsideLeft.clickable{cursor:pointer;fill:#003163 !important;font-weight:bold}#mermaid-svg-djyuMyh4W7vvxmhv .taskTextOutsideRight.clickable{cursor:pointer;fill:#003163 !important;font-weight:bold}#mermaid-svg-djyuMyh4W7vvxmhv .taskText0,#mermaid-svg-djyuMyh4W7vvxmhv .taskText1,#mermaid-svg-djyuMyh4W7vvxmhv .taskText2,#mermaid-svg-djyuMyh4W7vvxmhv .taskText3{fill:#fff}#mermaid-svg-djyuMyh4W7vvxmhv .task0,#mermaid-svg-djyuMyh4W7vvxmhv .task1,#mermaid-svg-djyuMyh4W7vvxmhv .task2,#mermaid-svg-djyuMyh4W7vvxmhv .task3{fill:#8a90dd;stroke:#534fbc}#mermaid-svg-djyuMyh4W7vvxmhv .taskTextOutside0,#mermaid-svg-djyuMyh4W7vvxmhv .taskTextOutside2{fill:#000}#mermaid-svg-djyuMyh4W7vvxmhv .taskTextOutside1,#mermaid-svg-djyuMyh4W7vvxmhv .taskTextOutside3{fill:#000}#mermaid-svg-djyuMyh4W7vvxmhv .active0,#mermaid-svg-djyuMyh4W7vvxmhv .active1,#mermaid-svg-djyuMyh4W7vvxmhv .active2,#mermaid-svg-djyuMyh4W7vvxmhv .active3{fill:#bfc7ff;stroke:#534fbc}#mermaid-svg-djyuMyh4W7vvxmhv .activeText0,#mermaid-svg-djyuMyh4W7vvxmhv .activeText1,#mermaid-svg-djyuMyh4W7vvxmhv .activeText2,#mermaid-svg-djyuMyh4W7vvxmhv .activeText3{fill:#000 !important}#mermaid-svg-djyuMyh4W7vvxmhv .done0,#mermaid-svg-djyuMyh4W7vvxmhv .done1,#mermaid-svg-djyuMyh4W7vvxmhv .done2,#mermaid-svg-djyuMyh4W7vvxmhv .done3{stroke:grey;fill:#d3d3d3;stroke-width:2}#mermaid-svg-djyuMyh4W7vvxmhv .doneText0,#mermaid-svg-djyuMyh4W7vvxmhv .doneText1,#mermaid-svg-djyuMyh4W7vvxmhv .doneText2,#mermaid-svg-djyuMyh4W7vvxmhv .doneText3{fill:#000 !important}#mermaid-svg-djyuMyh4W7vvxmhv .crit0,#mermaid-svg-djyuMyh4W7vvxmhv .crit1,#mermaid-svg-djyuMyh4W7vvxmhv .crit2,#mermaid-svg-djyuMyh4W7vvxmhv .crit3{stroke:#f88;fill:red;stroke-width:2}#mermaid-svg-djyuMyh4W7vvxmhv .activeCrit0,#mermaid-svg-djyuMyh4W7vvxmhv .activeCrit1,#mermaid-svg-djyuMyh4W7vvxmhv .activeCrit2,#mermaid-svg-djyuMyh4W7vvxmhv .activeCrit3{stroke:#f88;fill:#bfc7ff;stroke-width:2}#mermaid-svg-djyuMyh4W7vvxmhv .doneCrit0,#mermaid-svg-djyuMyh4W7vvxmhv .doneCrit1,#mermaid-svg-djyuMyh4W7vvxmhv .doneCrit2,#mermaid-svg-djyuMyh4W7vvxmhv .doneCrit3{stroke:#f88;fill:#d3d3d3;stroke-width:2;cursor:pointer;shape-rendering:crispEdges}#mermaid-svg-djyuMyh4W7vvxmhv .milestone{transform:rotate(45deg) scale(0.8, 0.8)}#mermaid-svg-djyuMyh4W7vvxmhv .milestoneText{font-style:italic}#mermaid-svg-djyuMyh4W7vvxmhv .doneCritText0,#mermaid-svg-djyuMyh4W7vvxmhv .doneCritText1,#mermaid-svg-djyuMyh4W7vvxmhv .doneCritText2,#mermaid-svg-djyuMyh4W7vvxmhv .doneCritText3{fill:#000 !important}#mermaid-svg-djyuMyh4W7vvxmhv .activeCritText0,#mermaid-svg-djyuMyh4W7vvxmhv .activeCritText1,#mermaid-svg-djyuMyh4W7vvxmhv .activeCritText2,#mermaid-svg-djyuMyh4W7vvxmhv .activeCritText3{fill:#000 !important}#mermaid-svg-djyuMyh4W7vvxmhv .titleText{text-anchor:middle;font-size:18px;fill:#000;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-djyuMyh4W7vvxmhv g.classGroup text{fill:#9370db;stroke:none;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family);font-size:10px}#mermaid-svg-djyuMyh4W7vvxmhv g.classGroup text .title{font-weight:bolder}#mermaid-svg-djyuMyh4W7vvxmhv g.clickable{cursor:pointer}#mermaid-svg-djyuMyh4W7vvxmhv g.classGroup rect{fill:#ECECFF;stroke:#9370db}#mermaid-svg-djyuMyh4W7vvxmhv g.classGroup line{stroke:#9370db;stroke-width:1}#mermaid-svg-djyuMyh4W7vvxmhv .classLabel .box{stroke:none;stroke-width:0;fill:#ECECFF;opacity:0.5}#mermaid-svg-djyuMyh4W7vvxmhv .classLabel .label{fill:#9370db;font-size:10px}#mermaid-svg-djyuMyh4W7vvxmhv .relation{stroke:#9370db;stroke-width:1;fill:none}#mermaid-svg-djyuMyh4W7vvxmhv .dashed-line{stroke-dasharray:3}#mermaid-svg-djyuMyh4W7vvxmhv #compositionStart{fill:#9370db;stroke:#9370db;stroke-width:1}#mermaid-svg-djyuMyh4W7vvxmhv #compositionEnd{fill:#9370db;stroke:#9370db;stroke-width:1}#mermaid-svg-djyuMyh4W7vvxmhv #aggregationStart{fill:#ECECFF;stroke:#9370db;stroke-width:1}#mermaid-svg-djyuMyh4W7vvxmhv #aggregationEnd{fill:#ECECFF;stroke:#9370db;stroke-width:1}#mermaid-svg-djyuMyh4W7vvxmhv #dependencyStart{fill:#9370db;stroke:#9370db;stroke-width:1}#mermaid-svg-djyuMyh4W7vvxmhv #dependencyEnd{fill:#9370db;stroke:#9370db;stroke-width:1}#mermaid-svg-djyuMyh4W7vvxmhv #extensionStart{fill:#9370db;stroke:#9370db;stroke-width:1}#mermaid-svg-djyuMyh4W7vvxmhv #extensionEnd{fill:#9370db;stroke:#9370db;stroke-width:1}#mermaid-svg-djyuMyh4W7vvxmhv .commit-id,#mermaid-svg-djyuMyh4W7vvxmhv .commit-msg,#mermaid-svg-djyuMyh4W7vvxmhv .branch-label{fill:lightgrey;color:lightgrey;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-djyuMyh4W7vvxmhv .pieTitleText{text-anchor:middle;font-size:25px;fill:#000;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-djyuMyh4W7vvxmhv .slice{font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-djyuMyh4W7vvxmhv g.stateGroup text{fill:#9370db;stroke:none;font-size:10px;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-djyuMyh4W7vvxmhv g.stateGroup text{fill:#9370db;fill:#333;stroke:none;font-size:10px}#mermaid-svg-djyuMyh4W7vvxmhv g.statediagram-cluster .cluster-label text{fill:#333}#mermaid-svg-djyuMyh4W7vvxmhv g.stateGroup .state-title{font-weight:bolder;fill:#000}#mermaid-svg-djyuMyh4W7vvxmhv g.stateGroup rect{fill:#ECECFF;stroke:#9370db}#mermaid-svg-djyuMyh4W7vvxmhv g.stateGroup line{stroke:#9370db;stroke-width:1}#mermaid-svg-djyuMyh4W7vvxmhv .transition{stroke:#9370db;stroke-width:1;fill:none}#mermaid-svg-djyuMyh4W7vvxmhv .stateGroup .composit{fill:white;border-bottom:1px}#mermaid-svg-djyuMyh4W7vvxmhv .stateGroup .alt-composit{fill:#e0e0e0;border-bottom:1px}#mermaid-svg-djyuMyh4W7vvxmhv .state-note{stroke:#aa3;fill:#fff5ad}#mermaid-svg-djyuMyh4W7vvxmhv .state-note text{fill:black;stroke:none;font-size:10px}#mermaid-svg-djyuMyh4W7vvxmhv .stateLabel .box{stroke:none;stroke-width:0;fill:#ECECFF;opacity:0.7}#mermaid-svg-djyuMyh4W7vvxmhv .edgeLabel text{fill:#333}#mermaid-svg-djyuMyh4W7vvxmhv .stateLabel text{fill:#000;font-size:10px;font-weight:bold;font-family:'trebuchet ms', verdana, arial;font-family:var(--mermaid-font-family)}#mermaid-svg-djyuMyh4W7vvxmhv .node circle.state-start{fill:black;stroke:black}#mermaid-svg-djyuMyh4W7vvxmhv .node circle.state-end{fill:black;stroke:white;stroke-width:1.5}#mermaid-svg-djyuMyh4W7vvxmhv #statediagram-barbEnd{fill:#9370db}#mermaid-svg-djyuMyh4W7vvxmhv .statediagram-cluster rect{fill:#ECECFF;stroke:#9370db;stroke-width:1px}#mermaid-svg-djyuMyh4W7vvxmhv .statediagram-cluster rect.outer{rx:5px;ry:5px}#mermaid-svg-djyuMyh4W7vvxmhv .statediagram-state .divider{stroke:#9370db}#mermaid-svg-djyuMyh4W7vvxmhv .statediagram-state .title-state{rx:5px;ry:5px}#mermaid-svg-djyuMyh4W7vvxmhv .statediagram-cluster.statediagram-cluster .inner{fill:white}#mermaid-svg-djyuMyh4W7vvxmhv .statediagram-cluster.statediagram-cluster-alt .inner{fill:#e0e0e0}#mermaid-svg-djyuMyh4W7vvxmhv .statediagram-cluster .inner{rx:0;ry:0}#mermaid-svg-djyuMyh4W7vvxmhv .statediagram-state rect.basic{rx:5px;ry:5px}#mermaid-svg-djyuMyh4W7vvxmhv .statediagram-state rect.divider{stroke-dasharray:10,10;fill:#efefef}#mermaid-svg-djyuMyh4W7vvxmhv .note-edge{stroke-dasharray:5}#mermaid-svg-djyuMyh4W7vvxmhv .statediagram-note rect{fill:#fff5ad;stroke:#aa3;stroke-width:1px;rx:0;ry:0}:root{--mermaid-font-family: '"trebuchet ms", verdana, arial';--mermaid-font-family: "Comic Sans MS", "Comic Sans", cursive}#mermaid-svg-djyuMyh4W7vvxmhv .error-icon{fill:#522}#mermaid-svg-djyuMyh4W7vvxmhv .error-text{fill:#522;stroke:#522}#mermaid-svg-djyuMyh4W7vvxmhv .edge-thickness-normal{stroke-width:2px}#mermaid-svg-djyuMyh4W7vvxmhv .edge-thickness-thick{stroke-width:3.5px}#mermaid-svg-djyuMyh4W7vvxmhv .edge-pattern-solid{stroke-dasharray:0}#mermaid-svg-djyuMyh4W7vvxmhv .edge-pattern-dashed{stroke-dasharray:3}#mermaid-svg-djyuMyh4W7vvxmhv .edge-pattern-dotted{stroke-dasharray:2}#mermaid-svg-djyuMyh4W7vvxmhv .marker{fill:#333}#mermaid-svg-djyuMyh4W7vvxmhv .marker.cross{stroke:#333}
:root { --mermaid-font-family: "trebuchet ms", verdana, arial;}#mermaid-svg-djyuMyh4W7vvxmhv {
color: rgba(0, 0, 0, 0.75);
font: ;
}
1.主界面
学生管理界面
用户管理界面
对话框界面
2.登录界面
界面设计因为PR用的不行事,所以用excel搞定
- 登陆界面
- 学生管理界面
- 管理员界面
6.【学生信息管理系统】需求分析
功能列表:
1.登陆界面,输入用户名和密码
2.权限管理,分为浏览权限和管理员权限,浏览权限无法删除和添加
3.学生添加、删除、搜索、导出、分页
4.学生信息:姓名、学号、年龄、年级、班级、微信、电话)
7.【学生信息管理系统】系统设计
- Sqlite3类:负责数据库操作
- MainWindow类:主界面
- Cell_Student类:学生管理界面
- Cell_Test类:测试界面
- Cell_Admin类:管理员界面
- Dlg_AddPerson类:添加用户界面
- Tester类:测试界面
8.【学生信息管理系统】详细设计
8.1数据库设计
- 学生表 student
数据库字段名称类型id唯一标识主键自增name姓名Textage年龄integergrade年级integerclass班级integerstudentid学号integerphone电话TEXTwechat微信TEXTsql语句
CREATETABLE"student"("id"integerNOTNULLPRIMARYKEY AUTOINCREMENT,"name "TEXT,"age "integer,"grade"integer,"class"integer,"studentid "integer,"phone"TEXT,"wechat "TEXT);
- 用户表 user
数据库字段名称类型username用户名TEXTpassword密码TEXTaut权限TEXTsql语句
CREATETABLE"username"("username"TEXT,"password"TEXT,"auth"TEXT);
8.2Sql语句设计
- 查询所有学生数量
selectcount(id)from student;
- 查询第几页学生数据
offset代表从第几条记录“之后“开始查询,limit表明查询多少条结果
select*from student orderby id limit2offset1;
- 增加学生
INSERTINTO"student"VALUES(NULL,'张三',12,3,2,1,15940224444,'asdzhang');
- 删除学生
deletefrom student where id =1;
- 清空学生表
deletefrom student
- 修改学生信息
update student set name ='asd'where id=25;
- 查询所有用户
select*from username
- 查询用户名是否存在
select*from username where username='admin';
- 修改用户权限
update username set auth='user';
- 添加单个用户
INSERTINTO"username"VALUES('admin',111,'admin');
- 删除单个用户
deletefrom username where username='admin';
版权归原作者 鱼酱2333 所有, 如有侵权,请联系我们删除。