Scala for Data Science

JDBC summary

We now have an overview of JDBC. The rest of this chapter will concentrate on writing abstractions that sit above JDBC, making database accesses feel more natural. Before we do this, let's summarize what we have seen so far.

We have used three JDBC classes:

• The Connection class represents a connection to a specific SQL database. Instantiate a connection as follows:

  import java.sql._
  Class.forName("com.mysql.jdbc.Driver")val connection = DriverManager.getConnection(
    "jdbc:mysql://127.0.0.1:3306/test",
    "root", // username when connecting
    "" // password
  )

  Our main use of Connection instances has been to generate PreparedStatement objects:

  connection.prepareStatement("SELECT * FROM physicists")

• A PreparedStatement instance represents a SQL ...