Use SQL statements directly in Grails

Use SQL statements directly in Grails to query, you can get a new connection directly, or you can use the default data source

Query code:

      ApplicationContext ctx =  (ApplicationContext)   Applicationholder.getapplication (). Getmaincontext ()       def datasource  = ctx.getbean (' DataSource ')       def sql = new  SQL (dataSource)       String strSql =  Select * from  company "      sql.eachrow (strSQL)  {           println it           println it.id      }      //Need Guide Pack        import groovy.sql.Sql      import  org.codehaus.groovy.grails.commons.applicationholder      import  Org.springframework.context.ApplicationContext