import java.sql.{Connection,DriverManager}
import com.typesafe.scalalogging._
import org.slf4j.LoggerFactory

object MysqlJDBC extends App {

  val logger = Logger(LoggerFactory.getLogger(this.getClass))

  val url = "jdbc:mysql://10.120.136.90:3306/hackpad"
  val driver = "com.mysql.jdbc.Driver"
  val username = "root"
  val password = "ssir"
  var connection: Connection = _

  try {
    Class.forName(driver)
    connection = DriverManager.getConnection(url, username, password)
    val statement = connection.createStatement
    val rs = statement.executeQuery("SELECT email, token FROM email_signup")

    while (rs.next) {
      val email = rs.getString("email")
      val token = rs.getString("token")
      logger.info("Email: {}, Token: {}", email, token)
    }

  } catch {
    case e: Exception => logger.error("JDBC error", e)
  }
  connection.close
}