Display database result query

Miscellaneous
1

hello,

Please i want to display the result of a select SQL query using katalon studio

2


or https://store.katalon.com/product/24/DBMS-Keywords

3

i have successfully connected to my sql server, but i can’t see the results of my query executed in the console

1
1861×132 6.11 KB

i want to see the result

4

so, switch to the console tab. it is named ‘Console’

5

in the console , i get only “true” not the database records !!

true
true1127×238 22.6 KB

my script;

Sql sql = Sql.newInstance(dbConnString, dbUsername, dbPassword, dbDriver) // already defined values

String queryResult = sql.execute(‘SELECT * FROM Users’)

System.out.println(queryResult);

6

so.
this is the value your query method returns. what else did you want from it?
you can do
queryResult = 'whatever i like to print because i don't like what the query say'
before the print.

problem solved