版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
1、 程序附件1:1、 主界面:学生课程成绩管理系统1、打开文件按钮:% - Executes on button press in pushbutton5.function pushbutton5_Callback(hObject, eventdata, handles)% hObject handle to pushbutton5 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDA
2、TA)global str;FileName PathName=uigetfile('*.xls'),'choose a File');str=PathName FileName;set(handles.edit1,'string',str);2、 数据库管理按扭:% - Executes on button press in pushbutton1.function pushbutton1_Callback(hObject, eventdata, handles)% hObject handle to pushbutton1 (see GCBO
3、)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)%shujukuguanli();global str;setappdata(shujukuguanli(),'str',str);3、 成绩查询按钮:% - Executes on button press in pushbutton2.function pushbutton2_Callback(hObject, eventd
4、ata, handles)% hObject handle to pushbutton2 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)global str;setappdata(chengjichaxun(),'str',str);5、 成绩直方图按钮:% - Executes on button press in pushbutton4.functio
5、n pushbutton4_Callback(hObject, eventdata, handles)% hObject handle to pushbutton4 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)global str;setappdata(chengjizhifangtu(),'str',str);6、 退出按钮:% - Executes
6、on button press in pushbutton6.function pushbutton6_Callback(hObject, eventdata, handles)% hObject handle to pushbutton6 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA) close(cjguanli();2、 子界面:数据库管理1、 显示整体数据按钮:%
7、 - Executes on button press in pushbutton1.function pushbutton1_Callback(hbject, eventdata, handles)% hObject handle to pushbutton1 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)%FileName PathName=uigetfile(
8、9;*.xls'),'choose a File');%str=PathName FileName;%set(handles.edit1,'string',str);global str1;str1=getappdata(shujukuguanli(),'str');shuzi fuhao=xlsread(str1);hj=size(shuzi,1);handles.xingming=fuhao(2:hj+1,1);set(handles.listbox1,'string',handles.xingming);set(ha
9、ndles.listbox3,'string',num2str(shuzi(:,2:end);set(handles.listbox2,'string',num2str(shuzi(:,1);handles.chengji=shuzi(:,2:end);handles.xuehao=shuzi(:,1);guidata(hObject,handles);2、 设置课程学分按钮:% - Executes on button press in pushbutton2.function pushbutton2_Callback(hObject, eventdata,
10、handles) %设置各科学分% hObject handle to pushbutton2 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)ke1xuefeng=get(handles.edit3,'string'); %各科学分ke2xuefeng=get(handles.edit4,'string'); ke3xuefeng=get(
11、handles.edit5,'string');xuefenghe=ke1xuefeng+ke2xuefeng+ke3xuefeng;%三课学分之和ke1xuefeng1=ke1xuefeng/xuefenghe; %各科学分占比ke2xuefeng1=ke2xuefeng/xuefenghe;ke3xuefeng1=ke3xuefeng/xuefenghe;ke1chengjijiaquan=handles.chengji(:,1).*ke1xuefeng1;%各科成绩乘以占比ke2chengjijiaquan=handles.chengji(:,2).*ke2xuefeng
12、1;ke3chengjijiaquan=handles.chengji(:,3).*ke3xuefeng1;jiaquanchengji=ke1chengjijiaquan + ke2chengjijiaquan + ke2chengjijiaquan;set(handles.listbox4,'string',num2str(jiaquanchengji);3、 添加按钮:% - Executes on button press in pushbutton3.function pushbutton3_Callback(hObject, eventdata, handles)
13、%添加函数% hObject handle to pushbutton3 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)global str1;mima=get(handles.edit11,'string');password='123456'k=strcmp(mima,password);if k=0 set(handles.edit1
14、1,'string','密码输入错误请重输!'); returnelse name1=get(handles.edit6,'string'); xuehao1=str2num(get(handles.edit7,'string'); kecheng11=str2num(get(handles.edit8,'string'); kecheng21=str2num(get(handles.edit9,'string'); kecheng31=str2num(get(handles.edit10,'
15、;string'); handles.xingming=handles.xingming;name1; handles.xuehao=handles.xuehao;xuehao1; handles.chengji=handles.chengji; kecheng11, kecheng21,kecheng31; guidata(hObject,handles); set(handles.listbox1,'string',handles.xingming); set(handles.listbox2,'string',num2str(handles.xue
16、hao); set(handles.listbox3,'string',num2str(handles.chengji); xlswrite(str1,handles.xingming,1,'A2'); xlswrite(str1,handles.xuehao,1,'B2'); xlswrite(str1,handles.chengji,1,'C2');end4、 按姓名查询按钮:% - Executes on button press in pushbutton6.function pushbutton6_Cllback(hOb
17、ject, eventdata, handles) %姓名查询% hObject handle to pushbutton6 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)global mm; name2=get(handles.edit6,'string');aa=strcmp(name2,handles.xingming);mm n=find(aa=1
18、); xingming=handles.xingming;xuehao=handles.xuehao;chengji=handles.chengji;if mm=0 set(handles.edit11,'string','无此人!请重输!'); returnelseset(handles.edit6,'string',xingming(mm,: );set(handles.edit7,'string',num2str(xuehao(mm,: );set(handles.edit8,'string',num2str
19、(chengji(mm,1);set(handles.edit9,'string',num2str(chengji(mm,2);set(handles.edit10,'string',num2str(chengji(mm,3);End5、 修改按钮:% - Executes on button press in pushbutton5.function pushbutton5_Callback(hObject, eventdata, handles) %修改函数% hObject handle to pushbutton5 (see GCBO)% eventda
20、ta reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)global str1;mima=get(handles.edit11,'string');password='123456'k=strcmp(mima,password);if k=0 set(handles.edit11,'string','密码输入错误请重输!'); returnelsename
21、1=get(handles.edit6,'string');xuehao1=str2num(get(handles.edit7,'string');kecheng11=str2num(get(handles.edit8,'string');kecheng21=str2num(get(handles.edit9,'string');kecheng31=str2num(get(handles.edit10,'string'); xingming=handles.xingming;xuehao=handles.xueha
22、o;chengji=handles.chengji; xingming(mm)=name1;xuehao(mm)=xuehao1;chengji(mm,:)=kecheng11,kecheng21,kecheng31; handles.xingming=xingming;handles.xuehao=xuehao;handles.chengji=chengji;guidata(hObject,handles); set(handles.listbox1,'string',handles.xingming);set(handles.listbox2,'string'
23、;,num2str(handles.xuehao);set(handles.listbox3,'string',num2str(handles.chengji);xlswrite(str1,handles.xingming,1,'A2');xlswrite(str1,handles.xuehao,1,'B2');xlswrite(str1,handles.chengji,1,'C2');end7、 返回按钮:% - Executes on button press in pushbutton8.function pushbutto
24、n8_Callback(hObject, eventdata, handles)% hObject handle to pushbutton8 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)cjguanli();close(shujukuguanli();3、 子系统成绩查询:1、 姓名查询按钮:% - Executes on button press in pushbu
25、tton1.function pushbutton1_Callback(hObject, eventdata, handles)% hObject handle to pushbutton1 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)global str1;name=get(handles.edit1,'string');str1=getappdata
26、(chengjichaxun(),'str');shuzi fuhao=xlsread(str1);handles.xingming=fuhao(2:end,1);handles.xuehao=shuzi(:,1);handles.chengji=shuzi(:,2:end);guidata(hObject,handles); chengji=handles.chengji;xuehao=handles.xuehao;xingming=handles.xingming;lia,id=ismember(name,handles.xingming); set(handles.lis
27、tbox1,'string',xingming(id,: );set(handles.listbox2,'string',num2str(xuehao(id,: );set(handles.listbox3,'string',num2str(chengji(id,: );3、 返回按钮:% - Executes on button press in pushbutton5.function pushbutton5_Callback(hObject, eventdata, handles)% hObject handle to pushbutton
28、5 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)cjguanli();close(chengjichaxun();4、 子系统:成绩排序1、 课程1排序按钮:% - Executes on button press in pushbutton1.function pushbutton1_Callback(hObject, eventdata, handles) %按课程
29、1 降序排序% hObject handle to pushbutton1 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)global shuzi;global fuhao;str1=getappdata(chengjipaixu(),'str');shuzi fuhao=xlsread(str1);handles.xingming=fuhao(2:end
30、,1);handles.xuehao=shuzi(:,1);handles.chengji=shuzi(:,2:end);handles.zhongtishuju=shuzi;zhongtishuju1=sortrows(shuzi,-2);%排序xuehao1=zhongtishuju1(:,1);chengji1=zhongtishuju1(:,2:end);hang=size(xuehao1,1); id1,id2=ismember(handles.xuehao,xuehao1); for pp=1:hang xingming1(id2(pp)=handles.xingming(pp);
31、 end xingming2=xingming1' handles.xingming22=xingming2; handles.xuehao22=xuehao1; handles.chengji22=chengji1; guidata(hObject,handles);set(handles.listbox1,'string',xingming2);set(handles.listbox2,'string',num2str(xuehao1);set(handles.listbox3,'string',num2str(chengji1);2
32、、 课程2排序按钮:% - Executes on button press in pushbutton2.function pushbutton2_Callback(hObject, eventdata, handles)%按课程2排序% hObject handle to pushbutton2 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)%global shuzi
33、;%global fuhao;str1=getappdata(chengjipaixu(),'str');shuzi fuhao=xlsread(str1);xingming=fuhao(2:end,1);xuehao=shuzi(:,1);zhongtishuju3=sortrows(shuzi,-3);%排序xuehao1=zhongtishuju3(:,1);chengji1=zhongtishuju3(:,2:end);hang=size(xuehao1,1); id1,id2=ismember(xuehao,xuehao1); for pp=1:hang xingmi
34、ng1(id2(pp)=xingming(pp); end xingming2=xingming1' handles.xingming22=xingming2; handles.xuehao22=xuehao1; handles.chengji22=chengji1; guidata(hObject,handles); set(handles.listbox1,'string',xingming2);set(handles.listbox2,'string',num2str(xuehao1);set(handles.listbox3,'strin
35、g',num2str(chengji1);4、 对排序结果保存按钮:% - Executes on button press in pushbutton5.function pushbutton5_Callback(hObject, eventdata, handles)% hObject handle to pushbutton5 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see
36、GUIDATA)str1=getappdata(chengjipaixu(),'str'); xlswrite(str1,handles.xingming22,1,'A2'); xlswrite(str1,handles.xuehao22,1,'B2'); xlswrite(str1,handles.chengji22,1,'C2');5、 返回按钮:function pushbutton4_Callback(hObject, eventdata, handles)% hObject handle to pushbutton4 (
37、see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)cjguanli();close(chengjipaixu();5、 子系统:成绩直方图1、 课程1按钮:% - Executes on button press in pushbutton2.function pushbutton2_Callback(hObject, eventdata, handles) %课程1直方图%
38、hObject handle to pushbutton2 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)str1=getappdata(chengjizhifangtu(),'str');shuzi fuhao=xlsread(str1);axes(handles.axes1);X=5,15,25,35,45,55,65,75,85,95;handles.chengji=shuzi(:,2:end);kecheng1=handles.chengji(:,1);hist(kecheng1,X);2、 课程2按扭:% - Executes on button press in push
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2024年安全教育培训试题含答案(精练)
- 2023年教师资格之幼儿综合素质押题练习试卷B卷附答案
- 2025 安全工程师(初级)考试及答案
- 2024年女职工权益保护法律知识竞赛题库及答案
- (2025年)设备维护保养培训考试卷(含答案)
- 2025叉车司机考试试题及答案
- 【房屋构造与维护管理】形成性考核册答案(附题目)
- 2022年基金从业资格考试真题及答案
- (2025)建筑安全生产知识竞赛题库及答案
- (2026版)医院感染管理相关法律法规知识试题及答案
- 中医医院卒中中心脑出血救治流程
- 《股票价值评估用》课件
- 2027贵州航天电器秋季招聘284人考试备考题库及答案解析
- 地理信息数据分类分级工作指南试行全文
- 再生水回用处理工程设计
- 【新教材核心素养】教科版科学五年级上册3.3《用弹力驱动小车》教学课件
- 企业车间主任(班组长)岗位安全职责培训
- 氧、氮、氩气管道安装施工方案
- G3111混凝土结构加固构造图集施工技术交底与验收检查表模板
- 小学五年级英语语法讲义
- 学校实习委托书范本
评论
0/150
提交评论