CN102609263A - Component and implementation method for implementing WEBSERVICE transaction control through PB12 (power builder 12) - Google Patents

Component and implementation method for implementing WEBSERVICE transaction control through PB12 (power builder 12) Download PDF

Info

Publication number
CN102609263A
CN102609263A CN2012100306925A CN201210030692A CN102609263A CN 102609263 A CN102609263 A CN 102609263A CN 2012100306925 A CN2012100306925 A CN 2012100306925A CN 201210030692 A CN201210030692 A CN 201210030692A CN 102609263 A CN102609263 A CN 102609263A
Authority
CN
China
Prior art keywords
webservice
transaction
affairs
sql
data window
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.)
Pending
Application number
CN2012100306925A
Other languages
Chinese (zh)
Inventor
王常林
任彦青
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Inspur Group Shandong General Software Co Ltd
Original Assignee
Inspur Group Shandong General Software Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Inspur Group Shandong General Software Co Ltd filed Critical Inspur Group Shandong General Software Co Ltd
Priority to CN2012100306925A priority Critical patent/CN102609263A/en
Publication of CN102609263A publication Critical patent/CN102609263A/en
Pending legal-status Critical Current

Links

Images

Abstract

The invention discloses a component and an implementation method for implementing WEBSERVICE transaction control through a PB12 (power builder 12), which belong to the technical field of computer application. The implementation method is characterized by A, implementing uniform transaction objects, providing registration transaction objects for a client side and having uniform properties and methods; B, implementing uniform database SQL (structured query language) execution objects for executing SQL commands through the transaction objects; C, implementing uniform data window objects and exchanging the data window objects with a database through a data window of the PB by the aid of the client side; and D, implementing uniform registration transaction objects and registering and canceling transactions through the registration transaction objects by the aid of the client side. Compared with the prior art, the component and the implementation method for implementing WEBSERVICE transaction control through the PB12 solve the problem that a developer cannot control transactions through Webservice, improve development inexpensiveness, and have excellent popularization and application values.

Description

Realize the assembly and the implementation method of the control of WEBSERVICE affairs through PB12
 
