groovy mysql_groovy控作sql的高级用法

下面是编程之家 jb51.cc 通过网络收集整理的代码片段。

编程之家小编现在分享给大家，也给大家做个参考。

def sql = sql.newInstance("jdbc:MysqL://localhost:3306/mydb","user","pswd","com.MysqL.jdbc.Driver")

// delete table if prevIoUsly created

try {

sql.execute("drop table PERSON")

} catch(Exception e){}

// create table

sql.execute('''create table PERSON (

id integer not null primary key,firstname varchar(20),lastname varchar(20),location_id integer,location_name varchar(30)

)''')

// now let's populate the table

def people = sql.dataSet("PERSON")

people.add( firstname:"James",lastname:"Strachan",id:1,location_id:10,location_name:'London' )

people.add( firstname:"Bob",lastname:"Mcwhirter",id:2,location_id:20,location_name:'Atlanta' )

people.add( firstname:"Sam",lastname:"Pullara",id:3,location_id:30,location_name:'California' )

// do a query to check it all worked ok

def results = sql.firstRow("select firstname,lastname from PERSON where id=1").firstname

def expected = "James"

assert results == expected

// allow resultSets to be able to be changed

sql.resultSetConcurrency = java.sql.ResultSet.CONCUR_UPDATABLE

// change the data

sql.eachRow("select * from PERSON") {

it.firstname = it.firstname * 2

}

// reset resultSetsConcurrency back to read only (no further changes required)

sql.resultSetConcurrency = java.sql.ResultSet.CONCUR_READ_ONLY

// do a query to confirm that our change actually worked

results = sql.firstRow("select firstname,lastname from PERSON where id=1").firstname

expected = "JamesJames"

assert results == expected

以上是编程之家(jb51.cc)为你收集整理的全部代码内容，希望文章能够帮你解决所遇到的程序开发问题。

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

总结

以上是编程之家为你收集整理的groovy控作sql的高级用法全部内容，希望文章能够帮你解决groovy控作sql的高级用法所遇到的程序开发问题。

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。

如您喜欢交流学习经验，点击链接加入交流1群：1065694478(已满)交流2群：163560250