play framework 数据库连接

接着上一篇的play framework redis缓存、作为一个优秀的框架怎么没有数据库操作呢、这篇介绍一下怎么配置jdbc连接、使用的数据库是mysql。

使用教程

build.sbt 添加依赖

libraryDependencies += javaJdbc
libraryDependencies += "mysql" % "mysql-connector-java" % "5.1.47"

jdbc配置

db {
  default.driver = com.mysql.jdbc.Driver
  default.url = "jdbc:mysql://localhost:3306/testdb?characterEncoding=UTF-8&useSSL=false"
  default.username = root
  default.password = root
  default.logSql = true
}

控制器注入使用

@Singleton
class HomeController @Inject()(@NamedDatabase("default") db: Database, cc: ControllerComponents)(implicit assetsFinder: AssetsFinder)
  extends AbstractController(cc) {

  def index = Action {
    val res = new mutable.ListBuffer[String]()
    db.withConnection {
      conn =>
        val state = conn.createStatement()
        val result = state.executeQuery("select * from user")
        while (result.next()) {
          res += result.getString("nickName")
        }
    }
    Ok(views.html.index(res.mkString(",")))
  }

}

刷新页面就可以看到啦

image

连接池配置

play.db {
  # The combination of these two settings results in "db.default" as the
  # default JDBC pool:
  config = "db"
  default = "default"

  # Play uses HikariCP as the default connection pool.  You can override
  # settings by changing the prototype:
  prototype {
    # Sets a fixed JDBC connection pool size of 50
    hikaricp.minimumIdle = 50
    hikaricp.maximumPoolSize = 50
  }
}

默认初始50个连接

验证mysql是不是

root@385ff263e2bd:/# mysqladmin -uroot -proot status
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Uptime: 6053  Threads: 51  Questions: 2898  Slow queries: 0  Opens: 569  Flush tables: 1  Open tables: 384  Queries per second avg: 0.478

可以看到Threads：是51个、有一个连接是其它项目的。

最后

play framework真的很好用、添加代码动态加载。真的很棒。
下一篇文章继续介绍在playframework中如何上传文件。