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