How to get data from MySQL database in matlab GUI
Show older comments
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 Comments
Geoff Hayes
on 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
on 17 Mar 2016
Geoff Hayes
on 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
on 26 Mar 2016
Geoff Hayes
on 28 Mar 2016
Gytis - wouldn't you use the same function (that establishes the connection) to query the database for the data?
Answers (1)
Stalin Samuel
on 26 Mar 2016
0 votes
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!