SQL语句配置方法、装置及电子设备
By establishing mapping entity classes and operation instance classes in a centralized database, generating and executing target SQL statements, the problem of poor compatibility of traditional ORM frameworks with tabular data is solved, and effective support for electronic accounting archive data is achieved.
CN115576980BActive Publication Date: 2026-07-17北京合思信息技术有限公司
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- 北京合思信息技术有限公司
- Filing Date
- 2022-11-10
- Publication Date
- 2026-07-17
AI Technical Summary
Technical Problem
Traditional ORM frameworks have poor compatibility with tabular data (such as JSON and XML data), making them unsuitable for applications involving electronic accounting records.
Method used
By establishing mapping entity classes and operation instance classes, and based on the centralized database structure, the target SQL statement is generated and executed to achieve compatibility with tabular data documents.
Benefits of technology
It improves the compatibility of centralized databases with tabular data, meeting the application needs of electronic accounting records.
✦ Generated by Eureka AI based on patent content.
Smart Images
Figure CN115576980B_ABST
Abstract
本发明提供了一种SQL语句配置方法、装置及电子设备，将预设框架与用于存储多个表格数据文档的中心化数据库连接；基于中心化数据库的数据库结构，建立映射实体类；基于预设框架所需的业务操作，建立操作实例类；在发生目标业务操作时，通过预设框架根据操作实例类和映射实体类获取目标业务操作对应的目标SQL语句，并将目标SQL语句传输给中心化数据库；通过中心化数据库执行目标SQL语句，并获取目标SQL语句的执行结果。采用本发明可以缓解传统ORM框架对表格格式数据兼容性较差的问题，从而满足接入各类电子会计档案数据的应用需求。
Need to check novelty before this filing date? Find Prior Art