markinlqx的专栏

//Groovy 读取SQL Server数据import groovy.sql.Sqldef username = "sa"def password = "sasa"def url = "jdbc:sqlserver://ServerName\\InstanceName"def driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"

def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )def response = context.expand( '${MyRequest#ResponseAsXml}' )def holder = groovyUtils.getXmlHolder(response)def NodeValue= hol

def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )def projectPath= groovyUtils.getProjectPath()log.info projectPath

If the print result of data from SQLServer Data Base is null, you should use null;if the print result of data from SQLServer Data Base is nothing, you should use isEmpty.for example:lo

Reference:http://java.dzone.com/articles/groovy-jdk-gdk-date-andhttp://www.javabeat.net/2008/09/sample-code-for-simpledateformat///String to Dateimport java.util.Datedef newDate ='

def now= new Date()println nowdef longType= now.timeprintln longTypedef gCalendar= new GregorianCalendar()println gCalendar.timeprintln gCalendar.time.timeprintln System.currentTimeMilli

1.1. Get and Set propertiesGetting properties from groovy is straight-forward; all objects that contain properties have a getPropertyValue / setPropertyValue methods. The following examples are from i

Book:Groovy in action   Down load address:http://download.youkuaiyun.com/detail/markinlqx/4459750http://groovy.codehaus.org/api/http://docs.oracle.com/javase/6/docs/api/