play!连接mysql配置,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中如何上传文件。