lr_db_connect

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);