|
rails中使用fasterCSV解析csv文件比标准库的csv要快倍左右 先安装fasterCSV Java代码 gem install fastercsv gem install fastercsv gem install fastercsvViews: indexrhtml Java代码 <% form_for :myform :url=>{:controller=>users :action=>import} :html => { :multipart => true } do |f| %> Select a CSV File :<%= ffile_field :file %> <%= submit_tag Submit %> <% end %> <% form_for :myform :url=>{:controller=>users :action=>import} :html => { :multipart => true } do |f| %> Select a CSV File :<%= ffile_field :file %> <%= submit_tag Submit %> <% end %> <% form_for :myform :url=>{:controller=>users :action=>import} :html => { :multipart => true } do |f| %> Select a CSV File :<%= ffile_field :file %> <%= submit_tag Submit %> <% end %>importrhtml Java代码 <font color=red>OK!!!</font> <font color=red>OK!!!</font> <font color=red>OK!!!</font>Controller: import Java代码 require faster_csv require faster_csv require faster_csvJava代码 def import n= FasterCSVparse(params[:myform][:file]:headers=>true)do |row| user = Usernew userusername = row[] userpassword = row[] usersave! n=n+ GCstart if n%== #GC 是Rails 的垃圾收集器的类(Garbage CollectorGC) flashnow[:notice]=CSV Import Successful #{n} new records added to data base end end def import n= FasterCSVparse(params[:myform][:file]:headers=>true)do |row| user = Usernew userusername = row[] userpassword = row[] usersave! n=n+ GCstart if n%== #GC 是Rails 的垃圾收集器的类(Garbage CollectorGC) flashnow[:notice]=CSV Import Successful #{n} new records added to data base end end def import n= FasterCSVparse(params[:myform][:file]:headers=>true)do |row| user = Usernew userusername = row[] userpassword = row[] usersave! n=n+ GCstart if n%== #GC 是Rails 的垃圾收集器的类(Garbage CollectorGC) flashnow[:notice]=CSV Import Successful #{n} new records added to data base end end# :headers=>true 的意思是第一行存在行头不导入数据库 gem install fastercsv gem install fastercsv gem install fastercsvViews: indexrhtml Java代码 <% form_for :myform :url=>{:controller=>users :action=>import} :html => { :multipart => true } do |f| %> Select a CSV File :<%= ffile_field :file %> <%= submit_tag Submit %> <% end %> <% form_for :myform :url=>{:controller=>users :action=>import} :html => { :multipart => true } do |f| %> Select a CSV File :<%= ffile_field :file %> <%= submit_tag Submit %> <% end %> <% form_for :myform :url=>{:controller=>users :action=>import} :html => { :multipart => true } do |f| %> Select a CSV File :<%= ffile_field :file %> <%= submit_tag Submit %> <% end %>importrhtml Java代码 <font color=red>OK!!!</font> <font color=red>OK!!!</font> <font color=red>OK!!!</font>Controller: import Java代码 require faster_csv require faster_csv require faster_csvJava代码 def import n= FasterCSVparse(params[:myform][:file]:headers=>true)do |row| user = Usernew userusername = row[] userpassword = row[] usersave! n=n+ GCstart if n%== #GC 是Rails 的垃圾收集器的类(Garbage CollectorGC) flashnow[:notice]=CSV Import Successful #{n} new records added to data base end end def import n= FasterCSVparse(params[:myform][:file]:headers=>true)do |row| user = Usernew userusername = row[] userpassword = row[] usersave! n=n+ GCstart if n%== #GC 是Rails 的垃圾收集器的类(Garbage CollectorGC) flashnow[:notice]=CSV Import Successful #{n} new records added to data base end end def import n= FasterCSVparse(params[:myform][:file]:headers=>true)do |row| user = Usernew userusername = row[] userpassword = row[] usersave! n=n+ GCstart if n%== #GC 是Rails 的垃圾收集器的类(Garbage CollectorGC) flashnow[:notice]=CSV Import Successful #{n} new records added to data base end end# :headers=>true 的意思是第一行存在行头不导入数据库 |
