使用Slick进行多或过滤

import slick.jdbc.MySQLProfile.api._

// 定义数据表映射
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 db = Database.forConfig("mysql")

// 定义过滤条件
val ageFilter = users.filter(_.age > 18)
val nameFilter = users.filter(_.name.startsWith("John"))

// 组合多个过滤条件
val combinedFilter = ageFilter.filter(_.name.endsWith("Doe"))

// 执行查询
val result = db.run(combinedFilter.result)

// 处理查询结果
result.map { users =>
  users.foreach(println)
}.recover {
  case ex: Exception => println("An error occurred: " + ex.getMessage)
}