groovy 无法连接mysql_Groovy之连接数据库

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

package dsl

import groovy.sql.Sql

def orderCode="201003100621700";

db= Sql.newInstance(

"jdbc:oracle:thin:@127.0.0.1:CRM",

"iomcuser",

"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,'93010314','警务E通','0','0','0','1','','-1','','','',null)");