Example code is available on github.com/vaadin-on-grails/groovy-sql .
TODO: steps how to create entities...
Copy import com.vaadin.ui.UI
import com.vaadin.ui.VerticalLayout
import com.vaadin.server.VaadinRequest
import com.vaadin.ui.Label
import com.vaadin.grails.Grails
import groovy.sql.GroovyResultSet
import groovy.sql.Sql
class MyUI extends UI {
@Override
protected void init(VaadinRequest vaadinRequest) {
VerticalLayout layout = new VerticalLayout()
Sql sql = Grails.get(Sql)
sql.eachRow("SELECT * FROM User") { GroovyResultSet result ->
String firstName = result.getString('username')
layout.addComponent(new Label(firstName))
}
setContent(layout)
// Sql sql = new Sql(dataSource: Grails.applicationContext.getBean('dataSource'))
// execute your queries
// sql.close()
}
}
Constructing SQL strings in Java or Groovy code is not easy and it is, for some of us, annoying. I recommend to use jOOQ library to construct SQL strings.