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

Method for automatically generating and using code

An automatic generation and code technology, applied in the field of database application and logic combination, can solve the problem of repeatedly writing database business table operation programs, etc., to reduce the error rate, improve program maintainability and readability, and reduce frequent program changes. Effect

Active Publication Date: 2013-07-31
BEIJING JINHER SOFTWARE
View PDF2 Cites 35 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 automatically generating and using codes, which is used to solve the problem of repeatedly writing database business table operating procedures due to business changes or differences in database tables

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 automatically generating and using code
  • Method for automatically generating and using code
  • Method for automatically generating and using code

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] The present invention will be further described in detail below in conjunction with the accompanying drawings, so that those skilled in the art can implement it with reference to the description.

[0022] Such as figure 1 Shown:

[0023] A method for automatically generating and using codes, comprising the following steps:

[0024] Step 1. The data acquisition module connects to the database through the database connection string, and obtains the database set by the user and the system properties of the database business table. For example, the database set by the user is the school's grade management database, and the business table specified for access is the third grade 2 The report card of the students in the first half of the class of 2013, then the data acquisition module will find the report card according to the user's settings, and obtain the name, grade and other fields in the report card;

[0025] Step 2, the code generation module acquires the system attri...

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 automatically generating and using a code. The method is characterized by comprising the following steps that: 1, a data acquiring module acquires system attributes of a database and a database service table; 2, a code generating module splices the acquired corresponding system attributes into an entity class code, a mode class code and a data processing class code and stores the entity class code, the mode class code and the data processing class code; 3, a base class inherited by the class codes generated in the step 2 is a corresponding base class method; and 4, when a user sends an operating request to the service table data at a client end, a data processing class module instantiates a data type requested by the user to the corresponding model class code and carries out SQL (Structured Query Language) statement splicing through a reflection mechanism, and a database processing assembly receives and executes an SQL statement and returns a generated operating result. According to the method, by using a reflection technology and the SQL statement capable of being executed by a dynamics splicing database, the error rate is reduced and the program simplicity, maintainability and readability are improved.

Description

technical field [0001] The present invention relates to the technical field of logical combination in the database application field technology, mainly relates to the development process of products operated by data tables, and particularly relates to a method for automatically generating and using codes. Background technique [0002] With the popularization and development of information technology, more and more enterprises, units or teams need computer software to assist in the management of increasingly complex daily work. [0003] With the rapid growth of society's demand for software and the continuous rise of business complexity, the number and types of data tables in business databases are also very different. , investigation, and code modification according to business changes, there will be some operations with the same operation process and operation method. With the same operation process and operation method, the programmer must do a lot of repetitive work. In o...

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): G06F9/44G06F17/30
Inventor 李军锋李跃海
Owner BEIJING JINHER SOFTWARE
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