CN115809225A - Development method and system convenient for database management based on front-end technology - Google Patents
Development method and system convenient for database management based on front-end technology Download PDFInfo
- Publication number
- CN115809225A CN115809225A CN202211498995.XA CN202211498995A CN115809225A CN 115809225 A CN115809225 A CN 115809225A CN 202211498995 A CN202211498995 A CN 202211498995A CN 115809225 A CN115809225 A CN 115809225A
- Authority
- CN
- China
- Prior art keywords
- browser
- database
- database management
- management tool
- data
- 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.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a development method and a system convenient for database management based on a front-end technology, which define a database management tool and present the database management tool on a browser, wherein the database management tool has a function of connecting any one database supporting an ODBC connection mode, and the function enables the database management tool to operate and manage the database on the browser; and adapting the browser to enable the browser page to be adaptive to the screen of the equipment. The invention can provide a database management tool for accessing different databases by multiple terminals, thereby effectively improving the compatibility of the database management tool and the convenience of multi-terminal access; the method reduces a large amount of workload caused by switching among different databases when a database user uses the different databases; the method can reduce the learning cost and the management cost of enterprise database users caused by using different database client management tools, reduce resource loss and reduce resource waste.
Description
Technical Field
The invention relates to the technical field of database management, in particular to a development method and a development system which are based on a front-end technology and are convenient for database management.
Background
With the continuous expansion of the database scale, under the rapid development of computer technology and network technology, the traditional management mode based on the local database can not meet the business requirements. In the field of data management, enterprises can establish a data console, and through the data console, service system data sources separated from each other are integrated together to construct and provide a uniform data sharing platform. At present, most of database management tools adopt a client-server design mode, and the mode needs to download an EXE file installation package and install a special database management tool provided by a database supplier. In an actual development project, a database manager or developer may contact multiple projects, multiple different types of databases; the database manager or developer needs to install various database client management tools on the client host, and also needs to spend a lot of time learning to use various database management tools, which increases the learning cost of using the database and the management cost of the enterprise to the database.
Disclosure of Invention
One of the purposes of the invention is to provide a development method convenient for database management based on a front-end technology, so as to solve the problems that the prior art increases the learning cost of using a database and the management cost of an enterprise on the database; the second purpose is to provide a development system which is convenient for database management based on the front-end technology.
In order to achieve the purpose, the technical scheme adopted by the invention is as follows:
a development method for facilitating database management based on front-end technology,
defining a database management tool and displaying the database management tool on a browser, wherein the database management tool has a function of connecting any database supporting an ODBC connection mode, and the function enables the database management tool to operate and manage the database on the browser;
and adapting the browser to enable the browser page to be adaptive to the screen of the equipment.
According to the technical means, because the defined database management tool is presented on the browser, and the browser page can self-adaptively use the screen of the equipment, the browser can be started on various equipment, and the database management tool is operated, so that any terminal can be arranged in a response mode, and the limitation that the traditional CS architecture database management tool can only be operated on a computer is broken through;
because the database management tool has the function of connecting any database supporting the ODBC connection mode, a worker can operate any database supporting the ODBC connection mode through the browser without downloading the EXE file installation package for each database, database management personnel and developers can call different databases easily and conveniently, and the learning cost and the use cost are reduced.
Furthermore, database management personnel and developers directly operate the database through a front-end technology, and the step that the traditional calling database needs to pass through a corresponding database client tool is omitted; the workload is reduced, and the working efficiency is improved.
Further, the specific method of the adaptation processing is as follows:
acquiring the size of a browser page of equipment;
adding a META tag in a head file of HTML of a browser terminal, and defining the scaling of the screen size of equipment and the page size of the browser and the maximum value and the minimum value of the scaling in the META tag.
Further, the size of the browser page of the acquisition device is realized by introducing a CSS3 media querier.
Further, the method for connecting any database supporting an ODBC connection mode includes: and connecting the corresponding database by sending an HTTP request to the server and utilizing the database management tool to input parameters in combination with the rules.
Further, the database management tool has functions of creating a data table, adding data, updating data, deleting data, and querying data.
A development system facilitating database management based on front-end technology based on the above method, comprising:
the database management tool definition module is configured to define a database management tool and present the database management tool on the browser, and the database management tool can be connected with any database supporting the ODBC connection mode so that the database management tool can operate and manage the database on the browser;
and the browser adaptation module is configured to adapt the browser so that the browser page can adaptively use the screen of the equipment.
Further, the browser adaptation module implements the adaptation processing of the browser by the following method:
acquiring the size of a browser page of equipment;
adding a META tag in a head file of HTML of a browser terminal, and defining the scaling of the screen size of equipment and the page size of the browser and the maximum value and the minimum value of the scaling in the META tag.
Further, the browser adaptation module obtains the browser page size of the device through the CSS3 media querier.
Further, the database management tool definition module realizes connection with the database by the following method: and connecting the corresponding database by sending an HTTP request to the server and utilizing the database management tool to input parameters in combination with the rules.
Further, the database management tool has a create data table component, an add data component, an update data component, a delete data component, and a query data component.
The invention has the beneficial effects that:
the invention can provide a database management tool for accessing different databases by multiple terminals, thereby effectively improving the compatibility of the database management tool and the convenience of accessing the multiple terminals; the workload caused by switching different databases when a database user uses the different databases is reduced; the method can reduce the learning cost and the management cost of enterprise database users caused by using different database client management tools, reduce resource loss and reduce resource waste.
Drawings
FIG. 1 is a flowchart of example 1 of the present invention;
fig. 2 is a block diagram of a system according to embodiment 2 of the present invention.
Wherein, 1-database management tool definition module; 2-browser adaptation module.
Detailed Description
Other advantages and effects of the present invention will be readily apparent to those skilled in the art from the disclosure herein, wherein embodiments of the present invention are described below with reference to the accompanying drawings and preferred embodiments. The invention is capable of other and different embodiments and of being practiced or of being carried out in various ways, and its several details are capable of modification in various respects, all without departing from the spirit and scope of the present invention. It should be understood that the preferred embodiments are illustrative of the invention only and are not limiting upon the scope of the invention.
It should be noted that the drawings provided in the following embodiments are only for illustrating the basic idea of the present invention, and the components related to the present invention are only shown in the drawings rather than drawn according to the number, shape and size of the components in actual implementation, and the type, quantity and proportion of the components in actual implementation may be changed freely, and the layout of the components may be more complicated.
The embodiment provides a development method convenient for database management based on a front-end technology, as shown in fig. 1, the development method specifically includes:
database management tools are defined and presented on a browser.
The database management tool module can realize data management (functions of adding, modifying, deleting, inquiring and the like) on WEB and encapsulate common operation components for database operation. Creating a data table, adding data, updating data, deleting data and inquiring data. The user can conveniently browse and maintain all the data tables in the database. And provides a data retrieval filtering function and a display control function. The system can complete the general database processing function and is a very practical tool for managing and inquiring and maintaining the database.
The method comprises the steps of sending an HTTP request to a server, utilizing a database management tool to input parameters in combination with rules to connect a corresponding database, enabling the database management tool to have a function of connecting any one database supporting an ODBC connection mode, and enabling the database management tool to operate and manage the database on a browser.
For example: a Database Source Name (DSN) is created, created by ODBC, used and identified by ODBC to connect application programs and database logical names of background databases, assuming that an ODBC data source named "USERS" has been created for an SQL Server database. The Connection object may be created by the CreateObject method of the server object and, once created, may be used to open any ODBC data source connections.
In this embodiment, the database management tool has functions of creating a data table, adding data, updating data, deleting data, and querying data.
In this step, after the browser interface is successfully operated and connected with the database, the function of creating the data table in the database management tool universal module is called, and the following user table is created:
and then entering a database user table management page, and opening the successfully created USERS user table as follows:
if a new user is needed, the function of adding data can be used, and the incoming name, age and sex are directly added to the database. If all boys need to be queried, the query data function can be used to query the incoming gender for data. If the age of the plum four is filled in by mistake, the function of updating data can be used, and the user id needing to update the age is transmitted to realize data editing. If the user with the name of Zhang III needs to be deleted, the data deleting function can be used, the id of the user needing to be deleted is transmitted, and the data deleting operation is achieved.
And adapting the browser to enable the browser page to be adaptive to the screen of the equipment.
The method for adapting the browser comprises the following steps:
acquiring the size of a browser page of equipment by introducing a CSS3 media querier;
adding a META tag in a head file of HTML of a browser terminal, and defining the scaling of the screen size of equipment and the page size of the browser and the maximum value and the minimum value of the scaling in the META tag.
In this embodiment, a plurality of browsers can be introduced, and by adopting the above manner, the pages of all the browsers can be made to be self-adaptive to the use devices, and the use devices are mobile phone terminals, computer terminals, car terminals, and the like, so that the purpose of self-adapting the pages of all the browsers and the screens of all the devices is achieved, and thus any terminal can be distributed in a responsive manner, and the limitation that the traditional CS architecture database management tool can only operate on a computer is broken through.
Example 2
As shown in fig. 2, the present embodiment proposes a development system facilitating database management based on front-end technology, based on the method described in embodiment 1. Assuming that the embodiment is based on NODEJS as a development environment, the VUE whole family bucket, the Ant Design UI component framework, the LESS preprocessor, the VITE construction tool and the NPM component library package are integrated as a basic base to carry out development services, and the component library stores various components selected and freely combined by a user. And generating a front-end database management tool project based on the VUE whole family bucket, the Ant Design UI component framework and the LESS preprocessor through the VUE construction tool.
The system proposed in this embodiment comprises a database management tool definition module 1 and a browser adaptation module 2.
The database management tool definition module 1 is configured to define a database management tool and present the database management tool on a browser, wherein the database management tool can be connected with any database supporting an ODBC connection mode, so that the database management tool can operate and manage the database on the browser;
the browser adaptation module 2 is configured to adapt the browser so that the browser page can adaptively use the screen of the device.
The database management tool has a create data table component, an add data component, an update data component, a delete data component, and a query data component.
The operation logic of the database management tool definition module 1 and the browser adaptation module 2 has been described in embodiment 1, and this embodiment is not described again.
The above embodiments are merely preferred embodiments for fully illustrating the present invention, and the scope of the present invention is not limited thereto. The equivalent substitution or change made by the technical personnel in the technical field on the basis of the invention is all within the protection scope of the invention.
Claims (10)
1. A development method convenient for database management based on front-end technology is characterized in that:
defining a database management tool and displaying the database management tool on a browser, wherein the database management tool has a function of connecting any database supporting an ODBC connection mode, and the function enables the database management tool to operate and manage the database on the browser;
and adapting the browser to enable the browser page to be adaptive to the screen of the equipment.
2. The method of claim 1, wherein: the specific method of the adaptation processing is as follows:
acquiring the size of a browser page of equipment;
adding a META tag into a head file of HTML of a browser terminal, and defining the scaling of the screen size of equipment and the page size of the browser and the maximum value and the minimum value of the scaling in the META tag.
3. The method of claim 2, wherein: the size of the browser page of the acquisition device is realized by introducing a CSS3 media querier.
4. The method of claim 1, wherein: the method for connecting any database supporting the ODBC connection mode comprises the following steps: and connecting the corresponding database by sending an HTTP request to the server and utilizing the database management tool to input parameters in combination with the rules.
5. The method of claim 1, wherein: the database management tool has functions of creating a data table, adding data, updating data, deleting data, and querying data.
6. A front-end technology based development system for facilitating database management based on the method of any of claims 1-5, characterized by: the method comprises the following steps:
the database management tool definition module is configured to define a database management tool and present the database management tool on a browser, and the database management tool can be connected with any database supporting an ODBC connection mode so that the database management tool can operate and manage the database on the browser;
and the browser adaptation module is configured to adapt the browser so that the browser page can adaptively use the screen of the equipment.
7. The system of claim 6, wherein: the browser adaptation module realizes the adaptation processing of the browser by the following method:
acquiring the size of a browser page of equipment;
adding a META tag in a head file of HTML of a browser terminal, and defining the scaling of the screen size of equipment and the page size of the browser and the maximum value and the minimum value of the scaling in the META tag.
8. The system of claim 7, wherein: the browser adaptation module acquires the browser page size of the equipment through the CSS3 media querier.
9. The system of claim 6, wherein: the database management tool definition module realizes connection with a database by the following method: and connecting the corresponding database by sending an HTTP request to the server and utilizing the database management tool to input parameters in combination with the rules.
10. The system of claim 6, wherein: the database management tool has a create data table component, an add data component, an update data component, a delete data component, and a query data component.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211498995.XA CN115809225A (en) | 2022-11-28 | 2022-11-28 | Development method and system convenient for database management based on front-end technology |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211498995.XA CN115809225A (en) | 2022-11-28 | 2022-11-28 | Development method and system convenient for database management based on front-end technology |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115809225A true CN115809225A (en) | 2023-03-17 |
Family
ID=85484303
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211498995.XA Pending CN115809225A (en) | 2022-11-28 | 2022-11-28 | Development method and system convenient for database management based on front-end technology |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115809225A (en) |
-
2022
- 2022-11-28 CN CN202211498995.XA patent/CN115809225A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7900214B2 (en) | System and method for adaptable provisioning of generic application content | |
| EP1661036B1 (en) | A method and system for improving presentation of html pages in web devices | |
| US6061686A (en) | Updating a copy of a remote document stored in a local computer system | |
| EP0504085B1 (en) | Method and apparatus for accessing a relational database without exiting an object-oriented environment | |
| CA2495396C (en) | System and method for customized provisioning of application content | |
| CN109033403B (en) | Method, apparatus and storage medium for searching blockchain data | |
| KR20050085164A (en) | Real-time web sharing system | |
| KR20120042762A (en) | Managed system extensibility | |
| CN109101607B (en) | Method, apparatus and storage medium for searching blockchain data | |
| US20090132538A1 (en) | Information processing apparatus, information processing system, and information processing method | |
| US6883020B1 (en) | Apparatus and method for filtering downloaded network sites | |
| CN112256772A (en) | Data service method, device and readable storage medium | |
| CN1647040A (en) | Method and system for managing a computer system | |
| CN109086414B (en) | Method, apparatus and storage medium for searching blockchain data | |
| CN111158777B (en) | Component calling method, device and computer readable storage medium | |
| CN111045928A (en) | Interface data testing method, device, terminal and storage medium | |
| CN115809225A (en) | Development method and system convenient for database management based on front-end technology | |
| CN107357853B (en) | Method and device for operating REDIS console and computer system | |
| CN115794076A (en) | Model-driven customization-based method, system, electronic device and storage medium | |
| CN114153438A (en) | API automatic generation system | |
| KR100545348B1 (en) | An integrated development system for a SyncML server application development | |
| EP0520926A2 (en) | Method and apparatus for managing class information | |
| KR102121975B1 (en) | Method for providing actual data through synchronized table and data managing system | |
| JPH0561746A (en) | Data processing system and access method of related data base | |
| CN116776345A (en) | Data authority setting method, device, 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 |