require 'dbi'
begin
  #连接数据库
  dbh=DBI.connect("DBI:Mysql:dbi_test:localhost","root","")
  
  dbh.columns("simple").each do |h|
    p h
  end
  #示范3种事务处理方式
  #手动commit
  dbh["AutoCommit"]=false
  1.upto(10) do |i|
    sql = "insert into simple (name, author) VALUES (?, ?)"
    dbh.do(sql, "Song #{i}", "#{i}")
  end
  dbh.commit
  
  #使用transaction方法
  dbh.transaction do |dbh|
    1.upto(10) do |i|
      sql = "insert into simple (name, author) VALUES (?, ?)"
      dbh.do(sql, "Song #{i}", "#{i}")
    end
  end
  
  #使用SQL语句
  dbh.do("SET AUTOCOMMIT=0")
  dbh.do("BEGIN")
  dbh["AutoCommit"]=false
  dbh.do("UPDATE simple set name='test' where id='1'")
  dbh.do("COMMIT")
  
  #查询
  sth=dbh.execute("select count(id) from simple")
  puts "bookCount:#{sth.fetch[0]}"
  sth.finish
  begin
    sth=dbh.prepare("select * from simple")
    sth.execute
    while row=sth.fetch do
      p row
    end
    sth.finish
  rescue
  end
  
  #上面这段查询可以改写为：
  #dbh.select_all("select * from simple") do |row|
  #   p row
  #end   
  
  
  #使用工具类输出xml格式结果集以及测量查询时间
  sql="select * from simple"
  mesuretime=DBI::Utils::measure do
    sth=dbh.execute(sql)
  end 
  puts "SQL:#{sql}"
  puts "Time:#{mesuretime}"
  rows=sth.fetch_all
  col_names=sth.column_names
  sth.finish
  puts DBI::Utils::XMLFormatter.table(rows)
  
  dbh.do("delete from simple")
rescue  DBI::DatabaseError=>e
  puts "error code:#{e.err}"
  puts "Error message:#{e.errstr}"
ensure
  dbh.disconnect if dbh
end   

出现问题：

但是每次我执行第一步的时候就会出现 config: unknown option --with=dbi,dbd_mysql Try 'ruby setup.rb --help' for detailed usage. 

原因分析：

这是由于dbi版本问题造成的。

因此新版本的安装方式如下：

一般方法是：下载dbi（tar.gz或zip格式），CMD下切换到解压的目录，使用以下命令：

ruby setup.rb config （或ruby setup.rb config --with=dbi,dbd_mysql）

ruby setup.rb setup

ruby setup.rb install

报错：

irb(main):001:0> require 'dbi'
LoadError: no such file to load -- deprecated
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from C:/MyProgramFiles/Ruby192/lib/ruby/site_ruby/1.9.1/dbi.rb:48:in `<t
op (required)>'
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from (irb):1
        from C:/MyProgramFiles/Ruby192/bin/irb:12:in `<main>'
irb(main):002:0>

irb(main):001:0> require 'dbi'
NoMethodError: undefined method `deprecate' for DBI::Date:Class
        from C:/MyProgramFiles/Ruby192/lib/ruby/site_ruby/1.9.1/dbi/utils/date.r
b:57:in `<class:Date>'
        from C:/MyProgramFiles/Ruby192/lib/ruby/site_ruby/1.9.1/dbi/utils/date.r
b:7:in `<module:DBI>'
        from C:/MyProgramFiles/Ruby192/lib/ruby/site_ruby/1.9.1/dbi/utils/date.r
b:1:in `<top (required)>'
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from C:/MyProgramFiles/Ruby192/lib/ruby/site_ruby/1.9.1/dbi/utils.rb:56:
in `<top (required)>'
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from C:/MyProgramFiles/Ruby192/lib/ruby/site_ruby/1.9.1/dbi.rb:50:in `<t
op (required)>'
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from (irb):1
        from C:/MyProgramFiles/Ruby192/bin/irb:12:in `<main>'
irb(main):002:0>

irb(main):001:0> require 'dbi'  
=> true  
irb(main):002:0> 

<internal:lib/rubygems/custom_require>:29:in `require': no such file to load -- parsedate (LoadError)
	from <internal:lib/rubygems/custom_require>:29:in `require'
	from c:/Program Files (x86)/RailsInstaller/Ruby1.9.2/lib/ruby/site_ruby/1.9.1/dbi/sql.rb:9:in `<module:DBI>'
	from c:/Program Files (x86)/RailsInstaller/Ruby1.9.2/lib/ruby/site_ruby/1.9.1/dbi/sql.rb:7:in `<top (required)>'
	from <internal:lib/rubygems/custom_require>:29:in `require'
	from <internal:lib/rubygems/custom_require>:29:in `require'
	from c:/Program Files (x86)/RailsInstaller/Ruby1.9.2/lib/ruby/site_ruby/1.9.1/dbi.rb:37:in `<top (required)>'
	from <internal:lib/rubygems/custom_require>:29:in `require'
	from <internal:lib/rubygems/custom_require>:29:in `require'
	from E:/Program/Eclipse/RubyTest/dbi.rb:1:in `<main>'