Technical field
The present invention relates to Computer Applied Technology, specifically a kind of assembly and implementation method that realizes the control of WEBSERVICE affairs through PB12.
Background technology
In Traditional Web service exploitation system, affairs control requires to submit to the necessary disposable submission of affairs generally through single affairs control, and is more to developer's restriction ratio under this background, causes bad processing code under some situation.Such as, in Webservice, require each client in oneself viewing content within the affairs independently.Difficult realization the in this former exploitation system.
Summary of the invention
Technical assignment of the present invention is the deficiency to above-mentioned prior art, and a kind of assembly and implementation method that realizes the control of WEBSERVICE affairs through PB12 is provided.Utilize this method developer just can registration transactions arrive server end in client, service end is returned affairs ID after the success, and the user is through the affairs of this ID Control Server end.
Technical assignment of the present invention is realized by following mode: the assembly through PB12 realizes the control of WEBSERVICE affairs is characterized in:
A, the unified transaction object of realization provide client registration transactions object, have unified attribute and method;
B, realization unified data storehouse SQL carry out object, and this object is carried out sql command through transaction object;
C, realization unified data window object, client can be mutual with database through the data window of PB with this object;
D, the unified registration transactions object of realization, client is through these object Register Cancel affairs.
Among the A:
Said transaction object connects database;
Transaction object is responsible for rollback and is submitted client transaction to;
Database linkage information is set.
Among the B:
SQL carries out object and carries out SQL through transaction object;
SQL carries out object can obtain database information, carries out the SQL grammer of appointment.
Among the C:
The data window object passes through transaction object alternately with database;
Can form the database grammer according to SQL statement;
According to data window grammer refresh data that imports into and return data window grammer;
Data window grammer according to importing into Updates Information.
The method that realizes the control of WEBSERVICE affairs through PB12 may further comprise the steps:
A, set up the discernible class libraries of Framwork through PB12, client transaction is through this class libraries Register Cancel and operation affairs;
B, in Framwork, quote the class libraries that uses PB12 to create, and be issued as IIS;
C, be the Webservice object encapsulation interface object, all are realized through this object with the Webservice interactive action.
Further, steps A comprises:
A, according to the different objects of difference in functionality module creation, comprise and carry out SQL object, service data window object;
B, the unified transaction object of use;
Unified interface object is used in c, external issue.
Compared with prior art, the developer can realize the affairs control of remote server through method of the present invention in software, and solving the developer can't be through the problem of Webservice control affairs.
The developer disposes assembly of the present invention in development environment, through this assembly claimed alternative, accesses remote databases can reach the purpose of control affairs, has effectively reduced code development quantity, has improved the cheap property of exploitation.
Description of drawings
Accompanying drawing 1 is that the present invention calls schematic diagram through the exploitation of PB12 realization WEBSERVICE affairs Control Component.
Embodiment
Realize assembly and implementation method work below at length explanation that WEBSERVICE affairs control to of the present invention through PB12 with specific embodiment with reference to Figure of description.
Embodiment:
Of the present inventionly realize that through PB12 the characteristics of the assembly of WEBSERVICE affairs control are:
A, the unified transaction object of realization provide client registration transactions object, have unified attribute and method:
Said transaction object connects database;
Transaction object is responsible for rollback and is submitted client transaction to;
Database linkage information is set.
B, realization unified data storehouse SQL carry out object, and this object is carried out sql command through transaction object:
SQL carries out object and carries out SQL through transaction object;
SQL carries out object can obtain database information, carries out the SQL grammer of appointment.
C, realization unified data window object, client can be mutual with database through the data window of PB with this object:
The data window object passes through transaction object alternately with database;
Can form the database grammer according to SQL statement;
According to data window grammer refresh data that imports into and return data window grammer;
Data window grammer according to importing into Updates Information.
Shown in accompanying drawing 1, implementation procedure is following:
1. set up the discernible class libraries of Framwork through PB12, client transaction is through this class libraries Register Cancel and operation affairs.
A), comprise at present and carry out SQL object, service data window object etc. according to the different objects of difference in functionality module creation;
A1) it is following to carry out the public function that the SQL object comprises:
A2) the public function of service data window is following:
Figure 201210030692510000200041
B) use unified transaction object;
C) externally unified interface object is used in issue, and externally the common interface of issue is following:
Figure 201210030692510000200042
Figure 201210030692510000200051
Figure 201210030692510000200061
2. in Framwork, quote the class libraries that uses PB12 to create, and be issued as IIS
A) according to unified external interface object in the class libraries of PB12 establishment, issue Webservice calls;
B) it is following that the Webservice that issues can call function list:
PbCloseTrans
PbCommitTrans
PbCreateTab
PbCreateTabWithIndex
PbDwSaveByState
PbExecProc
PbExecSql
PbExecSqlArray
PbGetDSBlob
PbGetDSBlobArgString
PbGetSelectValues
PbGetSelectValuesArray
PbGetSelectValuesBlob
PbGetSelectValuesBlobNet
PbGetSelectValuesCursor
PbOpenTrans
PbReconnectTrans
PbRegLogin
PbRetrieveDS
PbRetrieveDSArgString
PbRollbackTrans
PbSelectToDSBlob
PbSetAutoCommit
PbSetGlobalVariables
PbSetTransParm
PbSetUpdateBlob
PbSyntaxFromSql
PbTestOne
PbUnRegTrans
RegPbTransAction
3. in the PB development environment, encapsulate the Webservice object
A) be the Webservice object encapsulation interface object, all are realized through this object with the Webservice interactive action.
In the PB12 development environment, form the PB12 object to the Webservice method of issue in 2 through acting on behalf of guide, and further expand this object, so that the developer calls.Call method is following:
1. the developer realizes function corresponding through invocation component when software is realized;
2. call method is following:
Developed Webservice transaction object nvo_psp_connection, wherein encapsulated various long-range control methods, concrete grammar is explained as follows:
Close affairs:
of_closetrans()
Create table
of_createtab()
Carry out SQL
of_exec_sql()
Obtain the Select data
Of_get_select_values()
Login
Of_login()
The retrieve data window
Of_retrieve()
Submit affairs to
Of_trans_commit()
The rollback affairs
Of_trans_rollback()
Window Updates Information
Of_update()
Upgrade big binary approach
Of_updateBlob()
Obtain big binary approach
Of_selectBlob()

Claims (6)

1. realize the assembly of WEBSERVICE affairs control through PB12, it is characterized in that,
A, the unified transaction object of realization provide client registration transactions object, have unified attribute and method;
B, realization unified data storehouse SQL carry out object, and this object is carried out sql command through transaction object;
C, realization unified data window object, client can be mutual with database through the data window of PB with this object;
Realize unified registration transactions object, client is through these object Register Cancel affairs.
2. the assembly through the control of PB12 realization WEBSERVICE affairs according to claim 1 is characterized in that, among the A:
Said transaction object connects database;
Transaction object is responsible for rollback and is submitted client transaction to;
Database linkage information is set.
3. the assembly through the control of PB12 realization WEBSERVICE affairs according to claim 1 is characterized in that, among the B:
SQL carries out object and carries out SQL through transaction object;
SQL carries out object can obtain database information, carries out the SQL grammer of appointment.
4. the assembly through the control of PB12 realization WEBSERVICE affairs according to claim 1 is characterized in that, among the C:
The data window object passes through transaction object alternately with database;
Can form the database grammer according to SQL statement;
According to data window grammer refresh data that imports into and return data window grammer;
Data window grammer according to importing into Updates Information.
5. realize the method for WEBSERVICE affairs control through PB12, it is characterized in that may further comprise the steps:
A, set up the discernible class libraries of Framwork through PB12, client transaction is through this class libraries Register Cancel and operation affairs;
B, in Framwork, quote the class libraries that uses PB12 to create, and be issued as IIS;
C, be the Webservice object encapsulation interface object, all are realized through this object with the Webservice interactive action.
6. the method that realizes the control of WEBSERVICE affairs through PB12 according to claim 5 is characterized in that steps A comprises:
A, according to the different objects of difference in functionality module creation, comprise and carry out SQL object, service data window object, things management object, operation flow controlling object;
B, the unified transaction object of use;
Unified interface object is used in c, external issue.
CN2012100306925A 2012-02-13 2012-02-13 Component and implementation method for implementing WEBSERVICE transaction control through PB12 (power builder 12) Pending CN102609263A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2012100306925A CN102609263A (en) 2012-02-13 2012-02-13 Component and implementation method for implementing WEBSERVICE transaction control through PB12 (power builder 12)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2012100306925A CN102609263A (en) 2012-02-13 2012-02-13 Component and implementation method for implementing WEBSERVICE transaction control through PB12 (power builder 12)

