Hello,crudapi！（ Hello , Add delete check interface ！）

In this paper, through the student object as an example , No programming , By configuration CRUD RESTful API.

Summary

CRUD brief introduction

crud It refers to the increase in the calculation process (Create)、 retrieval (Retrieve)、 to update (Update) And delete (Delete) The initials of a few words .crud It is mainly used to describe the basic operation function of database or persistence layer in software system .

RESTfull API

REST（ english ：Representational State Transfer, abbreviation REST） Describes an architecture style network system , such as web Applications . It first appeared in 2000 year Roy Fielding In his doctoral thesis ,Roy Fielding yes HTTP One of the main authors of the specification . In the current mainstream of three kinds Web In the service interaction scheme ,REST Compared with SOAP（Simple Object Access protocol, Simple object access protocol ） as well as XML-RPC It's simpler , Both for URL The treatment is still right Payload The coding ,REST They tend to design and implement in a simpler and lighter way . It is worth noting that REST There is no clear standard , It's more like a design style through RESTful API Realization , The specific interface of student operation is as follows

Table design

Student field design

Through the background metadata management UI Design student table fields , It mainly includes the name , Student number , Age , Major and other fields

Basic attributes

Object names uniquely identify different objects , Object plural is used for URL Resources in the path , The physical table name is ultimately the table name in the database
Field properties mainly include ： name , type , Indexes , length , Precision etc.

More properties

Include ： Whether it can be null , The default value is , Can I insert , Can I edit , Whether it can be inquired, etc

database

By looking at mysql database , Student list ca_student Generated

Swagger API file

https://demo.crudapi.cn/swagger-ui.html

Take creation as an example ：/api/business/{name}, among name Plural the object name （ Compatible object name ）

Business data

adopt post man verification API

Creating students

request URL
https://demo.crudapi.cn/api/business/students

request body

{
    
    "name":" Zhugeliang ",
    "stuNo":"10000",
    "age":18,
    "major":" Computer science and technology "
}

Return value 1 by id

Inquire about id by 1 Details of the students

request URL
https://demo.crudapi.cn/api/business/students/1

return body

{
    
    "id": 1,
    "name": " Zhugeliang ",
    "createdDate": 1613013249000,
    "stuNo": "10000",
    "age": 18,
    "major": " Computer science and technology "
}

adopt UI operation

Creating students

Get a list of all students

Other operating

And the editor , Delete etc. API similar , see swager Just documents ！

Summary

In this paper, through the configuration of the form to achieve RESTful CRUD API, Compared with the traditional way of development as follows ：

in summary , utilize crudapi The system can greatly improve work efficiency and save cost , Make data processing easier ！

attach demo demonstration

This system belongs to the product level zero code platform , Unlike automatic code generators , You don't have to generate Controller、Service、Repository、Entity And so on , The program can be used as soon as it runs , real 0 Code , It can cover basic business independent CRUD RESTful API.

Official website address ：https://crudapi.cn
Address of the test ：https://demo.crudapi.cn/crudapi/login