package jdbc
import java.sql.DriverManager
import java.sql.Connection
object ScalaJDBC {
def main(args: Array[String]) {
// connect to the database named "mysql" on the localhost
val driver = "com.mysql.jdbc.Driver"
val url = "jdbc:mysql://localhost/scala_test"
val username = "root"
val password = "1234"
var connection:Connection = null
try {
Class.forName(driver)
connection = DriverManager.getConnection(url, username, password)
val statement = connection.createStatement()
val resultSet = statement.executeQuery("select name, password from scala_t")
while ( resultSet.next() ) {
val name = resultSet.getString("name")
val password = resultSet.getString("password")
println("name, password = " + password + ", " + password)
}
} catch {
case e => e.printStackTrace
//case _: Throwable => println("ERROR")
}
connection.close()
}
}