groovy玩sql

蛮easy的 groovy彻底把java变成脚本了

首先要做的是把mysql的包扔到groovy的lib文件夹下，然后重启，保证初始化加载的时候可以加载到

import groovy.sql.Sql
sql = Sql.newInstance("jdbc:mysql://localhost:3306/test","root","beckham","com.mysql.jdbc.Driver")
sql.eachRow("select * from seller",{println it.seller_name + ",${it.seller_id}"})
println("----------------------------------")
row = sql.firstRow("select seller_name from seller")
println("${row.seller_name}")                       // 类似于这样的输出必须引起来，不然会报找不到方法签名的错误
println("-----------------------------------")
name = "david.beckham"
tel = "15990001295"
sql.execute("insert into seller(seller_name,seller_tel) values(${name},${tel})")
sql.execute("insert into seller(seller_name,seller_tel) values(?,?)",[name,tel])  //其他类推了 都一样
println("-----------------------------------")