Shulou(Shulou.com)06/01 Report--

This article mainly introduces the relevant knowledge of "how to develop the discipline ranking function of Mini Program". The editor shows you the operation process through an actual case, and the operation method is simple, fast and practical. I hope this "how to develop Mini Program discipline ranking function" article can help you solve the problem.

Database

To put it bluntly, the result of discipline evaluation is how about a certain discipline in a certain university. The database is designed as follows:

CREATE TABLE `ranking` (`universityNum` INTEGER NOT NULL,-- university code `university` TEXT NOT NULL,-- university name `universityLogo` TEXT NOT NULL,-- university emblem `klassCode` TEXT NOT NULL,-- discipline category code `klass` TEXT NOT NULL,-- discipline category name `roomtCode` TEXT NOT NULL -- discipline name `resultNum` INTEGER NOT NULL-- discipline evaluation results)

There are 5 university codes, such as Peking University is 10001, other universities are larger than this number, so use the INTEGER type.

The results of discipline evaluation are expressed by the numbers 1-9, and the specific meaning and corresponding relationship are as follows:

The number 123456789 results: the first 2% or the top 2% 5% 5% 5% 10% 10% 20% 20% 30% 30% 40% 40% 50% 50% 60% 60% 70%

The specific data is obtained from the official website through the crawler script, with 5000 + pieces of data.

Considering that two SELECT statements are used in the back end, one is to build two single-column indexes according to the discipline code and the other is to set up two single-column indexes according to the university code:

CREATE INDEX idx_subjectCode ON ranking (subjectCode) CREATE INDEX idx_universityNum ON ranking (universityNum) school badge

In order to make the university ranking page visually more concise and generous, plus the school badge element is a good choice.

This is the end of the content on "how to develop the discipline ranking function of Mini Program". Thank you for your reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.