require 'rubygems'
require 'java'

module Jdbc
  DriverManager = java.sql.DriverManager
  Driver = com.mysql.jdbc.Driver
end

url = "jdbc:mysql://fedora/blog_development"
user  = "vvs"
pass  = "yeah, right"

connSelect = Jdbc::DriverManager.get_connection(url, user, pass)
stmtSelect = connSelect.create_statement

selectquery = "SELECT * FROM posts"

rsS = stmtSelect.execute_query(selectquery)

# For each row returned do some stuff
while (rsS.next) do
  veg = Hash.new
  veg["id"] = rsS.getObject("id")
  veg["title"] = rsS.getObject("title")
  puts veg.inspect
end

stmtSelect.close
connSelect.close