matlabgui数据管理系统.docx
- 文档编号:9312709
- 上传时间:2023-02-04
- 格式:DOCX
- 页数:17
- 大小:225.92KB
matlabgui数据管理系统.docx
《matlabgui数据管理系统.docx》由会员分享,可在线阅读,更多相关《matlabgui数据管理系统.docx(17页珍藏版)》请在冰豆网上搜索。
matlabgui数据管理系统
matlab--gui---数据管理系统
程序附件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);
2、数据库管理按扭:
%---Executesonbuttonpressinpushbutton1.
functionpushbutton1_Callback(hObject,eventdata,handles)
%hObjecthandletopushbutton1(seeGCBO)
%eventdatareserved-tobedefinedinafutureversionofMATLAB
%handlesstructurewithhandlesanduserdata(seeGUIDATA)
%shujukuguanli();
globalstr;
setappdata(shujukuguanli(),'str',str);
3、成绩查询按钮:
%---Executesonbuttonpressinpushbutton2.
functionpushbutton2_Callback(hObject,eventdata,handles)
%hObjecthandletopushbutton2(seeGCBO)
%eventdatareserved-tobedefinedinafutureversionofMATLAB
%handlesstructurewithhandlesanduserdata(seeGUIDATA)
globalstr;
setappdata(chengjichaxun(),'str',str);
5、成绩直方图按钮:
%---Executesonbuttonpressinpushbutton4.
functionpushbutton4_Callback(hObject,eventdata,handles)
%hObjecthandletopushbutton4(seeGCBO)
%eventdatareserved-tobedefinedinafutureversionofMATLAB
%handlesstructurewithhandlesanduserdata(seeGUIDATA)
globalstr;
setappdata(chengjizhifangtu(),'str',str);
6、退出按钮:
%---Executesonbuttonpressinpushbutton6.
functionpushbutton6_Callback(hObject,eventdata,handles)
%hObjecthandletopushbutton6(seeGCBO)
%eventdatareserved-tobedefinedinafutureversionofMATLAB
%handlesstructurewithhandlesanduserdata(seeGUIDATA)
close(cjguanli());
二、子界面:
数据库管理
1、显示整体数据按钮:
%---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);
2、设置课程学分按钮:
%---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));
3、添加按钮:
%---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==0
set(handles.edit11,'string','密码输入错误请重输!
');
return
else
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,'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
4、按姓名查询按钮:
%---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==0
set(handles.edit11,'string','无此人!
请重输!
');
return
else
set(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
5、修改按钮:
%---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==0
set(handles.edit11,'string','密码输入错误请重输!
');
return
else
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,'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
7、返回按钮:
%---Executesonbuttonpressinpushbutton8.
functionpushbutton8_Callback(hObject,eventdata,handles)
%hObjecthandletopushbutton8(seeGCBO)
%eventdatareserved-tobedefinedinafutureversionofMATLAB
%handlesstructurewithhandlesanduserdata(seeGUIDATA)
cjguanli();
close(shujukuguanli());
三、子系统成绩查询:
1、姓名查询按钮:
%---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,:
)));
3、返回按钮:
%---Executesonbuttonpressinpushbutton5.
functionpushbutton5_Callback(hObject,eventdata,handles)
%hObjecthandletopushbutton5(seeGCBO)
%eventdatareserved-tobedefinedinafutureversionofMATLAB
%handlesstructurewithhandlesanduserdata(seeGUIDATA)
cjguanli();
close(chengjichaxun());
四、子系统:
成绩排序
1、课程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:
hang
xingming1(id2(pp))=handles.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,'string',num2str(chengji1));
2、课程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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- matlabgui 数据管理 系统
![提示](https://static.bdocx.com/images/bang_tan.gif)