Compare value to cell in database

Question

Han 2018-3-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/387666-compare-value-to-cell-in-database

评论： Han 2018-3-12

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

HI ..

Id and password are int data type in database

I want to check if the id and password entered by user are in database.

Code:

a = get(handles.Id,'String');
b = get(handles.password,'String');
conn = database.ODBCConnection('users','root','root');
x = exec(conn,'select ID from Admin');
y = exec(conn,'select Password from Admin');
x = fetch(x);
y = fetch(y);
x1 = x.Data
y1 = y.Data
L1 = strcmp(a,x1)
L2= strcmp(b,x1)
if L1 == 1 && L2 == 1
track    
else
msgbox('Rong ID or Password ! ');
end

I trired to convert x1 and y1 to string

x2 = num2str(x1);

I get this error:

Input to num2str must be numeric.

I know that x1 is cell but I don't know how can I do it !

Can you please help me?

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2018-3-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/387666-compare-value-to-cell-in-database#answer_309552

Except for SQLite, it is possible to configure the database as to what datatype is to be returned by fetch (SQLite always returns the same datatype, and that is not the same datatype as the default for other databases.)

I suspect that if you check class(x1) that you will find that it is a 1 x 1 cell array containing a numeric value. Another possibility is that it might be a struct containing the field 'ID' .