JMeter - JDBC Sampler output to .csv file

JDBC-sampler-to-CSV.groovy

// Set "Result variable name" as "resultList" in JDBC Sampler
resultSet = vars.getObject("resultList")
result = new StringBuilder()

// result.append("Header1,Header2,...,\r\n");

for (Object row : resultSet ) {
    iter = row.entrySet().iterator()
    while (iter.hasNext()) {
        pair = iter.next()
        result.append(pair.getValue())
        result.append(",")
    }
    result.append(System.getProperty("line.separator"))
}

// File will be created in jmeter/bin folder
org.apache.commons.io.FileUtils.writeStringToFile(new File("test.csv"), result.toString(), "UTF-8")