Guest User

Untitled

a guest
Nov 21st, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. @GrabConfig(systemClassLoader = true)
  2. @Grab(group='org.postgresql', module='postgresql', version='42.1.4')
  3.  
  4. import groovy.sql.Sql
  5.  
  6. def db = [
  7. url: 'jdbc:postgresql://dbHost/dbName',
  8. user: 'user',
  9. password: 'pw',
  10. driver: 'org.postgresql.Driver'
  11. ]
  12. Sql sql = Sql.newInstance(db.url, db.user, db.password, db.driver)
  13.  
  14. println sql.rows('SELECT * FROM schema.table');
Add Comment
Please, Sign In to add comment