2022.2

data.findRegExp("\\d{3}-[A-Z]{3}","gi",50,100);}}
Bothexpressionswouldmatchthefollowingstrings:001-ABC,678-xYz.
Notehowinthesecondversion,wheretheregularexpressionisspecifiedasastring,somecharacters
havetobeescapedwithanadditionalbackslash,whichisstandardinJavaScript.
db
Objectthatallowstoconnecttoadatabase.
Methods
Thefollowingtabledescribesthemethodsofthedbobject.
Method Description Available in File
type
"connect()"below Methodthatreturnsanewdatabasecon-
nectionobject.
Boundaries
Preprocessor,Extract,Condition,Repeat,Action,andPost-
processorsteps
all
connect()
Methodthatreturnsanewdatabaseconnectionobject.
connect(url, user, password)
ThismethodreturnsanewdatabaseConnectionobjectafterconnectingtothegivenURLandauthen-
ticatingtheconnectionwiththeprovideduserandpasswordinformation.
Thefunctionacceptsargumentsasdescribedhere:https://-
docs.oracle.com/javase/8/docs/api/java/sql/DriverManager.html#getConnection-java.lang.String-
java.lang.String-java.lang.String-.
InthereturnedConnectionobjectnormallyanypublicmethodshouldbeavailable.ThereturnedCon-
nectionobjectisdescribedhere:https://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html.
Note: MakesuretocloseanyConnectionobjectcreatedbyconnect()andanyotherclosable
resourcescreatedfromtheConnectioninstance(ResultSet,etc.).
url
Stringthatrepresentsadatabaseurloftheformjdbc:subprotocol:subname,e.g.'jdb-
c:mysql://localhost:3306/mycompany'.
Page 389