change the jdbc request :
1.change the driver name,connection string,query string or assert.
- the object we will use here is : JdbcRequestTestStep
TestCase newcase=testRunner.getTestCase(); JdbcRequestTestStep step1=(JdbcRequestTestStep) newcase.getTestStepByName(""); String driver=step1.getDriver(); String constr=step1.getConnectionString(); String password=step1.getPassword(); step1.setDriver(""); //if there‘s no driver should set as step1.setDriver(null) step1.setConnectionString(""); step1.setPassword("");
- change the jdbc sql statement:
step1.setQuery("");
step1.setQueryTimeout("");- change the assertion behavior(like xpath string,jquery string):
http://www.soapui.org/apidocs/com/eviware/soapui/model/testsuite/TestAssertion.html
int totalassert=step1.getAssertionCount(); for(int k=0;k<totalassert;k++){ TestAssertion asserts=step1.getAssertionAt(k); if(asserts instanceof XPathContainsAssertion ){ if(asserts.getName().contains("Check count")){ String originalxpath=((XPathContainsAssertion) asserts).getPath(); String newxpath=originalxpath.replaceAll("Row", "Row2"); ((XPathContainsAssertion) asserts).setPath(newxpath); } } }
SoapUI Pro Project Solution Collection-change the JDBC Request behavior