How matlab display data from database in gui edit box
1 回表示 (過去 30 日間)
古いコメントを表示
Hi everyone, i programing license plate recognition programs, and appeared problem. So after few examples i figure out my code.
function pushbutton1_Callback(hObject, eventdata, handles)
conn = database('baze', 'root', 'root', 'Vendor', 'MYSQL', 'Server', 'localhost', 'PortNumber', 3306);
setdbprefs('datareturnformat','structure');
a = get(handles.edit8,'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);
curs.data
close(curs)
close(conn)
All this i got in Matlab command window, but if i have gui aplication and i want retrive value in gui wich have edit text box. Example: after i input car plate number - got 'vardas' in edit1 and 'pavarde' in edit2. Thanks in advance for the answers.
2 件のコメント
akshatha nayak
2019 年 4 月 29 日
How to display the database rows in GUI Or database multiple rows in GUI
Geoff Hayes
2019 年 4 月 29 日
akshatha - I see that you have a question posted at https://www.mathworks.com/matlabcentral/answers/459147-how-to-display-the-database-in-gui-or-database-multiple-rows-in-gui. Please further the conversation there.
採用された回答
Geoff Hayes
2016 年 10 月 2 日
Gytis - if you want to retrieve the text from your edit1 and edit2 controls, then in the above pushbutton callback you would use the handles structure to get the values for these controls:
edit1Text = get(handles.edit1,'String');
edit2Text = get(handles.edit2,'String');
You can then use the above two local variables however you wish. Is this the solution that you are looking for?
8 件のコメント
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Language Support についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!