Kundensuche about sap-hana-scala

[frederike-ramin]

Das wäre so meine (bisher ungetestete, weil zu doof) vorläufige Lösung. (Danke für den Sceleton Code, Christian. ;))

def printResults(resultSet: ResultSet): Unit = {
    while (resultSet.next()) {
      println(resultSet)
    }
  }

  def selectCustomers(kdnr: String = "", plz: String = "", name: String = ""): Unit = {
    try {
      val statement = connection.get.createStatement()
      if kdnr != "" {
        val resultSet = statement.executeQuery("SELECT * FROM SAPQ92.KNA1_HPI WHERE LOWER(KUNDE) LIKE LOWER('" + kdnr + "') LIMIT 100")
        printResults(resultSet)
      } else {
        if (plz != "" && name != "") {
          val resultSet = statement.executeQuery("SELECT * FROM SAPQ92.KNA1_HPI " +
            "WHERE LOWER(NAME) LIKE LOWER('" + name + "')AND PLZ LIKE '" + plz + "' LIMIT 100")
          printResults(resultSet)
        }
        else {
          println("Please insert either customer's ID or the name and the zip code.")
        }
      } catch {
        case e: Throwable => e.printStackTrace()
      }
    }
  }