Shulou(Shulou.com)06/01 Report--

* Settings * *

Force Tags Data

Library DatabaseLibrary

* Test Cases * *

1 、 coonectDatabase

[Documentation] connect to the database

... "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. Use parameters to query data

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.