Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for operating database table based on backward generation of database table structure

A database and table structure technology, applied in the database field, can solve the problems of irregular code writing, low code writing efficiency, cumbersome configuration information, etc., and achieve the effect of convenient post-maintenance, fast editing operations, and unified operating code standards

Inactive Publication Date: 2018-02-23
成都卓凡软件科技有限公司
View PDF8 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to provide a method for reversely generating database table operations based on the database table structure, which mainly solves the cumbersome configuration information, irregular code writing, poor coupling performance, heavy workload, and code writing efficiency existing in the prior art. low level problem

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for operating database table based on backward generation of database table structure
  • Method for operating database table based on backward generation of database table structure
  • Method for operating database table based on backward generation of database table structure

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0026] Such as figure 1 As shown, the present invention provides a database table operation method with unified standards, convenient operation, and good coupling performance. The specific implementation is as follows:

[0027] First, create a database table in the database editor, and establish a database table structure mapping relationship, the database table structure includes primary keys, foreign keys, fields and types, wherein the created database table follows the rules of the Oracle database. The following takes an account data table as an example to illustrate the whole process. First, create an account data table named ZL_ZBZLB in the database editor. The script is as follows:

[0028]

[0029]

[0030] Among them, RESID is the primary key of the account data table ZL_ZBZLB, which will be used as the foreign key of other Oracle database tables. Field name BH, character type ZJM IS_HD, KMBH, other field names such as IS_HD are numeric types.

[0031] Then, qu...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for operating a database table based on backward generation of a database table structure. The method comprises the following steps of creating an Oracle database table in a database editor, and establishing a database table structure mapping relationship; querying, reading and judging the information of the Oracle database table; reversely extracting a managementtable from the Oracle database table, and respectively storing the query contents into a manager database table; cyclically querying the information stored in the manager database table, extracting and storing into a defined dynamic module, organizing data in the dynamic module into Java codes, and generating two DAO files, two TO files, a FROM file and a VO file; by calling the files, increasing,deleting, modifying and querying the database table. The method has the advantages that the operation codes are standard and uniform, the operation and subsequent maintenance of the database are convenient, the workload of a developer is reduced, the quick editing of the database is realized, and the like; the higher application value and popularization value are realized in the technical field of the databases.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method for reversely generating database table operations based on the database table structure. Background technique [0002] With the development of computers, enterprises rely more and more on databases, and user needs are also constantly improving. In order to meet the requirements of business logic and underlying data persistence interaction, the database operation code must be unified and standardized to achieve efficient addition, deletion, modification, and query of the database. At present, database operations generally use third-party java packages or write database operation codes by yourself. The disadvantage is that it is cumbersome to import configuration information to operate databases using java packages. However, when writing data operation codes, due to the difference in the skill level of the writers, it is easy to cause problems such as irregular codes a...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
CPCG06F16/2282G06F16/23G06F16/245
Inventor 尹科胡涛
Owner 成都卓凡软件科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com