How to develop a simple online exam system using MySQL and Ruby on Rails

How to develop a simple online exam system using MySQL and Ruby on Rails

In recent years, with the development of online education, online exam systems have attracted more and more attention . The online examination system can conveniently carry out functions such as examination management, test question management, and score analysis, which brings great convenience to students and teachers. This article will introduce how to use MySQL and Ruby on Rails (Rails for short) to develop a simple online examination system, and provide specific code examples.

1. Environment preparation

Before starting development, you need to install the following software and libraries:

1. MySQL: used to store the data of the examination system. It can be downloaded and installed from the official website.
2. Ruby: Rails is developed based on Ruby, so Ruby needs to be installed. It can be downloaded and installed from the Ruby official website.
3. Rails: Rails is a Ruby-based web application development framework that can be installed through Ruby's Gem package manager.

After the installation is complete, you can verify whether the installation is successful by running the following command:

$ ruby -v
$ rails -v
$ mysql -V

2. Create a Rails application

1. Open the terminal and enter Go to the directory where you want to create the project.
2. Run the following command to create a new Rails project:

$ rails new exam_system

This will create a Rails application named exam_system.

3. Configure the database

1. Enter the exam_system directory and open the config/database.yml file.
2. In development and test environments, modify the default database configuration as follows:

development:
  adapter: mysql2
  encoding: utf8
  database: exam_system_development
  pool: 5
  username: root
  password: your_password
  host: localhost

test:
  adapter: mysql2
  encoding: utf8
  database: exam_system_test
  pool: 5
  username: root
  password: your_password
  host: localhost

Please replace your_password with your own MySQL password.

3. Run the following command in the terminal to create the database:

$ rails db:create

4. Create the model and database table

1. Create an Exam model, And add the corresponding attributes to it:

$ rails g model Exam title:string time_limit:integer

2. Create a Question model and add the corresponding attributes to it:

$ rails g model Question exam:references content:text answer_a:string answer_b:string answer_c:string answer_d:string correct_answer:integer

3. Run the following command To perform database migration:

$ rails db:migrate

5. Write controllers and views

1. Create an Exams controller and write related action methods:

$ rails g controller Exams

In the app/controllers/exams_controller.rb file, add the following code:

class ExamsController < ApplicationController
  def index
    @exams = Exam.all
  end

  def show
    @exam = Exam.find(params[:id])
    @questions = @exam.questions
  end
end

2. In the app/views/exams directory, create index.html.erb and show.html.erb View file:

index.html.erb:

<h1 id="所有考试">所有考试</h1>

<table>
  <tr>
    <th>标题</th>
    <th>时间限制</th>
    <th>操作</th>
  </tr>

  <% @exams.each do |exam| %>
    <tr>
      <td><%= exam.title %></td>
      <td><%= exam.time_limit %>分钟</td>
      <td><%= link_to '开始考试', exam %></td>
    </tr>
  <% end %>
</table>

show.html.erb:

<h1 id="exam-title-考试"><%= @exam.title %>考试</h1>

<h2 id="试题列表">试题列表</h2>

<% @questions.each do |question| %>
  <h3><%= question.content %></h3>
  <ul>
    <li><%= question.answer_a %></li>
    <li><%= question.answer_b %></li>
    <li><%= question.answer_c %></li>
    <li><%= question.answer_d %></li>
  </ul>
<% end %>

6. Run the application

1. Run the following command in the terminal to start the Rails server:

$ rails s

2. Open the browser and visit http://localhost:3000/exams to see a list of all exams.
3. Click on the title of an exam to jump to the exam question list page.

This article only introduces some functions of the online examination system. In actual development, more functions such as user login, examination submission, and score management can be improved.

I hope the above content will be helpful for developing a simple online examination system using MySQL and Ruby on Rails. Through learning and practice, you can further expand and improve the system and conduct customized development according to actual needs.

The above is the detailed content of How to develop a simple online exam system using MySQL and Ruby on Rails. For more information, please follow other related articles on the PHP Chinese website!