How to get data from database in GUI?

Question

Gytis Raudonius 2016-8-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/301538-how-to-get-data-from-database-in-gui

评论： Gytis Raudonius 2016-9-11

Atpazinimas.zip

Hey, have problem, i work with license plate recognition. At this moument i have create and link database with matlab, but question is how i can get data about driver from database, by license plate numbers, as you can see in file which add. I want to get data in edittext fields, so if someone can help me with simple example. Thanks for yours answers.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Geoff Hayes 2016-9-1

Gytis - rather than attaching a zip file, which many of may be reluctant to open, please attach the m and fig files instead.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

mbonus 2016-9-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/301538-how-to-get-data-from-database-in-gui#answer_233470

在 MATLAB Online 中打开

You can do

get(findobj('tag','objTagName'),'String')
or 
get(hObject,'String')

where objTagName is the tag you assigned to the uicontrol('Style','edit',...) and hObject is the handle if it was saved.

3 个评论
显示 1更早的评论隐藏 1更早的评论

mbonus 2016-9-7

在 MATLAB Online 中打开

setappdata(0,'VarName',VarName)
getappdata(0,'VarName')

Just make sure that you save it to the root directory (0), that way it can be accessed regardless of whether the GUI has been closed

Gytis Raudonius 2016-9-11

在 MATLAB Online 中打开

maybe you can explain more how it should be work

function pushbutton1_Callback(hObject, eventdata, handles)
conn = database('baze', 'root', 'root', 'Vendor', 'MYSQL', 'Server', 'localhost', 'PortNumber', 3306);
a = get(handles.edit8,'String');
%b = get(handles.edit9,'String');
if iscell(a) && numel(a) == 1
    a = a{1};
end
if ~ischar(a) || isempty(a);
    error('A valid string must be supplied!');
end
sqlquery = ['select vardas, pavarde, laipsnis, pareigos, telefonas, marke, numeris, tarnyba from info '...
       'where numeris = ' '''' a ''''];
curs = exec(conn, sqlquery);
curs = fetch(curs);
getappdata(handles.edit9,'vardas');
curs.data
close(curs)
close(conn)