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: