在Scala中使用哪个数据库(以及需要的示例)

libraryDependencies ++= Seq(
  "com.typesafe.slick" %% "slick" % "3.3.3",
  "com.typesafe.slick" %% "slick-hikaricp" % "3.3.3",
  "mysql" % "mysql-connector-java" % "8.0.27"
)

import slick.jdbc.MySQLProfile.api._

object SlickMySQLDatabase {
  val db = Database.forConfig("mysql")
}

mysql {
  driver = "slick.jdbc.MySQLProfile$"
  url = "jdbc:mysql://localhost:3306/mydb"
  user = "root"
  password = "password"
  connectionPool = HikariCP
  numThreads = 10
}

case class User(id: Int, name: String, age: Int)

class Users(tag: Tag) extends Table[User](tag, "users") {
  def id = column[Int]("id", O.PrimaryKey)
  def name = column[String]("name")
  def age = column[Int]("age")

  def * = (id, name, age) <> (User.tupled, User.unapply)
}

val users = TableQuery[Users]

val insertAction = users += User(1, "Alice", 25)
val selectAction = users.filter(_.age > 20).result

val insertResult = SlickMySQLDatabase.db.run(insertAction)
val selectResult = SlickMySQLDatabase.db.run(selectAction)