require "java"
require "jdbc_drivers/sqlite3/lib/sqlite-jdbc-3.6.0.jar"

driver = Java::org.sqlite.JDBC.new

conn = driver.connect("jdbc:sqlite:temp.db", java.util.Properties.new)

conn.setAutoCommit(true)

statement = conn.createStatement
metadata = conn.getMetaData
tabrs = metadata.getTables(nil, nil, "people", nil)
unless tabrs.next
  statement.executeUpdate "create table people (id integer, name varchar)"
  statement.executeUpdate "insert into people (id, name) values (1, 'wycats')"
end
tabrs.close

begin
  result_set = statement.executeQuery "select * from people"
  while result_set.next
    puts result_set.getInt("id")
    puts result_set.getString("name")
  end
  result_set.close
ensure
  statement.close
  conn.close
end