《matlabgui数据管理系统.doc》由会员分享,可在线阅读,更多相关《matlabgui数据管理系统.doc(19页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
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; PathName=uigetfile(*.xls),choose a File);str=PathName ;set(handles.edit1,string,str);2、 数据库管理按扭:% - Executes on button press in pushbutton1.function pushbutton1_Callback(hObject, eventdata, handles)% hObject handle to pushbutton1 (see GCBO)% eventdata reserved - to be defined in a fut
3、ure 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, eventdata, handles)% hObject handle to pushbutton2 (see GCBO)%
4、 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.function pushbutton4_Callback(hObject, eventdata, handles)% hObject handl
5、e 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 on button press in pushbutton6.function pushbutton6_Callback(hObject, eventd
6、ata, 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();二、 子界面:数据库管理1、 显示整体数据按钮:% - Executes on button press in pushbutton1.function pushbutton1_Callback(hbj
7、ect, 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)% PathName=uigetfile(*.xls),choose a File);%str=PathName ;%set(handles.edit1,string,str);global str1;str1=ge
8、tappdata(shujukuguanli(),str);shuzi fuhao=xlsread(str1);hj=size(shuzi,1);handles.xingming=fuhao(2:hj+1,1);set(handles.listbox1,string,handles.xingming);set(handles.listbox3,string,num2str(shuzi(:,2:end);set(handles.listbox2,string,num2str(shuzi(:,1);handles.chengji=shuzi(:,2:end);handles.xuehao=shuz
9、i(:,1);guidata(hObject,handles);2、 设置课程学分按钮:% - Executes on button press in pushbutton2.function pushbutton2_Callback(hObject, eventdata, handles) %设置各科学分% hObject handle to pushbutton2 (see GCBO)% eventdata reserved - to be defined in a future version of MATLAB% handles structure with handles and u
10、ser data (see GUIDATA)ke1xuefeng=get(handles.edit3,string); %各科学分ke2xuefeng=get(handles.edit4,string); ke3xuefeng=get(handles.edit5,string);xuefenghe=ke1xuefeng+ke2xuefeng+ke3xuefeng;%三课学分之和ke1xuefeng1=ke1xuefeng/xuefenghe; %各科学分占比ke2xuefeng1=ke2xuefeng/xuefenghe;ke3xuefeng1=ke3xuefeng/xuefenghe;ke1
11、chengjijiaquan=handles.chengji(:,1).*ke1xuefeng1;%各科成绩乘以占比ke2chengjijiaquan=handles.chengji(:,2).*ke2xuefeng1;ke3chengjijiaquan=handles.chengji(:,3).*ke3xuefeng1;jiaquanchengji=ke1chengjijiaquan + ke2chengjijiaquan + ke2chengjijiaquan;set(handles.listbox4,string,num2str(jiaquanchengji);3、 添加按钮:% - E
12、xecutes on button press in pushbutton3.function pushbutton3_Callback(hObject, eventdata, handles) %添加函数% 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.
13、edit11,string);password=123456;k=strcmp(mima,password);if k=0 set(handles.edit11,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(
14、handles.edit10,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.xuehao); set(h
15、andles.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(hObject, eventdata, handles) %姓名查询% hObject handle to
16、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);xingming=handles.xingming;xuehao=handles.xuehao;chengji=hand
17、les.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(chengji(mm,1);set(handles.edit9,string,num2str(chengji(mm,2);set(handles.edit10,string,num2str(chengji(mm,3);End
18、5、 修改按钮:% - 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 GUIDATA)global str1;mima
19、=get(handles.edit11,string);password=123456;k=strcmp(mima,password);if k=0 set(handles.edit11,string,密码输入错误请重输!); returnelsename1=get(handles.edit6,string);xuehao1=str2num(get(handles.edit7,string);kecheng11=str2num(get(handles.edit8,string);kecheng21=str2num(get(handles.edit9,string);kecheng31=str2
20、num(get(handles.edit10,string);xingming=handles.xingming;xuehao=handles.xuehao;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.listbo
21、x1,string,handles.xingming);set(handles.listbox2,string,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.func
22、tion pushbutton8_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();三、 子系统成绩查询:1、 姓名查询按钮:% - Executes on button p
23、ress in pushbutton1.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=getapp
24、data(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.listbox1,st
25、ring,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 pushbutton5 (see GCBO)% eventdata reserved - to
26、be defined in a future version of MATLAB% handles structure with handles and user data (see GUIDATA)cjguanli();close(chengjichaxun();四、 子系统:成绩排序1、 课程1排序按钮:% - Executes on button press in pushbutton1.function pushbutton1_Callback(hObject, eventdata, handles) %按课程1 降序排序% hObject handle to pushbutton1
27、(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,1);handles.xuehao=shuzi(:,1);handles.chengji=sh
28、uzi(:,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); end xingming2=xingming1; handles.xingming22=xin
29、gming2; 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、 课程2排序按钮:% - Executes on button press in pushbutton2.function pushbutton2_Callbac
30、k(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;%global fuhao;str1=getappdata(chengjipaixu(),str);shuzi fuhao=xlsread(str1);xingm
31、ing=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 xingming1(id2(pp)=xingming(pp); end xingming2=xingming1; handles.xingming22=xingming2; handles.xue
32、hao22=xuehao1; handles.chengji22=chengji1; guidata(hObject,handles);set(handles.listbox1,string,xingming2);set(handles.listbox2,string,num2str(xuehao1);set(handles.listbox3,string,num2str(chengji1);4、 对排序结果保存按钮:% - Executes on button press in pushbutton5.function pushbutton5_Callback(hObject, eventd
33、ata, 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 GUIDATA)str1=getappdata(chengjipaixu(),str); xlswrite(str1,handles.xingming22,1,A2); xlswrite(str1,handles.xuehao22,1,B2); xlsw
34、rite(str1,handles.chengji22,1,C2);5、 返回按钮:function 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)cjguanli();close(chengjipaixu();
35、五、 子系统:成绩直方图1、 课程1按钮:% - Executes on button press in pushbutton2.function pushbutton2_Callback(hObject, eventdata, handles) %课程1直方图% 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)s
36、tr1=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 pushbutton6.function pushbutton6_Callback(hObject, eventdata, han
37、dles)% 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)str1=getappdata(chengjizhifangtu(),str);shuzi fuhao=xlsread(str1);axes(handles.axes2);X=5,15,25,35,45,55,65,75,85,95;handles.ch
38、engji=shuzi(:,2:end);kecheng2=handles.chengji(:,2);hist(kecheng2,X);xlabel(分数);ylabel(人数);3、 课程3按钮:% - Executes on button press in pushbutton4.function pushbutton4_Callback(hObject, eventdata, handles)% hObject handle to pushbutton4 (see GCBO)% eventdata reserved - to be defined in a future version
39、of MATLAB% handles structure with handles and user data (see GUIDATA)str1=getappdata(chengjizhifangtu(),str);shuzi fuhao=xlsread(str1);axes(handles.axes3);X=5,15,25,35,45,55,65,75,85,95;handles.chengji=shuzi(:,2:end);kecheng3=handles.chengji(:,3);hist(kecheng3,X);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 GUIDATA)cjguanli();close(chengjizhifangtu();第 19 页
限制150内