?????????￡?
????curs =fetch(curs)
???????curs.Data??????????curs.Data???????CELL???????????CELL???????
????MATRIX????????
????cur=cell2mat(cur)
????a=cur(1??1);
????????????????????a??
???????
??????exec??????в???????У??е?sql?????????????????????strcat????????
?????????
t =strcat(s1?? s2?? s3?? ...)
for(t=1:10)
sql1 = strcat('select count(did) from rss_genepairs_u wheregocc>='??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 fromrss_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