Unlock instant, AI-driven research and patent intelligence for your innovation.

SQL statement construction method and apparatus for preprocessing special-character

A technology of special characters and construction methods, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of difficult modification and maintenance, bloated structure, code confusion, etc., to reduce the amount of code, ensure correctness, and system Clearly Structured Effects

Inactive Publication Date: 2009-06-24
ZTE CORP
View PDF4 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The technical problem to be solved by the present invention is to overcome the shortcomings of existing technologies such as code confusion, bloated structure, and difficulty in modification and maintenance, in order to provide a method and device for preprocessing special characters in SQL statement construction

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
  • SQL statement construction method and apparatus for preprocessing special-character
  • SQL statement construction method and apparatus for preprocessing special-character
  • SQL statement construction method and apparatus for preprocessing special-character

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] Specific embodiments of the present invention are described in further detail below in conjunction with accompanying drawing:

[0026] figure 1 It is a flow chart of the sql statement construction method for preprocessing special characters according to the present invention.

[0027] The method of the present invention limits the special character conversion operation contained in the statement to be realized in a unified interface. In order to illustrate the sql statement construction process provided by the present invention, the following two conventions need to be made at first:

[0028] Convention 1: The field value corresponding to the database table is said to be a value string, because it comes from the application, so it may contain any character, number or time and other structural type data. The difference is non-value strings, including field names or sql keywords, because there are clear grammatical regulations, so they only contain standard characters; ...

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 present invention provides a sql statement construction method and device for preprocessing special characters in the field of computers. The method includes step 1: numbering all value character strings contained in a sql statement according to the order of appearance, and according to the Numbering organizes the sql statement. If the value string is involved, the actual content is not added, and a substitution character is added to replace it. This cycle continues until the entire statement construction ends; Step 2: Convert the illegal characters in the first value string, and use the Its type performs corresponding legality judgment and range verification and other operations to obtain a legal value string, and replaces the replacement characters in the initial SQL statement with the legal value string until all value strings are added to the SQL statement. The adoption of the invention makes the system structure relatively clear, reduces the amount of codes, and ensures the correctness of the codes.

Description

technical field [0001] The invention relates to the field of computer applications, in particular to a SQL statement construction method and device for preprocessing special characters in a relational database management system. Background technique [0002] Databases, especially relational databases, are widely used in the field of software development. The most used in the development process is to construct sql statements and send them to the database for execution according to application requirements. Due to the limitations of the current database management system itself, SQL statements containing certain special characters (such as single quotation marks) cannot be directly and normally executed, so these special characters must be converted when constructing SQL statements. The so-called special characters are the characters specified by the existing database system to express special meanings, such as the single quotation mark ', which is used as the delimiter of t...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
Inventor 郭文君
Owner ZTE CORP
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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