3种链接数据库的方式

来源:互联网 发布:epson r230清零软件 编辑:程序博客网 时间:2024/06/01 19:53
# 三种链接数据库的方式:OCI  DBI Activerecordrequire 'activerecord'ActiveRecord::Base.establish_connection(    :adapter => 'oracle',    :database     => "test3_srttest3",    :username => "test3",    :password => "srttest3"  )class Tab_xn_adminright < ActiveRecord::Base  set_table_name "tab_xn_adminright"  endputs Tab_xn_adminright.countrequire 'dbi'def open_connection(open_connection,username,password)    begin      dbh=DBI.connect('DBI:OCI8:'"#{open_connection}", username, password)    rescue DBI::DatabaseError => e      puts "An error occurred"      puts "Error code: #{e.err}"      puts "Error message: #{e.errstr}"    ensure      # disconnect from server      dbh.disconnect if dbh    end  end  puts open_connection("SRT_54","test2","srttest2")require 'oci8'conn = OCI8.new("test3", "srttest3", "test3_srttest3").exec("select * from tab_xn_adminright t where t.admin_id=628") { |r|  puts r.join(',')}