OnlyTheStrongSurvive
lr_db_connect
上一篇 /
下一篇 2012-08-23 15:08:45
/ 个人分类:自动化
int NumRows=0;
int i;
lr_db_connect("StepName=DatabaseConnection",
"ConnectionString=Provider=OraOLEDB.Oracle.1;Password = 密码 ;Persist Security Info=True; User ID = 用户名 ; Data Source =数据源(orcl_192.168.1.1); Server = 192.168.1.1",
"ConnectionName=InvDatabaseConnection",
"ConnectionType=OLEDB",
LAST);
//通过
SQL查找数据,返回总数信息
NumRows = lr_db_executeSQLStatement("StepName=PerformQuery",
"ConnectionName=InvDatabaseConnection",
"SQLStatement=查询sql",
"DatasetName=MyDataset",
LAST );
lr_output_message("The query returned %d rows.", NumRows);
while(i<NumRows) {
lr_db_getvalue("StepName=GetValue",
"DatasetName=MyDataset",
"Column=OID", //字段名
"Row=next",
"OutParam=MyOutputParam",
LAST);
lr_output_message("The value is: %s", lr_eval_string("{MyOutputParam}") );
i=i+1;
}
//断开连接
lr_db_disconnect("StepName=Disconnect",
"ConnectionName=InvDatabaseConnection",
LAST);
收藏
举报
TAG: