jdbs

how to connect and write on db using groovy connector

i create one connector (groovy)

and use following code

import groovy.sql.Sql; import java.sql.Driver;

import groovy.sql.Sql sql = Sql.newInstance("jdbc:oracle:thin:@200.200.1.224:1583:DNLCLONE", "apps", "spider123", "oracle.jdbc.pool.OracleDataSource") sql.execute( """INSERT INTO XX_HOTEL (NAME,ADDRESS) VALUES(?, ?)""", [test,test])

Notifications