考虑一个测试场景:在页面注册一个用户,其中用到的注册E-mail地址是从数据库中获取的。因此,先建立DB连接,然后从DB中获取数据:
代码如下:
<span style="font-size:14px;">Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver”);
String url = “jdbc:sqlserver://192.168.1.102”:1433;DatabaseName=Test;
Public static connection con =
DriverManger.getConnection(url,”username”,”password”);
Public static Statement stmt = con.creatStatement();
ResultSet result = stmt.executeQuery(“select top 1 email_address from user_resgister_table”);
String emailaddress = result.getString(“email_address”);
Selenium.type(“userID”,emailaddress);
</span>