mysql - [运行时异常 : SqlMappingError(No rows when expecting a single one)]

Question

有没有办法让 Scala Anorm 处理空行结果？

我刚收到这个错误:[RuntimeException: SqlMappingError(No rows when expecting a one one)]

我的方法:

def findByEmail(email: String): User = {
      DB.withConnection { implicit connection=>
        SQL("SELECT * FROM users WHERE email = {email}").on(
          'email  -> email
          ).as(User.simple.single)
      }
}

Answer 1

您几乎就在那里，不需要使用单打和奇怪的大小写匹配。只需这样做:

def findByEmail(email: String): Option[User] = {
  DB.withConnection { implicit connection=>
    SQL("SELECT * FROM users WHERE email = {email}").on(
      'email  -> email
      ).as(User.simple.singleOpt)
  }
}