Create a function for set name, user, password for sql database
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Cristian Martin
am 12 Jun. 2022
Kommentiert: Rik
am 13 Jun. 2022
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 Kommentare
Akzeptierte Antwort
Rik
am 13 Jun. 2022
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 Kommentare
Rik
am 13 Jun. 2022
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.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Database Toolbox finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!