yanfei 发表于 2016-11-28 11:44:21

应用JDBC连接SQLite

  用"SQLite.JDBCDriver"作为JDBC的驱动程序类名。连接JDBC的URL格式为jdbc:sqlite:/path。这里的path为指定到SQLite数据库文件的路径,例如:
jdbc:sqlite://dirA/dirB/dbfile
jdbc:sqlite://DRIVE:/dirA/dirB/dbfile
jdbc:sqlite://COMPUTERNAME/shareA/dirB/dbfile
  設置environment.rb:

if RUBY_PLATFORM =~ /java/
require 'rubygems'
gem 'activerecord-jdbcsqlite3-adapter'
#require 'active_record/connection_adapters/jdbcsqlite3_adapter'
require 'jdbc_adapter'
end
   設置database.yml:

#SQLite3
development:
adapter: jdbcsqlite3
url: jdbc:sqlite:db/test.db
production:
adapter: jdbcsqlite3
url: jdbc:sqlite:db/test.db
 
页: [1]
查看完整版本: 应用JDBC连接SQLite