0001 function cb_connectBtn(varargin)
0002
0003
0004
0005
0006
0007
0008
0009
0010 myh = varargin{1};
0011 mainfig = varargin{4};
0012 status = findobj('Tag', 'statusTxt');
0013 panels = getappdata(mainfig, 'panels');
0014
0015
0016 conn = getappdata(mainfig, 'connection');
0017
0018 if isempty(conn)
0019
0020
0021 hostname = get(findobj('Tag','serverTxt'), 'String');
0022
0023
0024 db = get(findobj('Tag','databaseTxt'), 'String');
0025
0026
0027 dbuser = getappdata(mainfig, 'dbuser');
0028 dbpass = getappdata(mainfig, 'dbpass');
0029
0030
0031 if ~isempty(dbpass) && ~isempty(dbuser)
0032 conn = mysql_connect(hostname, db, dbuser, dbpass);
0033 else
0034 [conn, dbpass] = mysql_connect(hostname, db);
0035 end
0036 if isa(conn, 'database')
0037 setappdata(mainfig, 'connection', conn);
0038 setappdata(mainfig, 'username', conn.Username);
0039 set(myh, 'String', 'disconnect');
0040 set(status, 'String', sprintf('connected to %s on %s as %s', db, hostname, conn.Username));
0041
0042
0043 buildConditions(panels(3));
0044
0045
0046 setappdata(mainfig, 'dbuser', conn.Username);
0047 setappdata(mainfig, 'dbpass', dbpass);
0048 else
0049 set(status, 'String', 'not connected');
0050 error('Invalid connection.');
0051 end
0052 else
0053
0054 close(conn);
0055 conn = [];
0056 disp('* disconnected.');
0057 setappdata(mainfig, 'connection', conn);
0058 setappdata(mainfig, 'username', '');
0059 set(myh, 'String', 'connect');
0060 set(status, 'String', 'not connected');
0061 setappdata(mainfig, 'dbuser', '');
0062 setappdata(mainfig, 'dbpass', '');
0063 end
0064