crudapi Add, delete, modify and check the golden tea king voting system for the success cases of interface zero code products

brief introduction

2020 Because of the epidemic situation , The golden tea king voting activity is changed to online cloud voting , So we need a voting system to compete . There are two types of contestants , They are the restaurant and the master , Vote is passed through the WeChat official account page , To prevent cheating , Each person can work for 3 Master and 3 A restaurant voted , The voting duration is one week , The final ranking is based on the number of votes .

UI Interface prototypes

Technical framework

The project adopts the way of front end and back end separation , Database adoption MySql, Back end API use Java+Spring boot, front end H5 use Vue+Quasar, Because the business logic of the project is mainly the basic form crud Additions and deletions , So it is very suitable for crudapi Secondary development , By configuration RESTful API And background management Web, front end H5 The page can be customized and developed separately .

Database forms

The main business forms include candidates （ Including the chef and the restaurant ）, Competition area , Voting , Event registration , Voting records, etc

Establish table associations between different tables

The master shares the candidate with the restaurant candidate surface , According to the type type Fields to differentiate ,restaurant Indicates a restaurant ,chef It means master .

Voting record voteLog surface , By unique index uq_vote_log_token Restricted ticket swiping

Contains design forms to configuration , The workload is about an hour .

Back end API

The form and table relationship are configured , Corresponding crud Additions and deletions RESTful API It is automatically generated , The back end is basically finished 80% workload , Then integrate wechat automatic login and Alibaba cloud OSS Image upload , Remaining work 2 Within days ,

Background management Web

It is mainly used by administrators to edit restaurants 、 Master information 、 View voting results and export data ,crudapi The default page has basically met the requirements .

front end H5

Custom development ,15 Complete the development and testing within working days .

Summary

This paper mainly introduces the golden tea king voting system , Take advantage of crudapi Add, delete, modify and check interface zero code products for secondary development , Saved a lot of time , Total development time 18 People are naturally . Finally, complete the task on time and with high quality ,2020 The international Golden Tea King competition was a complete success .