Project DBS-selectCourse

Introduction

This is my implementation of an imaginary course selection system. Backed by a relational database, hosted by SparkJava web framework and interfaced with Vue.js client.

Hosted Instance

Hosted site
The SparkJava application is hosted on Google App Engine Standard Environment with Java11. Since GAE only allows read-only access to SQLite datafile, exceptions are caught. But can be ignored, data query and operations are still simulated. db is copied to /tmp, changes persist as long as the app instance is running.

Available Course List

Selected Course List

Todo

Todo list

---

### Project Requirements

DB Select course System

• Vaadin/SparkJava
• sql2o or Mybatis

Function

• list selectable courses
• select courses (cart)
• edit-selected course (cart edit)

Constrains

• 21 max credit
• Dependency Courses
• Time conflict resolution

Build

Directory Structure

• /docs - documentation
• /src/main/java - java source files
• /src/main/resources - html/js source files
• /target - compiled executables
• /db - default database location

Compilation

1. MVN clean
2. MVN compile
3. MVN package
4. The executable jar is in /target

By default operations are reverted. To make permanent change, change /src/main/java/Main.java DEBUG constant to 0.

Progress Screenshots

Before Bootstrap

After Bootstrap