Home >Database >Mysql Tutorial >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:
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
$ rails new exam_system
This will create a Rails application named exam_system.
3. Configure the database
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.
$ rails db:create
4. Create the model and database table
$ rails g model Exam title:string time_limit:integer
$ rails g model Question exam:references content:text answer_a:string answer_b:string answer_c:string answer_d:string correct_answer:integer
$ rails db:migrate
5. Write controllers and views
$ 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
index.html.erb:
<h1>所有考试</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><%= @exam.title %>考试</h1> <h2>试题列表</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
$ rails s
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!