/** * Executes all the SQL queries passed to it * * @param queries * @return List of HashMap containing all the query results where Keys are column names * @throws SQLException */ public List<Map<String, String>> executeQueries(List<String> queries) throws SQLException { Iterator<String> queriesIt = queries.iterator(); List<Map<String, String>> resultList = new ArrayList<Map<String, String>>(); // Iterating through all the passed queries while (queriesIt.hasNext()) { String query = queriesIt.next(); // Executing query List<Map<String, String>> results = dbReader.executeQuery(query); if (results != null) { resultList.addAll(results); } } logger.info(resultList.toString()); return resultList; }