PlugIns JdbcSlim UserGuide 2KeyBenefits 3MultiTableStatement
The Scenario with two execute statements
Scenario | Get The Name | name | and phone number | phone | for id | id |
execute | select Name from TestData where ID = '@id' | |||||
show | success | |||||
show | rawResult | |||||
show | resultSheet | |||||
$name= | getColumnValueByName | NAME | ||||
# | ||||||
execute | select * from TestData where ID = '@id' | |||||
show | success | |||||
show | rawResult | |||||
show | resultSheet | |||||
$phone= | getColumnValueByName | Phone |
Define connection details and open a connection
Define Properties | ScriptDatabase |
key | value |
.include | TestDatabase |
cmd | select * from TestData |
Script | SQLCommand | ScriptDatabase |
openConnection |
Contents: