Ruby 使用 ODBC 连接数据库

life-boy

1. require "odbc"
   
2. 
   
3. DSN  = "Myodbc"
   
4. USER = "YourName"
   
5. PWD  = "123"
   
6. 
   
7. ODBC.connect(DSN, USER, PWD) do |dbh|
   
8.   dbh.autocommit = true
   
9.   begin
   
10.     dbh.do("DROP TABLE test")
    
11.   rescue ODBC::Error; end
    
12.   dbh.do("CREATE TABLE test (id INT, name VARCHAR(30))")
    
13.   dbh.do("INSERT INTO test VALUES (?,?)", 1, 'Michael')
    
14.   dbh.autocommit = false
    
15.   dbh.prepare("INSERT INTO test VALUES(?,?)") do |sth|
    
16.     name = "AAAAA"
    
17.     99.times {|n| sth.execute(n+2, name.succ!) }
    
18.   end
    
19.   dbh.commit
    
20.   dbh.run("SELECT COUNT(*) FROM test") do |sth|
    
21.     p sth.fetch[0]  # => 100
    
22.   end
    
23.   sql = "SELECT name FROM test WHERE id BETWEEN ? AND ?"
    
24.   sth = dbh.run(sql, 49, 50)
    
25.   sth.ignorecase = true
    
26.   sth.fetch_hash do |row|
    
27.     p row['NAME']            # => "AAABW", "AAABX"
    
28.   end
    
29.   sth.drop
    
30. end

复制代码