matlabgui数据管理系统Word格式文档下载.docx

1、function pushbutton1_Callback（hObject, eventdata, handles）% hObject handle to pushbutton1 （see GCBO）%shujukuguanli（）;setappdata（shujukuguanli（）,str3、成绩查询按钮：% - Executes on button press in pushbutton2.function pushbutton2_Callback（hObject, eventdata, handles）% hObject handle to pushbutton2 （see GCBO）

2、setappdata（chengjichaxun（）,5、成绩直方图按钮：% - Executes on button press in pushbutton4.function pushbutton4_Callback（hObject, eventdata, handles）% hObject handle to pushbutton4 （see GCBO）setappdata（chengjizhifangtu（）,6、退出按钮：% - Executes on button press in pushbutton6.function pushbutton6_Callback（hObject,

3、 eventdata, handles）% hObject handle to pushbutton6 （see GCBO） close（cjguanli（）;2、子界面：数据库管理1、显示整体数据按钮：function pushbutton1_Callback（hbject, eventdata, handles）% PathName=uigetfile（%str=PathName ;%set（handles.edit1,global str1;str1=getappdata（shujukuguanli（）,shuzi fuhao=xlsread（str1）;hj=size（shuzi,1）

4、;handles.xingming=fuhao（2:hj+1,1）;set（handles.listbox1,handles.xingming）;set（handles.listbox3,num2str（shuzi（:,2:end）;set（handles.listbox2,1）;handles.chengji=shuzi（:end）;handles.xuehao=shuzi（:,1）;guidata（hObject,handles）;2、设置课程学分按钮：function pushbutton2_Callback（hObject, eventdata, handles） %设置各科学分ke1

5、xuefeng=get（handles.edit3, %各科学分ke2xuefeng=get（handles.edit4, ke3xuefeng=get（handles.edit5,xuefenghe=ke1xuefeng+ke2xuefeng+ke3xuefeng;%三课学分之和ke1xuefeng1=ke1xuefeng/xuefenghe; %各科学分占比ke2xuefeng1=ke2xuefeng/xuefenghe;ke3xuefeng1=ke3xuefeng/xuefenghe;ke1chengjijiaquan=handles.chengji（:,1）.*ke1xuefeng1;

6、%各科成绩乘以占比ke2chengjijiaquan=handles.chengji（:,2）.*ke2xuefeng1;ke3chengjijiaquan=handles.chengji（:,3）.*ke3xuefeng1;jiaquanchengji=ke1chengjijiaquan + ke2chengjijiaquan + ke2chengjijiaquan;set（handles.listbox4,num2str（jiaquanchengji）;3、添加按钮：% - Executes on button press in pushbutton3.function pushbutto

7、n3_Callback（hObject, eventdata, handles） %添加函数% hObject handle to pushbutton3 （see GCBO）mima=get（handles.edit11,password=123456;k=strcmp（mima,password）;if k=0 set（handles.edit11,密码输入错误请重输！ returnelse name1=get（handles.edit6, xuehao1=str2num（get（handles.edit7,）; kecheng11=str2num（get（handles.edit8, k

8、echeng21=str2num（get（handles.edit9, kecheng31=str2num（get（handles.edit10, handles.xingming=handles.xingming;name1; handles.xuehao=handles.xuehao;xuehao1; handles.chengji=handles.chengji; kecheng11, kecheng21,kecheng31; guidata（hObject,handles）; set（handles.listbox1, set（handles.listbox2,num2str（hand

9、les.xuehao）; set（handles.listbox3,num2str（handles.chengji）; xlswrite（str1,handles.xingming,1,A2 xlswrite（str1,handles.xuehao,1,B2 xlswrite（str1,handles.chengji,1,C2end4、按姓名查询按钮：function pushbutton6_Cllback（hObject, eventdata, handles） %姓名查询global mm;name2=get（handles.edit6,aa=strcmp（name2,handles.xi

10、ngming）;mm n=find（aa=1）;xingming=handles.xingming;xuehao=handles.xuehao;chengji=handles.chengji;if mm=0无此人!请重输！set（handles.edit6,xingming（mm,: ）;set（handles.edit7,num2str（xuehao（mm,: ）;set（handles.edit8,num2str（chengji（mm,1）;set（handles.edit9,num2str（chengji（mm,2）;set（handles.edit10,num2str（chengji（

11、mm,3）;End5、修改按钮：function pushbutton5_Callback（hObject, eventdata, handles） %修改函数name1=get（handles.edit6,xuehao1=str2num（get（handles.edit7,kecheng11=str2num（get（handles.edit8,kecheng21=str2num（get（handles.edit9,kecheng31=str2num（get（handles.edit10,xingming（mm）=name1;xuehao（mm）=xuehao1;chengji（mm,:）=k

12、echeng11,kecheng21,kecheng31;handles.xingming=xingming;handles.xuehao=xuehao;handles.chengji=chengji;xlswrite（str1,handles.xingming,1,xlswrite（str1,handles.xuehao,1,xlswrite（str1,handles.chengji,1,7、返回按钮：% - Executes on button press in pushbutton8.function pushbutton8_Callback（hObject, eventdata, ha

13、ndles）% hObject handle to pushbutton8 （see GCBO）cjguanli（）;close（shujukuguanli（）;3、子系统成绩查询：1、姓名查询按钮：name=get（handles.edit1,str1=getappdata（chengjichaxun（）,end,1）;lia,id=ismember（name,handles.xingming）;,xingming（id,:,num2str（xuehao（id,:,num2str（chengji（id,:3、返回按钮：close（chengjichaxun（）;4、子系统：成绩排序1、课程1

14、排序按钮：function pushbutton1_Callback（hObject, eventdata, handles） %按课程1 降序排序global shuzi;global fuhao;str1=getappdata（chengjipaixu（）,handles.zhongtishuju=shuzi;zhongtishuju1=sortrows（shuzi,-2）;%排序xuehao1=zhongtishuju1（:chengji1=zhongtishuju1（:hang=size（xuehao1,1）; id1,id2=ismember（handles.xuehao,xueha

15、o1）; for pp=1:hang xingming1（id2（pp）=handles.xingming（pp）; end xingming2=xingming1 handles.xingming22=xingming2; handles.xuehao22=xuehao1; handles.chengji22=chengji1;,xingming2）;,num2str（xuehao1）;,num2str（chengji1）;2、课程2排序按钮：function pushbutton2_Callback（hObject, eventdata, handles）%按课程2排序%global shuzi;%global fuhao;xingming=fuhao（2:xuehao=shuzi（:zhongtishuju3=sortrows（shuzi,-3）;xuehao1=zhongtishuju3（:chengji1=zhongtishuju3（: id1,id2=ismember（xuehao,xuehao1）;