matlab中使用sql语言查询过程中如何在select语句中使用变量

来源：互联网发布：bad rabbit勒索软件编辑：程序博客网时间：2024/06/05 10:34

matlab中使用sql语言查询过程中,在select语句中使用where语句进行过滤筛选，需要使用变量a时，变量a应该写成如下形式: =''',a,'''

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->>

附上参考例子程序，其中forecastSchemeCode为变量：

function arrayCompResult= modelTrain(forecastSchemeCode, dbIp, dbUser, dbPass,dbName)

sc=sprintf('jdbc:sqlserver://%s;databaseName=%s',dbIp,dbName);
dbConnection=database(dbName,dbUser,dbPass,'com.microsoft.sqlserver.jdbc.SQLServerDriver',sc);

if isconnection(dbConnection) == 1

curs=exec(dbConnection,['select beginTrainDt,EndTrainDt,beginVerifyDt,endVerifyDt from MT_LTQForecastSchemeParamCache where ... forecastSchemeCode=''',forecastSchemeCode,'''']);
curs=fetch(curs);

trainAndVerifyDt=curs.data;

else
'connect failed'
end

end

0 0