Supercharge Your Innovation With Domain-Expert AI Agents!

FMDB-based SQL statement encapsulation method

An encapsulation method and statement technology, applied in special data processing applications, instruments, electrical and digital data processing, etc., can solve problems such as inconvenience and unfriendly use of SQLiteAPI, and achieve the effect of clear structure, improved development efficiency, and easy implementation.

Active Publication Date: 2018-03-20
BEIJING KUWO TECH
View PDF9 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the native SQLite API is quite unfriendly in use, and it is very inconvenient to use

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
  • FMDB-based SQL statement encapsulation method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0035] Such as figure 1 As shown, the FMDB-based SQL statement encapsulation method of the present invention comprises the steps:

[0036] In the FM interface layer, create a UserDBManager class to manage the user database,

[0037] The UserDBManager class generates an object and calls the method: AllModel(), which internally calls the FMDB wrapper function:

[0038] table function, used to specify the table in the user database, figure 1 In the illustrated embodiment, the user table is specified, that is, the user table,

[0039] selectArray function, used to specify the operation to be performed, figure 1 In the illustrated embodiment, the selectarray instruction is specified, that is, an array is selected, and a nil object is specified to be selected,

[0040] append function, for specifying optional append directives, figure 1 In the illustrated emb...

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 relates to an FMDB-based SQL statement encapsulation method. The FMDB-based SQL statement encapsulation method includes the following steps that in an FM interface layer, a UserDBManagerclass for managing a user database is created, wherein the UserDBManager class generates an object and calls a method: AllModel(), the method internally calls FMDB encapsulation functions: a table function used for specifying tables in the user database, a selectArray function used for specifying operations to be performed, and an additional function used for specifying optional additional instructions, and after the above parameters are received and parsed, the UserDBManager class encapsulates the parsed result through a commit instruction and transmits the parsed result to an SQL executionlayer for processing. The FMDB-based SQL statement encapsulation method has a clear structure and easy implementation, simplifies the code writing amount of an SQL statement, is beneficial to the improvement of the development efficiency, and reduces errors caused by repeated work in programming.

Description

technical field [0001] The invention relates to the technical field of SQLite API encapsulation, in particular to an FMDB-based SQL statement encapsulation method. Background technique [0002] The iOS SDK has supported SQLite for a long time. When using it, you only need to add the libsqlite3.dylib dependency and import the sqlite3.h header file. However, the native SQLite API is quite unfriendly in use, and it is very inconvenient to use. Contents of the invention [0003] For the defects existing in the prior art, the purpose of the present invention is to provide a method for encapsulating SQL statements based on FMDB. Based on FMDB, the structure is clear, easy to implement, and simplifies the amount of code written in SQL statements, which is conducive to improving development efficiency and reducing Errors caused by duplication of effort in programming. [0004] For achieving above object, the technical scheme that the present invention takes is: [0005] A metho...

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 Applications(China)
IPC IPC(8): G06F17/30G06F8/30
CPCG06F8/315G06F16/2433
Inventor 郭艳杰
Owner BEIJING KUWO TECH
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