package test
import java.sql.DriverManager
//Connects to mysql DB using java.sql.DriverManager class

object test1 {

  def main(args: Array[String]): Unit = {
    //Class.forName("com.mysql.jdbc.Driver")

    val connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/retail_db","root","xxxx")
    val statement = connection.createStatement()
    val resultSet = statement.executeQuery("select * from customers limit 5")
    while (resultSet.next()) {
      println(resultSet.getInt(1) + " " + resultSet.getString(2))
    }

    val meta = connection.getMetaData().getColumns(null, null, "customers", null)
    //println(connection.getNetworkTimeout)
    //println(DriverManager.getLoginTimeout)
    //println(resultSet.getMetaData().getColumnName(1) + " " + resultSet.getMetaData().getColumnName(2))

  }

}