Publications (1)

Publication Number Publication Date
CN102609263A true CN102609263A (en) 2012-07-25

Family

ID=46526662

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2012100306925A Pending CN102609263A (en) 2012-02-13 2012-02-13 Component and implementation method for implementing WEBSERVICE transaction control through PB12 (power builder 12)

Country Status (1)

Country Link
CN (1) CN102609263A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103246517A (en) * 2013-05-21 2013-08-14 浪潮集团山东通用软件有限公司 Method for smart client programs to invoke web services to achieve database transaction persistence
CN114138829A (en) * 2020-09-03 2022-03-04 金篆信科有限责任公司 Method, system and network equipment for sharing Prepare State

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5566330A (en) * 1991-08-20 1996-10-15 Powersoft Corporation Method for forming a reusable and modifiable database interface object
CN102254024A (en) * 2011-07-27 2011-11-23 国网信息通信有限公司 Mass data processing system and method

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5566330A (en) * 1991-08-20 1996-10-15 Powersoft Corporation Method for forming a reusable and modifiable database interface object
CN102254024A (en) * 2011-07-27 2011-11-23 国网信息通信有限公司 Mass data processing system and method

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
佚名: "《通用类库和业务类库的设计思想》", 《HTTP://WWW.TH7.CN/ARTICLE/BC/PB/200801/88467.HTML》 *
杨小平: "《浅谈PowerBuilder中动态DataWindow的技术应用》", 《现代计算机》 *
莫问奴归处: "《web service中的事务控制》", 《HTTP://WWW.CNBLOGS.COM/CHINHR/ARCHIVE/2010/04/16/1713514.HTML》 *

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103246517A (en) * 2013-05-21 2013-08-14 浪潮集团山东通用软件有限公司 Method for smart client programs to invoke web services to achieve database transaction persistence
CN114138829A (en) * 2020-09-03 2022-03-04 金篆信科有限责任公司 Method, system and network equipment for sharing Prepare State
WO2022048390A1 (en) * 2020-09-03 2022-03-10 中兴通讯股份有限公司 Method for sharing prepare statement, system, network device, and storage medium

Similar Documents

Publication Publication Date Title
US11170002B2 (en) Integrating Kafka data-in-motion with data-at-rest tables
US10706046B2 (en) Metadata-based general request translator for distributed computer systems
CN101408899B (en) Method and apparatus for switching website multiple data sources
US8645973B2 (en) Mobile applications
US20030167456A1 (en) Architecture for building scalable object oriented web database applications
JP2019533854A (en) Graph generation for distributed event processing systems.
EP2386965A1 (en) Performing complex operations in a database using a semantic layer
CN105955208B (en) Network robot data control system based on cloud platform
EP2352101A1 (en) Data processing device and processing method of web page
US20110106853A1 (en) Declarative model security pattern
US10318359B2 (en) Techniques to remotely access object events
CN109194762B (en) SSH-based soil information network publishing system and method
CN102209111A (en) Open cross-platform system for cloud computing mobile network terminal equipment
US9563650B2 (en) Migrating federated data to multi-source universe database environment
CN103902283B (en) Method for achieving real-time asynchronous communication through model transformation in CORBA
CN103530425A (en) Android terminal remote data base access code generation system and method based on object dependence mapping
CN104252501A (en) Computing equipment and method for executing database operating command
CN102523200A (en) Internet of things information processing method
CN109254808A (en) Interface call method, device and computer readable storage medium
US20090328043A1 (en) Infrastructure of data summarization including light programs and helper steps
CN101436184B (en) Batch data operating method
Byun et al. Oliot epcis: Engineering a web information system complying with epc information services standard towards the internet of things
CN105138646A (en) Database operation method based on Hibernate
CN102945264B (en) Method for intelligently starting distributed transaction
CN103152433A (en) Distributed server side framework and use, interaction and request processing method thereof

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C02 Deemed withdrawal of patent application after publication (patent law 2001)
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20120725