Skip to content

Instantly share code, notes, and snippets.

@jpokrzyk

jpokrzyk/app.groovy

Created December 24, 2013 05:30
Show Gist options
  • Save jpokrzyk/8109151 to your computer and use it in GitHub Desktop.
Save jpokrzyk/8109151 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. jpokrzyk created this gist Dec 24, 2013.
    14 changes: 14 additions & 0 deletions app.groovy
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,14 @@
    import org.vertx.groovy.core.http.RouteMatcher
    import groovy.sql.Sql

    def rm = new RouteMatcher()

    rm.getWithRegEx('.*') { req ->
    def db = [url:'jdbc:jtds:sqlserver://AnyServer:1433/AnyDB', user:'test', password:'test', driver:'net.sourceforge.jtds.jdbc.Driver']
    Sql sql = Sql.newInstance(db.url, db.user, db.password, db.driver)
    def result = sql.firstRow("select * from AnyTable")
    sql.close()
    req.response.end result.HCI_Filename
    }

    vertx.createHttpServer().requestHandler(rm.asClosure()).listen(8080)