CN109992589A - Method, apparatus, server and the medium of SQL statement are generated based on visual page - Google Patents
Method, apparatus, server and the medium of SQL statement are generated based on visual page Download PDFInfo
- Publication number
- CN109992589A CN109992589A CN201910288930.4A CN201910288930A CN109992589A CN 109992589 A CN109992589 A CN 109992589A CN 201910288930 A CN201910288930 A CN 201910288930A CN 109992589 A CN109992589 A CN 109992589A
- Authority
- CN
- China
- Prior art keywords
- field
- sql statement
- user
- configuration information
- object field
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/0486—Drag-and-drop
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Human Computer Interaction (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- User Interface Of Digital Computer (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a kind of method, apparatus, server and media that SQL statement is generated based on visual page.Visual page is realized based on VUE frame, and desktop end Component Gallery is integrated in VUE frame and can pull Component Gallery;This method comprises: obtaining the target data source of user's selection, and the attribute information of target data source is shown in the first predeterminable area of current page, attribute information includes the field in target data source in each database table;It is instructed in response to pulling, determines aiming field, and by aiming field from the output field region in the second predeterminable area that the first predeterminable area is drawn to current page;User is obtained in output field region to the operation configuration information of aiming field;If detecting, SQL statement generates event, according to the operation configuration information of aiming field and aiming field, generates and saves SQL statement.The technical solution of the embodiment of the present invention provides a kind of easy new approaches for generating SQL statement for user.
Description
Technical field
The present embodiments relate to field of computer technology, more particularly to a kind of visual page that is based on to generate SQL statement
Method, apparatus, server and storage medium.
Background technique
Recently as the development of computer and database, SQL (Structure Query Languge, structuralized query
Language) a kind of dedicated computer programming language of database is widely used, and becoming most important is also most common pass
It is database manipulation language.
However, the method for generating SQL statement at present, by the user by having the relevant professional knowledges such as database in rear end
It writes, and then generates SQL statement.The method is more demanding to the background knowledge for writing SQL statement user, no professional knowledge background
Ordinary user, then can not generate the SQL statement needed for oneself.In addition, also having at present a small number of based on visual page generation SQL
The method of sentence, but the visual page is unfriendly, user can only be configured by way of clicking, selecting, Jin Ersheng
At SQL.Therefore it provides a kind of new SQL statement generating mode is very necessary.
Summary of the invention
The embodiment of the invention provides a kind of method, apparatus, server and Jie that SQL statement is generated based on visual page
Matter optimizes the interactive experience between visual page and user, and the user of no data library professional knowledge background, may be based on can
Depending on changing the SQL statement needed for the page generates oneself, a kind of easy new approaches for generating SQL statement are provided for user.
In a first aspect, the embodiment of the invention provides it is a kind of based on visual page generate SQL statement method, it is described can
It is realized depending on changing the page based on VUE frame, desktop end Component Gallery is integrated in the VUE frame and Component Gallery, this method can be pulled
Include:
The target data source of user's selection is obtained, and the attribute information of the target data source is shown in current page
First predeterminable area, wherein the attribute information includes the field in the target data source in each database table;
Instruction is pulled in response to first, determines first object field, and the first object field is pre- from described first
If region is drawn in the output field region in the second predeterminable area of current page;
User is obtained in the output field region to the first operation configuration information of the first object field;
If detecting, SQL statement generates event, first according to the first object field and first object field
Operation configuration information generates and saves SQL statement.
Second aspect, the embodiment of the invention provides it is a kind of based on visual page generate SQL statement device, it is described can
It is realized depending on changing the page based on VUE frame, desktop end Component Gallery is integrated in the VUE frame and Component Gallery can be pulled, the device
Include:
Attribute information display module, for obtaining the target data source of user's selection, and by the category of the target data source
Property information is shown in the first predeterminable area of current page, wherein the attribute information includes each number in the target data source
According to the field in the table of library;
Field pulls module, instructs for pulling in response to first, determines first object field, and by the first object
Field is from the output field region in the second predeterminable area that first predeterminable area is drawn to current page;
Configuration information obtains module, for obtaining user the in the output field region to the first object field
One operation configuration information;
Sentence generate preserving module, if for detect SQL statement generate event, according to the first object field with
And the first operation configuration information of first object field, it generates and saves SQL statement.
The third aspect, the embodiment of the invention also provides a kind of server, which includes:
One or more processors;
Storage device, for storing one or more programs;
When one or more of programs are executed by one or more of processors, so that one or more of processing
Device realizes any method for generating SQL statement based on visual page in first aspect.
Fourth aspect, the embodiment of the invention also provides a kind of media, are stored thereon with computer program, which is located
It manages and realizes any method that SQL statement is generated based on visual page in first aspect when device executes.
Method, apparatus, server and the medium provided in an embodiment of the present invention that SQL statement is generated based on visual page,
The first predeterminable area of current page is shown in by the attribute information for the target data source for selecting user, so that user can be straight
See the field navigated to needed for oneself;Component Gallery can be pulled due to being integrated in visual page, is made in each database table
Field have and can pull attribute, and then may be in response to user is triggered first and pull instruction, by first object field from the
One predeterminable area is drawn in the output field region in the second predeterminable area of current page, and obtains user in output field
To the first operation configuration information of first object field in region;It, can be according to the to when detecting that SQL statement generates event
First operation configuration information of one aiming field and first object field, SQL statement needed for generating and saving user.We
Case, Database field support drag function, optimize the interactive experience between visual page and user;And no data library profession
The user of knowledge background may be based on visual page and generate SQL statement needed for oneself, provide for user a kind of easy to be raw
At the new approaches of SQL statement.
Detailed description of the invention
Figure 1A is a kind of process for method that SQL statement is generated based on visual page that the embodiment of the present invention one provides
Figure;
Figure 1B is a kind of visual page schematic diagram that the embodiment of the present invention one provides;
Fig. 1 C is a kind of output field region set interface schematic diagram that the embodiment of the present invention one provides;
Fig. 2 is a kind of flow chart of method that SQL statement is generated based on visual page provided by Embodiment 2 of the present invention;
Fig. 3 is a kind of flow chart for method that SQL statement is generated based on visual page that the embodiment of the present invention three provides;
Fig. 4 A is a kind of process for method that SQL statement is generated based on visual page that the embodiment of the present invention four provides
Figure;
Fig. 4 B is a kind of input field region set interface schematic diagram that the embodiment of the present invention four provides;
Fig. 5 is a kind of structural frames for device that SQL statement is generated based on visual page that the embodiment of the present invention five provides
Figure;
Fig. 6 is a kind of structural schematic diagram for server that the embodiment of the present invention six provides.
Specific embodiment
The embodiment of the present invention is described in further detail with reference to the accompanying drawings and examples.It is understood that this
Locate described specific embodiment and is used only for explaining the embodiment of the present invention, rather than limitation of the invention.It further needs exist for
Bright, only parts related to embodiments of the present invention are shown for ease of description, in attached drawing rather than entire infrastructure.
Before introducing various embodiments of the present invention, first the application scenarios of the embodiment of the present invention are illustrated.The present invention is real
The visual page applied in example is realized based on VUE frame, wherein VUE is a set of for constructing the gradual frame of user interface,
It is not only easy to hand, is also convenient for and third party library or existing Item increasing.In addition, working as the tools chain with modernization and various branch
When holding class libraries combined use, VUE is also fully able to provide driving for complicated single page application.Therefore, it is developed based on VUE frame
Visual page the user of no data library professional knowledge background can be made also to generate the SQL needed for oneself by visual page
Sentence.Optionally, it is integrated with desktop end Component Gallery in VUE frame and Component Gallery can be pulled.Wherein, desktop end Component Gallery is
ElementUI is a UI Component Gallery based on VUE, can help developer's rapid build page;Component Gallery can be pulled i.e.
Vue.Draggable Component Gallery is that a field allowed in the page in database table based on VUE design supports the function pulled
It can library.And then the database table field in the visual page developed in the embodiment of the present invention based on VUE frame is had and can be dragged
Attribute is dragged, solves that prior art visual page is unfriendly, what user can only be configured by way of clicking, selecting asks
Topic.Technical solution of embodiment of the present invention is introduced based on this.
It should also be noted that similar label and letter indicate similar terms in following attached drawing, therefore, once a certain Xiang Yi
It is defined in a attached drawing, does not then need that it is further defined and explained in subsequent attached drawing.Meanwhile of the invention
In description, term " first ", " second " etc. are only used for distinguishing description, are not understood to indicate or imply relative importance, with
And sequencing etc..
Embodiment one
Figure 1A is a kind of process for method that SQL statement is generated based on visual page that the embodiment of the present invention one provides
Figure, the present embodiment are applicable to the case where generating SQL statement, are particularly suitable for how simplifying the complex process for generating SQL statement,
The scene of the SQL statement needed for oneself is also produced so as to the user of no data library professional knowledge background.It is visual in the present embodiment
Change the page to realize based on VUE frame, and is integrated with desktop end Component Gallery in VUE frame and Component Gallery can be pulled.This method can be with
Executed by the device provided in an embodiment of the present invention for generating SQL statement based on visual page, the device can be used hardware and/
Or the mode of software is realized, which can be integrated in server (configured with VUE frame system in the server).Referring to figure
1A, this method can specifically include:
S110, obtains the target data source of user's selection, and the attribute information of target data source is shown in current page
The first predeterminable area, wherein attribute information includes the field in target data source in each database table.
In the present embodiment, user can be the ordinary user of no data library professional knowledge background, can also be developer etc..
Data source refers to for providing the device or original media of data required for certain.Optionally, it may be provided in a data source
Multiple databases include table in each database again, again include field in table.It is corresponding, target data source refer to user according to
Self-demand is from any data source selected in optional multiple data sources.The attribute information of target data source may include this
The title of set all databases in target data source, each field in the title of table and each table in each database.
Wherein, field may include field name, can also be including field label etc.;Field label is the note of field, is used for into one
Step explains field, quickly identifies and is navigated at required field location convenient for user.
Current page is visual page, is the interactive interface that user generates SQL statement needed for oneself.First preset areas
Domain refers to the pre-set region for the attribute information in current page displaying target data source.Optionally, first is default
Region can be located at the left side of current page, and the attribute information of target data source can be shown in a left side for current page with tree
Side.For example, as shown in Figure 1B, the attribute information of target data source may include database-name api_test, table name school_
Each field etc. under info and table school_info, such as id (major key id), sh_name (school's name);Wherein, id is word
Name section, major key id are field label;The attribute information of target data source is shown in the left side of current page with tree.It can
Choosing, the size of the first predeterminable area can show that situation carries out dynamic adjustment according to practical;In the case where database is more, it is
The field under required database is quickly navigated to convenient for user, input frame can also be set in the first predeterminable area, be used for
For user's input field title, as shown in Figure 1B.
In the present embodiment, user can load current page by local browser, can then be given birth on current page
At the relevant operation of SQL statement.Specifically, needed for user can select oneself in current page data source options drop-down list
Data source, and then current page can obtain the data source of user's selection, and using the data source as target data source;Later, may be used
The attribute information of target data source is shown in the first predeterminable area of current page, such as the left side of current page.
Illustratively, for the ease of the more intuitive selection data source of user, settable triggering key in current page, Huo Zheqi
His trigger mechanism.In turn, if current page detects that user clicks a certain function button or a certain number of input on current page
According to etc., then it can be with display data source options interface, so that user intuitively selects, it then can be using the data source that user selects as mesh
Mark data source;Later, the attribute information of target data source can be shown in the first predeterminable area of current page, such as current page
Left side.
Illustratively, before the target data source for obtaining user's selection, if can also include: to detect data variation thing
Part, then display data source options interface.Wherein, data change event refers to that user clicks on current page or input a certain number
According to the event for triggering generation.It include optional multiple data sources in data source options interface.
S120 pulls in response to first and instructs, determines first object field, and by first object field from the first preset areas
Domain is drawn in the output field region in the second predeterminable area of current page.
In the present embodiment, Component Gallery can be pulled by being integrated in the VUE frame due to realizing current page, and then make current page
Database table field in face has and can pull attribute.Pulling instruction, to be user be dragged to for the field in the first predeterminable area
Caused by two predeterminable areas.Wherein, the second predeterminable area refers to that the field in pre-set current page can pull placement
Region;Optionally, the second predeterminable area can be located at the right side of current page, and the first predeterminable area is connected, and can be from function
On be divided into filter area, input field region, output field region and grouping field region etc. and can pull rest area
Domain (illustratively shows filter region, the input field region in the second predeterminable area, output is not shown as shown in Figure 1B
Field area and grouping field region).Wherein, filter area is the region that can be used for that field is arranged screening function, point
Group field region is the region for field being arranged block functions, and output field region can be used for being arranged the statistics of output field
Condition.In addition, it should be noted that, the field in the first predeterminable area can be drawn to this four according to actual needs by user
Arbitrary region is placed in region, but combines SQL statement formation characteristic, filter area, input field region and grouping field
Region is without that must place dragging field, that is to say, that and filter area, input field region and grouping field region can be sky,
And output field region must have the relevant information of field and field.Illustratively, the second predeterminable area may also include blank can
Editing area, user can also add the content needed for oneself in current page according to the actual situation, and generate oneself can
Depending on changing page etc..
Corresponding, the first dragging instruction is that the field in the first predeterminable area is dragged in the second predeterminable area by user
Caused by output field region.First object field is output of the user from the first predeterminable area into the second predeterminable area
The field that field area is pulled;Optionally, first object can be determined according to drag operation of the user at the first predeterminable area
Field, and the number of first object field is at least one.Illustratively, in the case where first object field is multiple, one
Secondary drag operation can pull multiple fields simultaneously, can also once pull a field, and user can select according to actual needs.
Specifically, if detecting the output word that the field in the first predeterminable area is drawn in the second predeterminable area by user
The first dragging instruction that section region is triggered then responds the first dragging instruction, using the field as first object field, and will
First object field is placed from the output field region being drawn in the second predeterminable area from the first predeterminable area position.
For example, as shown in Figure 1 C, if detecting, field age (students ' age) is drawn to the from the first predeterminable area by user
The first dragging instruction that output field region in two predeterminable areas is triggered then responds the first dragging instruction, by the field
Age (students ' age) is used as first object field, and field age (students ' age) is drawn to from the first predeterminable area position
It is placed in output field region in second predeterminable area.
S130 obtains user in output field region to the first operation configuration information of first object field.
In the present embodiment, the first operation configuration information refers to statistical condition set by first object field.Optionally,
First object field type is different, and the first corresponding operation configuration information is different.For example, if first object field is numeric type
Field, then the first operation configuration information can include but is not limited to value, summation, average, maximum value, minimum value, counting and
Non-repetition counting etc..
For example, as shown in Figure 1 C, it is pre- field age (students ' age) to be drawn to second at the first predeterminable area position
If after placing in the output field region in region, user can be by clicking field age (students ' age) position
Plus sige enters the operation set interface of field age (students ' age), then can be according to demand from optional operation configuration information
It is selected;And then current page can obtain the operation configuration information of user's selection, and using the operation configuration information as first
First operation configuration information of aiming field.
Optionally, same first object field can correspond at least one first operation configuration information;In first object field
In the case where multiple, different first object fields can correspond to the first identical or different operation configuration information.
S140, if detecting SQL statement generation event, the first of foundation first object field and first object field
Operation configuration information generates and saves SQL statement.
In the present embodiment, it is the triggered generation of function case on user's click current page that SQL statement, which generates event,
Event, for example, it may be user clicks caused by the save button on current page;It can also be and given birth to according to preset rules
At, user such as is being got after output field region is to the first operation configuration information of first object field, if pre-
If any operation that user acts on current page is not detected in duration, automatically generated etc..
Specifically, if detecting, SQL statement generates event, can pass through the server communication with carrying target data source
The fixed interface of connection, the first operation configuration information according to first object field and first object field is from target data source
Middle first object field obtains relevant SQL code section in the database, then format is generated according to SQL statement, to being obtained
The SQL code section splicing taken produces required SQL statement, and saves.
It can also be first object field and first object field based on communication mechanism or by other servers etc.
The first operation configuration information be sent to the server of carrying target data source so that it is according to first object field and first
First operation configuration information of aiming field first object field from target data source obtains relevant SQL in the database
Code segment then generates format according to SQL statement, produces required SQL statement to acquired SQL code section splicing,
And it saves.
Illustratively, the first operation configuration information according to first object field and first object field, generates and protects
Depositing SQL statement may include: by loading the local browser of current page for first object field and first object field
The first operation configuration information be sent to destination server so that destination server is according to first object field and first object
First operation configuration information of field generates and saves SQL statement.In the present embodiment, destination server is carrying target data source
Server.
Specifically, if detecting, SQL statement generates event, can be by loading the local browser of current page for the
First operation configuration information of one aiming field and first object field is sent to destination server so that destination server according to
According to the first operation configuration information of first object field and first object field from target data source first object field institute
Relevant SQL code section is obtained in the database, then generates format according to SQL statement, and acquired SQL code section is spliced
Required SQL statement is produced, and is saved, destination server can feed back saved SQL statement and SQL statement institute later
Corresponding operation result.
Technical solution provided in an embodiment of the present invention is shown in by the attribute information for the target data source for selecting user
First predeterminable area of current page, so that user can intuitively navigate to the field needed for oneself;Due to collecting in visual page
Cheng Youke pulls Component Gallery, therefore has the field in each database table can to pull attribute, and then may be in response to user and touched
The first of hair pulls instruction, by first object field from the second predeterminable area that the first predeterminable area is drawn to current page
In output field region, and user is obtained in output field region to the first operation configuration information of first object field;From
And when detecting that SQL statement generates event, confidence can be matched according to the first operation of first object field and first object field
Breath, SQL statement needed for generating and saving user.This programme, Database field support drag function, optimize visual page
Interactive experience between user;And the user of no data library professional knowledge background, it may be based on visual page and generate oneself
Required SQL statement provides a kind of easy new approaches for generating SQL statement for user.
Embodiment two
Fig. 2 is a kind of flow chart of method that SQL statement is generated based on visual page provided by Embodiment 2 of the present invention,
The present embodiment is on the basis of the above embodiment 1, further to optimize.Referring to fig. 2, this method can specifically include:
S210, obtains the target data source of user's selection, and the attribute information of target data source is shown in current page
The first predeterminable area, wherein attribute information includes the field in target data source in each database table.
S220 pulls in response to second and instructs, determines the second aiming field, and by the second aiming field from the first preset areas
Domain is drawn in the filter area in the second predeterminable area.
In the present embodiment, second to pull instruction be that the field in the first predeterminable area is dragged to the second predeterminable area by user
In filter area caused by.Corresponding, the second aiming field is user from the first predeterminable area to the second preset areas
The field that filter area in domain is pulled;Optionally, it can be determined according to drag operation of the user at the first predeterminable area
Second aiming field, and the number of the second aiming field is at least one, the relationship between each second aiming field can be for simultaneously
And relationship, or can be or relationship etc..Illustratively, in the case where the second aiming field is multiple, a drag operation
Multiple fields can be pulled simultaneously, can also once pull a field, and user can select according to actual needs.
Specifically, if detecting the filter that the field in the first predeterminable area is drawn in the second predeterminable area by user
What region was triggered second pulls instruction, then responds this and second pull instruction, using the field as the second aiming field, and by the
Two aiming fields are placed from the filter area being drawn in the second predeterminable area from the first predeterminable area position.
For example, as shown in Figure 1B, if detecting, field id (major key id) is drawn to second from the first predeterminable area by user
The second dragging instruction that filter area in predeterminable area is triggered then responds the second dragging instruction, and field id is (main
Key id) it is used as the second aiming field, and field id (major key id) is drawn to the second preset areas from the first predeterminable area position
It is placed in filter area in domain.
It, can also be in addition, it should be noted that, the second aiming field can be identical as first object field portions or whole
It is different.
S230 obtains user in filter area to the second operation configuration information of the second aiming field;Wherein, the second fortune
Calculating the operator in configuration information is to compare data set, and the calculation condition in the second operation configuration information is the second aiming field quilt
It is contained in another database.
In the present embodiment, the second operation configuration information refers to operation information set by the second aiming field, can wrap
Include operator and calculation condition.Wherein, operator is corresponding with field type, and the second aiming field type is different, corresponding
Operator is different.Optionally, the second aiming field type can be numeric type field, date type-word section or text-type field etc..
Wherein, numeric type field and the date supported operator of type-word section can be identical, be including but not limited to equal to, not etc., be greater than, be small
In, be equal to or more than, be less than or equal to, be empty, be not sky, range, compare data set etc.;The supported operation of text-type field
According with, which may include but be not limited to, is, is not, includes, not including, it is empty to be, it is empty not to be, to start and with end etc..Wherein, compare
Data set is a kind of operator that incidence relation can be established with other data sources, and the calculation condition supported may include second
Aiming field is contained in another database and the second aiming field is not contained in another database.Optionally, in operation
Condition can be in the case that the second aiming field be contained in another database, it can be achieved that inter-library generation SQL statement.
It is similar with the process of the first operation configuration information is obtained, user is obtained in filter area to the second aiming field
The process of second operation configuration information, which may is that, is being drawn to second at the first predeterminable area position for field id (major key id)
After placing in filter area in predeterminable area, user can pass through the plus sige of click field id (major key id) position
Into the operation set interface of field id (major key id), can then be selected from optional operation configuration information according to demand
Corresponding operator and select or input corresponding calculation condition;Optionally, user is when needing inter-library generation SQL statement,
The operator in the second operation configuration information of the second aiming field can be set as to compare data set, set calculation condition to
Second aiming field is contained in another database, as shown in Figure 1B.And then user is obtained acquired in current page in filter zone
Domain is to compare data set to the operator in the second operation configuration information of the second aiming field, in the second operation configuration information
Calculation condition is that the second aiming field is contained in another database.
It should be noted that in the case where the second aiming field is multiple, as long as there is the fortune of any second aiming field
Operator is to compare data set, and calculation condition is that the second aiming field is contained in another database, and inter-library generation SQL can be realized
Sentence.
S240 pulls in response to first and instructs, determines first object field, and by first object field from the first preset areas
Domain is drawn in the output field region in the second predeterminable area.
S250 obtains user in output field region to the first operation configuration information of first object field.
S260, if detecting, SQL statement generates event, according to first object field, the first operation configuration information, second
Aiming field and the second operation configuration information, generate and save inter-library SQL statement.
In the present embodiment, inter-library SQL statement refers to that SQL statement is generated based on sentence at least two databases.
Specifically, if detecting, SQL statement generates event, can be by loading the local browser of current page for the
One aiming field, the first operation configuration information, the second aiming field and the second operation configuration information are sent to destination server,
So that destination server according to first object field and first object field the first operation configuration information from target data source
Middle first object field obtains relevant SQL code section in the database, matches according to the second aiming field and the second operation
Confidence breath second aiming field from target data source obtains relevant SQL code section in the database, then according to SQL language
Sentence generates format, produces required inter-library SQL statement to acquired SQL code section splicing, and save, target takes later
Business device can feed back operation result corresponding to the inter-library SQL statement and inter-library SQL statement saved.
It should be noted that the relevant operation S220 and S230 of the second aiming field, with the phase to first object field
The execution sequence of operation S240 and S250 is closed without after successively, the present embodiment is with filter area and output field region the
Display order in two predeterminable areas provides a kind of preferred embodiment.
Technical solution provided in an embodiment of the present invention is shown in by the attribute information for the target data source for selecting user
First predeterminable area of current page, so that user can intuitively navigate to the field needed for oneself;Due to collecting in visual page
Cheng Youke pulls Component Gallery, therefore has the field in each database table can to pull attribute, and then can be respectively responsive to user
The dragging instruction triggered such as second pulls instruction and first and pulls instruction, and the second aiming field is pulled from the first predeterminable area
In filter area into the second predeterminable area, and first object field is drawn to current page from the first predeterminable area
The second predeterminable area in output field region in;And the of user in filter area to the second aiming field is obtained respectively
Two operation configuration informations, and to the first operation configuration information of first object field in output field region;To examine
It, can be according to first object field, the first operation configuration information, the second aiming field and the when measuring SQL statement and generating event
Two operation configuration informations, generate inter-library SQL statement.This programme, Database field support drag function, optimize visual page
Interactive experience between user;And the user of no data library professional knowledge background, it may be based on visual page and generate oneself
Required SQL statement provides a kind of easy new approaches for generating SQL statement for user.In addition, this programme provides for field
A variety of operators can support selection to compare data set, so that inter-library splicing be supported to generate SQL statement, splice for user and generate more
Possibility is provided for complicated SQL statement.
Embodiment three
Fig. 3 is a kind of flow chart for method that SQL statement is generated based on visual page that the embodiment of the present invention three provides,
On the basis of the above embodiments, if further pair detecting, SQL statement generates event to the present embodiment, according to first object word
First operation configuration information of section and first object field, generates and saves SQL statement and be explained.It, should referring to Fig. 3
Method can specifically include:
S310, obtains the target data source of user's selection, and the attribute information of target data source is shown in current page
The first predeterminable area, wherein attribute information includes the field in target data source in each database table.
S320 pulls in response to first and instructs, determines first object field, and by first object field from the first preset areas
Domain is drawn in the output field region in the second predeterminable area of current page.
S330 obtains user in output field region to the first operation configuration information of first object field.
S340, if detecting previewing events, the first operation according to first object field and first object field is matched
Confidence breath, generates SQL statement, and show operation result corresponding to SQL statement.
In the present embodiment, previewing events are the event for the triggered generation of function case that user clicks on current page, example
Such as, it can be caused by the preview button that user clicks on current page.
It, can be by loading the local browser of current page for first object specifically, if detecting previewing events
First operation configuration information of field and first object field is sent to destination server, so that destination server is according to first
First operation configuration information of aiming field and first object field data where first object field from target data source
Relevant SQL code section is obtained in library, then generates format according to SQL statement, and acquired SQL code section splicing can be given birth to
At required SQL statement, and feed back operation result corresponding to SQL statement.And then current page can be by loading current page
Local browser obtain the operation result of destination server feedback, and the operation result is showed in the form of new webpage
User, or be shown in current page in the form of floating window etc., so that user is by checking operation result, determine generated
Required for whether SQL statement is oneself.
S350 saves SQL statement if getting preservation event.
In the present embodiment, preservation event is the event for the triggered generation of function case that user clicks on current page, example
Such as, it can be caused by the save button that user clicks on current page.
Specifically, if can be clicked on current page required for user determines that SQL statement generated is oneself
Save button;If current page gets preservation event, can be taken by loading the local browser of current page to target
Business device sends SQL statement acquisition request, so that destination server feeds back the SQL statement generated and is stored in local.If user is true
Required for SQL statement generated is not oneself calmly, then closing case can be clicked;And then if current page gets closing
Event can then empty the second predeterminable area, so that user re-starts drag operation, to regenerate SQL statement.
Technical solution provided in an embodiment of the present invention will be according to first object word before saving SQL statement generated
Section and the first operation configuration information, the operation result of the SQL statement of generation show user, so that user is by checking operation
As a result, required for determining whether SQL statement generated is oneself;In the case where determination is that user needs, even obtain
To save event when, then save SQL statement.It, can be to avoid final institute by the way that SQL statement operation result is showed user in advance
Phenomenon required for the SQL non-user of preservation occurs, and further improves the experience of user.
Example IV
Fig. 4 A is a kind of process for method that SQL statement is generated based on visual page that the embodiment of the present invention four provides
Figure, the present embodiment on the basis of the above embodiments, provide one kind to filter area, input field in the second predeterminable area
The preferable example that region and output field region three are operated.A referring to fig. 4, this method can specifically include:
S401, if detecting data change event, display data source options interface.
S402, obtains the target data source of user's selection, and the attribute information of target data source is shown in current page
The first predeterminable area, wherein attribute information includes the field in target data source in each database table.
S403 pulls in response to second and instructs, determines the second aiming field, and by the second aiming field from the first preset areas
Domain is drawn in the filter area in the second predeterminable area.
S404 obtains user in filter area to the second operation configuration information of the second aiming field;Wherein, the second fortune
Calculating the operator in configuration information is to compare data set, and the calculation condition in the second operation configuration information is the second aiming field quilt
It is contained in another database.
S405 pulls in response to third and instructs, determines third aiming field, and by third aiming field from the first preset areas
Domain is drawn in the input field region in the second predeterminable area.
In the present embodiment, it is that the field in the first predeterminable area is dragged to the second predeterminable area by user that third, which pulls instruction,
In input field region caused by.Corresponding, third aiming field is that user is default from the first predeterminable area to second
The field that input field region in region is pulled;It optionally, can be according to drag operation of the user at the first predeterminable area
Determine third aiming field, and the number of third aiming field is at least one.It illustratively, is multiple in third aiming field
In the case where, one time drag operation can pull multiple fields simultaneously, can also once pull a field, and user can be according to practical need
It asks and is selected.
Specifically, if detecting the input word that the field in the first predeterminable area is drawn in the second predeterminable area by user
The third that section region is triggered pulls instruction, then responds the third and pull instruction, using the field as third aiming field, and will
Third aiming field is placed from the input field region being drawn in the second predeterminable area from the first predeterminable area position.
For example, as shown in Figure 4 B, if detecting, user drags field city (city where school) from the first predeterminable area
The third that the input field region dragged into the second predeterminable area is triggered pulls instruction, then responds the third and pull instruction, will
Field city (city where school) is used as third aiming field, and field city (city where school) is default from first
It is placed in the input field region being drawn at regional location in the second predeterminable area.
In addition, it should be noted that, third aiming field can be with first object field and/or first object field portions
Or it is all identical, it can also be different.
S406 obtains user in input field region to the third operation configuration information of third aiming field.
In the present embodiment, third operation configuration information refers to that operation set by third aiming field, may include must
Filling out a variety of options such as must fill out with non-.
It is similar with the process of the first operation configuration information is obtained, user is obtained in input field region to third aiming field
Third operation configuration information process may is that by field city (school where city) at the first predeterminable area position
It is drawn to after being placed in the input field region in the second predeterminable area, user can be by clicking field city (where school
City) plus sige of position enters the operation set interface of field city (school where city), and it then can be according to demand
It is selected from optional operation configuration information;And then current page can obtain the operation configuration information of user's selection, and will
Third operation configuration information of the operation configuration information as third aiming field, as shown in Figure 4 B.
S407 pulls in response to first and instructs, determines first object field, and by first object field from the first preset areas
Domain is drawn in the output field region in the second predeterminable area.
S408 obtains user in output field region to the first operation configuration information of first object field.
S409, if detecting previewing events, according to first object field, the first operation configuration information, the second aiming field,
Second operation configuration information, third aiming field and third operation configuration information, generate inter-library SQL statement, and show SQL language
Operation result corresponding to sentence.
S410 saves SQL statement if getting preservation event.
Optionally, it can also include: to pull instruction in response to the 4th before S409, determine the 4th aiming field, and will
4th aiming field is drawn in the grouping field region in the second predeterminable area from the first predeterminable area;User is obtained to be grouped
Fourth operation configuration information of the field area to the 4th aiming field.Other areas in its concrete implementation process and second area
Domain such as input field region Similarity Class, details are not described herein again.
It should be noted that the relevant operation S403 and S404 of the second aiming field, to the related of the second aiming field
Operate S405 and S406 and to the execution sequence between the relevant operation S407 of first object field and S408 three without first
After afterwards, display of the present embodiment with filter area, input field region and output field region in the second predeterminable area
Sequentially, a kind of preferred embodiment is provided.
Technical solution provided in an embodiment of the present invention optimizes visualization by making Database field support drag function
Interactive experience between the page and user;And the user of no data library professional knowledge background, it may be based on visual page generation
SQL statement needed for oneself provides a kind of easy new approaches for generating SQL statement for user.In addition, this programme mentions for field
A variety of operators have been supplied, selection can be supported to compare data set, so that inter-library splicing be supported to generate SQL statement, have spliced life for user
Possibility is provided at increasingly complex SQL statement.Moreover, can be kept away by the way that SQL statement operation result is showed user in advance
Exempt from the appearance of phenomenon required for the SQL non-user finally saved, further improves the experience of user.
Embodiment five
Fig. 5 is a kind of structural frames for device that SQL statement is generated based on visual page that the embodiment of the present invention five provides
Figure, the device can be performed the visual page provided by any embodiment of the invention that is based on and generate SQL statement method, have execution
The corresponding functional module of method and beneficial effect.Wherein, visual page is realized based on VUE frame, is integrated with table in VUE frame
Face end Component Gallery and Component Gallery can be pulled, as shown in figure 5, the apparatus may include:
Attribute information display module 510, for obtaining the target data source of user's selection, and by the attribute of target data source
Information is shown in the first predeterminable area of current page, wherein attribute information includes each database table in the target data source
In field;
Field pulls module 520, instructs for pulling in response to first, determines first object field, and by first object
Field is from the output field region in the second predeterminable area that the first predeterminable area is drawn to current page;
Configuration information obtains module 530, for obtaining first fortune of the user in output field region to first object field
Calculate configuration information;
Sentence generate preserving module 540, if for detect SQL statement generate event, according to first object field with
And the first operation configuration information of first object field, it generates and saves SQL statement.
Technical solution provided in an embodiment of the present invention is shown in by the attribute information for the target data source for selecting user
First predeterminable area of current page, so that user can intuitively navigate to the field needed for oneself;Due to collecting in visual page
Cheng Youke pulls Component Gallery, therefore has the field in each database table can to pull attribute, and then may be in response to user and touched
The first of hair pulls instruction, by first object field from the second predeterminable area that the first predeterminable area is drawn to current page
In output field region, and user is obtained in output field region to the first operation configuration information of first object field;From
And when detecting that SQL statement generates event, confidence can be matched according to the first operation of first object field and first object field
Breath, SQL statement needed for generating and saving user.This programme, Database field support drag function, optimize visual page
Interactive experience between user;And the user of no data library professional knowledge background, it may be based on visual page and generate oneself
Required SQL statement provides a kind of easy new approaches for generating SQL statement for user.
Illustratively, above-mentioned apparatus can also include:
Options interface display module, for obtain user selection target data source before, if detecting data variation
Event, then display data source options interface.
Illustratively, field pulls module 520 and can be also used for, if detecting that SQL statement generates event, according to the
First operation configuration information of one aiming field and first object field, before generating and saving SQL statement, in response to second
Instruction is pulled, determines the second aiming field, and the second aiming field is drawn in the second predeterminable area from the first predeterminable area
Filter area in;
Configuration information obtains module 530 and can be also used for, and obtains the of user in filter area to the second aiming field
Two operation configuration informations;Wherein, the operator in the second operation configuration information is to compare data set, in the second operation configuration information
Calculation condition be the second aiming field be contained in another database.
Illustratively, sentence generates preserving module 540 and specifically can be used for: matching according to first object field, the first operation
Confidence breath, the second aiming field and the second operation configuration information, generate and save inter-library SQL statement.
Illustratively, sentence generates preserving module 540 and specifically can be also used for: the local browsing by loading current page
First operation configuration information of first object field and first object field is sent to destination server by device, so that target takes
Business device generates according to the first operation configuration information of first object field and first object field and saves SQL statement.
Illustratively, sentence generates preserving module 540 and specifically can be also used for: if detecting previewing events, according to the
First operation configuration information of one aiming field and first object field generates SQL statement, and shows corresponding to SQL statement
Operation result;
If getting preservation event, SQL statement is saved.
Embodiment six
Fig. 6 is a kind of structural schematic diagram for server that the embodiment of the present invention six provides, and Fig. 6, which is shown, to be suitable for being used to realizing
The block diagram of the exemplary servers of embodiment of the embodiment of the present invention.The server that Fig. 6 is shown is only an example, should not be right
The function and use scope of the embodiment of the present invention bring any restrictions.
As shown in fig. 6, server 12 is showed in the form of universal computing device.The component of server 12 may include but not
Be limited to: one or more processor or processing unit 16, system storage 28 connect different system components (including system
Memory 28 and processing unit 16) bus 18.
Bus 18 indicates one of a few class bus structures or a variety of, including memory bus or Memory Controller,
Peripheral bus, graphics acceleration port, processor or the local bus using any bus structures in a variety of bus structures.It lifts
For example, these architectures include but is not limited to industry standard architecture (ISA) bus, microchannel architecture (MAC)
Bus, enhanced isa bus, Video Electronics Standards Association (VESA) local bus and peripheral component interconnection (PCI) bus.
Server 12 typically comprises a variety of computer system readable media.These media can be and any can be serviced
The usable medium that device 12 accesses, including volatile and non-volatile media, moveable and immovable medium.
System storage 28 may include the computer system readable media of form of volatile memory, such as arbitrary access
Memory (RAM) 30 and/or cache memory 32.Server 12 may further include other removable/nonremovable
, volatile/non-volatile computer system storage medium.Only as an example, storage system 34 can be used for reading and writing not removable
Dynamic, non-volatile magnetic media (Fig. 6 do not show, commonly referred to as " hard disk drive ").Although being not shown in Fig. 6, can provide
Disc driver for being read and write to removable non-volatile magnetic disk (such as " floppy disk "), and to removable anonvolatile optical disk
The CD drive of (such as CD-ROM, DVD-ROM or other optical mediums) read-write.In these cases, each driver can
To be connected by one or more data media interfaces with bus 18.System storage 28 may include that at least one program produces
Product, the program product have one group of (for example, at least one) program module, these program modules are configured to perform of the invention real
Apply the function of each embodiment of example.
Program/utility 40 with one group of (at least one) program module 42 can store and store in such as system
In device 28, such program module 42 includes but is not limited to operating system, one or more application program, other program modules
And program data, it may include the realization of network environment in each of these examples or certain combination.Program module 42
Usually execute the function and/or method in described embodiment of the embodiment of the present invention.
Server 12 can also be logical with one or more external equipments 14 (such as keyboard, sensing equipment, display 24 etc.)
Letter, can also be enabled a user to one or more equipment interact with the server 12 communicate, and/or with make the server
The 12 any equipment (such as network interface card, modem etc.) that can be communicated with one or more of the other calculating equipment communicate.
This communication can be carried out by input/output (I/O) interface 22.Also, server 12 can also pass through network adapter 20
With one or more network (such as local area network (LAN), wide area network (WAN) and/or public network, such as internet) communication.
As shown, network adapter 20 is communicated by bus 18 with other modules of server 12.It should be understood that although not showing in figure
Out, can in conjunction with server 12 use other hardware and/or software module, including but not limited to: microcode, device driver,
Redundant processing unit, external disk drive array, RAID system, tape drive and data backup storage system etc..
Processing unit 16 by the program that is stored in system storage 28 of operation, thereby executing various function application and
Data processing, such as realize the method that SQL statement is generated based on visual page provided by the embodiment of the present invention.
Embodiment seven
The embodiment of the present invention seven also provides a kind of computer readable storage medium, be stored thereon with computer program (or
For computer executable instructions), it is a kind of based on visual page generation SQL statement for executing when which is executed by processor
Method, wherein visual page is realized based on VUE frame, and desktop end Component Gallery is integrated in VUE frame and can pull component
Library, this method comprises:
The target data source of user's selection is obtained, and the attribute information of target data source is shown in the first of current page
Predeterminable area, wherein attribute information includes the field in target data source in each database table;
Instruction is pulled in response to first, determines first object field, and first object field is dragged from the first predeterminable area
It drags in the output field region into the second predeterminable area of current page;
User is obtained in output field region to the first operation configuration information of first object field;
If detecting the first operation that SQL statement generates event, according to first object field and first object field
Configuration information generates and saves SQL statement.
The computer storage medium of the embodiment of the present invention, can be using any of one or more computer-readable media
Combination.Computer-readable medium can be computer-readable signal media or computer readable storage medium.It is computer-readable
Storage medium for example may be-but not limited to-the system of electricity, magnetic, optical, electromagnetic, infrared ray or semiconductor, device or
Device, or any above combination.The more specific example (non exhaustive list) of computer readable storage medium includes: tool
There are electrical connection, the portable computer diskette, hard disk, random access memory (RAM), read-only memory of one or more conducting wires
(ROM), erasable programmable read only memory (EPROM or flash memory), optical fiber, portable compact disc read-only memory (CD-
ROM), light storage device, magnetic memory device or above-mentioned any appropriate combination.In this document, computer-readable storage
Medium can be any tangible medium for including or store program, which can be commanded execution system, device or device
Using or it is in connection.
Computer-readable signal media may include in a base band or as carrier wave a part propagate data-signal,
Wherein carry computer-readable program code.The data-signal of this propagation can take various forms, including but unlimited
In electromagnetic signal, optical signal or above-mentioned any appropriate combination.Computer-readable signal media can also be that computer can
Any computer-readable medium other than storage medium is read, which can send, propagates or transmit and be used for
By the use of instruction execution system, device or device or program in connection.
The program code for including on computer-readable medium can transmit with any suitable medium, including --- but it is unlimited
In wireless, electric wire, optical cable, RF etc. or above-mentioned any appropriate combination.
Can with one or more programming languages or combinations thereof come write for execute the embodiment of the present invention operation
Computer program code, described program design language include object oriented program language-such as Java,
Smalltalk, C++, further include conventional procedural programming language-such as " C " language or similar program design language
Speech.Program code can be executed fully on the user computer, partly be executed on the user computer, as an independence
Software package execute, part on the user computer part execute on the remote computer or completely in remote computer or
It is executed on server.In situations involving remote computers, remote computer can pass through the network of any kind --- packet
It includes local area network (LAN) or wide area network (WAN)-is connected to subscriber computer, or, it may be connected to outer computer (such as benefit
It is connected with ISP by internet).
Note that the above is only a better embodiment of the present invention and the applied technical principle.It will be appreciated by those skilled in the art that
The invention is not limited to the specific embodiments described herein, be able to carry out for a person skilled in the art it is various it is apparent variation,
It readjusts and substitutes without departing from protection scope of the present invention.Therefore, although being implemented by above embodiments to the present invention
Example is described in further detail, but the embodiment of the present invention is not limited only to above embodiments, is not departing from structure of the present invention
It can also include more other equivalent embodiments in the case where think of, and the scope of the present invention is determined by scope of the appended claims
It is fixed.
Claims (10)
1. a kind of method for generating SQL statement based on visual page, which is characterized in that the visual page is based on VUE frame
Frame is realized, desktop end Component Gallery is integrated in the VUE frame and can pull Component Gallery, which comprises
The target data source of user's selection is obtained, and the attribute information of the target data source is shown in the first of current page
Predeterminable area, wherein the attribute information includes the field in the target data source in each database table;
Instruction is pulled in response to first, determines first object field, and by the first object field from first preset areas
Domain is drawn in the output field region in the second predeterminable area of current page;
User is obtained in the output field region to the first operation configuration information of the first object field;
If detecting, SQL statement generates event, the first operation according to the first object field and first object field
Configuration information generates and saves SQL statement.
2. the method according to claim 1, wherein before obtaining the target data source that user selects, further includes:
If detecting data change event, display data source options interface.
3. the method according to claim 1, wherein if detecting, SQL statement generates event, according to described the
First operation configuration information of one aiming field and first object field, before generating and saving SQL statement, further includes:
Instruction is pulled in response to second, determines the second aiming field, and by second aiming field from first preset areas
Domain is drawn in the filter area in the second predeterminable area;
User is obtained in the filter area to the second operation configuration information of second aiming field;Wherein, described
Operator in two operation configuration informations is to compare data set, and the calculation condition in the second operation configuration information is the second mesh
Marking-up section is contained in another database.
4. according to the method described in claim 3, it is characterized in that, according to the first object field and first object field
The first operation configuration information, generate SQL statement, comprising:
It is raw according to the first object field, the first operation configuration information, the second aiming field and the second operation configuration information
At and save inter-library SQL statement.
5. the method according to claim 1, wherein according to the first object field and first object field
Operation configuration information, generate and save SQL statement, comprising:
By loading the local browser of current page for the first operation of the first object field and first object field
Configuration information is sent to destination server, so that the destination server is according to the first object field and first object word
First operation configuration information of section generates and saves SQL statement.
6. the method according to claim 1, wherein if detecting, SQL statement generates event, according to described the
The operation configuration information of one aiming field and first object field, generates and saves SQL statement, comprising:
If detecting previewing events, confidence is matched in the first operation according to the first object field and first object field
Breath generates SQL statement, and shows operation result corresponding to the SQL statement;
If getting preservation event, the SQL statement is saved.
7. a kind of device for generating SQL statement based on visual page, which is characterized in that the visual page is based on VUE frame
Frame is realized, desktop end Component Gallery is integrated in the VUE frame and can pull Component Gallery, described device includes:
Attribute information display module is believed for obtaining the target data source of user's selection, and by the attribute of the target data source
Breath is shown in the first predeterminable area of current page, wherein the attribute information includes each database in the target data source
Field in table;
Field pulls module, instructs for pulling in response to first, determines first object field, and by the first object field
From the output field region in the second predeterminable area that first predeterminable area is drawn to current page;
Configuration information obtains module, for obtaining first fortune of the user in the output field region to the first object field
Calculate configuration information;
Sentence generates preserving module, if for detecting that SQL statement generates event, according to the first object field and the
First operation configuration information of one aiming field, generates and saves SQL statement.
8. device according to claim 7, which is characterized in that further include:
Showing interface module, for if detecting data change event, opening up before the target data source for obtaining user's selection
Show data source options interface.
9. a kind of server characterized by comprising
One or more processors;
Memory, for storing one or more programs;
When one or more of programs are executed by one or more of processors, so that one or more of processors are real
Now such as the method for any of claims 1-6 for generating SQL statement based on visual page.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is by processor
It is realized when execution such as the method for any of claims 1-6 for generating SQL statement based on visual page.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910288930.4A CN109992589B (en) | 2019-04-11 | 2019-04-11 | Method, device, server and medium for generating SQL (structured query language) statements based on visual page |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910288930.4A CN109992589B (en) | 2019-04-11 | 2019-04-11 | Method, device, server and medium for generating SQL (structured query language) statements based on visual page |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109992589A true CN109992589A (en) | 2019-07-09 |
CN109992589B CN109992589B (en) | 2020-04-10 |
Family
ID=67133250
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910288930.4A Active CN109992589B (en) | 2019-04-11 | 2019-04-11 | Method, device, server and medium for generating SQL (structured query language) statements based on visual page |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109992589B (en) |
Cited By (36)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110377429A (en) * | 2019-07-24 | 2019-10-25 | 深圳乐信软件技术有限公司 | A kind of control method, device, server and storage medium that real-time task calculates |
CN110413675A (en) * | 2019-07-24 | 2019-11-05 | 深圳乐信软件技术有限公司 | A kind of control method, device, server and storage medium that real-time task calculates |
CN110825745A (en) * | 2019-10-31 | 2020-02-21 | 口碑(上海)信息技术有限公司 | Page generation method and device |
CN110941634A (en) * | 2019-11-27 | 2020-03-31 | 北京明略软件系统有限公司 | Data processing method and device, storage medium and electronic device |
CN110955478A (en) * | 2019-10-12 | 2020-04-03 | 平安医疗健康管理股份有限公司 | Partition dynamic display method, device and equipment of data and readable storage medium |
CN110955481A (en) * | 2019-11-27 | 2020-04-03 | 北京锐安科技有限公司 | Label task generation method and device, storage medium and electronic equipment |
CN111241123A (en) * | 2020-01-07 | 2020-06-05 | 深圳市华宇讯科技有限公司 | View data query method, device, server and storage medium |
CN111274263A (en) * | 2020-01-13 | 2020-06-12 | 平安国际智慧城市科技股份有限公司 | Visual database change statement generation method and device and storage medium |
CN111352628A (en) * | 2020-02-28 | 2020-06-30 | 深圳壹账通智能科技有限公司 | Front-end code generation method and device, computer system and readable storage medium |
CN111427626A (en) * | 2020-03-26 | 2020-07-17 | 山东浪潮通软信息科技有限公司 | Method and system for rapidly generating report based on dimensional data warehouse |
CN111694813A (en) * | 2020-05-08 | 2020-09-22 | 北京明略软件系统有限公司 | Data source management method and device |
CN111782629A (en) * | 2020-06-23 | 2020-10-16 | 京东数字科技控股有限公司 | Feature processing script generation method and device |
CN111967269A (en) * | 2020-08-13 | 2020-11-20 | 支付宝(杭州)信息技术有限公司 | Business risk identification method and device and electronic equipment |
CN111984177A (en) * | 2020-07-08 | 2020-11-24 | 福建亿能达信息技术股份有限公司 | Graph configuration method, device, equipment and medium based on vue |
CN112131248A (en) * | 2020-09-25 | 2020-12-25 | 北京锐安科技有限公司 | Data analysis method, device, equipment and storage medium |
CN112130841A (en) * | 2020-09-02 | 2020-12-25 | 广州市双照电子科技有限公司 | SQL development method and device and terminal equipment |
CN112463151A (en) * | 2020-11-03 | 2021-03-09 | 杭州讯酷科技有限公司 | Visual page construction method based on data source |
CN112685445A (en) * | 2020-12-29 | 2021-04-20 | 杭州旷云金智科技有限公司 | Data query method and device, storage medium and electronic equipment |
CN112861060A (en) * | 2021-03-23 | 2021-05-28 | 金岭教育科技(北京)有限公司 | Page creating method and device, computer equipment and storage medium |
CN112860725A (en) * | 2021-02-02 | 2021-05-28 | 浙江大华技术股份有限公司 | SQL automatic generation method and device, storage medium and electronic equipment |
CN113065326A (en) * | 2021-03-31 | 2021-07-02 | 北京达佳互联信息技术有限公司 | Text comparison method and device, electronic equipment and storage medium |
CN113220386A (en) * | 2021-04-06 | 2021-08-06 | 北京健康之家科技有限公司 | Instrument board publishing method and related equipment |
CN113220714A (en) * | 2021-05-29 | 2021-08-06 | 五八到家有限公司 | Configurable data query platform and method, electronic equipment and readable medium |
CN113535749A (en) * | 2020-04-17 | 2021-10-22 | 阿里巴巴集团控股有限公司 | Query statement generation method and device |
CN113590097A (en) * | 2021-07-30 | 2021-11-02 | 中电金信软件有限公司 | API interface generation method and device, electronic equipment and storage medium |
CN113722391A (en) * | 2021-07-09 | 2021-11-30 | 同盾科技有限公司 | Data visualization method and device |
CN113779037A (en) * | 2021-09-23 | 2021-12-10 | 上海淇玥信息技术有限公司 | Worksheet processing method and device and electronic equipment |
CN113821749A (en) * | 2021-09-30 | 2021-12-21 | 上海柯林布瑞信息技术有限公司 | Page generation method based on JS real-time analysis and computer |
CN114238724A (en) * | 2021-12-23 | 2022-03-25 | 中国建设银行股份有限公司 | Data visualization method and device |
CN114860737A (en) * | 2022-06-28 | 2022-08-05 | 北京世纪好未来教育科技有限公司 | Processing method, device, equipment and medium of teaching and research data |
CN114896264A (en) * | 2022-04-15 | 2022-08-12 | 中国航空工业集团公司沈阳飞机设计研究所 | Vue and dynamic SQL-based visualized information collection method and system |
CN115563149A (en) * | 2022-10-27 | 2023-01-03 | 中电金信软件有限公司 | Index calculation method and device, electronic equipment and storage medium |
CN115827644A (en) * | 2023-02-13 | 2023-03-21 | 明度智云(浙江)科技有限公司 | Report generation method, system and server based on visual view configuration |
CN116466932A (en) * | 2023-03-27 | 2023-07-21 | 飞算数智科技(深圳)有限公司 | Database statement generation method and device, storage medium and electronic equipment |
CN117235190A (en) * | 2023-09-05 | 2023-12-15 | 上海异工同智信息科技有限公司 | Data table generation method and device |
WO2024001493A1 (en) * | 2022-06-29 | 2024-01-04 | 京东方科技集团股份有限公司 | Visual data analysis method and device |
Citations (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6282539B1 (en) * | 1998-08-31 | 2001-08-28 | Anthony J. Luca | Method and system for database publishing |
US20020129039A1 (en) * | 2000-12-29 | 2002-09-12 | Majewski Edward Kennedy | Error usage investigation and disposal system |
CN105740333A (en) * | 2016-01-23 | 2016-07-06 | 北京掌阔移动传媒科技有限公司 | Visual advertisement management platform, and implementation method thereof |
CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
CN106855889A (en) * | 2016-12-29 | 2017-06-16 | 深圳市华傲数据技术有限公司 | The development approach and device of the extemporaneous query function of the tables of data of different data sources |
CN106909610A (en) * | 2017-01-10 | 2017-06-30 | 中电科华云信息技术有限公司 | Visualization based on browser pulls the method and system of inquiry data |
CN107145558A (en) * | 2017-05-02 | 2017-09-08 | 山东浪潮通软信息科技有限公司 | A kind of self-service visualization data analysing method based on data set |
CN107704608A (en) * | 2017-10-17 | 2018-02-16 | 北京览群智数据科技有限责任公司 | A kind of OLAP multidimensional analyses and data digging system |
CN108319687A (en) * | 2018-02-01 | 2018-07-24 | 中国农业银行股份有限公司 | A kind of SQL Rule Builders pulling technology based on JS |
CN108376176A (en) * | 2018-03-14 | 2018-08-07 | 深圳日彤大数据有限公司 | It can towed big data visualization analysis tools system |
CN108491470A (en) * | 2018-03-07 | 2018-09-04 | 北京奇安信科技有限公司 | For the management method, server-side and management method of search server |
CN109408540A (en) * | 2018-08-24 | 2019-03-01 | 周宁 | A kind of visualization SQL query system and method |
-
2019
- 2019-04-11 CN CN201910288930.4A patent/CN109992589B/en active Active
Patent Citations (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6282539B1 (en) * | 1998-08-31 | 2001-08-28 | Anthony J. Luca | Method and system for database publishing |
US20020129039A1 (en) * | 2000-12-29 | 2002-09-12 | Majewski Edward Kennedy | Error usage investigation and disposal system |
CN105740333A (en) * | 2016-01-23 | 2016-07-06 | 北京掌阔移动传媒科技有限公司 | Visual advertisement management platform, and implementation method thereof |
CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
CN106855889A (en) * | 2016-12-29 | 2017-06-16 | 深圳市华傲数据技术有限公司 | The development approach and device of the extemporaneous query function of the tables of data of different data sources |
CN106909610A (en) * | 2017-01-10 | 2017-06-30 | 中电科华云信息技术有限公司 | Visualization based on browser pulls the method and system of inquiry data |
CN107145558A (en) * | 2017-05-02 | 2017-09-08 | 山东浪潮通软信息科技有限公司 | A kind of self-service visualization data analysing method based on data set |
CN107704608A (en) * | 2017-10-17 | 2018-02-16 | 北京览群智数据科技有限责任公司 | A kind of OLAP multidimensional analyses and data digging system |
CN108319687A (en) * | 2018-02-01 | 2018-07-24 | 中国农业银行股份有限公司 | A kind of SQL Rule Builders pulling technology based on JS |
CN108491470A (en) * | 2018-03-07 | 2018-09-04 | 北京奇安信科技有限公司 | For the management method, server-side and management method of search server |
CN108376176A (en) * | 2018-03-14 | 2018-08-07 | 深圳日彤大数据有限公司 | It can towed big data visualization analysis tools system |
CN109408540A (en) * | 2018-08-24 | 2019-03-01 | 周宁 | A kind of visualization SQL query system and method |
Cited By (43)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110377429A (en) * | 2019-07-24 | 2019-10-25 | 深圳乐信软件技术有限公司 | A kind of control method, device, server and storage medium that real-time task calculates |
CN110413675A (en) * | 2019-07-24 | 2019-11-05 | 深圳乐信软件技术有限公司 | A kind of control method, device, server and storage medium that real-time task calculates |
CN110955478A (en) * | 2019-10-12 | 2020-04-03 | 平安医疗健康管理股份有限公司 | Partition dynamic display method, device and equipment of data and readable storage medium |
CN110825745A (en) * | 2019-10-31 | 2020-02-21 | 口碑(上海)信息技术有限公司 | Page generation method and device |
CN110941634A (en) * | 2019-11-27 | 2020-03-31 | 北京明略软件系统有限公司 | Data processing method and device, storage medium and electronic device |
CN110955481A (en) * | 2019-11-27 | 2020-04-03 | 北京锐安科技有限公司 | Label task generation method and device, storage medium and electronic equipment |
CN111241123A (en) * | 2020-01-07 | 2020-06-05 | 深圳市华宇讯科技有限公司 | View data query method, device, server and storage medium |
CN111274263A (en) * | 2020-01-13 | 2020-06-12 | 平安国际智慧城市科技股份有限公司 | Visual database change statement generation method and device and storage medium |
CN111352628A (en) * | 2020-02-28 | 2020-06-30 | 深圳壹账通智能科技有限公司 | Front-end code generation method and device, computer system and readable storage medium |
CN111427626A (en) * | 2020-03-26 | 2020-07-17 | 山东浪潮通软信息科技有限公司 | Method and system for rapidly generating report based on dimensional data warehouse |
CN111427626B (en) * | 2020-03-26 | 2023-07-25 | 浪潮通用软件有限公司 | Method and system for rapidly generating report based on dimension data warehouse |
CN113535749A (en) * | 2020-04-17 | 2021-10-22 | 阿里巴巴集团控股有限公司 | Query statement generation method and device |
CN111694813A (en) * | 2020-05-08 | 2020-09-22 | 北京明略软件系统有限公司 | Data source management method and device |
CN111782629A (en) * | 2020-06-23 | 2020-10-16 | 京东数字科技控股有限公司 | Feature processing script generation method and device |
CN111782629B (en) * | 2020-06-23 | 2024-05-17 | 京东科技控股股份有限公司 | Feature processing script generation method and device |
CN111984177A (en) * | 2020-07-08 | 2020-11-24 | 福建亿能达信息技术股份有限公司 | Graph configuration method, device, equipment and medium based on vue |
CN111967269A (en) * | 2020-08-13 | 2020-11-20 | 支付宝(杭州)信息技术有限公司 | Business risk identification method and device and electronic equipment |
CN111967269B (en) * | 2020-08-13 | 2024-04-26 | 支付宝(杭州)信息技术有限公司 | Business risk identification method and device and electronic equipment |
CN112130841A (en) * | 2020-09-02 | 2020-12-25 | 广州市双照电子科技有限公司 | SQL development method and device and terminal equipment |
CN112131248B (en) * | 2020-09-25 | 2024-05-10 | 北京锐安科技有限公司 | Data analysis method, device, equipment and storage medium |
CN112131248A (en) * | 2020-09-25 | 2020-12-25 | 北京锐安科技有限公司 | Data analysis method, device, equipment and storage medium |
CN112463151A (en) * | 2020-11-03 | 2021-03-09 | 杭州讯酷科技有限公司 | Visual page construction method based on data source |
CN112463151B (en) * | 2020-11-03 | 2024-02-06 | 杭州讯酷科技有限公司 | Visual page construction method based on data source |
CN112685445A (en) * | 2020-12-29 | 2021-04-20 | 杭州旷云金智科技有限公司 | Data query method and device, storage medium and electronic equipment |
CN112860725A (en) * | 2021-02-02 | 2021-05-28 | 浙江大华技术股份有限公司 | SQL automatic generation method and device, storage medium and electronic equipment |
CN112861060A (en) * | 2021-03-23 | 2021-05-28 | 金岭教育科技(北京)有限公司 | Page creating method and device, computer equipment and storage medium |
CN113065326A (en) * | 2021-03-31 | 2021-07-02 | 北京达佳互联信息技术有限公司 | Text comparison method and device, electronic equipment and storage medium |
CN113220386A (en) * | 2021-04-06 | 2021-08-06 | 北京健康之家科技有限公司 | Instrument board publishing method and related equipment |
CN113220714A (en) * | 2021-05-29 | 2021-08-06 | 五八到家有限公司 | Configurable data query platform and method, electronic equipment and readable medium |
CN113722391A (en) * | 2021-07-09 | 2021-11-30 | 同盾科技有限公司 | Data visualization method and device |
CN113590097B (en) * | 2021-07-30 | 2022-11-29 | 中电金信软件有限公司 | API interface generation method and device, electronic equipment and storage medium |
CN113590097A (en) * | 2021-07-30 | 2021-11-02 | 中电金信软件有限公司 | API interface generation method and device, electronic equipment and storage medium |
CN113779037A (en) * | 2021-09-23 | 2021-12-10 | 上海淇玥信息技术有限公司 | Worksheet processing method and device and electronic equipment |
CN113821749A (en) * | 2021-09-30 | 2021-12-21 | 上海柯林布瑞信息技术有限公司 | Page generation method based on JS real-time analysis and computer |
CN113821749B (en) * | 2021-09-30 | 2023-09-01 | 上海柯林布瑞信息技术有限公司 | Page generation method and computer based on JS real-time analysis |
CN114238724A (en) * | 2021-12-23 | 2022-03-25 | 中国建设银行股份有限公司 | Data visualization method and device |
CN114896264A (en) * | 2022-04-15 | 2022-08-12 | 中国航空工业集团公司沈阳飞机设计研究所 | Vue and dynamic SQL-based visualized information collection method and system |
CN114860737A (en) * | 2022-06-28 | 2022-08-05 | 北京世纪好未来教育科技有限公司 | Processing method, device, equipment and medium of teaching and research data |
WO2024001493A1 (en) * | 2022-06-29 | 2024-01-04 | 京东方科技集团股份有限公司 | Visual data analysis method and device |
CN115563149A (en) * | 2022-10-27 | 2023-01-03 | 中电金信软件有限公司 | Index calculation method and device, electronic equipment and storage medium |
CN115827644A (en) * | 2023-02-13 | 2023-03-21 | 明度智云(浙江)科技有限公司 | Report generation method, system and server based on visual view configuration |
CN116466932A (en) * | 2023-03-27 | 2023-07-21 | 飞算数智科技(深圳)有限公司 | Database statement generation method and device, storage medium and electronic equipment |
CN117235190A (en) * | 2023-09-05 | 2023-12-15 | 上海异工同智信息科技有限公司 | Data table generation method and device |
Also Published As
Publication number | Publication date |
---|---|
CN109992589B (en) | 2020-04-10 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109992589A (en) | Method, apparatus, server and the medium of SQL statement are generated based on visual page | |
CN110008232A (en) | Generation method, device, server and the medium of structured query sentence | |
US20230385033A1 (en) | Storing logical units of program code generated using a dynamic programming notebook user interface | |
US8418257B2 (en) | Collection user interface | |
US11049525B2 (en) | Transcript-based insertion of secondary video content into primary video content | |
US9529842B2 (en) | Dynamically creating queries to find related records in a database | |
US10635855B1 (en) | Code comment markup | |
CN110032700B (en) | Information release control method and device, storage medium and electronic equipment | |
CN109739855A (en) | Realize the method and system of tables of data splicing and automatic training machine learning model | |
CN107368568A (en) | Method, device, equipment and storage medium for generating notes | |
US8584001B2 (en) | Managing bookmarks in applications | |
CN114416667A (en) | Method and device for rapidly sharing network disk file, network disk and storage medium | |
CN112214155B (en) | View information playing method, device, equipment and storage medium | |
US20140380158A1 (en) | Displaying tooltips to users of touch screens | |
US10169054B2 (en) | Undo and redo of content specific operations | |
US8381187B2 (en) | Graphical user interface for job output retrieval based on errors | |
US20140298243A1 (en) | Adjustable gui for displaying information from a database | |
US20150143243A1 (en) | Hierarchical presentation editor | |
US9547491B2 (en) | Automatic comment creation for computer files | |
WO2018103223A1 (en) | Method and device for operating database | |
US11768573B2 (en) | Graphical user interface marking feedback | |
JPH07282079A (en) | Linkage displaying method | |
US11194843B2 (en) | Methods and systems for visual management of relational data | |
CN113126863A (en) | Object selection implementation method and device, storage medium and electronic equipment | |
US11450043B2 (en) | Element association and modification |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210525 Address after: No.1, 14th floor, unit 1, building 1, No.38, Sanse Road, Jinjiang Industrial Park, Chengdu, Sichuan 610011 Patentee after: Sichuan Qidi Shuan blockchain Technology Development Co.,Ltd. Address before: 100084 a1201f, 12 / F, building 8, yard 1, Zhongguancun East Road, Haidian District, Beijing Patentee before: Beijing Qidi Block Chain Technology Development Co.,Ltd. |
|
TR01 | Transfer of patent right |