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

Method and device for carrying out condition query on database table

A conditional query and database technology, applied in the field of conditional query on database tables, can solve problems affecting the response speed of application systems and development efficiency, and achieve the effect of improving efficiency and response speed

Inactive Publication Date: 2010-06-16
CHINA ELECTRIC POWER RES INST +1
View PDF0 Cites 36 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] However, the process of manually writing a large number of query codes by developers affects the efficiency of development; at the same time, since the application system needs to be restarted when the background code changes, under the existing technical solutions, when user requirements change (requires new Adding or modifying the query type), it is necessary to restart the system after the developer modifies the code to continue running. Therefore, the response speed of the application system when the query type is changed is affected.

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
  • Method and device for carrying out condition query on database table
  • Method and device for carrying out condition query on database table
  • Method and device for carrying out condition query on database table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] In order to make the above objects, features and advantages of the present invention more comprehensible, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0036] see figure 1 The method for querying a database table provided by an embodiment of the present invention includes the following steps:

[0037] S101: Obtain the relationship between the page and the target database table, analyze the query object tag written in the page file, and display the query page; the query object is encapsulated by the query input box in the page;

[0038] In the embodiment of the present invention, it is first necessary to establish the association relationship between the page and the target database table, because the query type in the page may change, therefore, in order to facilitate implementation, the following method can be used to establish the association relationship between the page and t...

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 discloses a method for carrying out condition query on a database table. The method comprises the following steps: acquiring the correlation relation between a page and a target database table and analyzing a query object label compiled in a page file to display a query page, wherein the query object is formed by encapsulating a query input frame in the page; extracting a query condition value input in the query input frame by a user from the query object when receiving a query request sent by the user on the query page; binding the extracted query condition value to the target database table correlated to the query page to form a query sentence; and executing the query sentence and returning a query result in accordance with query conditions. The method improves developmentefficiency and quickens the response speed of an application system when a query type changes.

Description

technical field [0001] The invention relates to the technical field of business processing, in particular to a method and device for performing conditional query on a database table. Background technique [0002] Nowadays, the network is developing rapidly, and the business system is gradually changing from the original C / S (Client / Server, client / server) structure to the B / S (Browser / Server, browser / server) structure. Almost all application systems will use a large number of conditional query functions for database tables. Users organize certain query conditions through various methods such as input boxes or drop-down boxes, and then click the query button to record the qualified records in the page. displayed in the list. [0003] Under the existing technical solutions, in order to realize the above-mentioned function of conditional query on the database table, the application system needs to have a page displaying the query condition (ordinary text input box) and a send r...

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/30G06F9/44
Inventor 方国罗华永王宇飞杨宁
Owner CHINA ELECTRIC POWER RES INST
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com