Create a function for set name, user, password for sql database
显示 更早的评论
Hi guys,
I want to create a file with a function inside for call every time a want to connect to a sql database inside of a script of a gui with manny connection.
Now I use this script to connect to it but when the password it's changed I must to change many places the pass:
conn = database('root', '****', '****');
curs = exec(conn, 'SELECT * FROM prices.prices order by Crt desc limit 200 ');
curs = fetch(curs);
close(curs);
data1 = curs.Data;
close(conn);
clear curs conn
If you could give me an example will be highly appreciated !
Thank you!
R2015a
采纳的回答
Rik
2022-6-13
1 个投票
Why don't you use a variable that contains the password? Or a function that returns the password as a char array? That way you only have to change one place.
4 个评论
Cristian Martin
2022-6-13
Cristian Martin
2022-6-13
Cristian Martin
2022-6-13
Rik
2022-6-13
Glad to be of help.
setappdata will work, but you can also store the password in one of the guidata fields. For general advice and examples for how to create a GUI (and avoid using GUIDE), have look at this thread.
更多回答（0 个）
类别
在 帮助中心 和 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 
