insert data to mysql

hi there..i really new in matlab.i want to save data in database, where i use mysql as my database.

however, how to connect the query that we have made with the button in gui..for example, button insert.

Answer 1

[Walter Roberson]

Matt Fig has a good set of example GUI in the MATLAB File Exchange.

Basically, if you want the user to be able to insert arbitrary text, you create an edit uicontrol, and when you want to insert it into the mysql database, you get() the 'String' property of the uicontrol. If you want the user to be able to insert arbitrary numbers, you do much the same, except after you get the String property you validate that it has numbers like you need and then you use a routine such as str2double() to convert the string into numeric values.

[Siti Maisarah]

ok this is my coding

function pushbutton1_Callback(hObject, eventdata, handles)

A=get(handles.edit1,'String')

B=get(handles.edit2,'String')

C = {A,B};

s.DataReturnFormat = 'cellarray';

s.ErrorHandling = 'store';

s.NullNumberRead = 'NaN';

s.NullNumberWrite = 'NaN';

s.NullStringRead = 'null';

s.NullStringWrite = 'null';

s.JDBCDataSourceFile = 'C:\Users\mai\Documents\MATLAB\test\test.mat';

s.UseRegistryForSources = 'yes';

s.TempDirForRegistryOutput = 'C:\Users\mai\AppData\Local\Temp';

setdbprefs(s)

% Make connection to database. Note that the password has been omitted.

% Using JDBC driver.

conn = database('test','root','admin','com.mysql.jdbc.Driver','jdbc:mysql://localhost/test');

% Write data to database.

insert(conn,'test',{'aa','bb'},C)

% Close database connection.

close(conn)

i use this coding but the data only save in .mat file, not in sql

[Walter Roberson]

At a guess, you are missing the SQL "commit".

Consider using fastinsert with AutoCommit:

http://www.mathworks.com/help/toolbox/database/ug/fastinsert.html

[Siti Maisarah]

i got this error

No constructor 'com.mathworks.toolbox.database.sqlExec' with matching

signature found

i think, it cannot read data that we insert from gui..

i don't know how to call it in insert statement

insert(conn,'test',{'aa','bb'},C)

[Siti Maisarah]

if i use this coding

insert(conn,'test',{'aa','bb'},{'hi','hi'})

then hi is successfully insert to mysql..

but when i try to call from the gui which is i use this coding,

insert(conn,'test',{'aa','bb'},{edit1.edit2})

edit1 and edit2 is my textbox in gui, the data not insert in mysql

[Siti Maisarah]

succesfull ! thx