CN103020171B - Based on the electric power ERP business simulating system data access method of Java - Google Patents
Based on the electric power ERP business simulating system data access method of Java Download PDFInfo
- Publication number
- CN103020171B CN103020171B CN201210490223.1A CN201210490223A CN103020171B CN 103020171 B CN103020171 B CN 103020171B CN 201210490223 A CN201210490223 A CN 201210490223A CN 103020171 B CN103020171 B CN 103020171B
- Authority
- CN
- China
- Prior art keywords
- data
- node
- tree
- display
- executable code
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of electric power ERP business simulating system data access method based on Java, it comprises data background process and data foreground shows two steps, data access method and the data interaction between Visual Graph and database, realized by Java, JavaScript, Vg three intercommunication, wherein Java is responsible for the inquiry of data and organizes Vg script; JavaScript is responsible for initialization, the Vg interface interchange of access parameter; Vg is responsible for script sentence, the configuration querying information of resolving the generation of Java end.The present invention achieves the reciprocal process of IE, Visual Graph and database with Servlet and JavaScript for core technology, can realize display effect identical with real power ERP system.
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, deepens continuously, get more and more with international association along with Chinese foreign is open, simultaneously due to the strong request of Chinese Enterprise, ERP mono-introduces China, namely obtains the welcome of many enterprises, and extensively starts application.Due to China's thinking habit in the past and mode of doing things, different very large with ERP pattern, therefore, student is far from suitable from custom to mode, resentment is created to this, work efficiency is very low, has had a strong impact on the work in every of enterprise, and then drastically influence the development of enterprise, although Enterprises Leader also recognizes this point, carried out a large amount of training, training also had certain effect at that time, but got back to original shape again after a while.By a large amount of investigation, find that training method, when needing training, is bought or lease corresponding hardware device, build corresponding software and Training Environment, remove immediately after having trained.This training method has high input, time-consuming bothersome, and hold training needs to consider for a long time, and can only carry out limited training.ERP is an extraordinary software really, and implement ERP drops into also very huge, also expensive manpower and energy, if do not play its effectiveness, waste is too large really.
Since the enforcement of national grid " SG-186 " engineering in 2006 in our department of provincial electric power company and each subordinate unit, each business department is more and more higher to the dependence of system in routine duties, and the knowledge that 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 Individual traffic system also relates to ripe package software (SAP system).
Need along with to staff straining, urgently set up a set of for each operation system, particularly to the analogue system that emphasis, difficult point module in operation system give training.
Provincial electric power company's business simulating is not building of simple each operation system simulated environment.Service analogue system refers to a set of system similar with actual production environment of installation and deployment in an enclosed environment, and has the function consistent with production system, and except the cut-and-dried simulated data of employing is carried out except system exercise, other and real system are the same.
The construction of analogue system is not only reach a simulation to original system, more urgent target is by the simulation to original system, give target and the means of student's study, learn use procedure student and can give the relevant prompting such as professional knowledge, operating function and help, by study and the use of analogue system, reach and grasp relevant professional knowledge and the operational applications of operation system comprehensively.
Existing analogue system can not produce display effect identical with real power ERP system, due to the difference of effect data, interfacial effect, be unfavorable for that student uses the work of real power ERP system after completing 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 with the identical display effect of real power ERP system that can realize is provided.
The object 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 data background process and Data Frontend shows two steps, and described data background process step comprises following sub-step:
S101: obtain URL from front end, URL is resolved, the parameter in URL comprises data query table tableName, tree structure initial query node startID, foreground display field query, the corresponding identification field name flag of system code identifier and tables of data, tree structure allow maximum display level treeLevel, specify level display field fixField, query filter condition filter and initial inquiring position start;
S102: by tableName, startID, query, flag, treeLevel, filter generated query SQL, front end display object data List is inquired about, by tableName inquiry system data dictionary, obtain the data display length Map of data field in front end, by flag inquiry system code, obtain the icon type that data show in front end;
S103: if emulated data List is the length that sky or start are more than or equal to List, then run time version is set to "-1 ", and returns run time version; Otherwise perform step S104;
S104: start searching loop emulated data List, initialization father node array parent [] and temporary variable;
S105: obtain emulated data object tempObj;
S106: each field of traversal emulated data, according to the data dictionary normative field length of configuration, not enough use space polishing, exceed part use " ... " replace;
S107: the hierarchical relationship judging current traverse object and last traverse object, is greater than, is designated as the father node of present node by the position of last traverse object, and upgrades the position of parent [level]=last traverse object;
S108: upgrade current traverse object level, uses in upper once circulation;
S109: generate VG can perform shell script TreeView, Addltem () according to emulated data tempObj, icon type, parent [];
S110: if executable code length >VG executable code length that existing executable code length+previous cycle generates, upgrade start=current location, stops loading executable code, jumps out circulation, perform step S114; Otherwise perform step S111;
S111: this circulation run time version is added in executable code;
S112: if List has traveled through or initial loading position > shows maximum length, upgrade the length of start=List;
S113: perform step S114;
S114: after circulation terminates, add initial inquiring position start before executable code, and split with ": " and executable code;
Described Data Frontend step display comprises following sub-step:
During the display of S201:VG control, call tree structure TreeView.clear () and empty all data;
S202: if background access URL is empty, then initialization is carried out to tree structure, display tree structure, this tree structure is blank tree structure, otherwise performs step S203;
S203: call function TreeView.BeginUpdate (), start tree-like renewal affairs;
S204: call VG interface GetUrl (), carries out database background application inquiry using URL as parameter, and obtains rreturn value and run time version;
S205: if run time version="-1 ", represents that data have been inquired about, jumps out circulation, perform step S208, otherwise perform step S206;
S206: run time version is decomposed into current expiration operating position and executable code;
S207: the value upgrading start in URL, and call VG interface Execute () execution executable code, invocation step S204;
S208: call function TreeView.EndUpdate (), terminate tree-like renewal affairs;
S209: display tree structure.
Tree-like displaying TreeView of the present invention, mainly realize the tree-like displaying of data, its Key Functions is described as follows:
Addltem (Aparent, AValue, AType, ALevel, AExpand, AObject): for tree structure adds node, wherein, Aparent is father node, and root node is 0, AValue is node display Name, AType is node corresponding icon explicit identification, ALevel is node place level, and AExpand is whether node launches, and AObject is node object data;
BeginUpdate (): upgrade tree-like affairs and start;
EndUpdate (): upgrade tree-like affairs and terminate;
Clear (): empty tree-like all data.
The invention has the beneficial effects as follows: the present invention achieves the reciprocal process of IE, Visual Graph and database with Servlet and JavaScript for core technology, can realize display effect identical with real power ERP system.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of the background process of data in the present invention;
Fig. 2 is the process flow diagram of the foreground display of data in the present invention.
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 data background process and Data Frontend shows two steps, and as shown in Figure 1, described data background process step comprises following sub-step:
S101: obtain URL from front end, URL is resolved, the parameter in URL comprises data query table tableName, tree structure initial query node startID, foreground display field query, the corresponding identification field name flag of system code identifier and tables of data, tree structure allow maximum display level treeLevel, specify level display field fixField, query filter condition filter and initial inquiring position start;
S102: by tableName, startID, query, flag, treeLevel, filter generated query SQL, front end display object data List is inquired about, by tableName inquiry system data dictionary, obtain the data display length Map of data field in front end, by flag inquiry system code, obtain the icon type that data show in front end;
S103: if emulated data List is more than or equal to List size for empty or start, then run time version is set to "-1 ", and returns run time version; Otherwise perform step S104;
S104: start searching loop emulated data List, initialization father node array parent [] and temporary variable;
S105: obtain emulated data object tempObj;
S106: each field of traversal emulated data, according to the data dictionary normative field length of configuration, not enough use space polishing, exceed part use " ... " replace;
S107: the hierarchical relationship judging current traverse object and last traverse object, is greater than, is designated as the father node of present node by the position of last traverse object, and upgrades the position of parent [level]=last traverse object;
S108: upgrade current traverse object level, uses in upper once circulation;
S109: generate VG can perform shell script TreeView, Addltem () according to emulated data tempObj, icon type, parent [];
S110: if executable code length >VG executable code length that existing executable code length+previous cycle generates, upgrade start=current location, stops loading executable code, jumps out circulation, perform step S114; Otherwise perform step S111;
S111: this circulation run time version is added in executable code;
S112: if List has traveled through or initial loading position > shows maximum length, upgrade the length of start=List;
S113: perform step S114;
S114: after circulation terminates, add initial inquiring position start before executable code, and split with ": " and executable code;
As shown in Figure 2, described Data Frontend step display comprises following sub-step:
During the display of S201:VG control, call tree structure TreeView.clear () and empty all data;
S202: if background access URL is empty, then initialization is carried out to tree structure, display tree structure, this tree structure is blank tree structure, otherwise performs step S203;
S203: call function TreeView.BeginUpdate (), start tree-like renewal affairs;
S204: call VG interface GetUrl (), carries out database background application inquiry using URL as parameter, and obtains rreturn value and run time version;
S205: if run time version="-1 ", represents that data have been inquired about, jumps out circulation, perform step S208, otherwise perform step S206;
S206: run time version is decomposed into current expiration operating position and executable code;
S207: the value upgrading start in URL, and call VG interface Execute () execution executable code, invocation step S204;
S208: call function TreeView.EndUpdate (), terminate tree-like renewal affairs;
S209: display tree structure.
Tree-like displaying TreeView of the present invention, mainly realize the tree-like displaying of data, its Key Functions is described as follows:
Addltem (Aparent, AValue, AType, ALevel, AExpand, AObject): for tree structure adds node, wherein, Aparent is father node, and root node is 0, AValue is node display Name, AType is node corresponding icon explicit identification, ALevel is node place level, and AExpand is whether node launches, and AObject is node object data;
BeginUpdate (): upgrade tree-like affairs and start;
EndUpdate (): upgrade tree-like affairs and terminate;
Clear (): empty tree-like all data.
Visual Graph and Vg, and the data interaction between database is realized by Java, JavaScript, Vg three intercommunication, and wherein Java is responsible for the inquiry of data and organizes Vg script; JavaScript is responsible for initialization, the Vg interface interchange of access parameter; Vg is responsible for script sentence, the configuration querying information of resolving the generation of Java end.
Claims (2)
1., based on the electric power ERP business simulating system data access method of Java, it is characterized in that: it comprises data background process and Data Frontend shows two steps, described data background process step comprises following sub-step:
S101: obtain URL from front end, URL is resolved, the parameter in URL comprises data query table tableName, tree structure initial query node startID, foreground display field query, the corresponding identification field name flag of system code identifier and tables of data, tree structure allow maximum display level treeLevel, specify level display field fixField, query filter condition filter and initial inquiring position start;
S102: by tableName, startID, query, flag, treeLevel, filter generated query SQL, front end display object data List is inquired about, by tableName inquiry system data dictionary, obtain the data display length Map of data field in front end, by flag inquiry system code, obtain the icon type that data show in front end;
S103: if emulated data List is the length that sky or start are more than or equal to emulated data List, then run time version is set to "-1 ", and returns run time version; Otherwise perform step S104;
S104: start searching loop emulated data List, initialization father node array parent [] and temporary variable;
S105: obtain emulated data object tempObj;
S106: each field of traversal emulated data, according to the data dictionary normative field length of configuration, not enough use space polishing, exceed part use " ... " replace;
S107: the hierarchical relationship judging current traverse object and last traverse object, is greater than, is designated as the father node of present node by the position of last traverse object, and upgrades the position of parent [level]=last traverse object;
S108: upgrade current traverse object level, uses in upper once circulation;
S109: generate VG can perform shell script TreeView, Addltem () according to emulated data tempObj, icon type, parent [];
S110: if executable code length >VG executable code length that existing executable code length+previous cycle generates, upgrade start=current location, stops loading executable code, jumps out circulation, perform step S114; Otherwise perform step S111;
S111: this circulation run time version is added in executable code;
S112: if emulated data List has traveled through or initial loading position > shows maximum length, upgrade the length of start=emulated data List;
S113: perform step S114;
S114: after circulation terminates, add initial inquiring position start before executable code, and split with ": " and executable code;
Described Data Frontend step display comprises following sub-step:
During the display of S201:VG control, call tree structure TreeView.clear () and empty all data;
S202: if background access URL is empty, then initialization is carried out to tree structure, display tree structure, this tree structure is blank tree structure, otherwise performs step S203;
S203: call function TreeView.BeginUpdate (), start tree-like renewal affairs;
S204: call VG interface GetUrl (), carries out database background application inquiry using URL as parameter, and obtains rreturn value and run time version;
S205: if run time version="-1 ", represents that data have been inquired about, jumps out circulation, perform step S208, otherwise perform step S206;
S206: run time version is decomposed into current expiration operating position and executable code;
S207: the value upgrading start in URL, and call VG interface Execute () execution executable code, invocation step S204;
S208: call function TreeView.EndUpdate (), terminate tree-like renewal affairs;
S209: display tree structure.
2. the electric power ERP business simulating system data access method based on Java according to claim 1, it is characterized in that: described tree-like displaying TreeView, mainly realize the tree-like displaying of data, its Key Functions is described as follows:
Addltem (Aparent, AValue, AType, ALevel, AExpand, AObject): for tree structure adds node, wherein, Aparent is father node, and root node is 0, AValue is node display Name, AType is node corresponding icon explicit identification, ALevel is node place level, and AExpand is whether node launches, and AObject is node object data;
BeginUpdate (): upgrade tree-like affairs and start;
EndUpdate (): upgrade tree-like affairs and terminate;
Clear (): empty tree-like all 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 CN103020171A (en) | 2013-04-03 |
| CN103020171B true 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) |
Families Citing this family (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 |
| CN108073706B (en) * | 2017-12-20 | 2022-02-22 | 北京四方继保自动化股份有限公司 | Method for transversely displaying longitudinal data of simulation system historical library |
| CN110297626B (en) * | 2019-05-23 | 2023-04-18 | 唐山钢铁集团有限责任公司 | Tree display method based on SAP system |
Citations (5)
| 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 |
| 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 |
| 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 |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6944828B2 (en) * | 2001-12-13 | 2005-09-13 | Appeon Corporation | System and method for retrieving and editing the data structure of an HTML UI Control |
| US8548992B2 (en) * | 2010-10-28 | 2013-10-01 | Cary Scott Abramoff | User interface for a digital content management system |
-
2012
- 2012-11-27 CN CN201210490223.1A patent/CN103020171B/en active Active
Patent Citations (5)
| 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 |
| 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 |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103020171A (en) | 2013-04-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106407302B (en) | It supports to call the special functional method of middleware database by Simple SQL | |
| CN104123227A (en) | Method for automatically generating testing cases | |
| CN108829378A (en) | A kind of development approach of application software, device and electronic equipment | |
| CN103699389A (en) | Linux kernel module relation extracting method based on compiling options | |
| CN111797450B (en) | BIM-based power grid engineering model design system, method, equipment and storage medium | |
| CN103020171B (en) | Based on the electric power ERP business simulating system data access method of Java | |
| CN1683914A (en) | Railway simulating laboratory | |
| CN103914307A (en) | Interactive-interface fast implementation method based on reusable library | |
| CN107611962A (en) | Network system branch road searching method, system and electronic equipment | |
| CN112948572A (en) | Method for visually displaying equipment information and relation of power system through knowledge graph | |
| CN112148708A (en) | Power grid planning-oriented visual application system | |
| CN104361040A (en) | Method and device for customized query | |
| CN109191078A (en) | A kind of traffic flow modeling method, device and equipment | |
| CN104346378B (en) | A kind of method, apparatus and system for realizing complex data processing | |
| CN101452387A (en) | Service flow management method | |
| CN104331517A (en) | Retrieval method and retrieval device | |
| CN103544658A (en) | Power supply range analysis method and system based on entire distribution network | |
| Zhao et al. | Smart home power management system design based on human-computer interaction model | |
| CN103294480B (en) | Mesh row data transformations is the method for data list | |
| CN103035146B (en) | Intelligent prompt method of electric power enterprise resource planning (EPR) service simulation system | |
| CN111738874B (en) | Method and device for automatically generating operation steps of new equipment of power grid based on starting model | |
| CN114443427A (en) | Cloud resource efficiency evaluation method based on big data analysis | |
| KR20160031807A (en) | The spreadsheet-based big data analysis system and the method | |
| CN110544004A (en) | Method and system for realizing data index mapping | |
| CN103544569A (en) | Power supply path analysis method and system based on entire distribution network |
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 |