Groovy 读取SQL Server数据

//Groovy 读取SQL Server数据import groovy.sql.Sql
def username = "sa"
def password = "sasa"
def url = "jdbc:sqlserver://ServerName\\InstanceName"
def driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
 
def sql = Sql.newInstance(url,username,password,driver)
def row = sql.firstRow("SELECT ItemNumber,Title FROM table WITH(NOLOCK) WHERE ItemNumber = ''11111")
log.info"good:${row.ItemNumber},${row.Title}"//SoapUI里执行