Groovy之连接数据库
发布时间:2020-12-14 17:04:54 所属栏目:大数据 来源:网络整理
导读:让我们远离java丑陋的数据库连接吧 package dslimport 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.first
让我们远离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,'93010314','警务E通','0','1','','-1',null)"); (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |