Code Sample for using JDBC with scala. The gem is the translation of the ResultSet to a stream (http://stackoverflow.com/questions/9636545/treating-an-sql-resultset-like-a-scala-stream)

gistfile1.scala

object DaoUtil {
  import java.sql.DriverManager

  def main(args:Array[String]) {
      Class.forName("com.mysql.jdbc.Driver").newInstance

      val con = DriverManager.getConnection("jdbc:mysql://localhost/test?" +
        "user=root&password=password")

      val stmt = con.createStatement()

      val rs = stmt.executeQuery("Select count(*) from samples")

     val rsStream = new Iterator[String] {
       def hasNext = rs.next()
       def next() = rs.getString(1)
     }.toStream

    rsStream.foreach(println)
  }
}