Supercharge Your Innovation With Domain-Expert AI Agents!

method and a device for automatic table generation based on SQL

A form and automatic technology, applied in the direction of structured data retrieval, database model, etc., can solve the problem of low efficiency of the report engine, achieve the effect of solving the problem of report format adjustment and low efficiency

Inactive Publication Date: 2019-03-26
珠海迎迎科技有限公司
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The present invention aims at the problem of inefficient use of the reporting engine existing in the prior art, and proposes the following SQL-based automatic table generation method and device

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 a device for automatic table generation based on SQL
  • method and a device for automatic table generation based on SQL
  • method and a device for automatic table generation based on SQL

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] The idea, specific structure and technical effects of the present invention will be clearly and completely described below in conjunction with the embodiments and accompanying drawings, so as to fully understand the purpose, scheme and effect of the present invention. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The same reference numbers are used throughout the drawings to indicate the same or similar parts.

[0032] It should be noted that, unless otherwise specified, when a feature is called "fixed" or "connected" to another feature, it can be directly fixed and connected to another feature, or indirectly fixed and connected to another feature. on a feature. In addition, descriptions such as up, down, left, and right used in the application are only relative to the mutual positional relationship of the components of the application in the drawings....

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 an automatic table generation method based on SQL, which is characterized by comprising the following steps: S100) obtaining a format table containing data fields to be searchedfor defining a table display format and a query table containing SQL query sentences for obtaining table data; S200) checking whether the query table has the data field to be searched in the format table, and checking whether the data source specified in the SQL query statement has the data field to be searched, if so, continuing to execute the following steps, if not, ending; S300) obtaining thedata corresponding to the data field to be searched from the database through the SQL statement in the query table; S400) storing the obtained data into the query table and storing the obtained datainto the format table according to the display format of the defined table.

Description

technical field [0001] The invention relates to the technical field of report processing, in particular to an SQL-based automatic form generation method and device. Background technique [0002] With the rise of enterprise information system integration and enterprise e-commerce system construction, reports, as an important information carrier, play an extremely important role in the system, and configurable report display is more and more concerned by software developers. [0003] Currently JasperReports is the most popular open source reporting engine in the world. Written entirely in Java, it is able to consume data from any type of data source and generate pixel-level documents that can be viewed, printed or exported in a variety of document formats including HTML, PDF, XLS and DOC. However, there are problems that developers are very inefficient to use, need to learn another development language, and format adjustment is troublesome. Contents of the invention [000...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/28
Inventor 彭圣陈叙郭姣
Owner 珠海迎迎科技有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More