Matlab 数据库连接

1.安装mysql驱动

Step 1: 将mysql-connector-java-5.1.7-bin.jar文件拷贝到......\MATLAB\R2009b\java\jar\toolbox
Step 2: 到......\MATLAB\R2009a\toolbox\local目录下，找到classpath.txt文件，打开，并添加用来加载mysql的jdbc驱动语句：
$matlabroot/java/jar/toolbox/mysql-connector-java-5.1.25-bin.jar
Step 3:重新打开MATLAB即可

2. 

t = strcat(s1, s2, s3, ...)
for(t=1:10)
    sql1 = strcat('select count(did) from rss_genepairs_u where gocc>=',num2str(t),' || gomf >= ',num2str(t),' || gobp >= ',num2str(t));
end
完整代码如下： 
conn = database('tissueppi','root','root','com.mysql.jdbc.Driver','jdbc:mysql://localhost:3306/tissueppi');
for t=0.5:0.01:0.91
    for x=0.5:0.1:11
       sql = strcat('select count(did) from rss_genepairs_x2 where score <=',num2str(x),' and did in(select did from rss_genepairs_u where gocc >=',num2str(t),' || gomf >= ',num2str(t),' || gobp >= ',num2str(t),')');
       aTemp = exec(conn,sql);
       aTemp = fetch(aTemp);
       a = aTemp.Data;
       a = cell2mat(a);
       a= a(1,1);
    end
end