How to display an sql data Table in a uitable

Question

Oussama Louati 2018-11-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/431192-how-to-display-an-sql-data-table-in-a-uitable

评论： Kojiro Saito 2018-11-30

采纳的回答： Kojiro Saito

Hallo every one

How to Upload/ Display a an SQL data Table in a uitable,

Thank you in advance.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Kojiro Saito 2018-11-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/431192-how-to-display-an-sql-data-table-in-a-uitable#answer_349066

在 MATLAB Online 中打开

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 个评论
显示 2更早的评论隐藏 2更早的评论

Oussama Louati 2018-11-28

After displaying the Table, I want the user to be able to select lines from this table,

I want than later to do something with the selected lines

Kojiro Saito 2018-11-30

在 MATLAB Online 中打开

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