include Java

import java.sql.DriverManager
import java.sql.ResultSet

java.lang.Class.for_name("com.mysql.jdbc.Driver")

begin
  connection = DriverManager.get_connection("jdbc:mysql://localhost/mephisto_development", "mephisto", "mephisto")
  statement = connection.create_statement
  results = statement.execute_query("select * from users")

  puts results.get_string("email") while results.next
ensure
  results.close if results
  statement.close if statement
  connection.close if connection
end