How to populate matlab GUI edit texts with values from MySQL database?

1 次查看（过去 30 天）
hush puppy
hush puppy 2015-5-7
回答： Piyush Kumar 2024-10-21
I have created a table with 10 columns in MySQL and manage to connect it with Matlab. What is the code to retrieve those data and display them in a matlab GUI edit texts boxes?

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

回答（1 个）

Piyush Kumar
Piyush Kumar 2024-10-21
Hi,
To retrieve data from the database, you can use the fetch function.
If you have created the edit text box using uicontrol, you can use the set function to display the value extracted from the database.
For example,
fig = figure('Position', [100, 100, 300, 200], 'Name', 'Simple GUI');
% Create an edit text box
editText = uicontrol('Style', 'edit', ...
'Position', [50, 100, 200, 40], ...
'String', 'Default value');
% db_value = fetch(conn, sqlquery) % Replace conn and sqlquery with the correct values
db_value = 'Hi, I am from db'
% Set the string value of the edit text box
set(editText, 'String', db_value);

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by