Application.scala

package controllers

import play.api._
import play.api.mvc._
import play.api.db._
import play.api.Play.current
import anorm._
import java.sql._

object Application extends Controller {
  
  def index = Action {
    val prop = new java.util.Properties
    prop.put("charSet", "SJIS")
    
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")
    implicit val connection = DriverManager.getConnection("jdbc:odbc:TESTDB", prop)
    
    val firstRow = SQL("select * from テーブル1").apply.head
    val id = firstRow[Long]("番号")
    val name = firstRow[String]("名前")
    
    connection.close
    Ok(views.html.index(id + ", " + name))
  }
  
}

index.scala

@(message: String)

@main("test") {
    
    @message
    
}