matlabgui数据管理系统_第1页
matlabgui数据管理系统_第2页
matlabgui数据管理系统_第3页
matlabgui数据管理系统_第4页
matlabgui数据管理系统_第5页
已阅读5页,还剩9页未读, 继续免费阅读

下载本文档

版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领

文档简介

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. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

评论

0/150

提交评论