Service table query method and device, server and computer readable storage medium

A query method and business table technology are applied in the fields of servers and computer-readable storage media, business table query methods, and devices, and can solve problems such as difficulty in meeting complex query requirements and large labor cost input.

Inactive Publication Date: 2019-08-02
天津中新智冠信息技术有限公司 +1
View PDF4 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] In view of this, the present invention provides a business table query method, device, server, and computer-readable storage medium, so as to

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Service table query method and device, server and computer readable storage medium
  • Service table query method and device, server and computer readable storage medium
  • Service table query method and device, server and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0067] Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary examples do not represent all implementations consistent with the present invention. Rather, they are merely examples of apparatuses and methods consistent with aspects of the invention as recited in the appended claims.

[0068] The terminology used in the present invention is for the purpose of describing particular embodiments only and is not intended to limit the invention. As used herein and in the appended claims, the singular forms "a", "the", and "the" are intended to include the plural forms as well, unless the context clearly dictates otherwise. It should also be understood that the term "and / or" as use...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The embodiment of the invention provides a service table query method. The method comprises: storing a pre-constructed metadata table in a database, wherein the metadata table has a corresponding relation with a pre-defined standardized query interface, and the metadata table is used for describing the structure of a query service table; responding to a query request initiated by an upper application by calling the standardized query interface, and analyzing query interface parameters from the query request; determining query content indicated by the query interface parameter at least partially according to the structure of the query service table described by the metadata table; and querying the service table in the database at least partially according to the query content to obtain a query result. According to the embodiment of the invention, the problems of high labor cost input and difficulty in meeting complex query requirements of a business table query mode in the prior art canbe solved as much as possible. The embodiment of the invention also provides a service table query device, a server and a computer readable storage medium.

Description

technical field [0001] The invention relates to the field of database access, in particular to a service table query method, device, server and computer-readable storage medium. Background technique [0002] The business table query technology returns the data of the database to the front-end page according to the specified conditions and format through the program interface. As far as the business table query technology is concerned, there are mainly two methods: hard-coded interface query and code generation tool interface query. [0003] Currently, hard-coded interface queries and code generation tool interface queries have the following problems: [0004] 1. Hard-coded interface query requires technicians to manually write relevant interface codes according to the specific requirements of the report, which requires a large investment in labor costs. [0005] 2. Code generation tool interface query (for example, mybatisplus) improves the labor input cost of hard-coded i...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F16/22G06F16/25
CPCG06F16/2282G06F16/25
Inventor 张淑强李大勤郭翔
Owner 天津中新智冠信息技术有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products