rf连接mysql数据库_RF-连接数据库

*** Settings ***

Force Tags        Data

Library           DatabaseLibrary

*** Test Cases ***

1、coonectDatabase

[Documentation]    连接数据库

...    "Provider=SQLOLEDB.1;Data Source=172.17.1.77;Initial Catalog=Test2;Persist Security Info=True;User ID=ygtest;Password=ygtest"

Connect To Database Using Custom Params    adodbapi    "Provider=SQLOLEDB.1;Data Source=172.17.1.77;Initial Catalog=Test2;Persist Security Info=True;User ID=ygtest;Password=ygtest"

${sql}    Query    select * from Test2.dbo.table_a

${row}    Row Count    select * from Test2.dbo.table_a

: FOR    ${i}    IN RANGE    ${row}

\    log    ${sql[${i}][0]}

log    ${row}

Disconnect From Database

2、使用参数查询数据

Connect To Database Using Custom Params    adodbapi    "Provider=SQLOLEDB.1;Data Source=172.17.1.77;Initial Catalog=Test2;Persist Security Info=True;User ID=ygtest;Password=ygtest"

${sql}    query    select * from Test2.dbo.table_a

log    ${sql}

: FOR    ${i}    IN RANGE    3

\    log    ${sql[${i}][${i}]}

Disconnect From Database