从数据库查看 Rails 记录

2024 年 12 月 18 日 | 2 分钟阅读

我们将看到一个在应用程序中查看数据的示例。

步骤 1 创建一个新的 Rails 应用程序。

步骤 2 将您的目录更改为保存目录。

步骤 3 从控制台创建一个控制器。

步骤 4 从控制台创建一个模型。

rails g model product name:string price:decimal short_description:text full_description:text

步骤 5 转到 app/controllers/products_controller.rb 并编写以下代码。

class ProductsController < ApplicationController 
  
  # GET method to get all products from database 
  def index 
    @products = Product.all 
  end 
  
  # GET method to get a product by id 
  def show 
    @product = Product.find(params[:id]) 
  end 
  
  # GET method for the new product form 
  def new 
    @product = Product.new 
  end 
  
  # POST method for processing form data 
  def create 
    @product = Product.new(product_params) 
    if @product.save 
      flash[:notice] = 'Product added!' 
      redirect_to root_path 
    else 
      flash[:error] = 'Failed to edit product!' 
      render :new 
    end 
  end 

  def destroy 
    @product = Product.find(params[:id]) 
    if @product.delete 
      flash[:notice] = 'Product deleted!' 
      redirect_to root_path 
    else 
      flash[:error] = 'Failed to delete this product!' 
      render :destroy 
    end 
  end 
   
 def product_params 
    params.require(:product).permit(:name, :price, :old_price, :short_description, :full_description) 
  end 
   end 

步骤 6 运行以下命令

步骤 7 转到 app/views/products/index.html.erb 文件。

<h3>STOCK LIST</h3> 
    
      <div> 
        <%= link_to 'Add Product', new_product_path %> 
      </div> 
      <br> 
    
     <table class="table table-bordered table-striped"> 
       <tr> 
        <th>Name</th> 
        <th>Price</th> 
        <th>Description</th> 
        
      </tr> 
     
      <% @products.each do |product| %> 
          <tr> 
            <td><%= product.name %></td> 
            <td><%= product.price %></td> 
            <td><%= truncate(product.short_description, :length => 75) %></td> 
                <td><%= link_to 'Delete', product_path(product), method: :delete %></td> 
            
           </tr> 
      <% end %> 
    </table>

步骤 8 转到 app/views/products/new.html.erb 文件。

<%= form_for @product, url: {action: :create} do |f| %> 
      
        <h3>Add a Product</h3> 

        <div class="field"> 
            <%= f.label :name %> 
              <%= f.text_field :name %> 
        </div> 

        <div class="field"> 
             <%= f.label :price %> 
             <%= f.text_field :price %> 
        </div> 

        <div class="field"> 
           <%= f.label :short_description %> 
              <%= f.text_field :short_description %> 
        </div> 
		 </p> 
      </div> 
      <div class="actions"> 
        <%= link_to 'Back', { controller: 'products', action: 'index'} %> 
        <%= f.submit 'Create Product' %> 
      </div> 
  <% end %> 
</div>

步骤 9 启动服务器。

步骤 10 在 localhost 上运行它。