CN109992589B - Method, device, server and medium for generating SQL (structured query language) statements based on visual page - Google Patents
Method, device, server and medium for generating SQL (structured query language) statements based on visual page Download PDFInfo
- Publication number
- CN109992589B CN109992589B CN201910288930.4A CN201910288930A CN109992589B CN 109992589 B CN109992589 B CN 109992589B CN 201910288930 A CN201910288930 A CN 201910288930A CN 109992589 B CN109992589 B CN 109992589B
- Authority
- CN
- China
- Prior art keywords
- field
- target
- configuration information
- target field
- user
- 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.)
- Active
Links
Images
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 method, a device, a server and a medium for generating SQL statements based on visual pages. The visualization page is realized based on a VUE (virtual environment) framework, and a desktop end component library and a draggable component library are integrated in the VUE framework; the method comprises the following steps: acquiring a target data source selected by a user, and displaying attribute information of the target data source in a first preset area of a current page, wherein the attribute information comprises fields in each database table in the target data source; in response to the dragging instruction, determining a target field, and dragging the target field from the first preset area to an output field area in a second preset area of the current page; acquiring operation configuration information of a user on a target field in an output field area; and if the SQL sentence generation event is detected, generating and storing the SQL sentence according to the target field and the operation configuration information of the target field. The technical scheme of the embodiment of the invention provides a new idea for simply and conveniently generating the SQL statement for the user.
Description
Technical Field
The embodiment of the invention relates to the technical field of computers, in particular to a method, a device, a server and a storage medium for generating SQL statements based on visual pages.
Background
With the development of computers and databases in recent years, a computer programming language dedicated to a database, SQL (structured Query language), is widely used, and becomes the most important and most common relational database operation language.
However, in the current method for generating the SQL statement, the SQL statement is generated by writing at the back end by a user with related professional knowledge such as a database. The method has higher requirement on the background knowledge of a user writing the SQL sentence, and common users without professional knowledge background cannot generate the SQL sentence required by the common users. In addition, at present, there are a few methods for generating SQL statements based on a visualization page, but the visualization page is not friendly, and a user can only set the SQL statements by clicking and selecting the SQL statements. Therefore, it is necessary to provide a new SQL statement generation method.
Disclosure of Invention
The embodiment of the invention provides a method, a device, a server and a medium for generating SQL sentences based on a visual page, which optimize the interactive experience between the visual page and a user, enable the user without the professional knowledge background of a database to generate the SQL sentences required by the user based on the visual page, and provide a new thought for the user to generate the SQL sentences simply and conveniently.
In a first aspect, an embodiment of the present invention provides a method for generating an SQL statement based on a visual page, where the visual page is implemented based on a VUE framework, and the VUE framework is integrated with a desktop component library and a draggable component library, and the method includes:
acquiring a target data source selected by a user, and displaying attribute information of the target data source in a first preset area of a current page, wherein the attribute information comprises fields in database tables in the target data source;
responding to a first dragging instruction, determining a first target field, and dragging the first target field from the first preset area to an output field area in a second preset area of the current page;
acquiring first operation configuration information of a user on the first target field in the output field area;
and if the SQL statement generating event is detected, generating and storing the SQL statement according to the first target field and the first operation configuration information of the first target field.
In a second aspect, an embodiment of the present invention provides an apparatus for generating an SQL statement based on a visualized page, where the visualized page is implemented based on a VUE framework, and a desktop end component library and a draggable component library are integrated in the VUE framework, and the apparatus includes:
the attribute information display module is used for acquiring a target data source selected by a user and displaying attribute information of the target data source in a first preset area of a current page, wherein the attribute information comprises fields in database tables in the target data source;
the field dragging module is used for responding to a first dragging instruction, determining a first target field, and dragging the first target field from the first preset area to an output field area in a second preset area of the current page;
the configuration information acquisition module is used for acquiring first operation configuration information of the user on the first target field in the output field area;
and the statement generation and storage module is used for generating and storing the SQL statement according to the first target field and the first operation configuration information of the first target field if the SQL statement generation event is detected.
In a third aspect, an embodiment of the present invention further provides a server, where the server includes:
one or more processors;
storage means for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement any of the methods for generating SQL statements based on visualization pages of the first aspect.
In a fourth aspect, an embodiment of the present invention further provides a medium, on which a computer program is stored, where the computer program, when executed by a processor, implements any of the methods for generating an SQL statement based on a visualization page in the first aspect.
According to the method, the device, the server and the medium for generating the SQL statement based on the visual page, provided by the embodiment of the invention, the attribute information of the target data source selected by the user is displayed in the first preset area of the current page, so that the user can intuitively position the required field; the method comprises the steps that as a draggable component library is integrated in a visual page, fields in each database table have draggable attributes, and further a first dragging instruction triggered by a user can be responded, a first target field is dragged from a first preset area to an output field area in a second preset area of a current page, and first operation configuration information of the user on the first target field in the output field area is obtained; therefore, when the SQL statement generating event is detected, the SQL statement required by the user can be generated and stored according to the first target field and the first operation configuration information of the first target field. According to the scheme, the database field supports a dragging function, and interaction experience between a visual page and a user is optimized; and the user without the background of the professional knowledge of the database can also generate the SQL sentences required by the user based on the visual page, thereby providing a new idea for simply and conveniently generating the SQL sentences for the user.
Drawings
Fig. 1A is a flowchart of a method for generating an SQL statement based on a visualized page according to an embodiment of the present invention;
fig. 1B is a schematic view of a visualization page according to an embodiment of the present invention;
fig. 1C is a schematic diagram of an output field area setting interface according to an embodiment of the present invention;
fig. 2 is a flowchart of a method for generating an SQL statement based on a visualized page according to a second embodiment of the present invention;
fig. 3 is a flowchart of a method for generating an SQL statement based on a visualized page according to a third embodiment of the present invention;
fig. 4A is a flowchart of a method for generating an SQL statement based on a visualized page according to a fourth embodiment of the present invention;
fig. 4B is a schematic diagram of an input field area setting interface according to a fourth embodiment of the present invention;
fig. 5 is a structural block diagram of an apparatus for generating an SQL statement based on a visualized page according to a fifth embodiment of the present invention;
fig. 6 is a schematic structural diagram of a server according to a sixth embodiment of the present invention.
Detailed Description
The embodiments of the present invention will be described in further detail with reference to the drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the embodiments of the invention and that no limitation of the invention is intended. It should be further noted that, for convenience of description, only some structures, not all structures, relating to the embodiments of the present invention are shown in the drawings.
Before describing the embodiments of the present invention, an application scenario of the embodiments of the present invention is described. The visualization page in the embodiment of the invention is realized based on a VUE framework, wherein the VUE is a set of progressive framework for constructing a user interface, which is not only easy to operate, but also convenient to integrate with a third party library or an existing project. Furthermore, when used in conjunction with modern tool chains and various supporting class libraries, VUEs are also fully capable of providing drive for complex single-page applications. Therefore, the visualization page developed based on the VUE framework can enable users without a database professional knowledge background to generate the SQL sentences required by the users through the visualization page. Optionally, a desktop-end component library and a draggable component library are integrated into the VUE framework. The desktop component library, namely the ElementUI, is a UI component library based on the VUE, and can help a developer to quickly construct a page; the dragable component library is a functional library which is designed based on VUE and can enable fields in a database table in a page to support dragging. Furthermore, database table fields in the visual page developed based on the VUE framework in the embodiment of the invention have draggable attributes, and the problem that the visual page in the prior art is unfriendly and can only be set by a user in a clicking and selecting mode is solved. The technical scheme of the embodiment of the invention is introduced based on the above.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures. Meanwhile, in the description of the present invention, the terms "first", "second", and the like are used only for distinguishing the description, and are not to be construed as indicating or implying relative importance, order, or the like.
Example one
Fig. 1A is a flowchart of a method for generating an SQL statement based on a visualized page according to an embodiment of the present invention, which is applicable to a case of generating an SQL statement, and is particularly applicable to how to simplify a complex process of generating an SQL statement, so that a user without a database professional knowledge background can also generate a scene of the SQL statement required by the user. In this embodiment, the visualization page is implemented based on a VUE framework, and a desktop-side component library and a draggable component library are integrated in the VUE framework. The method can be executed by the apparatus for generating SQL statements based on visual pages provided by the embodiment of the present invention, and the apparatus can be implemented in a hardware and/or software manner, and the apparatus can be integrated in a server (the server is configured with a VUE framework system). Referring to fig. 1A, the method may specifically include:
s110, acquiring a target data source selected by a user, and displaying attribute information of the target data source in a first preset area of a current page, wherein the attribute information comprises fields in each database table in the target data source.
In this embodiment, the user may be a general user without a background of professional knowledge of the database, or may be a developer. A data source refers to a device or raw media used to provide some desired data. Optionally, a plurality of databases may be provided in one data source, each database including a table, and the table including fields. Correspondingly, the target data source refers to any data source selected by the user from a plurality of selectable data sources according to the requirement of the user. The attribute information of the target data source may include names of all databases set in the target data source, names of tables in each database, and fields in each table. The field may include a field name, and may further include a field tag and the like; the field tag is an annotation of the field for further interpretation of the field to facilitate the user's quick identification and location of the desired field location.
The current page is a visual page and is an interactive interface for the user to generate the SQL statement required by the user. The first preset area refers to an area which is preset and used for displaying the attribute information of the target data source on the current page. Optionally, the first preset area may be located on the left side of the current page, and the attribute information of the target data source may be displayed on the left side of the current page in a tree structure. For example, as shown in fig. 1B, the attribute information of the target data source may include a database name api _ test, a table name school _ info, and fields under the table school _ info, such as id (primary key id), sh _ name (school name), and the like; wherein id is field name, and primary key id is field label; the attribute information of the target data source is displayed on the left side of the current page in a tree structure. Optionally, the size of the first preset area may be dynamically adjusted according to an actual display condition; in the case of a large number of databases, in order to facilitate the user to quickly locate a required field under the database, an input box may be further disposed in the first preset area, for the user to input a field name, as shown in fig. 1B.
In this embodiment, a user may load a current page through a local browser, and then may perform a related operation of generating an SQL statement on the current page. Specifically, a user can select a data source required by the user from a data source option pull-down list of a current page, and then the current page can acquire the data source selected by the user and take the data source as a target data source; then, the attribute information of the target data source can be displayed in a first preset area of the current page, such as the left side of the current page.
For example, to facilitate a user to select a data source more intuitively, a trigger button, or other trigger mechanism, may be provided in the current page. Furthermore, if the current page detects that the user clicks a certain function key or inputs certain data and the like on the current page, a data source option interface can be displayed for the user to select visually, and then the data source selected by the user can be used as a target data source; then, the attribute information of the target data source can be displayed in a first preset area of the current page, such as the left side of the current page.
For example, before obtaining the target data source selected by the user, the method may further include: and if the data change event is detected, displaying a data source option interface. The data change event refers to an event triggered by clicking or inputting a certain data on the current page by a user. The data source option interface comprises a plurality of selectable data sources.
S120, responding to the first dragging instruction, determining a first target field, and dragging the first target field from the first preset area to an output field area in a second preset area of the current page.
In this embodiment, as the draggable component library is integrated in the VUE frame of the current page, the database table field in the current page has a draggable attribute. The dragging instruction is generated by dragging the field in the first preset area to the second preset area by the user. The second preset area refers to a preset draggable placement area of a field in the current page; optionally, the second preset area may be located on the right side of the current page, and the first preset area is connected to each other and may be functionally divided into a filter area, an input field area, an output field area, and a grouping field area, which are draggable and placed areas, as shown in fig. 1B (exemplarily, the filter area, the input field area, and the output field area, and the grouping field area in the second preset area are shown). The filter area is an area which can be used for setting a screening function for the field, the grouping field area is an area which is used for setting a grouping function for the field, and the output field area can be used for setting a statistical condition of the output field. In addition, it should be noted that, a user may drag a field in the first preset region to any of the four regions for placement according to actual requirements, but in combination with the SQL statement generation feature, the filter region, the input field region, and the grouping field region do not have to place the dragged field, that is, the filter region, the input field region, and the grouping field region may be empty, and the output field region has to have related information of the field and the field. For example, the second preset area may further include a blank editable area, and the user may also add content required by the user to the current page according to an actual situation to generate a visual page of the user.
Correspondingly, the first dragging instruction is generated by dragging the field in the first preset area to the output field area in the second preset area by the user. The first target field is a field dragged by a user from the first preset area to an output field area in the second preset area; optionally, the first target field may be determined according to a drag operation of the user at the first preset region, and the number of the first target field is at least one. For example, when a plurality of first target fields are provided, a plurality of fields may be dragged at the same time by one drag operation, or one field may be dragged at a time, and a user may select a field according to actual needs.
Specifically, if a first dragging instruction triggered by a user dragging a field in a first preset area to an output field area in a second preset area is detected, the first dragging instruction is responded, the field is used as a first target field, and the first target field is dragged from the position of the first preset area to the output field area in the second preset area to be placed.
For example, as shown in fig. 1C, if a first dragging instruction triggered by the user dragging the field age (student age) from the first preset area to the output field area in the second preset area is detected, in response to the first dragging instruction, the field age (student age) is used as a first target field, and the field age (student age) is dragged from the position of the first preset area to the position of the output field area in the second preset area and placed.
S130, acquiring first operation configuration information of the user on the first target field in the output field area.
In this embodiment, the first operation configuration information refers to a statistical condition set for the first target field. Optionally, the types of the first target fields are different, and the corresponding first operation configuration information is different. For example, if the first target field is a numeric field, the first operation configuration information may include, but is not limited to, a value, a sum, an average, a maximum, a minimum, a count, a deduplication, and the like.
For example, as shown in fig. 1C, after the field age (student age) is dragged from the first preset area to the output field area in the second preset area and placed therein, the user may enter the operation setting interface of the field age (student age) by clicking the plus sign at the position of the field age (student age), and then may select from the optional operation configuration information according to the requirement; and then the current page can acquire the operation configuration information selected by the user, and the operation configuration information is used as the first operation configuration information of the first target field.
Optionally, the same first target field may correspond to at least one first operation configuration information; in the case that the first target field is multiple, different first target fields may correspond to the same or different first operation configuration information.
S140, if the SQL statement generating event is detected, generating and storing the SQL statement according to the first target field and the first operation configuration information of the first target field.
In this embodiment, the SQL statement generating event is an event triggered by a user clicking a function case on a current page, for example, the SQL statement generating event may be generated by a user clicking a save button on a current page; the first operation configuration information of the user on the first target field in the output field area may also be generated according to a preset rule, for example, after the first operation configuration information of the user on the first target field is acquired, if any operation of the user on the current page is not detected within a preset time period, the operation may be automatically generated.
Specifically, if the SQL statement generation event is detected, the related SQL code segment may be obtained from the database where the first target field in the target data source is located according to the first target field and the first operational configuration information of the first target field through a fixed interface in communication connection with the server bearing the target data source, and then the obtained SQL code segment may be spliced according to the SQL statement generation format to generate the required SQL statement and stored.
The method can also be based on a communication mechanism or send the first target field and the first operational configuration information of the first target field to a server bearing a target data source through other servers and the like, so that the server obtains a related SQL code segment from a database where the first target field is located in the target data source according to the first operational configuration information of the first target field and the first target field, and then splices the obtained SQL code segments according to an SQL statement generation format to generate the needed SQL statement and store the SQL statement.
For example, generating and saving the SQL statement according to the first target field and the first operation configuration information of the first target field may include: and sending the first target field and the first operation configuration information of the first target field to a target server through a local browser loading the current page, so that the target server generates and stores the SQL statement according to the first target field and the first operation configuration information of the first target field. In this embodiment, the target server is a server that carries a target data source.
Specifically, if the SQL statement generation event is detected, the local browser loading the current page can send the first target field and the first operational configuration information of the first target field to the target server, so that the target server can obtain the related SQL code segment from the database where the first target field is located in the target data source according to the first target field and the first operational configuration information of the first target field, then splice the obtained SQL code segments according to the SQL statement generation format to generate the required SQL statement, and store the SQL statement, and then the target server can feed back the stored SQL statement and the operation result corresponding to the SQL statement.
According to the technical scheme provided by the embodiment of the invention, the attribute information of the target data source selected by the user is displayed in the first preset area of the current page, so that the user can intuitively position the required field; the method comprises the steps that as a draggable component library is integrated in a visual page, fields in each database table have draggable attributes, and further a first dragging instruction triggered by a user can be responded, a first target field is dragged from a first preset area to an output field area in a second preset area of a current page, and first operation configuration information of the user on the first target field in the output field area is obtained; therefore, when the SQL statement generating event is detected, the SQL statement required by the user can be generated and stored according to the first target field and the first operation configuration information of the first target field. According to the scheme, the database field supports a dragging function, and interaction experience between a visual page and a user is optimized; and the user without the background of the professional knowledge of the database can also generate the SQL sentences required by the user based on the visual page, thereby providing a new idea for simply and conveniently generating the SQL sentences for the user.
Example two
Fig. 2 is a flowchart of a method for generating an SQL statement based on a visualized page according to a second embodiment of the present invention, and this embodiment is further optimized based on the first embodiment. Referring to fig. 2, the method may specifically include:
s210, acquiring a target data source selected by a user, and displaying attribute information of the target data source in a first preset area of a current page, wherein the attribute information comprises fields in each database table in the target data source.
S220, responding to the second dragging instruction, determining a second target field, and dragging the second target field from the first preset area to a filter area in the second preset area.
In this embodiment, the second dragging instruction is generated by dragging, by the user, the field in the first preset area to the filter area in the second preset area. Correspondingly, the second target field is a field dragged by the user from the first preset area to the filter area in the second preset area; optionally, the second target fields may be determined according to a drag operation of the user at the first preset region, the number of the second target fields is at least one, and the relationship between the second target fields may be a union relationship, or may be an union relationship, or the like. For example, when a plurality of second target fields are provided, a plurality of fields may be dragged at the same time by one drag operation, or one field may be dragged at a time, and a user may select a field according to actual needs.
Specifically, if a second dragging instruction triggered by the fact that the user drags the field in the first preset area to the filter area in the second preset area is detected, the second dragging instruction is responded, the field is used as a second target field, and the second target field is dragged from the position of the first preset area to the position of the filter area in the second preset area to be placed.
For example, as shown in fig. 1B, if a second drag instruction triggered by the user dragging the field id (primary key id) from the first preset area to the filter area in the second preset area is detected, in response to the second drag instruction, the field id (primary key id) is used as a second target field, and the field id (primary key id) is dragged from the first preset area position to the filter area in the second preset area and placed.
In addition, the second object field may be partially or completely the same as the first object field, or may be different from the first object field.
S230, acquiring second operation configuration information of the user on a second target field in the filter area; wherein the operator in the second operation configuration information is the comparison data set, and the operation condition in the second operation configuration information is that the second target field is contained in another database.
In this embodiment, the second operation configuration information refers to operation information set for the second target field, and may include an operator and an operation condition. The operator corresponds to the field type, the second target field type is different, and the corresponding operators are different. Alternatively, the second target field type may be a numeric type field, a date type field, or a text type field, etc. Wherein, operators supportable by the numeric field and the date field can be the same, including but not limited to equal, unequal, greater than, less than, equal to or greater than, less than or equal to, empty, not empty, range, comparison data set, etc.; operators that may be supported by a text-type field may include, but are not limited to, yes, no, contain, no, null, no null, begin, end, and the like. Wherein, comparing the data set is an operator that can establish an association relationship with other data sources, and the supported operation conditions can include that the second target field is contained in another database and the second target field is not contained in another database. Alternatively, in the case that the operation condition may be that the second target field is included in another database, cross-library generation of the SQL statement may be implemented.
Similar to the process of acquiring the first operation configuration information, the process of acquiring the second operation configuration information of the user on the second target field in the filter area may be: after the field id (main key id) is dragged from the position of the first preset area to the filter area in the second preset area to be placed, a user can enter an operation setting interface of the field id (main key id) by clicking a plus sign at the position of the field id (main key id), and then can select a corresponding operator and select or input a corresponding operation condition from optional operation configuration information according to requirements; optionally, when the user needs to generate the SQL statement across the databases, the operator in the second operation configuration information of the second target field may be set as the comparison data set, and the operation condition is set as that the second target field is included in another database, as shown in fig. 1B. And then the operator in the second operation configuration information of the user on the second target field in the filter area obtained by the current page is a comparison data set, and the operation condition in the second operation configuration information is that the second target field is contained in another database.
It should be noted that, when there are a plurality of second target fields, as long as any operator of the second target fields is the comparison data set, and the operation condition is that the second target fields are included in another database, the cross-library generation of the SQL statement can be realized.
S240, responding to the first dragging instruction, determining a first target field, and dragging the first target field from the first preset area to an output field area in the second preset area.
S250, acquiring first operation configuration information of the user on the first target field in the output field area.
And S260, if the SQL statement generating event is detected, generating and storing a cross-library SQL statement according to the first target field, the first operation configuration information, the second target field and the second operation configuration information.
In this embodiment, the cross-library SQL statement means that the SQL statement is generated based on statements in at least two databases.
Specifically, if the SQL statement generation event is detected, the first target field, the first operation configuration information, the second target field, and the second operation configuration information may be sent to the target server through the local browser loading the current page, so that the target server obtains the related SQL code segment from the database where the first target field in the target data source is located according to the first target field and the first operation configuration information of the first target field, obtains the related SQL code segment from the database where the second target field in the target data source is located according to the second target field and the second operation configuration information, and then generates the format according to the SQL statement, and splicing the obtained SQL code segments to generate the required cross-library SQL sentences, storing the cross-library SQL sentences, and feeding back the stored cross-library SQL sentences and the operation results corresponding to the cross-library SQL sentences by the target server.
It should be noted that, after the execution sequence of the correlation operations S220 and S230 on the second target field is not consecutive to the execution sequence of the correlation operations S240 and S250 on the first target field, the present embodiment provides a preferred example in the display sequence of the filter area and the output field area in the second preset area.
According to the technical scheme provided by the embodiment of the invention, the attribute information of the target data source selected by the user is displayed in the first preset area of the current page, so that the user can intuitively position the required field; as the visual page is integrated with the draggable component library, the fields in each database table have draggable attributes, and further can respectively respond to dragging instructions triggered by a user, such as a second dragging instruction and a first dragging instruction, drag a second target field from a first preset area to a filter area in a second preset area, and drag a first target field from the first preset area to an output field area in the second preset area of the current page; respectively acquiring second operation configuration information of a user on a second target field in the filter area and first operation configuration information of a first target field in the output field area; therefore, when the SQL statement generating event is detected, the cross-library SQL statement can be generated according to the first target field, the first operation configuration information, the second target field and the second operation configuration information. According to the scheme, the database field supports a dragging function, and interaction experience between a visual page and a user is optimized; and the user without the background of the professional knowledge of the database can also generate the SQL sentences required by the user based on the visual page, thereby providing a new idea for simply and conveniently generating the SQL sentences for the user. In addition, the scheme provides various operators for the fields, and can support selection and comparison of the data sets, so that cross-library splicing is supported to generate the SQL sentences, and possibility is provided for users to splice and generate more complex SQL sentences.
EXAMPLE III
Fig. 3 is a flowchart of a method for generating an SQL statement based on a visualized page according to a third embodiment of the present invention, and this embodiment further explains, based on the third embodiment, that if an SQL statement generation event is detected, an SQL statement is generated and stored according to a first target field and first operation configuration information of the first target field. Referring to fig. 3, the method may specifically include:
s310, acquiring a target data source selected by a user, and displaying attribute information of the target data source in a first preset area of a current page, wherein the attribute information comprises fields in each database table in the target data source.
S320, responding to the first dragging instruction, determining a first target field, and dragging the first target field from the first preset area to an output field area in a second preset area of the current page.
S330, acquiring first operation configuration information of the user on the first target field in the output field area.
S340, if the preview event is detected, generating an SQL statement according to the first target field and the first operation configuration information of the first target field, and displaying an operation result corresponding to the SQL statement.
In this embodiment, the preview event is an event triggered by the user clicking a function case on the current page, and may be generated by the user clicking a preview button on the current page, for example.
Specifically, if a preview event is detected, the local browser loading the current page can send the first target field and the first operational configuration information of the first target field to the target server, so that the target server can obtain a related SQL code segment from a database where the first target field is located in the target data source according to the first operational configuration information of the first target field and the first target field, then splice the obtained SQL code segments according to the SQL statement generation format to generate a required SQL statement, and feed back an operation result corresponding to the SQL statement. And then the current page can obtain the operation result fed back by the target server through the local browser loading the current page, and the operation result is displayed to the user in a new webpage form or in a floating window form or the like, so that the user can determine whether the generated SQL statement is required by the user by checking the operation result.
And S350, if the save event is acquired, saving the SQL statement.
In this embodiment, the save event is an event triggered by the user clicking a function case on the current page, for example, the save event may be generated by the user clicking a save button on the current page.
Specifically, if the user determines that the generated SQL statement is required by the user, the user may click a save button on the current page; if the current page acquires the storage event, an SQL statement acquisition request can be sent to the target server through the local browser loading the current page, so that the target server feeds back the generated SQL statement and stores the SQL statement locally. If the user determines that the generated SQL statement is not required by the user, the case can be clicked to be closed; and if the current page acquires the closing event, the second preset area can be emptied, so that the user can drag again to regenerate the SQL statement.
According to the technical scheme provided by the embodiment of the invention, before the generated SQL statement is stored, the operation result of the generated SQL statement is displayed to a user according to the first target field and the first operation configuration information, so that the user can determine whether the generated SQL statement is required by the user by checking the operation result; and if the SQL statement is determined to be required by the user, namely if the saving event is acquired, saving the SQL statement. By displaying the SQL sentence operation result to the user in advance, the phenomenon that the SQL which is finally stored is not required by the user can be avoided, and the user experience is further improved.
Example four
Fig. 4A is a flowchart of a method for generating an SQL statement based on a visualized page according to a fourth embodiment of the present invention, and this embodiment provides a preferred example of operating a filter area, an input field area, and an output field area in a second preset area on the basis of the foregoing embodiment. Referring to fig. 4A, the method may specifically include:
s401, if a data change event is detected, displaying a data source option interface.
S402, acquiring a target data source selected by a user, and displaying attribute information of the target data source in a first preset area of a current page, wherein the attribute information comprises fields in each database table in the target data source.
And S403, in response to the second dragging instruction, determining a second target field, and dragging the second target field from the first preset area to a filter area in the second preset area.
S404, acquiring second operation configuration information of the user on a second target field in the filter area; wherein the operator in the second operation configuration information is the comparison data set, and the operation condition in the second operation configuration information is that the second target field is contained in another database.
S405, responding to a third dragging instruction, determining a third target field, and dragging the third target field from the first preset area to an input field area in the second preset area.
In this embodiment, the third dragging instruction is generated by dragging the field in the first preset area to the input field area in the second preset area by the user. Correspondingly, the third target field is a field dragged by the user from the first preset area to the input field area in the second preset area; optionally, the third target field may be determined according to a drag operation of the user at the first preset region, and the number of the third target field is at least one. For example, when a plurality of third target fields are provided, a plurality of fields may be dragged at the same time by one drag operation, or one field may be dragged at a time, and the user may select one field according to actual needs.
Specifically, if a third dragging instruction triggered by the fact that the user drags the field in the first preset area to the input field area in the second preset area is detected, the third dragging instruction is responded, the field is used as a third target field, and the third target field is dragged from the position of the first preset area to the input field area in the second preset area to be placed.
For example, as shown in fig. 4B, if a third drag instruction triggered by the user dragging the field city (the city where the school is located) from the first preset area to the input field area in the second preset area is detected, in response to the third drag instruction, the field city (the city where the school is located) is used as a third target field, and the field city (the city where the school is located) is dragged from the position of the first preset area to the input field area in the second preset area and placed.
In addition, the third object field may be partially or completely the same as the first object field and/or the first object field, or may be different from the first object field and/or the first object field.
S406, acquiring third operation configuration information of the user on the third target field in the input field area.
In this embodiment, the third operation configuration information refers to an operation set for the third target field, and may include various options such as padding and non-padding.
Similar to the process of acquiring the first operation configuration information, the process of acquiring the third operation configuration information of the user on the third target field in the input field area may be: after the field city is dragged from the position of the first preset area to the input field area in the second preset area and placed, a user can enter an operation setting interface of the field city by clicking a plus sign at the position of the field city, and then can select from optional operation configuration information according to requirements; further, the current page may obtain the operation configuration information selected by the user, and use the operation configuration information as the third operation configuration information of the third target field, as shown in fig. 4B.
S407, in response to the first dragging instruction, determining a first target field, and dragging the first target field from the first preset area to an output field area in the second preset area.
S408, acquiring first operation configuration information of the user on the first target field in the output field area.
S409, if the preview event is detected, generating a cross-library SQL statement according to the first target field, the first operation configuration information, the second target field, the second operation configuration information, the third target field and the third operation configuration information, and displaying an operation result corresponding to the SQL statement.
And S410, if the save event is acquired, saving the SQL statement.
Optionally, before S409, the method may further include: responding to a fourth dragging instruction, determining a fourth target field, and dragging the fourth target field from the first preset area to a grouping field area in the second preset area; and acquiring fourth operation configuration information of the user on a fourth target field in the grouping field area. The specific implementation process is similar to other areas in the second area, such as the input field area, and is not described herein again.
It should be noted that, after the execution sequence of the operations S403 and S404 related to the second target field, the operations S405 and S406 related to the second target field, and the operations S407 and S408 related to the first target field is not in sequence, the present embodiment provides a preferred example by the display sequence of the filter area, the input field area, and the output field area in the second preset area.
According to the technical scheme provided by the embodiment of the invention, the database field supports a dragging function, so that the interactive experience between a visual page and a user is optimized; and the user without the background of the professional knowledge of the database can also generate the SQL sentences required by the user based on the visual page, thereby providing a new idea for simply and conveniently generating the SQL sentences for the user. In addition, the scheme provides various operators for the fields, and can support selection and comparison of the data sets, so that cross-library splicing is supported to generate the SQL sentences, and possibility is provided for users to splice and generate more complex SQL sentences. Moreover, the SQL sentence running result is displayed to the user in advance, so that the phenomenon that the SQL which is finally stored is not required by the user can be avoided, and the user experience is further improved.
EXAMPLE five
Fig. 5 is a structural block diagram of a device for generating an SQL statement based on a visual page according to a fifth embodiment of the present invention, where the device can execute the method for generating an SQL statement based on a visual page according to any embodiment of the present invention, and has corresponding functional modules and beneficial effects of the execution method. The visualization page is implemented based on a VUE frame, a desktop end component library and a draggable component library are integrated in the VUE frame, and as shown in fig. 5, the apparatus may include:
the attribute information display module 510 is configured to obtain a target data source selected by a user, and display attribute information of the target data source in a first preset area of a current page, where the attribute information includes fields in database tables in the target data source;
a field dragging module 520, configured to determine a first target field in response to a first dragging instruction, and drag the first target field from a first preset area to an output field area in a second preset area of the current page;
a configuration information obtaining module 530, configured to obtain first operation configuration information of the user on the first target field in the output field area;
the statement generating and saving module 540 is configured to generate and save the SQL statement according to the first target field and the first operation configuration information of the first target field if the SQL statement generating event is detected.
According to the technical scheme provided by the embodiment of the invention, the attribute information of the target data source selected by the user is displayed in the first preset area of the current page, so that the user can intuitively position the required field; the method comprises the steps that as a draggable component library is integrated in a visual page, fields in each database table have draggable attributes, and further a first dragging instruction triggered by a user can be responded, a first target field is dragged from a first preset area to an output field area in a second preset area of a current page, and first operation configuration information of the user on the first target field in the output field area is obtained; therefore, when the SQL statement generating event is detected, the SQL statement required by the user can be generated and stored according to the first target field and the first operation configuration information of the first target field. According to the scheme, the database field supports a dragging function, and interaction experience between a visual page and a user is optimized; and the user without the background of the professional knowledge of the database can also generate the SQL sentences required by the user based on the visual page, thereby providing a new idea for simply and conveniently generating the SQL sentences for the user.
Illustratively, the apparatus may further include:
and the option interface display module is used for displaying the data source option interface if a data change event is detected before the target data source selected by the user is obtained.
For example, the field dragging module 520 may be further configured to, before the SQL statement is generated and stored according to the first target field and the first operation configuration information of the first target field if the SQL statement generating event is detected, determine a second target field in response to a second dragging instruction, and drag the second target field from the first preset area to a filter area in a second preset area;
the configuration information obtaining module 530 may be further configured to obtain second operation configuration information of the user on the second target field in the filter area; wherein the operator in the second operation configuration information is the comparison data set, and the operation condition in the second operation configuration information is that the second target field is contained in another database.
Illustratively, the statement generation and saving module 540 may be specifically configured to: and generating and storing the cross-library SQL statement according to the first target field, the first operation configuration information, the second target field and the second operation configuration information.
Illustratively, the statement generation and saving module 540 may be further configured to: and sending the first target field and the first operation configuration information of the first target field to a target server through a local browser loading the current page, so that the target server generates and stores the SQL statement according to the first target field and the first operation configuration information of the first target field.
Illustratively, the statement generation and saving module 540 may be further configured to: if the preview event is detected, generating an SQL statement according to the first target field and the first operation configuration information of the first target field, and displaying an operation result corresponding to the SQL statement;
and if the storage event is acquired, storing the SQL statement.
EXAMPLE six
Fig. 6 is a schematic structural diagram of a server according to a sixth embodiment of the present invention, and fig. 6 shows a block diagram of an exemplary server suitable for implementing the embodiment of the present invention. The server shown in fig. 6 is only an example, and should not bring any limitation to the function and the scope of use of the embodiments of the present invention.
As shown in FIG. 6, the server 12 is in the form of a general purpose computing device. The components of the server 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that couples various system components including the system memory 28 and the processing unit 16.
The server 12 typically includes a variety of computer system readable media. Such media may be any available media that is accessible by server 12 and includes both volatile and nonvolatile media, removable and non-removable media.
The system memory 28 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM)30 and/or cache memory 32. The server 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 6, and commonly referred to as a "hard drive"). Although not shown in FIG. 6, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. System memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.
A program/utility 40 having a set (at least one) of program modules 42 may be stored, for example, in system memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. Program modules 42 generally carry out the functions and/or methodologies of embodiments described herein.
The server 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), with one or more devices that enable a user to interact with the server 12, and/or with any devices (e.g., network card, modem, etc.) that enable the server 12 to communicate with one or more other computing devices. Such communication may be through an input/output (I/O) interface 22. Also, the server 12 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the Internet) via the network adapter 20. As shown, the network adapter 20 communicates with the other modules of the server 12 via the bus 18. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the server 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, among others.
The processing unit 16 executes programs stored in the system memory 28, thereby executing various functional applications and data processing, for example, implementing the method for generating SQL statements based on visualized pages provided by the embodiment of the present invention.
EXAMPLE seven
The seventh embodiment of the present invention further provides a computer-readable storage medium, on which a computer program (or called computer-executable instructions) is stored, where the computer program, when executed by a processor, is configured to execute a method for generating an SQL statement based on a visualization page, where the visualization page is implemented based on a VUE framework, and a desktop component library and a draggable component library are integrated in the VUE framework, and the method includes:
acquiring a target data source selected by a user, and displaying attribute information of the target data source in a first preset area of a current page, wherein the attribute information comprises fields in database tables in the target data source;
responding to the first dragging instruction, determining a first target field, and dragging the first target field from a first preset area to an output field area in a second preset area of the current page;
acquiring first operation configuration information of a user on a first target field in an output field area;
and if the SQL statement generating event is detected, generating and storing the SQL statement according to the first target field and the first operation configuration information of the first target field.
Computer storage media for embodiments of the invention may employ any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations for embodiments of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the embodiments of the present invention have been described in more detail through the above embodiments, the embodiments of the present invention are not limited to the above embodiments, and many other equivalent embodiments may be included without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (8)
1. A method for generating SQL statements based on a visual page is characterized in that the visual page is realized based on a VUE framework, a desktop end component library and a draggable component library are integrated in the VUE framework, and the method comprises the following steps:
acquiring a target data source selected by a user, and displaying attribute information of the target data source in a first preset area of a current page, wherein the attribute information comprises fields in database tables in the target data source;
responding to a first dragging instruction, determining a first target field, and dragging the first target field from the first preset area to an output field area in a second preset area of the current page;
acquiring first operation configuration information of a user on the first target field in the output field area;
responding to a second dragging instruction, determining a second target field, and dragging the second target field from the first preset area to a filter area in a second preset area;
acquiring second operation configuration information of the user on the second target field in the filter area; wherein an operator in the second operation configuration information is a comparison data set, and an operation condition in the second operation configuration information is that a second target field is contained in another database;
and if the SQL sentence generation event is detected, generating and storing a cross-library SQL sentence according to the first target field, the first operation configuration information, the second target field and the second operation configuration information.
2. The method of claim 1, wherein prior to obtaining the target data source selected by the user, further comprising:
and if the data change event is detected, displaying a data source option interface.
3. The method of claim 1, wherein generating and storing a cross-library SQL statement according to the first target field, the first operational configuration information, the second target field, and the second operational configuration information comprises:
and sending the first target field, the first operation configuration information, the second target field and the second operation configuration information to a target server through a local browser loading the current page, so that the target server generates and stores the SQL statement according to the first target field, the first operation configuration information, the second target field and the second operation configuration information.
4. The method of claim 1, wherein if an SQL statement generation event is detected, generating and saving a cross-library SQL statement according to the first target field, the first operation configuration information, the second target field, and the second operation configuration information comprises:
if a preview event is detected, generating a cross-library SQL statement according to the first target field, the first operation configuration information, the second target field and the second operation configuration information, and displaying an operation result corresponding to the cross-library SQL statement;
and if the storage event is acquired, storing the cross-database SQL statement.
5. The utility model provides an apparatus based on visual page generation SQL statement, which characterized in that, visual page is based on VUE frame realization, integrated desktop end component library and draggable component library in the VUE frame, the device includes:
the attribute information display module is used for acquiring a target data source selected by a user and displaying attribute information of the target data source in a first preset area of a current page, wherein the attribute information comprises fields in database tables in the target data source;
the field dragging module is used for responding to a first dragging instruction, determining a first target field, and dragging the first target field from the first preset area to an output field area in a second preset area of the current page;
the configuration information acquisition module is used for acquiring first operation configuration information of the user on the first target field in the output field area;
the field dragging module is further used for responding to a second dragging instruction, determining a second target field, and dragging the second target field from the first preset area to a filter area in a second preset area;
the configuration information acquisition module is further configured to acquire second operation configuration information of the user on the second target field in the filter area; wherein an operator in the second operation configuration information is a comparison data set, and an operation condition in the second operation configuration information is that a second target field is contained in another database;
and the statement generation and storage module is used for generating and storing the cross-library SQL statement according to the first target field, the first operation configuration information, the second target field and the second operation configuration information if the SQL statement generation event is detected.
6. The apparatus of claim 5, further comprising:
and the interface display module is used for displaying a data source option interface if a data change event is detected before the target data source selected by the user is obtained.
7. A server, comprising:
one or more processors;
a memory for storing one or more programs;
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of generating SQL statements based on visualization pages of any of claims 1-4.
8. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the method of generating SQL statements based on visualization pages according to any of claims 1-4.
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 CN109992589A (en) | 2019-07-09 |
| CN109992589B true 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) |
Families Citing this family (34)
| 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 |
| CN110955478B (en) * | 2019-10-12 | 2023-02-03 | 深圳平安医疗健康科技服务有限公司 | Partition dynamic display method, device and equipment of data and readable storage medium |
| CN110825745B (en) * | 2019-10-31 | 2023-03-07 | 口碑(上海)信息技术有限公司 | Page generation method and device |
| CN110955481A (en) * | 2019-11-27 | 2020-04-03 | 北京锐安科技有限公司 | Label task generation method and device, storage medium and electronic equipment |
| CN110941634A (en) * | 2019-11-27 | 2020-03-31 | 北京明略软件系统有限公司 | Data processing method and device, storage medium and electronic device |
| CN111241123A (en) * | 2020-01-07 | 2020-06-05 | 深圳市华宇讯科技有限公司 | View data query method, device, server and storage medium |
| CN111274263B (en) * | 2020-01-13 | 2024-07-05 | 平安国际智慧城市科技股份有限公司 | Visual database change sentence generation method, 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 |
| CN111427626B (en) * | 2020-03-26 | 2023-07-25 | 浪潮通用软件有限公司 | Method and system for rapidly generating report based on dimension data warehouse |
| CN111694813A (en) * | 2020-05-08 | 2020-09-22 | 北京明略软件系统有限公司 | Data source management 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 |
| CN111967269B (en) * | 2020-08-13 | 2024-04-26 | 支付宝(杭州)信息技术有限公司 | Business risk identification method and device and electronic equipment |
| CN112130841B (en) * | 2020-09-02 | 2022-04-22 | 广州市双照电子科技有限公司 | SQL development method and device and terminal equipment |
| CN112131248B (en) * | 2020-09-25 | 2024-05-10 | 北京锐安科技有限公司 | Data analysis method, device, equipment and storage medium |
| 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 |
| CN113065326B (en) * | 2021-03-31 | 2024-06-21 | 北京达佳互联信息技术有限公司 | Text comparison method, 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 |
| CN113779037A (en) * | 2021-09-23 | 2021-12-10 | 上海淇玥信息技术有限公司 | Worksheet processing method and device and electronic equipment |
| 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 |
| CN114860737B (en) * | 2022-06-28 | 2022-09-20 | 北京世纪好未来教育科技有限公司 | Processing method, device, equipment and medium of teaching and research data |
| CN115017182A (en) * | 2022-06-29 | 2022-09-06 | 京东方科技集团股份有限公司 | Visual data analysis method and equipment |
| CN115563149A (en) * | 2022-10-27 | 2023-01-03 | 中电金信软件有限公司 | Index calculation method and device, electronic equipment and storage medium |
| CN115827644B (en) * | 2023-02-13 | 2023-06-09 | 明度智云(浙江)科技有限公司 | 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 |
Citations (10)
| 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 |
| 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 |
| 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 |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6782388B2 (en) * | 2000-12-29 | 2004-08-24 | Bellsouth Intellectual Property Corporation | Error usage investigation and disposal 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 |
-
2019
- 2019-04-11 CN CN201910288930.4A patent/CN109992589B/en active Active
Patent Citations (10)
| 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 |
| 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 |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109992589A (en) | 2019-07-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109992589B (en) | Method, device, server and medium for generating SQL (structured query language) statements based on visual page | |
| US10970294B2 (en) | Website scoring system | |
| US11593102B1 (en) | Managing sharable cell-based analytical notebooks | |
| US10503821B2 (en) | Dynamic workflow assistant with shared application context | |
| CN110008232A (en) | Generation method, device, server and the medium of structured query sentence | |
| US10223698B2 (en) | Integrating a web-based CRM system with a PIM client application | |
| US10565280B2 (en) | Website content identification in a content management system | |
| CN110674117A (en) | Data modeling method and device, computer readable medium and electronic equipment | |
| CN110990445A (en) | Data processing method, device, equipment and medium | |
| CN111045653A (en) | System generation method and device, computer readable medium and electronic equipment | |
| JP4839813B2 (en) | Information processing system and program | |
| US9965450B2 (en) | Dynamic management of site components | |
| CN116594683A (en) | Code annotation information generation method, device, equipment and storage medium | |
| US11803697B2 (en) | Method and system for labeling and organizing data for summarizing and referencing content via a communication network | |
| CN114282129A (en) | Information system page generation method, system, electronic equipment and storage medium | |
| US20240086490A1 (en) | Systems and methods for pre-loading object models | |
| US9396176B2 (en) | Technique for copying and pasting information | |
| CN116467432A (en) | Method for displaying word searching result and related product | |
| US11995129B2 (en) | System and method for annotating website content | |
| US20210319172A1 (en) | Computing device for multiple cell linking | |
| US9934200B1 (en) | Method and system for implementing dynamic note formatting and display | |
| US11301636B2 (en) | Analyzing resumes and highlighting non-traditional resumes | |
| CN112084252A (en) | Multi-data linkage interaction method and device | |
| CN116185412B (en) | Data management method and device, electronic equipment and storage medium | |
| CN115857941A (en) | Code data display method and device, electronic equipment and storage medium |
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 | ||
| 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. |