package services
import groovy.sql.Sql
public class ServiceFindHTML {
static void main(String[] args) {
def sql = Sql.newInstance("jdbc:mysql:, user", "pass", "com.mysql.jdbc.Driver")
sql.rows("select * from service_provider").each {row ->
row.each {column, value ->
def serviceId = row.Service_id
if (value =~ /</) {
println "Service $serviceId contains html in column " + column + ": " + value
}
}
}
}
}