develop a general filtering solution

[opensas]

check this:

http://docs.oracle.com/javase/6/docs/api/java/sql/ResultSetMetaData.html

to test try with this:

play -DapplyEvolutions.default=true
console
new play.core.StaticApplication(new java.io.File("."))

import anorm._
import play.api.db._
import play.api.Play.current

implicit val conn = DB.getConnection()
val q = SQL("select * from Country where false")
val r = q.resultSet()
val m = r.getMetaData()

scala> m.getColumnCount()
res2: Int = 3

scala> m.getColumnTypeName(1)
res3: java.lang.String = INTEGER

scala> m.getColumnName(1)
res4: java.lang.String = ID