#!/usr/bin/ruby
require "mysql"
$hostname = "127.0.0.1"
$dbname = "データベース名"
$username = "ユーザ名"
$password = パスワード"
$tbl = "テーブル名"
print "Content-type: text/html\n\n";
print "CGI-Ruby DBI TEST\n";
print "\n";
print "DB接続テスト(CGI-Ruby GEM版)
\n";
conn = Mysql::connect($hostname, $username, $password, $dbname)
# 文字コードをUTF8に設定
conn.query("set character set utf8")
##### データ挿入 #####
#conn.query("insert into " + $tbl + " (value1,value2,value3) values ('data1','data2','data3');")
##### データ更新 #####
#conn.query("update " + $tbl + " set name = 'new_data' where name = 'old_data';")
##### データ削除 #####
#conn.query("delete from " + $tbl + " where name = 'data';")
# DBに問い合わせ
rs = conn.query("SELECT * FROM " + $tbl)
# 検索結果を表示
rs.each do |r|
puts r.join ", "
print "
\n"
end
# コネクションを閉じる
conn.close
print "\n";