1. so powerful
<pre name="code" class="html"><span style="font-size:18px;">addpath('C:\Users\Administrator\Documents\MATLAB\src');
import edu.stanford.covert.db.MySQLDatabase;
db = MySQLDatabase('172.20.22.52', 'SecuritiesCloud', 'root', 'root');
db.prepareStatement('SELECT * FROM t_storage_data WHERE dataId = "{S}"', 'cb8f47310db44cd2b76b921949450ce6');
data = db.query();
fname = strcat(tempname, '.xls')
fid = fopen(fname, 'w');
fwrite(fid, data.content{1});
fclose(fid);
stockdata = xlsread(tempname);</span>
%addpath(fullfile(pwd, 'src'));
strrep(char(java.util.UUID.randomUUID),'-','_')
p = findstr(fileName,'.') fileName(1:(p-1)) fileName((p+1) : length(fileName))