How to display an sql data Table in a uitable
显示 更早的评论
Hallo every one
How to Upload/ Display a an SQL data Table in a uitable,
Thank you in advance.
采纳的回答
Kojiro Saito
2018-11-27
From R2018a, we can display table array data in uitable.
The following is an example of reading data from PostgreSQL and show it in uitable.
%% Access to database
conn = database('db_name','usename', 'password', ...
'Vendor','PostgreSQL', ...
'Server','localhost','PortNumber',5432);
tableName = 'table_name';
% Read data from SQL
data = sqlread(conn, tableName);
%% plot in uitable
f = uifigure;
uit = uitable(f, 'Data', data);
4 个评论
Oussama Louati
2018-11-27
Kojiro Saito
2018-11-28
Does it mean selected cells are changable by clicking checkboxes?
Oussama Louati
2018-11-28
Kojiro Saito
2018-11-30
uitable has a property CellSelectionCallback, and by using this, selected lines can be caught up.
Here is an example of do something from selected lines (app.data and app.selected are properties added in AppDesigner)
app.UITable.CellSelectionCallback = {@selectedChange, app};
function selectedChange(src, eve, app)
% Get selected lines
app.selected = eve.Indices(:, 1);
% Extract only selected lines from original data
selectedData = app.data(app.selected, :);
% Do something on selected lines
% for example,
% m = mean(selectedData);
end
更多回答（1 个）
类别
在 帮助中心 和 File Exchange 中查找有关 App Building 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
