# Compare Number from test case and from Database

**URL:** <https://forum.katalon.com/t/compare-number-from-test-case-and-from-database/15946>\
**Category:** Web Testing\
**Tags:** katalon-studio\
**Created:** [December 25, 2018, 8:40am UTC](https://forum.katalon.com/t/compare-number-from-test-case-and-from-database/15946 "2018-12-25T08:40:21Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Marek\_Melocik](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/marek_melocik/32/371_2.png) [@Marek\_Melocik](https://forum.katalon.com/u/Marek_Melocik)\
**Post date:** [December 25, 2018, 10:55am UTC](https://forum.katalon.com/t/compare-number-from-test-case-and-from-database/15946/2 "2018-12-25T10:55:11Z")

</div>

Hello,

of course it is possible. First, you have to set up a database connection, run a query, get count(\*) and compare the result. See my sample code:

```
public class SQLHandler {
	String dbConnString = "jdbc:sqlserver://my.sqlserver.com:1433;databaseName=dummy"
	String dbUsername = "admin"
	String dbPassword = "passwd"
	String dbDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"

	Sql sql = Sql.newInstance(dbConnString,dbUsername,dbPassword,dbDriver)

	public List getSelectResults(String query) {
		KeywordUtil.logInfo("Executing the query: " + query)
		List results = sql.rows(query)
			if(results.size() == 0) {
				KeywordUtil.markFailedAndStop("No rows returned from SQL Server")
			}
		return results
	}

	public void closeConn() {
		sql.close()
	}
}

```

The usage in test case:

```
SQLHandler sql = new SQLHandler()
List res = sql.getSelectResults("select count(*) as Count from dummy.table1")

int countFromDb = res.get(0).get("Count")

```

Hope this helps.

Edit: Maybe it deserves a little bit of explanation. **List res** contains a list of results, one for each row. This row is a map of columnName:value.  
So to get a count of records in a table:

- get a first result row —\> res.**get(0)**.get(“Count”)
- get a value from column ‘Count’ —\> res.get(0).**get(“Count”)**

---

_[View the full topic](https://forum.katalon.com/t/compare-number-from-test-case-and-from-database/15946)._