Skip to main content

ResultSetX

If you are building with sbt, add the following to your build.sbt:

libraryDependencies ++= Seq(
  "org.bitlap" %% "rolls-core" % "<version>"
)

java.sql.ResultSet Data Extractor​

If you want to quickly obtain all the data for the ResultSet without relying on the orm framework. For example, during testing.

import bitlap.rolls.core.annotations.*
import bitlap.rolls.core.jdbc.*
import java.sql.*

val statement = DriverManager
  .getConnection(
    "jdbc:h2:mem:zim?caseSensitive=false;MODE=MYSQL;TRACE_LEVEL_FILE=2;INIT=RUNSCRIPT FROM 'classpath:test.sql'"
  )
val rs   = ResultSetX[TypeRow4[Int, String, String, String]](sqlQ"select * from T_USER")
// rows is a Scala List[Tuple]
val rows: LazyList[TypeRow] = rs.fetch()
// get first column
val column1: Int = rows.head.columns[rs.Out]._1

// get all columns
val columns: LazyList[Any] = rows.head.lazyColumns