import groovy.sql.Sql

Sql sqlInst = Sql.newInstance("jdbc:mysql://servername/datenbankname", 
				    "username","passwort", "com.mysql.jdbc.Driver")

def stmtSelect = "SELECT * FROM Artikel"
def result = sqlInst.rows(stmtSelect)

String subject = "Knapper Lagerbestand!"
String messageText = ""

Closure checkItems =
{
	if(it.bestand < it.mindestbestand)
	{
		it.artikelstatus = "knapp"
		messageText <<= "Mindestbestand für Artikel ${it.name} wurde 					    unterschritten.\n"
		messageText <<= "Aktueller Bestand $it.bestand bei einem 						    Mindestbestand von $it.mindestbestand.\n"
		messageText <<= "-" * 40 + "\n"
	}
	else
		it.artikelstatus = "vorrätig"
}

result.each{checkItems(it)}

AntBuilder ant = new AntBuilder()

ant.mail(mailhost:"mail.example.org",
	   mailport:25,
	   messagemimetype:"text/plain",
	   subject:"Knapper Lagerbestand!")
{
	from(address:"lager@example.org")
	to(address:"administrator@example.org")
	message(messageText)
}

def stmtUpdate = "UPDATE Artikel SET artikelstatus = ? WHERE id = ?"
result.each{sqlInst.execute(stmtUpdate, [it.artikelstatus, it.id])}