sqlwithbuildertest.groovy

来自「Groovy动态语言 运行在JVM中的动态语言 可以方便的处理业务逻辑变化大的业」· GROOVY 代码 · 共 27 行

package groovy.sql

import groovy.xml.MarkupBuilder 

/**
 * @author Brian McCallister
 * @version $Revision: 2287 $
 */
class SqlWithBuilderTest extends TestHelper {

    void testSqlQuery() {
         def sql = createSql()
         println "Created ${sql}"
        
         def doc = new MarkupBuilder()
        
         doc.people {
             sql.eachRow("select * from PERSON") {
                 doc.person(first: it.firstname, last: it.lastname, location: it.location_name)
             }
         }
        
         sql.close()
    }
}