MATLAB學(xué)生成績管理系統(tǒng)方案

1、functionvarargout=untitledl(varargin)gui_Singleton=1;mfilename,.gui_State=struct('gui_Name','gui_Singleton',gui_Singleton,.'gui_OpeningFcn',untitled1_OpeningFcn,.'gui_OutputFcn',untitled1_OutputFcn,.'gui_LayoutFcn',.'gui_Callback',);ifnargin&&i

2、schar(varargin1)gui_State.gui_Callback=str2func(varargin1);endifnargoutvarargout1:nargout=gui_mainfcn(gui_State,varargin(:);elsegui_mainfcn(gui_State,varargin:);endfunctionuntitled1_OpeningFcn(hObject,eventdata,handles,varargin)handles.output=hObject;%取數(shù)handles.data=;%生成data空數(shù)組handles.text=;%生成text空

3、數(shù)組guidata(hObject,handles);%保存更新數(shù)據(jù)handles.output=hObject;guidata(hObject,handles);functionvarargout=untitled1_OutputFcn(hObject,eventdata,handles)varargout1=handles.output;%excel表格入口functiondaoru_Callback(hObject,eventdata,handles)%可編輯信息表格導(dǎo)入文本框functiondaoru_CreateFcn(hObject,eventdata,handles)ifispc

4、&&isequal(get(hObject,'BackgroundColor'),get(0,'defaultUicontrolBackgroundColor')set(hObject,'BackgroundColor','white');endfunctionsure_Callback(hObject,eventdata,handles)%導(dǎo)入數(shù)據(jù)確定按鈕FileName,PathName=uigetfile('*.xls','Chooseafile');str=PathName,

5、FileName;set(handles.daoru,'string',str);data,text_data=xlsread(str);mess1=data(:,1);set(handles.showI,'string',mess1)%顯示入可編輯數(shù)據(jù)導(dǎo)入文本框%讀取str并生成新的數(shù)組%訪問excel表格第一列%把字符串顯示在顯示學(xué)號列表mess3=data(:,3);set(handles.showc,'string',mess3)表mess4=data(:,4);set(handles.showm,'string',mes

6、s4)列表mess5=data(:,5);set(handles.showe,'string',mess5)列表mess2=text_data(2:end,2);set(handles.shown,'string',mess2)表%訪問excel表格第三列%把字符串顯示在顯示語文列%訪問excel列表第四列%把字符串顯示在顯示數(shù)學(xué)%訪問excel列表第五列%把字符串顯示在顯示英語%訪問excel列表第二列%把字符串顯示在顯示名字列handles.mess2=mess2handles.data=data;%保存數(shù)據(jù)handles.text=text_data;gu

7、idata(hObject,handles);信息查詢顯示口functionsearchz_Callback(hObject,eventdata,handles)%可編輯總分輸出文本框functionsearchz_CreateFcn(hObject,eventdata,handles)ifispc&&isequal(get(hObject,'BackgroundColor'),get(0,'defaultUicontrolBackgroundColor')set(hObject,'BackgroundColor','wh

8、ite');endfunctionsearche_Callback(hObject,eventdata,handles)%可編輯英語輸出文本框functionsearche_CreateFcn(hObject,eventdata,handles)ifispc&&isequal(get(hObject,'BackgroundColor'),get(0,'defaultUicontrolBackgroundColor')set(hObject,'BackgroundColor','white');endfunc

9、tionsearchm_Callback(hObject,eventdata,handles)%可編輯數(shù)學(xué)輸出文本框functionsearchm_CreateFcn(hObject,eventdata,handles)ifispc&&isequal(get(hObject,'BackgroundColor'),get(0,'defaultUicontrolBackgroundColor')set(hObject,'BackgroundColor','white');endfunctionsearchc_Callb

10、ack(hObject,eventdata,handles)%可編輯語文輸出文本框functionsearchc_CreateFcn(hObject,eventdata,handles)ifispc&&isequal(get(hObject,'BackgroundColor'),get(0,'defaultUicontrolBackgroundColor')set(hObject,'BackgroundColor','white');endfunctionsearchp_Callback(hObject,event

11、data,handles)%可編輯名次輸出文本框functionsearchp_CreateFcn(hObject,eventdata,handles)ifispc&&isequal(get(hObject,'BackgroundColor'),get(0,'defaultUicontrolBackgroundColor')set(hObject,'BackgroundColor','white');end%信息輸入口functionID_Callback(hObject,eventdata,handles)%可編

12、輯學(xué)號輸入信息文本框functionID_CreateFcn(hObject,eventdata,handles)ifispc&&isequal(get(hObject,'BackgroundColor'),get(0,'defaultUicontrolBackgroundColor')set(hObject,'BackgroundColor','white');endfunctionname_Callback(hObject,eventdata,handles)%可編輯名字輸入信息文本框functionname_

13、CreateFcn(hObject,eventdata,handles)ifispc&&isequal(get(hObject,'BackgroundColor'),get(0,'defaultUicontrolBackgroundColor')set(hObject,'BackgroundColor','white');endfunctionsearchsoCallback(hObject,eventdata,handles)%搜索確定按鈕str=get(handles.ID,'string');

14、iflength(str)=0str_temp=str2double(str);l1=handles.data(:,1);l2=length(l1);l3=l2+201200;if(201200<str_temp)&&(str_temp<=l3)set(,'string','')index=find(handles.data(:)=(str_temp);數(shù)值相等的數(shù)據(jù)i,j=ind2sub(size(handles.data),index);表編號%學(xué)號字符串信息輸入查找%空字符串%字符串轉(zhuǎn)換為數(shù)值%學(xué)號查詢范

15、圍%名字輸入框?yàn)榭?查找全元素與學(xué)號%把單序號轉(zhuǎn)換成全下%生成只訪問i行的數(shù)str1=handles.data(i,:);str11=;str11fori=1:size(handles.data,2)1,步長為1,最大值為size值endstr11=strcat(str11,num2str(str1(i);set(handles.searchc,'string',num2str(str1(3);文列表set(handles.searchm,'string',num2str(str1(4);學(xué)列表set(handles.searche,'string

16、9;,num2str(str1(5);語列表set(handles.searchz,'string',num2str(str1(6);分列表i=handles.data(:,6);i=flipud(sort(i);val=find(i=str1(6);val=val(1);set(handles.searchp,'string',num2str(val)elseset(handles.searchc,'string','Nothing');%生成新的空數(shù)組%for語句，初始值為%橫向連接字符串%把字符串顯示在顯示語%把字符串顯示在

17、顯示數(shù)%把字符串顯示在顯示英%把字符串顯示在顯示總%總分升序%總分降序%總分名次%總分名次顯示%總分名次顯示%顯示無數(shù)據(jù)set(handles.searchm,'string','Nothing');set(handles.searche,'string','Nothing');set(handles.searchz,'string','Nothing');set(handles.searchp,'string','Nothing');endelsename1=get

18、(,'string');name2=char(handles.text(2:end,2);name11=name1(1)name12=name1(2)name21=char(name2(:,1)name22=name2(:,2)i,j=find(name21=name11)m,n=find(name22=name12)ifi=mstr1=handles.data(i,:);set(handles.searchc,'string',num2str(str1(3)串顯示在顯示語文列表set(handles.searchm,'strin

19、g',num2str(str1(4)符串顯示在顯示數(shù)學(xué)列表set(handles.searche,'string',num2str(str1(5)串顯示在顯示英語列表%獲得信息入口名字%名字字符串轉(zhuǎn)換%只顯示姓%只顯示名%只顯示姓%只顯示名%姓位置查找%名位置查找%行標(biāo)確定%查找全部數(shù)據(jù)%把字符%把字%把字符%把字符set(handles.searchz,'string',num2str(str1(6)串顯示在顯示總分列表i=handles.data(:,6);%總分升序i=flipud(sort(i);%總分降序val=find(i=str1(6);%

20、總分名次val=val(1);set(handles.searchp,'string',num2str(val)%總分名次顯示elseset(handles.searchc,'string','Nothing');%顯示無數(shù)據(jù)set(handles.searchm,'string','Nothing');set(handles.searche,'string','Nothing');set(handles.searchz,'string','Nothing&#

21、39;);set(handles.searchp,'string','Nothing');endendfunctionshowI_Callback(hObject,eventdata,handles)%學(xué)號顯示列表框functionshowI_CreateFcn(hObject,eventdata,handles)ifispc&&isequal(get(hObject,'BackgroundColor'),get(0,'defaultUicontrolBackgroundColor')set(hObject,

22、9;BackgroundColor','white');endfunctionshown_Callback(hObject,eventdata,handles)%名字顯示列表框functionshown_CreateFcn(hObject,eventdata,handles)ifispc&&isequal(get(hObject,'BackgroundColor'),get(0,'defaultUicontrolBackgroundColor')set(hObject,'BackgroundColor','white');endfunctionshowc_Callback(hObject,eventdata,handles)%語文顯示列表框functionshowc_CreateFcn(hOb