sqlwithbuildertest.groovy

大名鼎鼎的java动态脚本语言。已经通过了sun的认证

package groovy.sql

import groovy.xml.MarkupBuilder 

/**
 * @author Brian McCallister
 * @version $Revision: 1.6 $
 */
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()
    }
}