matlabgui数据标准管理系统

程序附件1：主界面：学生课程成绩管理系统1、打开文件按钮：%---Executesonbuttonpressinpushbutton5.functionpushbutton5_Callback(hObject,eventdata,handles)%hObjecthandletopushbutton5(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)globalstr;[FileNamePathName]=uigetfile(('*.xls'),'chooseaFile');str=[PathNameFileName];set(handles.edit1,'string',str);数据库管理按扭：%---Executesonbuttonpressinpushbutton1.functionpushbutton1_Callback(hObject,eventdata,handles)%hObjecthandletopushbutton1(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)%shujukuguanli();globalstr;setappdata(shujukuguanli(),'str',str);成绩查询按钮：%---Executesonbuttonpressinpushbutton2.functionpushbutton2_Callback(hObject,eventdata,handles)%hObjecthandletopushbutton2(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)globalstr;setappdata(chengjichaxun(),'str',str);成绩直方图按钮：%---Executesonbuttonpressinpushbutton4.functionpushbutton4_Callback(hObject,eventdata,handles)%hObjecthandletopushbutton4(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)globalstr;setappdata(chengjizhifangtu(),'str',str);退出按钮：%---Executesonbuttonpressinpushbutton6.functionpushbutton6_Callback(hObject,eventdata,handles)%hObjecthandletopushbutton6(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)close(cjguanli());子界面：数据库管理显示整体数据按钮：%---Executesonbuttonpressinpushbutton1.functionpushbutton1_Callback(hbject,eventdata,handles)%hObjecthandletopushbutton1(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)%[FileNamePathName]=uigetfile(('*.xls'),'chooseaFile');%str=[PathNameFileName];%set(handles.edit1,'string',str);globalstr1;str1=getappdata(shujukuguanli(),'str');[shuzifuhao]=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=shuzi(:,1);guidata(hObject,handles);设置课程学分按钮：%---Executesonbuttonpressinpushbutton2.functionpushbutton2_Callback(hObject,eventdata,handles)%设置各科学分%hObjecthandletopushbutton2(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)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;ke1chengjijiaquan=handles.chengji(:,1).*ke1xuefeng1;%各科成绩乘以占比ke2chengjijiaquan=handles.chengji(:,2).*ke2xuefeng1;ke3chengjijiaquan=handles.chengji(:,3).*ke3xuefeng1;jiaquanchengji=ke1chengjijiaquan+ke2chengjijiaquan+ke2chengjijiaquan;set(handles.listbox4,'string',num2str(jiaquanchengji));添加按钮：%---Executesonbuttonpressinpushbutton3.functionpushbutton3_Callback(hObject,eventdata,handles)%添加函数%hObjecthandletopushbutton3(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)globalstr1;mima=get(handles.edit11,'string');password='123456';k=strcmp(mima,password);ifk==0set(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=str2num(get(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(handles.listbox3,'string',num2str(handles.chengji));xlswrite(str1,handles.xingming,1,'A2');xlswrite(str1,handles.xuehao,1,'B2');xlswrite(str1,handles.chengji,1,'C2');end按姓名查询按钮：%---Executesonbuttonpressinpushbutton6.functionpushbutton6_Cllback(hObject,eventdata,handles)%姓名查询%hObjecthandletopushbutton6(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)globalmm;name2=get(handles.edit6,'string');aa=strcmp(name2,handles.xingming);[mmn]=find(aa==1);xingming=handles.xingming;xuehao=handles.xuehao;chengji=handles.chengji;ifmm==0set(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修改按钮：%---Executesonbuttonpressinpushbutton5.functionpushbutton5_Callback(hObject,eventdata,handles)%修改函数%hObjecthandletopushbutton5(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)globalstr1;mima=get(handles.edit11,'string');password='123456';k=strcmp(mima,password);ifk==0set(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=str2num(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.listbox1,'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');end返回按钮：%---Executesonbuttonpressinpushbutton8.functionpushbutton8_Callback(hObject,eventdata,handles)%hObjecthandletopushbutton8(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)cjguanli();close(shujukuguanli());子系统成绩查询：姓名查询按钮：%---Executesonbuttonpressinpushbutton1.functionpushbutton1_Callback(hObject,eventdata,handles)%hObjecthandletopushbutton1(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)globalstr1;name=get(handles.edit1,'string');str1=getappdata(chengjichaxun(),'str');[shuzifuhao]=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,'string',xingming(id,:));set(handles.listbox2,'string',num2str(xuehao(id,:)));set(handles.listbox3,'string',num2str(chengji(id,:)));返回按钮：%---Executesonbuttonpressinpushbutton5.functionpushbutton5_Callback(hObject,eventdata,handles)%hObjecthandletopushbutton5(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)cjguanli();close(chengjichaxun());子系统：成绩排序课程1排序按钮：%---Executesonbuttonpressinpushbutton1.functionpushbutton1_Callback(hObject,eventdata,handles)%按课程1降序排序%hObjecthandletopushbutton1(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)globalshuzi;globalfuhao;str1=getappdata(chengjipaixu(),'str');[shuzifuhao]=xlsread(str1);handles.xingming=fuhao(2:end,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);forpp=1:hangxingming1(id2(pp))=handles.xingming(pp);endxingming2=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排序按钮：%---Executesonbuttonpressinpushbutton2.functionpushbutton2_Callback(hObject,eventdata,handles)%按课程2排序%hObjecthandletopushbutton2(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)%globalshuzi;%globalfuhao;str1=getappdata(chengjipaixu(),'str');[shuzifuhao]=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);forpp=1:hangxingming1(id2(pp))=xingming(pp);endxingming2=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));对排序结果保留按钮：%---Executesonbuttonpressinpushbutton5.functionpushbutton5_Callback(hObject,eventdata,handles)%hObjecthandletopushbutton5(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)str1=getappdata(chengjipaixu(),'str');xlswrite(str1,handles.xingming22,1,'A2');xlswrite(str1,handles.xuehao22,1,'B2');xlswrite(str1,handles.chengji22,1,'C2');返回按钮：functionpushbutton4_Callback(hObject,eventdata,handles)%hObjecthandletopushbutton4(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)cjguanli();close(chengjipaixu());子系统：成绩直方图课程1按钮：%---Executesonbuttonpressinpushbutton2.functionpushbutton2_Callback(hObject,eventdata,handles)%课程1直方图%hObjecthandletopushbutton2(seeGCBO)%eventdatareserved-tobedefinedinafutureversionofMATLAB%handlesstructurewithhandlesanduserdata(seeGUIDATA)str1=getappdata(chengjizhifangtu(),'str');[shuzifuhao]=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按扭：%---Executesonbuttonpressinpushbutton6.functionpushbu