Play 框架和 DB2

使用Play框架和DB2构建强大的Web应用

scala
import play.api.mvc._
import play.api.db._
import anorm._
class UserController @Inject()(db: Database, cc: ControllerComponents) extends AbstractController(cc) {
  def getUser(id: Long) = Action { implicit request: Request[AnyContent] =>
    db.withConnection { implicit connection =>
      val result: Option[User] = SQL("SELECT * FROM users WHERE id = {id}")
        .on("id" -> id)
        .as(User.parser.singleOpt)
      Ok(Json.toJson(result))
    }
  }
  def addUser(name: String, age: Int) = Action { implicit request: Request[AnyContent] =>
    db.withConnection { implicit connection =>
      val id: Option[Long] = SQL("INSERT INTO users (name, age) VALUES ({name}, {age})")
        .on("name" -> name, "age" -> age)
        .executeInsert()
      Ok(s"User added with ID: ${id.getOrElse("N/A")}")
    }
  }
}