groovy的jdbc操作

最新推荐文章于 2024-04-17 15:24:04 发布

weixin_34033624

最新推荐文章于 2024-04-17 15:24:04 发布

阅读量225

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/scymore/blog/745821

版权

2019独角兽企业重金招聘Python工程师标准>>>

import groovy.sql.Sql


scriptSystemPath = "F:/Company Project/Script/scripttasksystem/ScriptTaskSystem/";
def jdbc = new Properties()
new File(scriptSystemPath + "conf/ais_jdbc.properties").withInputStream { stream ->
    jdbc.load(stream)
}

driverUrl = jdbc["test.jdbc.driveUrl"];
driverClassName = jdbc["test.jdbc.driverClassName"];
username = jdbc["test.jdbc.username"];
password = jdbc["test.jdbc.password"];

sql = Sql.newInstance(driverUrl,username,password,driverClassName);


deleteData()

updateDate()

insertData()

selectData()
//startTime = []

void selectData(){
    def sqlStr = "select * from ec_role";
    sql.eachRow(sqlStr){
        row ->
            def role = row.id + ", " + row.role_name + ", " + row.level;
            println(role)
    }
}

void deleteData(){
    def sqlStr = "delete from ec_role where id = ?";
    sql.execute(sqlStr,[23])
}

void updateDate(){
    def sqlStr = "update ec_role set level = ? where id = ?";
    sql.execute(sqlStr,[1,21]);
}

void insertData(){
    def sqlStr = "insert into ec_role (id,role_name,parent_id,level,coexist) values (?,?,?,?,?)";
    sql.execute(sqlStr,[23,"gnumMonitor",null,1,0]);
}

转载于:https://my.oschina.net/scymore/blog/745821