Unlock instant, AI-driven research and patent intelligence for your innovation.

Configurable Database Query Method

A query method and database technology, applied in the field of software development, can solve the problem of inflexible way of modifying code, and achieve the effect of satisfying data query requirements and improving reusability.

Inactive Publication Date: 2018-12-21
SICHUAN CHANGHONG ELECTRIC CO LTD
View PDF3 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to provide a configurable database query method to solve the inflexible problem of modifying the code when modifying the query statement

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0017] The configurable database query method in the embodiment of the present invention includes the following steps:

[0018] Step 1. Query and obtain all tables connected to the database, and display them through the web front end;

[0019] Step 2. Select the corresponding table among all the displayed tables;

[0020] Step 3, setting the query fields and query conditions of the table;

[0021] Step 4. When accessing the backend via url, submit the set query fields and query conditions to the backend;

[0022] Step 5, the backend generates a sql query statement corresponding to the url according to the received query field and query condition, wherein the generated sql query statement is preferably stored in an xml structure, and may also be stored in other structures;

[0023] Step 6. When the user accesses the corresponding url, parse the sql query statement of the url, and return to step 3 when the query result of the url needs to be changed.

[0024] Using the soluti...

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 invention provides a configurable database inquiry method, which relates to the field of software development. The invention solves the problem that the code modification mode is not flexible whenthe inquiry statement is wanted to be modified at present. The technical proposal is characterized in: all tables connected with the database being queried and obtained and displayed through the webfront end; selecting the appropriate table from all the tables shown; setting query fields and query criteria of the table; when the backend is accessed through the url, the query fields and query criteria set being submitted to the backend; the back end generating the sql query statement corresponding to the url according to the received query field and query condition; when the user accesses thecorresponding url, the sql query statement of the url being parsed. When the query result of the url needs to be changed, the query field and query condition of the table are reset The invention hasthe advantages of loosely coupling data inquiry and service code, improving code reusability, configurable inquiry fields and inquiry conditions of the table, and better adaptability to constantly changing data inquiry requirements.

Description

technical field [0001] The invention relates to a software development technology, in particular to a technology for realizing query of corresponding data of a database connected to the web front end. Background technique [0002] SQL language is the abbreviation of Structured Query Language. SQL language is a database query and programming language for accessing data and querying, updating and managing relational database systems; it is also the extension of database script files. The SQL language is a high-level, non-procedural programming language that allows users to work on high-level data structures. It does not require the user to specify the data storage method, nor does it require the user to understand the specific data storage method, so different database systems with completely different underlying structures can use the same structured query language as the interface for data input and management. SQL language statements can be nested, which gives him great f...

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): G06F17/30
Inventor 陈波
Owner SICHUAN CHANGHONG ELECTRIC CO LTD