Create a function for set name, user, password for sql database

2 次查看（过去 30 天）
Cristian Martin
Cristian Martin 2022-6-12
评论： Rik 2022-6-13
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
Rik 2022-6-13
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 个评论
显示 2更早的评论
Rik
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2015a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by