groovy基本mysql查询代码

groovy基本mysql查询代码

[文件] DB.groovy
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
package com.hongyuan.db
  
import groovy.sql.Sql
  
class DB {
  
    static main(args) {
        //创建查询对象
        def sql=Sql.newInstance("jdbc:mysql://localhost:3306/test",
                                "root","123456","org.gjt.mm.mysql.Driver");
        //执行查询并处理结果                
        sql.eachRow("select ename from emp"){
            println it.ename;
        }
    }
  
}