How to get data from MySQL database in matlab GUI
Afficher commentaires plus anciens
Hi, everyone have troble to retrive data from database. In GUI project i need write car plate symbols and then get data from database, because car number is indices. So question is how to connect database with GUI. Also i dont know that im right, but i think, when i press search button, then database need connect and retrive data in fields
Thans for answers.
5 commentaires
Geoff Hayes
le 14 Mar 2016
Gytis - how does your GUI work? Does the user enter a number in the Numeriari field and then presses the Gauti button? If so, does push button callback then connect to the MySQL database and query for all fields (to populate the GUI) conditioning on Numeriari?
See MySQL JDBC for Windows for a tutorial on how to connect to your database. The lines of code will be something similar to
conn = database('dbname','username','pwd',...
'Vendor','MySQL',...
'Server','sname');
Gytis Raudonius
le 17 Mar 2016
Geoff Hayes
le 17 Mar 2016
Gytis - first you have to be able to create the connection with your MySQL database and then query it for the correct data. Have you done that?
Gytis Raudonius
le 26 Mar 2016
Geoff Hayes
le 28 Mar 2016
Gytis - wouldn't you use the same function (that establishes the connection) to query the database for the data?
Réponses (1)
Catégories
En savoir plus sur Database Toolbox dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!