groovy控作sql的高级用法

以下代码由PHP站长网 52php.cn收集自互联网

现在PHP站长网小编把它分享给大家，仅供参考

 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

以上内容由PHP站长网【52php.cn】收集整理供大家参考研究

如果以上内容对您有帮助，欢迎收藏、点赞、推荐、分享。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!