CN107643926A - A kind of object type turns database type method - Google Patents
A kind of object type turns database type method Download PDFInfo
- Publication number
- CN107643926A CN107643926A CN201710905077.7A CN201710905077A CN107643926A CN 107643926 A CN107643926 A CN 107643926A CN 201710905077 A CN201710905077 A CN 201710905077A CN 107643926 A CN107643926 A CN 107643926A
- Authority
- CN
- China
- Prior art keywords
- type
- database
- object type
- user
- converted
- 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
Abstract
The present invention relates to a kind of object type to turn database type method, comprises the following steps：After obtaining user's input, call type Processing Algorithm, object type is parsed in the data that type of process algorithm inputs from user, object type is converted to type of database, the external output data type corresponding table of type of process algorithm by type of process algorithm.The present invention, can be according to presupposed information, the object type that user is inputted, corresponding type of database is automatically converted to, type conversion speed is improved and accuracy, fault-tolerant ability is good, strong adaptability, written in code speed and efficiency are favorably improved, avoids mistake caused by duplication of labour accumulation, the SQL statement to automatically generate standardization, formatting provides good basis.
Description
Technical field
The present invention relates to database technical field, specifically a kind of object type turns database type method.
Background technology
With the development of database technology, various demands continuously emerge, and constantly supervise further technological innovation, rise
Level.In program development, programmer runs into following situation sometimes：
When company goes to work, the sometimes work on daytime does not finish, and programmer will take work home overtime work at night and continue to do.But
It is that company is typically entity data bak with database for the supporting exploitation of program development, is deployed on development support server
, the development support server is a server inside corporate lan, and service end normal operation is dependent on exploitation branch
Hold the exploitation database on server.Due to being in, overtime work can not be accessed inside corporate lan, therefore cannot be connected
Exploitation database on upper development support server, this results in service end cisco unity malfunction, function during program development
It can not just debug.
In the prior art, a kind of solution method is exactly to use virtual data base.Just the use of company is journey when company goes to work
Sequence develops supporting exploitation database；Go back home, just use the virtual data base analog development database in internal memory, do one
A little basic function debuggings, are definitely generally enough.
Need largely to localize storage service in current app.In order to meet current business demand, we need in app
Data base tool is largely used, it is contemplated that allowing the convenient exploitation of programmer.
Entity data bak, which reads data, needs following steps：
1st, connected with Database,
2nd, SQL query statement is write,
3rd, query statement is performed,
4th, Query Result is obtained,
5th, database is closed.
Obviously, today of frequent reading/data storage is frequently interacted, needed with database in needs, accesses data
The workload in storehouse is very big, programmer it is cumbersome write SQL statement, not only workload is big, and easily causes to malfunction, it is necessary to
This further is reasonably optimized.
The content of the invention
For defect present in prior art, it is an object of the invention to provide a kind of object type to turn type of database
Method, it the object type for inputting user, can automatically be converted to corresponding type of database according to presupposed information, improve
Type conversion speed and accuracy, fault-tolerant ability is good, strong adaptability, is favorably improved written in code speed and efficiency, avoids weight
Mistake caused by multiple work accumulation, the SQL statement to automatically generate standardization, formatting provide good basis.
To achieve the above objectives, the present invention adopts the technical scheme that：
A kind of object type turns database type method, it is characterised in that comprises the following steps：
After obtaining user's input, call type Processing Algorithm,
Object type is parsed in the data that type of process algorithm inputs from user,
Object type is converted to type of database by type of process algorithm,
The external output data type corresponding table of type of process algorithm.
On the basis of above-mentioned technical proposal, an object list of types is preset, is parsed pair from the data of user's input
During as type, compared with the object type list, the object type parsed must be on the books in object type list.
On the basis of above-mentioned technical proposal, a type of database list is preset, object type is converted into class database
During type, compared with the type of database list, the type of database being converted to must be on the books in type of database list.
Object type of the present invention turns database type method, can be according to presupposed information, pair that user is inputted
As type, corresponding type of database is automatically converted to, improves type conversion speed and accuracy, fault-tolerant ability is good, adapts to
Property it is strong, be favorably improved written in code speed and efficiency, avoid the duplication of labour accumulate caused by mistake, to automatically generate standard
The SQL statement change, formatted provides good basis.
Brief description of the drawings
The present invention has drawings described below：
The FB(flow block) of Fig. 1 present invention.
Embodiment
The present invention is described in further detail below in conjunction with accompanying drawing.
As shown in figure 1, object type of the present invention turns database type method, comprise the following steps：
After obtaining user's input, call type Processing Algorithm,
Object type is parsed in the data that type of process algorithm inputs from user,
Object type is converted to type of database by type of process algorithm,
The external output data type corresponding table of type of process algorithm.
On the basis of above-mentioned technical proposal, an object list of types is preset, is parsed pair from the data of user's input
During as type, compared with the object type list, the object type parsed must be on the books in object type list.
On the basis of above-mentioned technical proposal, a type of database list is preset, object type is converted into class database
During type, compared with the type of database list, the type of database being converted to must be on the books in type of database list.
The content not being described in detail in this specification belongs to prior art known to professional and technical personnel in the field.
Claims (3)
1. a kind of object type turns database type method, it is characterised in that comprises the following steps：
After obtaining user's input, call type Processing Algorithm,
Object type is parsed in the data that type of process algorithm inputs from user,
Object type is converted to type of database by type of process algorithm,
The external output data type corresponding table of type of process algorithm.
2. object type as claimed in claim 1 turns database type method, it is characterised in that：A default object type column
Table, when parsing object type from the data of user's input, compared with the object type list, the object type parsed must
Must be on the books in object type list.
3. object type as claimed in claim 1 turns database type method, it is characterised in that：Default type of database row
Table, when object type is converted into type of database, compared with the type of database list, the type of database being converted to must
Must be on the books in type of database list.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710905077.7A CN107643926A (en) | 2017-09-29 | 2017-09-29 | A kind of object type turns database type method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710905077.7A CN107643926A (en) | 2017-09-29 | 2017-09-29 | A kind of object type turns database type method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107643926A true CN107643926A (en) | 2018-01-30 |
Family
ID=61122965
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710905077.7A Pending CN107643926A (en) | 2017-09-29 | 2017-09-29 | A kind of object type turns database type method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107643926A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113835929A (en) * | 2021-09-24 | 2021-12-24 | 深圳追一科技有限公司 | Data acquisition method and device, electronic equipment and storage medium |
| CN113835929B (en) * | 2021-09-24 | 2024-04-30 | 深圳追一科技有限公司 | Data acquisition method and device, electronic equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101247589A (en) * | 2007-07-04 | 2008-08-20 | 华为技术有限公司 | Mobile terminal data conversion/backup method, device and system |
| US20080250068A1 (en) * | 2007-03-14 | 2008-10-09 | Excel Wizards Ltd. | System for preparing reports |
| CN103970736A (en) * | 2013-01-25 | 2014-08-06 | 苏州精易会信息技术有限公司 | Method for converting Excel sheet to database table |
-
2017
- 2017-09-29 CN CN201710905077.7A patent/CN107643926A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080250068A1 (en) * | 2007-03-14 | 2008-10-09 | Excel Wizards Ltd. | System for preparing reports |
| CN101247589A (en) * | 2007-07-04 | 2008-08-20 | 华为技术有限公司 | Mobile terminal data conversion/backup method, device and system |
| CN103970736A (en) * | 2013-01-25 | 2014-08-06 | 苏州精易会信息技术有限公司 | Method for converting Excel sheet to database table |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113835929A (en) * | 2021-09-24 | 2021-12-24 | 深圳追一科技有限公司 | Data acquisition method and device, electronic equipment and storage medium |
| CN113835929B (en) * | 2021-09-24 | 2024-04-30 | 深圳追一科技有限公司 | Data acquisition method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104133772B (en) | Automatic test data generation method | |
| CN111078702B (en) | SQL sentence classification management and unified query method and device | |
| CN107491485A (en) | Generate method, planning unit and the distributed NewSQL Database Systems of executive plan | |
| CN106649771A (en) | Data model updating method and system for database | |
| CN103902653A (en) | Method and device for creating data warehouse table blood relationship graph | |
| CN104462269A (en) | Isomerous database data exchange method and system | |
| CN103970736A (en) | Method for converting Excel sheet to database table | |
| CN106844369B (en) | Objectification SQL sentence construction method and apparatus | |
| CN103903086A (en) | Method and system for developing management information system based on service model driving | |
| CN105159616A (en) | Disk space management method and device | |
| CN105426419A (en) | System and method for data promotion among heterogeneous systems | |
| CN105278961A (en) | Method and system for generating database table structure document | |
| CN104063636A (en) | Role permission control method and system | |
| CN102486772A (en) | Method and device for exporting data | |
| CN108073705B (en) | Distributed mass data aggregation acquisition method | |
| CN107643926A (en) | A kind of object type turns database type method | |
| CN101425078A (en) | Software source code updating method and device | |
| CN102521318A (en) | General data exchange device based on extensible markup language (XML) | |
| CN102880597A (en) | Multidimensional data generation device and multidimensional data generation method used for computer system | |
| CN107577816A (en) | A kind of method of entity data bak read-write | |
| CN116167719A (en) | Method and system for realizing mapping between different systems of power equipment ledgers | |
| CN103092841B (en) | A kind of data processing method and device | |
| CN107657036A (en) | A kind of production method of database object placement model | |
| CN107644097A (en) | A kind of SLQ sentence generation methods | |
| CN102043853A (en) | Method and device for updating stored data |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180130 |
|
| RJ01 | Rejection of invention patent application after publication |