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

1 次查看（过去 30 天）

Cristian Martin 2022-6-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1738980-create-a-function-for-set-name-user-password-for-sql-database

评论： 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

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

请先登录，再进行评论。

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

采纳的回答

Rik 2022-6-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1738980-create-a-function-for-set-name-user-password-for-sql-database#answer_984370

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

Cristian Martin 2022-6-13

I managed to do it with setappdata, thanks!

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.

请先登录，再进行评论。