Groovy之连接数据库

让我们远离java丑陋的数据库连接吧

package dsl

import groovy.sql.sql 
def orderCode="201003100621700";
db= sql.newInstance( 
		"jdbc:Oracle:thin:@127.0.0.1:CRM","iomcuser","Oracle.jdbc.driver.OracleDriver") 
println("执行查询语句");
sysdate=db.firstRow ("SELEct TO_CHAR(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual")
println sysdate[0];
orders=db.query ("SELEct order_code,order_id from cust_order where order_code=$orderCode",{
	while(it.next()){
		println "order_code is "+it.getString("order_code");
		println "order_id is "+it.getString("order_id");
	}
})
println("执行修改类语句");
db.execute ("insert into enum_value values (100115,'9@L_197_6@0314','警务E通','0','1','','-1',null)");