示例1:
- require'sqlite'
- db=SQLite::Database.new("library.db")
- db.execute("selecttitle,
- authorfrombooks")do|row|
- prow
- end
- db.close
示例2:
- db = SQLite3::Database.new 'abc.db'
- rows = db.execute <<-SQL
- create table numbers(
- name varchar(30),
- val int
- );
- SQL
- {
- "one"=>1,
- "two"=>2,
- }.each do |pair|
- db.execute "insert into numbers values(?,?)",pair
- end
- db.execute("select * from numbers") do |row|
- p row
- end
来源: http://www.phpxs.com/code/1005264/