#!/usr/bin/ruby
require "dbi"
$dbname = "データベース名"
$hostname = "localhost"
$username = "ユーザ名"
$password = "パスワード"
$tbl = "テーブル名"
print "Content-type: text/html\n\n";
print "CGI-Ruby DBI TEST\n";
print "\n";
print "DB接続テスト(CGI-Ruby DBI版)
\n";
begin
##### データ挿入 #####
#dbh = DBI.connect("dbi:mysql:" + $dbname + ":" + $hostname, $username, $password)
#dbh.do("insert into " + $tbl + " (row1,row2,row3) values ('data1','data2','data3');")
##### データ更新 #####
#dbh = DBI.connect("dbi:mysql:" + $dbname + ":" + $hostname, $username, $password)
#dbh.do("update " + $tbl + " set name = 'new_data' where name = 'old_data';")
##### データ削除 #####
dbh = DBI.connect("dbi:mysql:" + $dbname + ":" + $hostname, $username, $password)
dbh.do("delete from " + $tbl + " where name = 'data';")
##### データ表示 #####
#dbh = DBI.connect("dbi:mysql:" + $dbname + ":" + $hostname, $username, $password)
#$sql = "select * from " + $tbl + ";"
dbh.select_all($sql) do |row|
printf "%s, %s, %s
\n", row[0], row[1], row[2]
end
rescue DBI::DatabaseError => e
p "Error code: #{ e.err }
"
p "Error message: #{ e.errstr }
"
ensure
dbh.disconnect if dbh
end
print "\n";