CN103020171A - Java-based data access method of electric power ERP (Enterprise Resource Planning) business simulation system - Google Patents
Java-based data access method of electric power ERP (Enterprise Resource Planning) business simulation system Download PDFInfo
- Publication number
- CN103020171A CN103020171A CN2012104902231A CN201210490223A CN103020171A CN 103020171 A CN103020171 A CN 103020171A CN 2012104902231 A CN2012104902231 A CN 2012104902231A CN 201210490223 A CN201210490223 A CN 201210490223A CN 103020171 A CN103020171 A CN 103020171A
- Authority
- CN
- China
- Prior art keywords
- data
- executable code
- tree structure
- java
- execution
- 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.)
- Granted
Links
Images
Abstract
The invention discloses a Java-based data access method of an electric power ERP (Enterprise Resource Planning) business simulation system. The data access method comprises two steps of processing data on a backstage and displaying the data on a front stage. The data access method refers to data interaction between a Visual Graph and a databank and is realized through the mutual communication among Java, JavaScript and Vg, wherein Java is in charge of checking data and organizing a Vg script; the JavaScript is in charge of initializing access parameters and scheduling a Vg interface; and the Vg is in charge of analyzing script sentences generated from a Java and configuring checking information. According to the data access method, the interaction process of an IE (Internet Explorer), a Visual Graph and a databank is realized by using Servlet and JavaScript as the core technology, so that a display effect which is completely identical to a real electric power ERP system is realized.
Description
Technical field
The present invention relates to a kind of data access method, particularly a kind of electric power ERP business simulating system data access method based on Java.
Background technology
The ERP of SAP is quite extensive in whole world range of application, and is along with the Chinese foreign opening deepens continuously, more and more with international association, simultaneously because the strong request of Chinese Enterprise, ERP one introduces China, has namely obtained the welcome of many enterprises, and extensively begins to use.Because China's thinking habit and mode of doing things in the past, different very large with the ERP pattern, therefore, the student is far from suitable to mode from custom, this has been produced resentment, work efficiency is very low, has had a strong impact on the work in every of enterprise, and then is having a strong impact on the development of enterprise, although the leader of enterprise also recognizes this point, carried out a large amount of trainings, training also had certain effect at that time, but got back to again after a while original shape.By a large amount of investigations, find that training method is when needing training, to buy or lease corresponding hardware device, build corresponding software and Training Environment, remove immediately after having trained.This training method has high input, and is time-consuming bothersome, and hold training needs thought long on, and can only carry out limited training.ERP is an extraordinary software really, and implement ERP drops into also very huge, and also expensive manpower and energy if do not bring into play its effectiveness, are wasted too large really.
Since the enforcement of provincial electric power company our department and each subordinate unit, each business department was more and more higher to the dependence of system in routine duties from national grid " SG-186 " engineering in 2006, and the knowledge that the staff needs to be grasped is more, requires also more and more higher.The flow process of each operation system is complicated, and module is numerous, and indivedual operation systems also relate to ripe package software (SAP system).
Along with the staff straining is needed, demand setting up a cover urgently for each operation system, the analogue system that particularly emphasis, difficult point module in the operation system is giveed training.
The provincial electric power company business simulating is not building of simple each operation system simulated environment.The service analogue system refers in an enclosed environment to install and disposes a cover and the similar system of actual production environment, and has the function consistent with production system, and except adopting cut-and-dried simulated data to carry out system's exercise, other and real system are the same.
The construction of analogue system is not only a simulation that reaches original system, more urgent target is by the simulation to original system, give target and the means of student's study, learn use procedure the student and can give relevant prompting and the helps such as professional knowledge, operating function, by study and the use of analogue system, reach the relevant professional knowledge of comprehensive grasp and the operational applications of operation system.
Existing analogue system can not produce and the identical display effect of true electric power ERP system, because the difference of effect data, interfacial effect, be unfavorable for that the student uses the work of true electric power ERP system after finishing emulation training, therefore the existing analogue system of necessary improvement.
Summary of the invention
The object of the invention is to overcome the deficiencies in the prior art, a kind of electric power ERP business simulating system data access method based on Java that can realize with the identical display effect of true electric power ERP system is provided.
The objective of the invention is to be achieved through the following technical solutions: based on the electric power ERP business simulating system data access method of Java, it comprises that data background process and data front end show two steps, and described data background process step comprises following substep:
S101: obtain URL from front end, URL is resolved, and the parameter among the URL comprises that the corresponding identification field name of data query table tableName, the initial query node startID of tree structure, foreground display field query, system code identifier and tables of data flag, tree structure allow maximum level treeLevel, appointment level display field fixField, query filter condition filter and the initial inquiring position start of showing;
S102: by tableName, startID, query, flag, treeLevel, filter generated query SQL, front end is shown that object data List inquires about, by tableName inquiry system data dictionary, obtain data field and show length M ap in the data of front end, by flag inquiry system code, obtain the icon type that data show at front end;
S103: if emulated data List is that sky or start are big or small more than or equal to List, then run time version is set to " 1 ", and returns run time version; Otherwise execution in step 4;
S104: beginning searching loop emulated data List, initialization father node array parent[] and temporary variable;
S105: obtain emulated data object tempObj;
S106: travel through each field of emulated data, according to the data dictionary normative field length of configuration, deficiency is used the space polishing, exceed that part is used " ... " replace;
S107: judge the hierarchical relationship of current traversal object and last traversal object, be designated as the father node of present node greater than the position that is then traveled through object the last time, and upgrade the parent[level]=the last position that travels through object;
S108: upgrade current traversal object level, in next time circulation, use;
S109: according to emulated data tempObj, icon type, parent[] generate VG and can carry out shell script TreeView, Addltem ();
S110: if the executable code that existing executable code+current circulation generates〉executable code length of VG, upgrade the start=current location, stop to load executable code, jump out circulation, execution in step 14; Otherwise execution in step 11;
S111: this circulation run time version is added in executable code;
S112: if the List traversal is finished or initial loading position〉show maximum length, upgrade the length of start=List;
S113: execution in step 14;
S114: after circulation finishes, before executable code, add initial inquiring position start, and cut apart with ": " and executable code;
Described data front end step display comprises following substep:
When the S201:VG control shows, call tree structure TreeView.clear () and empty all data;
S202: if background access URL is empty, then tree structure is carried out initialization, show tree structure, this tree structure is blank tree structure, otherwise execution in step 3;
S203: call function TreeView.BeginUpdate () starts tree-like more new things;
S204: call VG interface GetUrl (), URL is carried out database background application inquiry as parameter, and to obtain rreturn value be run time version;
S205: if run time version=" 1 ", the expression data have been inquired about and have been finished, and jump out circulation, execution in step 8, otherwise execution in step 6;
S206: run time version is decomposed into current cut-off operating position and executable code;
S207: upgrade the value of start among the URL, and call VG interface Execute () and carry out executable code, invocation step 4;
S208: call function TreeView.EndUpdate () finishes tree-like more new things;
S209: show tree structure.
Tree-like displaying TreeView of the present invention mainly realizes the tree-like displaying of data, and its Key Functions is described as follows:
Addltem (Aparent, AValue, AType, ALevel, AExpand, AObject): for tree structure is added node, wherein, Aparent is father node, and root node is that 0, AValue is the node display Name, AType is node corresponding icon explicit identification, ALevel is node place level, and AExpand is whether node launches, and AObject is the node object data;
BeginUpdate (): upgrade tree-like things and start;
EndUpdate (): upgrade tree-like things and finish;
Clear (): empty tree-like all data.
The invention has the beneficial effects as follows: the present invention has realized the reciprocal process of IE, Visual Graph and database as core technology take Servlet and JavaScript, can realize and the identical display effect of true electric power ERP system.
Description of drawings
Fig. 1 is the process flow diagram of the background process of data among the present invention;
Fig. 2 is the process flow diagram that the foreground of data among the present invention shows.
Embodiment
Below in conjunction with accompanying drawing technical scheme of the present invention is described in further detail, but protection scope of the present invention is not limited to the following stated.
Based on the electric power ERP business simulating system data access method of Java, it comprises that data background process and data front end show two steps, and as shown in Figure 1, described data background process step comprises following substep:
S101: obtain URL from front end, URL is resolved, and the parameter among the URL comprises that the corresponding identification field name of data query table tableName, the initial query node startID of tree structure, foreground display field query, system code identifier and tables of data flag, tree structure allow maximum level treeLevel, appointment level display field fixField, query filter condition filter and the initial inquiring position start of showing;
S102: by tableName, startID, query, flag, treeLevel, filter generated query SQL, front end is shown that object data List inquires about, by tableName inquiry system data dictionary, obtain data field and show length M ap in the data of front end, by flag inquiry system code, obtain the icon type that data show at front end;
S103: if emulated data List is that sky or start are big or small more than or equal to List, then run time version is set to " 1 ", and returns run time version; Otherwise execution in step 4;
S104: beginning searching loop emulated data List, initialization father node array parent[] and temporary variable;
S105: obtain emulated data object tempObj;
S106: travel through each field of emulated data, according to the data dictionary normative field length of configuration, deficiency is used the space polishing, exceed that part is used " ... " replace;
S107: judge the hierarchical relationship of current traversal object and last traversal object, be designated as the father node of present node greater than the position that is then traveled through object the last time, and upgrade the parent[level]=the last position that travels through object;
S108: upgrade current traversal object level, in next time circulation, use;
S109: according to emulated data tempObj, icon type, parent[] generate VG and can carry out shell script TreeView, Addltem ();
S110: if the executable code that existing executable code+current circulation generates〉executable code length of VG, upgrade the start=current location, stop to load executable code, jump out circulation, execution in step 14; Otherwise execution in step 11;
S111: this circulation run time version is added in executable code;
S112: if the List traversal is finished or initial loading position〉show maximum length, upgrade the length of start=List;
S113: execution in step 14;
S114: after circulation finishes, before executable code, add initial inquiring position start, and cut apart with ": " and executable code;
As shown in Figure 2, described data front end step display comprises following substep:
When the S201:VG control shows, call tree structure TreeView.clear () and empty all data;
S202: if background access URL is empty, then tree structure is carried out initialization, show tree structure, this tree structure is blank tree structure, otherwise execution in step 3;
S203: call function TreeView.BeginUpdate () starts tree-like more new things;
S204: call VG interface GetUrl (), URL is carried out database background application inquiry as parameter, and to obtain rreturn value be run time version;
S205: if run time version=" 1 ", the expression data have been inquired about and have been finished, and jump out circulation, execution in step 8, otherwise execution in step 6;
S206: run time version is decomposed into current cut-off operating position and executable code;
S207: upgrade the value of start among the URL, and call VG interface Execute () and carry out executable code, invocation step 4;
S208: call function TreeView.EndUpdate () finishes tree-like more new things;
S209: show tree structure.
Tree-like displaying TreeView of the present invention mainly realizes the tree-like displaying of data, and its Key Functions is described as follows:
Addltem (Aparent, AValue, AType, ALevel, AExpand, AObject): for tree structure is added node, wherein, Aparent is father node, and root node is that 0, AValue is the node display Name, AType is node corresponding icon explicit identification, ALevel is node place level, and AExpand is whether node launches, and AObject is the node object data;
BeginUpdate (): upgrade tree-like things and start;
EndUpdate (): upgrade tree-like things and finish;
Clear (): empty tree-like all data.
Visual Graph is Vg, and the data interaction between the database realizes by Java, JavaScript, Vg three's intercommunication, and wherein Java is responsible for the inquiry of data and organizes the Vg script; JavaScript is responsible for initialization, the Vg interface interchange of access parameter; Vg is responsible for resolving script sentence, the configuration querying information that the Java end generates.
Claims (2)
1. based on the electric power ERP business simulating system data access method of Java, it is characterized in that: it comprises that data background process and data front end show two steps, and described data background process step comprises following substep:
S101: obtain URL from front end, URL is resolved, and the parameter among the URL comprises that the corresponding identification field name of data query table tableName, the initial query node startID of tree structure, foreground display field query, system code identifier and tables of data flag, tree structure allow maximum level treeLevel, appointment level display field fixField, query filter condition filter and the initial inquiring position start of showing;
S102: by tableName, startID, query, flag, treeLevel, filter generated query SQL, front end is shown that object data List inquires about, by tableName inquiry system data dictionary, obtain data field and show length M ap in the data of front end, by flag inquiry system code, obtain the icon type that data show at front end;
S103: if emulated data List is that sky or start are big or small more than or equal to List, then run time version is set to " 1 ", and returns run time version; Otherwise execution in step 4;
S104: beginning searching loop emulated data List, initialization father node array parent[] and temporary variable;
S105: obtain emulated data object tempObj;
S106: travel through each field of emulated data, according to the data dictionary normative field length of configuration, deficiency is used the space polishing, exceed that part is used " ... " replace;
S107: judge the hierarchical relationship of current traversal object and last traversal object, be designated as the father node of present node greater than the position that is then traveled through object the last time, and upgrade the parent[level]=the last position that travels through object;
S108: upgrade current traversal object level, in next time circulation, use;
S109: according to emulated data tempObj, icon type, parent[] generate VG and can carry out shell script TreeView, Addltem ();
S110: if the executable code that existing executable code+current circulation generates〉executable code length of VG, upgrade the start=current location, stop to load executable code, jump out circulation, execution in step 14; Otherwise execution in step 11;
S111: this circulation run time version is added in executable code;
S112: if the List traversal is finished or initial loading position〉show maximum length, upgrade the length of start=List;
S113: execution in step 14;
S114: after circulation finishes, before executable code, add initial inquiring position start, and cut apart with ": " and executable code;
Described data front end step display comprises following substep:
When the S201:VG control shows, call tree structure TreeView.clear () and empty all data;
S202: if background access URL is empty, then tree structure is carried out initialization, show tree structure, this tree structure is blank tree structure, otherwise execution in step 3;
S203: call function TreeView.BeginUpdate () starts tree-like more new things;
S204: call VG interface GetUrl (), URL is carried out database background application inquiry as parameter, and to obtain rreturn value be run time version;
S205: if run time version=" 1 ", the expression data have been inquired about and have been finished, and jump out circulation, execution in step 8, otherwise execution in step 6;
S206: run time version is decomposed into current cut-off operating position and executable code;
S207: upgrade the value of start among the URL, and call VG interface Execute () and carry out executable code, invocation step 4;
S208: call function TreeView.EndUpdate () finishes tree-like more new things;
S209: show tree structure.
2. the electric power ERP business simulating system data access method based on Java according to claim 1 is characterized in that: described tree-like displaying TreeView, mainly realize the tree-like displaying of data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210490223.1A CN103020171B (en) | 2012-11-27 | 2012-11-27 | Based on the electric power ERP business simulating system data access method of Java |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210490223.1A CN103020171B (en) | 2012-11-27 | 2012-11-27 | Based on the electric power ERP business simulating system data access method of Java |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103020171A true CN103020171A (en) | 2013-04-03 |
| CN103020171B CN103020171B (en) | 2015-10-14 |
Family
ID=47968775
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210490223.1A Active CN103020171B (en) | 2012-11-27 | 2012-11-27 | Based on the electric power ERP business simulating system data access method of Java |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103020171B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106201880A (en) * | 2016-07-12 | 2016-12-07 | 上海恒企教育培训有限公司 | A kind of ERP business simulating system and fast construction method thereof |
| CN108073706A (en) * | 2017-12-20 | 2018-05-25 | 北京四方继保自动化股份有限公司 | A kind of method of analogue system history library longitudinal data transverse directionization displaying |
| CN110297626A (en) * | 2019-05-23 | 2019-10-01 | 唐山钢铁集团有限责任公司 | Tree-like display methods based on SAP system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5999941A (en) * | 1997-11-25 | 1999-12-07 | Micron Electronics, Inc. | Database access using active server pages |
| US20030112274A1 (en) * | 2001-12-13 | 2003-06-19 | Yang Gao | System and method for retrieving and editing the data structure of an HTML UI control |
| CN101169716A (en) * | 2007-11-30 | 2008-04-30 | 清华大学 | Emulated procedure information modeling and maintenance method based on product structural tree |
| CN101510207A (en) * | 2009-02-26 | 2009-08-19 | 中兴通讯股份有限公司 | Tree menu dynamic maintenance method and apparatus based on web page |
| US20120110515A1 (en) * | 2010-10-28 | 2012-05-03 | Cary Scott Abramoff | User interface for a digital content management system |
| CN102446221A (en) * | 2011-12-22 | 2012-05-09 | 南京联创科技集团股份有限公司 | Dynamic tree structured directory retrieval method in BS (browser/server) structure software |
| CN102520933A (en) * | 2011-11-28 | 2012-06-27 | 深圳市五巨科技有限公司 | Method and device for establishing tree menu based on user right |
-
2012
- 2012-11-27 CN CN201210490223.1A patent/CN103020171B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5999941A (en) * | 1997-11-25 | 1999-12-07 | Micron Electronics, Inc. | Database access using active server pages |
| US20030112274A1 (en) * | 2001-12-13 | 2003-06-19 | Yang Gao | System and method for retrieving and editing the data structure of an HTML UI control |
| CN101169716A (en) * | 2007-11-30 | 2008-04-30 | 清华大学 | Emulated procedure information modeling and maintenance method based on product structural tree |
| CN101510207A (en) * | 2009-02-26 | 2009-08-19 | 中兴通讯股份有限公司 | Tree menu dynamic maintenance method and apparatus based on web page |
| US20120110515A1 (en) * | 2010-10-28 | 2012-05-03 | Cary Scott Abramoff | User interface for a digital content management system |
| CN102520933A (en) * | 2011-11-28 | 2012-06-27 | 深圳市五巨科技有限公司 | Method and device for establishing tree menu based on user right |
| CN102446221A (en) * | 2011-12-22 | 2012-05-09 | 南京联创科技集团股份有限公司 | Dynamic tree structured directory retrieval method in BS (browser/server) structure software |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106201880A (en) * | 2016-07-12 | 2016-12-07 | 上海恒企教育培训有限公司 | A kind of ERP business simulating system and fast construction method thereof |
| CN108073706A (en) * | 2017-12-20 | 2018-05-25 | 北京四方继保自动化股份有限公司 | A kind of method of analogue system history library longitudinal data transverse directionization displaying |
| CN108073706B (en) * | 2017-12-20 | 2022-02-22 | 北京四方继保自动化股份有限公司 | Method for transversely displaying longitudinal data of simulation system historical library |
| CN110297626A (en) * | 2019-05-23 | 2019-10-01 | 唐山钢铁集团有限责任公司 | Tree-like display methods based on SAP system |
| CN110297626B (en) * | 2019-05-23 | 2023-04-18 | 唐山钢铁集团有限责任公司 | Tree display method based on SAP system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103020171B (en) | 2015-10-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103064664B (en) | Hadoop parameter automatic optimization method and system based on performance pre-evaluation | |
| CN104573231A (en) | BIM based smart building system and method | |
| CN102360331B (en) | Test program automatic generation method based on formal description | |
| CN104123227A (en) | Method for automatically generating testing cases | |
| CN106407302B (en) | It supports to call the special functional method of middleware database by Simple SQL | |
| CN104268428A (en) | Visual configuration method for index calculation | |
| CN105069696A (en) | Avionics system capability demand analysis method based on architecture framework | |
| CN102012817A (en) | Flex technology-based large public building energy consumption monitoring platform development method | |
| CN106021344B (en) | A kind of flexible CIME electric network model sharing method | |
| CN103093007A (en) | Power transmission iron tower three-dimensional virtual assembly method | |
| CN105138547A (en) | Data search method and apparatus | |
| CN104182441A (en) | Data sheet synchronization method and device | |
| CN102902818A (en) | Method and device for upgrading database | |
| EP3388957A1 (en) | Method and system for optimizing database system, electronic device, and storage medium | |
| CN103020171A (en) | Java-based data access method of electric power ERP (Enterprise Resource Planning) business simulation system | |
| CN104361040A (en) | Method and device for customized query | |
| CN105243216A (en) | System confrontation simulation method and system based on situation dynamic intervention | |
| CN112418735A (en) | Power grid AI scheduling system and method based on graph calculation | |
| CN111046062A (en) | Applet data acquisition method, intelligent terminal and storage medium | |
| CN105426424A (en) | Directional paging type acquisition method for network data | |
| CN103035146A (en) | Intelligent prompt method of electric power enterprise resource planning (EPR) service simulation system | |
| CN104391782A (en) | Network-equipment managing-software client-end simulating method on basis of XML (X Extensive Markup Language) script | |
| CN107463374B (en) | Subset model extraction method and system based on inheritance and association automatic deduction | |
| CN110544004A (en) | Method and system for realizing data index mapping | |
| CN111400797A (en) | Intelligent brickwork brick arrangement method based on BIM + AR technology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |