PlugIns JdbcSlim UserGuide
The SQL Command can be called with 1, 2 or 3 constructor parameters
Constructor with one parameter
In this case the parameter must be the name of a configuration either defined in a file or a table.In addition the configuration must contain a "CMD" key with the sql code.
| Define Properties | AllInOne |
| key | value |
| .include | TestDatabase |
| cmd | select ID, NAME from TestData where Name ='%NAME%' |
| SQLCommand | AllInOne |
| ID? | NAME |
| $TestID= | Ben |
| $TestID2= | Sarah |
Constructor with two parameter
In this case the first parameter must be the name of a configuration either defined in a file or a table.The second parameter must be the SQL code to be executed.
SQL Query only with Header with Input and Output Columns and with expected value
| SQLCommand | TestDatabase | select * from TestData where ID = '%ID%' | ||
| ID | Name? | Phone? | City? | Profession? |
| 3 | Tom | |||
Constructor with three parameter
In this case the first parameter must be the name of a configuration either defined in a file or a table.The second parameter must be the SQL code to be executed
The third parameter can contain a list of further configuration parameters. The elements must be separated by spaces.
| SQLCommand | TestDatabase | select ID,Name from TestData where ID in('3','5') | SORT=true debug=true |
| ID?< | NAME? | ||
| 3 | Tom | ||
| 5 | Sarah | ||