CS 157A - Semester Project Team 1. This project emphasizing on SQL queries and database manipulation.
A mock up system of trains, stations and users are being administrated through our website. The website provide two UIs:
- For client to add/remove items from the database.
- For customers to view/buy/check the schedule, tickets, prices.
As the requirements to Java with SQL, we chose Spring Boot conneting to MySQL server and provide RESTFUL API endpoints to the client side. Then we deployed the server on Heroku hosting which you can access it here (may take a while to boot up as it's currently under free host).
- Sample API: https://evening-reef-56543.herokuapp.com/api/check
- JSON: { "message": "API service running!" }
For the UI, we chose Angular as the front-end framework as we already used it before. You can visit the page here !!(No longer working)
The client side will call the RESTFUL API from the server to fetch or update data. Due to the course's main focus is on databases, only simple security measures are implemented, such as SQL injections by validating user's input.
Click here for more implementations and documentations about the project.
-
Software:
-
Front-end:
-
Back-end:
CalTrain-Db is licensed under the MIT license. (http://opensource.org/licenses/MIT)