清空筛选条件
清空筛选条件

test if input entered by user is exist in database or not

1 次查看（过去 30 天）
Han
Han 2018-1-31
回答： Walter Roberson 2018-1-31
Hi !
I try the following code on a single record and it's work now I have a table with employees id I want to test if the number entered by user is exist so he can sign in my system
Code:
a = get(handles.ID,'String');
conn = database.ODBCConnection('users','root','root');
x = exec(conn,'select ID from employee');
x = fetch(x);
x1=(x.Data);
L1 = strcmp(a,x1);
if L1 == 1
.
end
Please Can you HELP ME !

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

采纳的回答

Walter Roberson
Walter Roberson 2018-1-31
x = exec(conn, sprintf('select ID from employee where ID=''%s''', a));

更多回答（0 个）

类别

在 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