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

Searching method for building query statement based on class information

A query statement and statement technology, applied in the field of database query, can solve the problem of few dynamic information query methods, etc.

Active Publication Date: 2017-05-31
XINGTANG TELECOMM TECH CO LTD
View PDF3 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of the above analysis, the present invention aims to provide a search method for constructing query sentences based on class information, in order to solve the problem that there are few dynamic class information query methods from background to foreground in existing methods

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
  • Searching method for building query statement based on class information
  • Searching method for building query statement based on class information
  • Searching method for building query statement based on class information

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] Preferred embodiments of the present invention will be specifically described below in conjunction with the accompanying drawings, wherein the accompanying drawings constitute a part of the application and are used together with the embodiments of the present invention to explain the principles of the present invention.

[0041] A specific embodiment of the present invention discloses a search method for constructing a query statement based on class information, wherein the class information refers to a Java class corresponding to a table in a database, and the columns of the table are attributes of the class, specifically comprising the following steps:

[0042] Step S1. The server side scans the persistent class file to extract the information of the Java class itself and its attribute information; reads the preset configuration file to obtain the default configuration of the attribute; automatically generates it according to the Java class information, attribute inform...

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 relates to a searching method for building a query statement based on class information, comprising the steps of S1, scanning, by a server, a persistent class file to extract Java class information and its attribute information; reading a preset configuration file to acquire default configuration of each attribute; automatically generating a class information data table file according to the Java class information, attribute information and configuration information; S2, setting, by a user, service parameters through a client, and dynamically adding to a text input box; inputting, by the user, query content to the text input box, and transmitting the input query content and the service parameters together to the server; S3, receiving, by the server, the query content and service parameters input by the client to automatically splice an SQL (structured query language) statement, performing corresponding database search operations according to the SQL statement, and performing information feedback on the client. The method of the invention has the advantages that searching speed is increased, a user may be assisted in operating quickly, and codes are simplified.

Description

technical field [0001] The invention relates to the technical field of database query, in particular to a search method for constructing a query statement based on class information (the class information refers to a Java class corresponding to a table in a database, and the columns of the table are the attributes of the class). Background technique [0002] As a relatively mature programming language, Java language is widely used in various software development. In today's software development, it is mainly developed in the B / S browser mode. The interactive aspect of AJAX partial refresh is the mainstream of application development. The server generally uses data persistence tools, such as JDBCTEMPLATE, HIBERNATE, IBATIS, etc. A typical application framework is JavaScript+Struts+Spring+Hibernate / Ibatis. At the same time, in software development, data access is essential, and in database technology, using SQL statements is the main method of database operation. [0003] Mo...

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): G06F9/44G06F17/30
CPCG06F8/24G06F16/242
Inventor 付雳赵雪良张康
Owner XINGTANG TELECOMM TECH 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

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