Ruby 使用 ODBC 连接数据库

以下代码由PHP站长网 52php.cn收集自互联网

现在PHP站长网小编把它分享给大家，仅供参考

require "odbc"

DSN  = "Myodbc"
USER = "YourName"
PWD  = "123"

ODBC.connect(DSN,USER,PWD) do |dbh|
  dbh.autocommit = true
  begin
    dbh.do("DROP TABLE test")
  rescue ODBC::Error; end
  dbh.do("CREATE TABLE test (id INT,name VARCHAR(30))")
  dbh.do("INSERT INTO test VALUES (?,?)",1,'Michael')
  dbh.autocommit = false
  dbh.prepare("INSERT INTO test VALUES(?,?)") do |sth|
    name = "AAAAA"
    99.times {|n| sth.execute(n+2,name.succ!) }
  end
  dbh.commit
  dbh.run("SELECT COUNT(*) FROM test") do |sth|
    p sth.fetch[0]  # => 100
  end
  sql = "SELECT name FROM test WHERE id BETWEEN ? AND ?"
  sth = dbh.run(sql,49,50)
  sth.ignorecase = true
  sth.fetch_hash do |row|
    p row['NAME']            # => "AAABW","AAABX"
  end
  sth.drop
end

以上内容由PHP站长网【52php.cn】收集整理供大家参考研究

如果以上内容对您有帮助，欢迎收藏、点赞、推荐、分享。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!