CN107704584B - Payment method adopting database application plug-in - Google Patents
Payment method adopting database application plug-in Download PDFInfo
- Publication number
- CN107704584B CN107704584B CN201710930811.5A CN201710930811A CN107704584B CN 107704584 B CN107704584 B CN 107704584B CN 201710930811 A CN201710930811 A CN 201710930811A CN 107704584 B CN107704584 B CN 107704584B
- Authority
- CN
- China
- Prior art keywords
- database
- application plug
- payment
- plug
- database application
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000012545 processing Methods 0.000 claims abstract description 15
- 230000003993 interaction Effects 0.000 claims abstract description 4
- 230000006870 function Effects 0.000 claims description 20
- 230000008569 process Effects 0.000 claims description 11
- 238000005516 engineering process Methods 0.000 claims description 9
- 230000002452 interceptive effect Effects 0.000 claims description 7
- 238000005538 encapsulation Methods 0.000 claims description 3
- 210000001503 joint Anatomy 0.000 abstract description 5
- 230000009466 transformation Effects 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000008676 import Effects 0.000 description 2
- 238000007689 inspection Methods 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 238000010276 construction Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000004806 packaging method and process Methods 0.000 description 1
- 238000012856 packing Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/38—Payment protocols; Details thereof
- G06Q20/382—Payment protocols; Details thereof insuring higher security of transaction
Abstract
The invention provides a payment method adopting a database application plug-in, which comprises the following steps: acquiring bottom database information adopted by all payment service systems in a hospital information system; according to the collected information of the bottom databases, all the access program packages supporting all the bottom databases are packaged to generate database application plug-ins; importing an application program in a database application plug-in into a hospital information system database; establishing a direct calling relation between each payment service system and the database application plug-in; when a user uses a certain payment service system in the hospital information system to pay, the interaction processing is carried out through the database application plug-in and the matched bottom database, and the payment and information display operation is completed. By adopting the payment method adopting the database application plug-in, which is provided by the invention, service transformation is not needed by other service systems, one-time butt joint is realized, and the access payment service of each service system of the whole hospital is completed.
Description
Technical Field
The invention relates to the field of computer databases, in particular to a payment method, a payment system and a payment terminal adopting a database application plug-in.
Background
With the development of medical informatization and the proposal of the 'Internet plus' in the government work report by the Likelong general principle, the informatization construction of hospitals must be changed from supporting the comprehensive management of hospitals to improving the humanized patient treatment service of patients. In order to facilitate the hospitalization of patients and fully and effectively utilize hospital medical resources, the hospital introduces convenience service systems such as an appointment registration system, a self-service system, a checking and examining system, a palm hospital APP, a WeChat public number, a Paibao service window and the like. In order to facilitate the payment of the related expenses for the patient, the data resources of the existing medical information system of the hospital need to be integrated, and a convenient, quick and humanized treatment service mode is created for the patient by combining various online and offline payment channels.
The existing convenient service systems such as the appointment register system, the self-service system, the inspection and examination system, the palm hospital APP, the WeChat public number, the Payment treasure service window and the like adopt programming languages which are not necessarily the programming languages supported by a database used by a hospital information system, each convenient service system has own standard and specification, when the hospital information system is accessed into each convenient service system, the hospital information system needs to be improved aiming at the convenient service system to be accessed, a module capable of being in butt joint with the convenient service system is added, otherwise, each convenient service system cannot be accessed into the hospital information system, or even after the convenient service system is accessed into the hospital information system, the convenient service system cannot necessarily realize the functions.
Disclosure of Invention
In order to solve the above problems, the present invention provides a payment method using a database application plug-in, comprising the following steps:
s110: acquiring bottom database information adopted by all payment service systems in a hospital information system;
s120: according to the collected information of the bottom databases, all the access program packages supporting all the bottom databases are packaged to generate database application plug-ins; the database application plug-in is a program set capable of quickly and effectively completing corresponding functions in the database; the database plug-in relies on corresponding database support, a program package with a specific function is realized through coding, after the program package is loaded into a database, the database plug-in is programmed and packaged by utilizing a storage process, a function and an SQL script supported by the data to form the database plug-in executable by the database;
s130: introducing the database application plug-in into a hospital information system database, and introducing an application program in the database application plug-in into the hospital information system database;
s140: establishing a direct calling relation between each payment service system and the database application plug-in;
s150: when a user uses a certain payment service system in the hospital information system to pay, the interaction processing is carried out through the database application plug-in and the matched bottom database, and the payment and information display operation is completed.
Further, the underlying database at least comprises an ORACLE database or an SQLServer database.
Furthermore, when the bottom database is an ORACLE database, the ORACLE database uses the support of the ORACLE database on the JAVA virtual machine technology to import the jar package packaged by the functional service realized by the JAVA technology into the ORACLE, and generates an ORACLE database application plug-in through the javascurute support provided by the ORACLE in combination with the ORACLE storage process or the functional encapsulation, so that the processing of calling the JAVA external service and the corresponding payment security service by the ORACLE database layer can be realized.
Further, when the bottom database is the SQLServer database, a corresponding program is written by using NET Framework language to form an SQLServer database plug-in module, so that the SQLServer database layer can call external services and process corresponding payment security services.
Further, in step S150, when the database application plug-in performs interactive processing with the matched underlying database, the database application plug-in decrypts or signs the data in the hospital information system database, so that the application program calls the data in the hospital information system database.
Further, in S150, when the database application plug-in performs interactive processing with the matched underlying database, the database application plug-in screens data in the hospital information system database according to the function of the application program.
Furthermore, the payment service system at least comprises an appointment registration system, a self-service system, a checking and checking system, an APP (application) of the palm pilot hospital, WeChat and a payment treasure.
The payment method adopting the Database application plug-in provided by the invention provides the extensible Database-level plug-in application for the HIS System on a Database (Database) System of a hospital information management System by utilizing the characteristic that other business systems of a hospital are already in butt joint with the hospital information System (HIS for short), the functions of payment services needing to be in butt joint in each business System are uniformly completed in the Database plug-in application, and the Database plug-in application completes the functions of encryption, decryption, signature and the like of data related to the payment services. Through the application of the HIS system database application plug-in, other business systems do not need to be subjected to business transformation again, one-time butt joint is realized, and the access payment business of all the business systems of the whole hospital is completed.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
FIG. 1 is a flowchart of a payment method using a database application plug-in according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a database application plug-in connected to a hospital information system database;
FIG. 3 is a schematic diagram of a database application plug-in.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The embodiment of the invention provides a payment method adopting a database application plug-in, which comprises the following steps as shown in figure 1:
s110: acquiring bottom database information adopted by all payment service systems in a hospital information system;
preferably, when the bottom database is an ORACLE database, the ORACLE database uses the support of the ORACLE database on the JAVA virtual machine technology to import a jar packet, which is obtained by packing the functional service realized by the JAVA technology, into the ORACLE, and generates an ORACLE database application plug-in through the javascurute support provided by the ORACLE in combination with an ORACLE storage process or functional encapsulation, so that the processing of calling the JAVA external service and the corresponding payment security service by the ORACLE database layer can be realized;
preferably, when the bottom database is an SQLServer database, a corresponding program is compiled by using NET Framework language to form an SQLServer database plug-in module, so that the SQLServer database layer can call external services and process corresponding payment security services;
s120: according to the collected bottom database information, all the access program packages supporting all the bottom databases are packaged to generate database application plug-ins, as shown in fig. 2;
preferably, the underlying database at least comprises an ORACLE database or an SQLServer database;
s130: introducing the database application plug-in into a hospital information system database, and introducing an application program in the database application plug-in into the hospital information system database;
s140: establishing a direct calling relation between each payment service system and the database application plug-in;
by establishing a direct calling relation between each payment service system and the database application plug-in, each service system can call data in a bottom database in the hospital information system for completing payment service;
s150: when a user uses a certain payment service system in a hospital information system to pay, the user carries out interactive processing with the matched bottom database through the database application plug-in unit to finish payment and information display operation;
preferably, in step S150, when the database application plug-in performs interactive processing with the matched underlying database, the database application plug-in decrypts or signs data in the hospital information system database, so that the application program calls the data in the hospital information system database;
preferably, in S150, when the database application plug-in performs interactive processing with the matched underlying database, the database application plug-in classifies and filters data in the hospital information system database according to the functions of the application program;
the data in the hospital information system database are classified and screened, when a certain service system is adopted for payment, the service system only calls partial data required to be adopted, and the data in the whole database does not need to be called, so that the data processing efficiency is improved. Such as: when the appointment register system is used for paying the register fee, the register system only needs to call the register fee information of the doctor to be registered and the account information of the user.
Preferably, the payment service system at least comprises an appointment registration system, a self-service system, a check and inspection system, an APP (application) of a palm pilot hospital, WeChat and a payment treasure;
the direct calling of the establishment of each business system and the hospital information system is realized through the database application plug-in, and the user can pay through clients such as an appointment register system, a self-service system, a checking and checking system, an palm hospital APP, WeChat and a payment treasure.
The application program of the service system adopts JAVA or Microsoft NET Framework language programming; the database application plug-in is a set of programs that can quickly and efficiently perform corresponding functions in the database. The method effectively solves the problems that the operation is difficult to realize or the efficiency does not meet the requirements through a database technology and an SQL script, the interaction between the database and external services is required, and the like. The database plug-in relies on corresponding database support, realizes a program package with a specific function through coding, and further performs database programming and packaging to form a program set (database plug-in) which can be executed by the database itself by using a storage process, a function and an SQL script supported by the data itself after the program package is loaded into the database. As shown in fig. 3: the database application plug-in is packaged with a plurality of language calling packages, such as: the method comprises the steps that a JAVA language calling packet and a NET Framework language calling packet are re-packaged by a database application plug-in, so that the database application plug-in can be directly connected with application programs of various service systems adopting different language programming, the database application plug-in can be connected with databases such as ORACLE, MySQL or SQL, the databases such as ORACLE, MySQL or SQL can be directly connected with application programs of the service systems adopting different databases, meanwhile, the database application plug-in decrypts and signs data in the database, and the application programs of the service systems adopting different databases to realize a payment function.
The database application plug-in depends on the technical support of the database, and the technical scheme of the database application plug-in is described by taking the fact that most HIS systems in the market use Orale and SQLServer databases as examples:
the ORACLE database utilizes the support of the ORACLE database to the JAVA virtual machine technology, a jar packet which is packaged by the functional service realized by the JAVA technology is led into the ORACLE, and a corresponding plug-in module is formed by combining the JAVASCOURCE support provided by the ORACLE with the function or the ORACLE storage process, so that the processing of calling JAVA external service and corresponding payment safety service by the ORACLE database layer can be realized;
the SQLServer database has the function of integrating with Common Language Runtime (CLR) components of Microsoft windows. CLR provides services for managed code, such as cross-language integration, code access security, object lifecycle management, and debugging and analysis support. NETFramework languages (including Microsoft Visual basic. NET and Microsoft Visual C #) are used for writing corresponding business functions to form plug-in modules, and then the SQLServer database layer can call external services and process corresponding payment security business.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.
Claims (7)
1. A payment method adopting a database application plug-in is characterized by comprising the following steps:
s110: acquiring bottom database information adopted by all payment service systems in a hospital information system;
s120: according to the collected information of the bottom databases, all the access program packages supporting all the bottom databases are packaged to generate database application plug-ins; the database application plug-in is a program set capable of quickly and effectively completing corresponding functions in the database; the database plug-in relies on corresponding database support, a program package with a specific function is realized through coding, after the program package is loaded into a database, the database plug-in is programmed and packaged by utilizing a storage process, a function and an SQL script supported by the data to form the database plug-in executable by the database;
s130: introducing the database application plug-in into a hospital information system database, and introducing an application program in the database application plug-in into the hospital information system database;
s140: establishing a direct calling relation between each payment service system and the database application plug-in;
s150: when a user uses a certain payment service system in the hospital information system to pay, the interaction processing is carried out through the database application plug-in and the matched bottom database, and the payment and information display operation is completed.
2. The payment method using the database application plug-in according to claim 1, wherein: the bottom database at least comprises an ORACLE database or an SQLServer database.
3. The payment method using the database application plug-in according to claim 2, wherein: when the bottom database is the ORACLE database, the ORACLE database utilizes the support of the ORACLE database on the JAVA virtual machine technology, and after a jar packet which is packaged by the functional service realized by the JAVA technology is imported into the ORACLE, the ORACLE database application plug-in is generated by combining the JAVASCOURCE support provided by the ORACLE with the ORACLE storage process or function encapsulation, so that the processing that the ORACLE database layer calls the JAVA external service and the corresponding payment security service can be realized.
4. The payment method using the database application plug-in according to claim 2, wherein: when the bottom database is the SQLServer database, a corresponding program is written by using NET Framework language to form an SQLServer database plug-in module, so that the SQLServer database layer can call external services and process corresponding payment security services.
5. The payment method using the database application plug-in according to claim 1, wherein: in step S150, when the database application plug-in performs interactive processing with the matched underlying database, the database application plug-in decrypts or signs the data in the hospital information system database, so that the application program calls the data in the hospital information system database.
6. The payment method using the database application plug-in according to claim 1, wherein: in S150, when the database application plug-in performs interactive processing with the matched underlying database, the database application plug-in screens data in the hospital information system database according to the function of the application program.
7. The payment method using the database application plug-in according to claim 1, wherein: the payment service system at least comprises an appointment registration system, a self-service system, a checking system, an APP (application) of a palm hospital, WeChat and a payment treasure.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710930811.5A CN107704584B (en) | 2017-10-09 | 2017-10-09 | Payment method adopting database application plug-in |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710930811.5A CN107704584B (en) | 2017-10-09 | 2017-10-09 | Payment method adopting database application plug-in |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107704584A CN107704584A (en) | 2018-02-16 |
| CN107704584B true CN107704584B (en) | 2020-06-16 |
Family
ID=61184704
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710930811.5A Active CN107704584B (en) | 2017-10-09 | 2017-10-09 | Payment method adopting database application plug-in |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107704584B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112115517A (en) * | 2020-09-24 | 2020-12-22 | 北京人大金仓信息技术股份有限公司 | Database plug-in inspection method, device, equipment and medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103761140A (en) * | 2013-11-29 | 2014-04-30 | 北京中启智源数字信息技术有限责任公司 | Method for implementing transaction processing in isomeric relational database |
| CN104794147A (en) * | 2013-12-30 | 2015-07-22 | 深圳键桥通讯技术股份有限公司 | Heterogeneous database access method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9495356B2 (en) * | 2006-03-30 | 2016-11-15 | International Business Machines Corporation | Automated interactive visual mapping utility and method for validation and storage of XML data |
-
2017
- 2017-10-09 CN CN201710930811.5A patent/CN107704584B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103761140A (en) * | 2013-11-29 | 2014-04-30 | 北京中启智源数字信息技术有限责任公司 | Method for implementing transaction processing in isomeric relational database |
| CN104794147A (en) * | 2013-12-30 | 2015-07-22 | 深圳键桥通讯技术股份有限公司 | Heterogeneous database access method |
Non-Patent Citations (1)
| Title |
|---|
| 一种智能小区异构数据库集成的解决方案;张玮 等;《智能建筑与城市信息》;20030805(第07期);第31-34页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107704584A (en) | 2018-02-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10193953B2 (en) | Self describing configuration | |
| US10586061B2 (en) | Federated search | |
| US10496837B2 (en) | Support sharing the same table for protected and non-protected data columns | |
| US10592684B2 (en) | Automatic operation detection on protected field | |
| KR20170061664A (en) | Method to modify android application life cycle to control its execution in a containerized workspace environment | |
| CN103559118A (en) | Security auditing method based on aspect oriented programming (AOP) and annotation information system | |
| US8903702B2 (en) | Generating specifications for expression language expressions and tag libraries | |
| JP7165715B2 (en) | Automatic motion detection on protected fields with support for federated search | |
| Xu et al. | A distributed dynamic authorisation method for Internet+ medical & healthcare data access based on consortium blockchain | |
| CN108091384A (en) | A kind of medical image processing system based on micro services frame | |
| US20120198417A1 (en) | Static Analysis of Computer Software Applications Having A Model-View-Controller Architecture | |
| CN105184152A (en) | Mobile terminal data processing method | |
| CN112100676A (en) | Clinical trial information access method and device | |
| CN107704584B (en) | Payment method adopting database application plug-in | |
| Soto-Rey et al. | Implementation of an ODM and HL7 compliant electronic patient-reported outcome system | |
| US11803786B2 (en) | Enterprise integration platform | |
| CN103761698A (en) | Patient administration system for real world clinical study | |
| CN114978649B (en) | Information security protection method, device, equipment and medium based on big data | |
| CN104521209A (en) | Method and system for providing customized network | |
| CN113535565B (en) | Interface use case generation method, device, equipment and medium | |
| CN113779528A (en) | Multi-system front-end page integration method, device, equipment and medium | |
| Odusote et al. | Towards a well-secured electronic health record in the health cloud | |
| KR20150129532A (en) | Method and system for providing medical work memu | |
| Nedaković et al. | Hyperledger fabric platform for healthcare trust relations—Proof-of-Concept | |
| CN112149106B (en) | Login method, device, equipment and medium of enterprise private applet |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20240119 Address after: 361008, No.1 504, No. 18 Guanri Road, Software Park Phase II, Xiamen City, Fujian Province Patentee after: XIAMEN YILIANZHONG YIHUI TECHNOLOGY CO.,LTD. Address before: 361008 Room 502, No.18, guanri Road, phase II, software park, Xiamen City, Fujian Province Patentee before: YLZ INFORMATION TECHNOLOGY Co.,Ltd. Patentee before: XIAMEN YILIANZHONG YIHUI TECHNOLOGY CO.,LTD. |
|
| TR01 | Transfer of patent right |