Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database query method and device, computer device and readable storage medium

A query method and database technology, applied in the fields of computer-readable storage media, devices, and database query methods, can solve the problems of difficulty in writing SQL statements, inconvenient user operations, and high basic requirements for databases, and achieve the effect of facilitating query operations

Pending Publication Date: 2019-06-04
CHINA PING AN LIFE INSURANCE CO LTD
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this access method has relatively high requirements on the database foundation of software developers. When querying records, it is necessary to write a special SQL query statement according to the query field, and then assign the query result to the application object of the programming language to execute the SQL statement. write
However, for non-software developers, it is difficult to write SQL statements, which is not convenient for users to operate

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
  • Database query method and device, computer device and readable storage medium
  • Database query method and device, computer device and readable storage medium
  • Database query method and device, computer device and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0047] figure 1 It is a flow chart of steps in a preferred embodiment of the database query method of the present invention. According to different requirements, the order of the steps in the flowchart can be changed, and some steps can be omitted.

[0048] refer to figure 1 As shown, the database query method specifically includes the following steps.

[0049] Step S1, acquiring attribute information of the database, and generating a tree selection model according to the attribute information.

[0050] In this embodiment, the attribute information of the database includes a database identifier, a data table identifier, a field identifier and a record identifier. Understandably, each database may include one or more data tables, each data table may include one or more fields, and each field may include one or more records.

[0051]Preferably, each database has a database identifier, each data table has a data table identifier, each field has a field identifier, and each fi...

Embodiment 2

[0078] figure 2 It is a functional block diagram of a preferred embodiment of the database query device of the present invention.

[0079] refer to figure 2 As shown, the database query device 20 may include a generation module 201 , an opening module 202 , an association module 203 , a query module 204 and an acquisition module 205 .

[0080] The generation module 201 is used to obtain attribute information of the database, and generate a tree selection model according to the attribute information.

[0081] In one embodiment, each database in the generating module 201 has a database identifier, each data table has a data table identifier, each field has a field identifier, and each field identifier has a record identifier. The database identification, data table identification, field identification and record identification can be used as nodes of the tree selection model, wherein each database identification node in the tree selection model is connected to the root node,...

Embodiment 3

[0109] image 3 It is a schematic diagram of a preferred embodiment of the computer device of the present invention.

[0110] The computer device 30 includes a memory 31 , a processor 32 and a computer program 33 stored in the memory 31 and operable on the processor 32 , such as a database query program. When the processor 32 executes the computer program 33, the steps in the above-mentioned database query method embodiment are realized, for example figure 1 Steps S1-S5 are shown. Alternatively, when the processor 32 executes the computer program 33, it realizes the functions of each module in the above database query device embodiment, for example figure 2 Modules 201-205 in .

[0111] Exemplarily, the computer program 33 can be divided into one or more modules / units, and the one or more modules / units are stored in the memory 31 and executed by the processor 32 to complete this invention. The one or more modules / units may be a series of computer program instruction segm...

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 database query method and device, a computer device and a computer readable storage medium. The database query method comprises the steps if acquiring attribute information ofa database, and generating a tree selection model according to the attribute information; receiving an access request and opening a preset interface according to the access request, wherein the preset interface comprises at least one input box and at least one selection box; Associating nodes of the tree selection model with the selection box, acquiring query information input in the input box and the options selected in the selection box, generating query statements according to the query information and the nodes of the tree selection model associated with the options selected in the selection box, executing the query statements and acquiring execution results in the database. According to the database query method provided by the invention, the data in the database can be queried on the preset webpage interface, data query visualization is realized, and a user can conveniently perform database query operation.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a database query method and device, a computer device and a computer-readable storage medium. Background technique [0002] The database system has become an indispensable and important part of the existing system, and the data access function is the most basic function of the database system. The traditional query data access method is realized by writing the structured query language (Structured Query Language, referred to as SQL) by calling the special interface of the database. However, this access method has relatively high requirements on the database foundation of software developers. When querying records, it is necessary to write a special SQL query statement according to the query field, and then assign the query result to the application object of the programming language to execute the SQL statement. write. However, for non-software developers, it is diffi...

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/245G06F16/242
Inventor 高雪松
Owner CHINA PING AN LIFE INSURANCE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products