JP2008052387A - Program generation device, program generation method, program, and recording medium - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a mechanism for automatically generating a program realizing free dialogue and transfer of a parameter to/from the dialogue without being impaired in simplicity of a screen definition. <P>SOLUTION: Based on designation information inside an input/output table A109, a code generation part A107 generates a code, which is used for searching an associated data table based on a parameter given from a transition source screen and setting a retrieval result in a table format to a matching input/output item, as a display processing code of a dialogue screen, a code, which is used for calling a transition destination screen as a dialogue and transferring a value designated as a next screen parameter and set in the input/output item on the transition source screen to the transition destination screen, as a screen transition code to the dialogue screen, and a code, which is used for transferring the value of the input/output item on the transition source screen designated as the next screen parameter to the transition destination screen, as a screen transition code from the dialog screen to a normal screen. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention relates to a program generation device, a program generation method, a program, and a recording medium that generate a source code of a program based on designation information.

  The dialog is a convenient GUI function because the user can easily select the corresponding information. Patent Document 1 proposes a program generation method in which a dialog is one of the program generation elements.

  In Patent Document 1, for example, a dialog that has already been completed, such as a selection dialog for gender sex, that is, some fixed dialogs are prepared as program parts and incorporated into a source program pattern by definition designation.

Patent Document 2 proposes a method for generating a screen transition program.
Japanese Patent No. 3227066 JP-A-8-286899

  However, the method of Patent Document 1 does not incorporate the structure of the dialog itself or selection data. That is, there is a problem that only a predetermined dialog can be generated, and the dialog cannot be freely defined.

  The state in which the dialog is displayed from the normal screen can be regarded as a kind of screen transition.

  However, in the method of Patent Document 2, it is possible to create a dialog which is a screen transition in a free format, but there is a problem that the definition of the screen transition becomes very complicated.

  In the method of Patent Document 2, when a part on the screen is clicked, a code for transitioning the state of another part (selected, non-selected, active, inactive, independent), or transition to another screen is performed. It is possible to generate code. However, with the method of Patent Document 2, it is not possible to automatically generate a code or the like for passing a value from the transition source screen to the transition destination screen during screen transition.

  In the method of Patent Document 2, although the screen can be freely defined, an external data table is searched based on the parameters received from the transition source screen, and the display content of the dialog, the number of display records, etc. are dynamically changed. It is not possible to automatically generate simple code.

  After all, such a code needs to be manually created by the user, which is not only very complicated, but also has a problem that it can only be performed by a user with advanced program skills.

  In the conventional technology, there is no technology for automatically generating such a screen transition program, but in fact, when trying to automatically generate such a screen transition program, there is a relationship between transition screens, which becomes a transition condition. It is estimated that complicated specification operations such as definition of items and clicks, specification of parameters to be held at the time of screen transition, and specification to display the transition destination screen at an accompanying position so as not to overlap the main screen are required. .

  As described above, there are various problems in automatically generating a free dialog, which cannot be realized by the conventional technology.

  The present invention has been made to solve this problem, and an object of the present invention is to realize a free dialog and pass parameters to and from the dialog without impairing the simplicity of the dialog definition. It is to provide a mechanism for automatically generating.

  The present invention relates to a definition of a screen used in a program to be generated, specification of a related data table related to the screen, specification of input / output items arranged on the screen, and input / output items in a program generation device for generating a program Generating means for generating a program code based on designation information including designation of a screen transition corresponding to the instruction of the screen and designation of a parameter passed from the transition source screen to the transition destination screen at the time of the screen transition, The definition includes designation of whether the screen to be generated is an accompanying type screen accompanying the transition source screen or a non-accompanying type screen not accompanying the transition source screen. As a code that realizes the display processing of the specified screen, “Search related data table based on parameters passed from transition source screen, Generate a code that sets the search result in the input / output item on the corresponding screen, and realize the screen transition to the screen defined as the accompanying type in the specified information, A screen that is called as an accompanying screen and passes the value set in the input / output item on the transition source screen specified as a parameter at the time of screen transition to the transition destination screen, and the screen specified as the accompanying type in the specified information Generate code that passes the value of the input / output item on the transition source screen specified as a parameter to the transition destination screen as the code that realizes the screen transition from the specified to the non-accompanying type screen And

  In an automatic program generation environment, an accompanying screen (dialog) accompanying the transition source screen can be freely designed and automatically generated as an input auxiliary function.

  For example, when there are input items of related hierarchies, instead of determining the input items by opening the dialog for the number of input items of each layer, display the items in a form such as a table that is easy to see the relationship. It is possible to generate a dialog that makes it easy to select and input the corresponding item group.

  In addition, a function that displays the dialog display data only on the part related to the item specified by the designer, and if there are many related item groups to be displayed, a search function is added to the dialog screen to complement the items to be displayed. Capability can be generated.

  For example, when existing data is used in a dialog, items that are unnecessary for the user are excluded and only necessary items are displayed. On the other hand, when there are many display groups, a significant selection candidate value is obtained by searching the dialog. Can be created within the same dialog screen, and a function that is useful for a large number of displays can be generated while maintaining the effect of the list of refinements.

  Further, when a desired group can be found from the dialog, if a corresponding group is selected once, it is possible to generate a function in which only necessary items are collectively set as input values from an item group included in the group. That is, it is possible to enjoy the convenience of selecting a plurality of items at a time by one selection.

  Therefore, it is possible to easily generate a program that makes the user-friendly hierarchical relationship between the input items and the display format of the relevant data in the generation of the input screen and the dialog screen that is the input assist at the time of application development. There is an effect.

[First Embodiment]
The present invention provides an automatic generation system particularly for a list type (matrix type) dialog in an application program automatic generation system constructed for the purpose of improving efficiency of program generation and ease of management of a developed product. is there.

  First, the entire application program automatic generation system will be described with reference to FIG. 1 to FIG. 4, and then portions related to the present invention will be taken up and described.

  FIG. 1 is a block diagram showing an embodiment of a program generation apparatus to which an application program automatic generation system according to the present invention can be applied.

  In FIG. 1, A101 is an input device and corresponds to a pointing device such as a keyboard and a mouse. The input device A101 includes business specification information (definition of a screen to be generated (screen information table 300 shown in FIG. 5 described later), definition of items of each screen (screen item information table 400 shown in FIG. 6 described later), data items. The relationship between the location of the database in the database and the data items, that is, information (not shown) indicating what data is obtained from under what conditions, and physical specification information (display screen) This is for selecting the input of layout, color, presence / absence of display, condition information such as size) used when generating the program code.

  A102 is a display device, which is composed of a CRT, LCD or the like. The display device A102 can display business specification information and physical specification information input screens, business specification information and physical specification information input from the input screens, generated program codes, and the like.

  A 104 is an external storage device such as a hard disk. The external storage device A104 includes an input / output table A109 for storing business specifications input from the input device A101, a physical specification table A110 for storing input physical specifications, and generated program code (JSP code 112). , A servlet code 113, a bean code 114), and the like.

  A103 is a processing device, and includes the CPU 101, ROM 103, RAM 102, and the like shown in FIG.

  FIG. 2 is a block diagram showing an example of the hardware configuration of the program generation apparatus shown in FIG. 1, and the same components as those in FIG. 1 are denoted by the same reference numerals.

  As shown in FIG. 2, the program generation device shown in FIG. 1 can be realized by a personal computer or the like.

  The CPU 101 is configured to comprehensively control access to various devices connected to the system bus based on a control program stored in the ROM 103 or the external storage device A104.

  The system bus is connected to a RAM 202 that functions as a main memory, work area, and the like for the CPU 101. In the ROM 203 or the external memory 104, a BIOS (Basic Input / Output System), an operating system (hereinafter referred to as “OS”) program, which is a control program of the CPU 201, and various types of processing necessary for realizing the processing executed by the computer A103. Programs and so on are stored.

  The CPU 201 implements the functions and various operations of the overall control unit A 108 shown in FIG. 1 by loading various programs necessary for execution of processing into the RAM 202 and executing the programs.

  The external memory 104 stores a boot program, various application programs, font data, user files, etc. (not shown) as the various programs described above.

  For example, the CPU 201 performs WYSIWYG on the display device 102 by executing outline font rasterization processing on a display information area in the RAM 202. Further, the CPU 201 opens various registered windows based on commands instructed by a mouse cursor (not shown) on the display device 102 and executes various data processing.

  Returning to the description of FIG.

  The CPU 101 of the processing device A103 loads a program stored in the ROM 103, the external storage device A104 or other recording medium onto the RAM 102 and executes it, thereby executing a screen control unit A105, a specification analysis unit A106, a code generation unit A107, The function of the overall control unit A 108 is realized.

  The screen control unit A105 includes a business specification description unit A116 that controls the screen of the display device A102 in order to input business specification information from the input device A101, and a screen of the display device A102 in order to input physical specification information from the input device A101. It consists of a physical specification description part A117 that controls

  The specification analysis unit A106 performs lexical analysis and grammatical analysis on the business specification information and physical specification information input from the input device A101 or read from the external storage device A104.

  The code generation unit A107 generates a program code (JSP code A112, servlet code A113, bean code A114) based on the business specification information and physical specification information analyzed by the specification analysis unit A106, and an external storage device Store in A104.

  The code generation unit A107 may be configured to construct a database (DB) A115 on the external storage device A104 based on the business specification information (input / output table A109) read from the external storage device A104. .

  The overall control unit A108 controls each unit such as the screen control unit A105, the specification analysis unit A106, and the code generation unit A107.

  FIG. 3 shows the overall configuration of the web application system using the servlet code A113, JSP code A112, and Bean code A114 generated by the code generation unit A107 shown in FIG. 1, and is automatically generated from the program generation apparatus. It is a schematic diagram which shows an example of a thing.

  As shown in FIG. 3, the servlet code A113, JSP code A112, and Bean code A114 generated by the code generation unit A107 are executable servlet A207, JSP (A209), and Bean (A208), respectively. It is arranged on the application server A 206 on the server A 204 side.

  This Web application system is used from the client A201 by the Web browser A202. By accessing the JSP (A209) from the web browser A202, an HTML page is generated and returned to the client A201 side. An HTML page A203 transmitted from the JSP (A209) is displayed on the web browser A202.

  Further, a request from the Web browser A202 is transmitted to the server A204 side via HTTP. The server A 204 includes an HTTP server A 205 and an application server A 206, and the application server A 206 includes a servlet and JSP execution environment.

  When a request is transmitted to the server A 204 side, the corresponding servlet A 207 is activated in response to the request. The servlet A207 requests the corresponding Bean (A208) for processing. Further, Bean (A208) accesses the database A211 by using the DB access object A210, performs business-related processing and data processing, and holds the processing result. The DB access object A210 is a class created as a result of analyzing and designing a business, or an existing class that can be reused.

  Next, Bean (A208) is passed from Servlet A207 to JSP (A209), and JSP (A209) is called. The JSP (A209) refers to the processing result held in the Bean (A208), generates an HTML page, and returns it to the client A201 side. The HTML page returned to the client A 201 side is displayed on the Web browser A 202.

  The servlet A 207 has a role of controlling and connecting between receiving a request from the Web browser A 202, processing request to the Bean (A 208), and calling the JSP (A 209). JSP (A209) is in charge of the display for outputting the HTML page, and Bean (A208) is in charge of processing related to operations such as access to the database A211. Although it is possible to process a request from the Web browser A202 only by the servlet A207 without using the Bean (A208) or JSP (A209), each bean (A208) or JSP (A209) can be processed. By clearly separating the roles, it is possible to grasp the functional division in a concise manner. In the present embodiment, a JSP code, a Servlet code, and a Bean code are exemplified as codes generated by the code generation unit A107. However, the code generated by the code generation unit A107 is not limited to JSP code, Servlet code, and Bean code, and may be any program code in any program language.

  Hereinafter, with reference to FIG. 4, processing in the program generation device of the present invention will be described.

  FIG. 4 is a flowchart showing an example of a first control processing procedure in the program generation device of the present invention, and corresponds to the operation of the overall control unit A108 of the processing device A103 shown in FIG. That is, this flowchart is realized by the CPU 101 shown in FIG. 2 executing a program stored in the external storage device A 104 or the like on the RAM 102. S101 to S107 indicate each step.

  The processing apparatus A103 shown in FIG. 1 has an input mode for inputting a business specification (input / output table A109) and a physical specification table A110 for generating a code, and an input business specification (input / output table A109) and a physical specification table A110. A generation mode for generating program code from the program.

  First, when the overall control unit A108 is activated, in step S101, the overall control unit A108 determines whether the mode selected by the operator's instruction from the input device A101 is the generation mode or the input mode. If it is determined that the input mode has been selected, the overall control unit A108 advances the process to step S102 and activates the screen control unit A105.

  In step S103, the activated screen control unit A105 causes the business specification description unit A116 to display a business specification input screen, and an operator inputs an application name of the web application to be generated and an input / output table that is a form of the business specification. The item input is accepted, and the input / output table is stored in the external storage device A104 (input / output table A109 shown in FIG. 1). The input / output table A109 will be described later with reference to FIGS.

  Next, in step S104, the screen control unit A105 activates the physical specification description unit A117. The activated physical specification description part A117 displays a physical specification input screen, accepts input from the operator to the physical specification table that is a form of physical specifications and selection of a business pattern, and selects the physical specification table and business pattern. Information is stored in the external storage device A104 (physical specification table A110 shown in FIG. 1). Then, the process ends.

  On the other hand, when it is determined in step S101 that the mode selected by the operator's instruction from the input device A101 is the generation mode, the overall control unit A108 advances the process to step S105.

  In step S105, the overall control unit A108 reads the input / output table A109 and the physical specification table A110 stored in the external storage device A104, and activates the specification analysis unit A106 to read the input / output table A109 and the physical specification table. Perform A110 lexical analysis and grammatical analysis.

  Next, in step S106, the overall control unit A108 activates the code generation unit A107, and generates a code based on the input / output table A109 and the physical specification table A110 that have been subjected to lexical analysis and grammatical analysis by the specification analysis unit A106. Processing and database construction. Details of the code generation process will be described later with reference to FIG.

  In step S107, the overall control unit A108 performs an output process in which the generated code is displayed on the display device A102 and written to the external storage device A104 according to an operator instruction.

  Hereinafter, with reference to FIG. 5 to FIG. 9, resources necessary for implementing the present invention from the application program automatic generation system will be described.

  5 and 6 are schematic diagrams showing an example of information in the input / output table A109 shown in FIG. 1, and define screens, items in the screen, screen transitions, and the like. At the time of code generation processing, conditions and the like necessary to be established as a program are expressed in the program with reference to this table.

  109 shown in FIG. 1 includes a screen information table 300 shown in FIG. 5 and a screen item information table 400 shown in FIG.

  The screen information table 300 in FIG. 5 stores definition information of the screen itself.

  The screen information table 300 includes a screen name 301 of a screen to be generated, a screen type 302 for designating whether the screen to be generated is a “normal” type or a “dialog” type, and “display” or “data” on the screen. A related table 303 that specifies a DB table to be “registered” and a display condition 304 that specifies a condition (that is, a search condition) for narrowing the display record when the screen is displayed are stored.

  Note that “normal” of the screen type 302 indicates a non-accompanying type screen (that is, a screen other than the dialog box) not associated with the transition source screen, and the “dialog” of the screen type 302 is associated with the transition source screen. A type screen (ie, a dialog box) is shown. In addition, a screen in which the screen type 302 is defined as “dialog” is searched for data from the DB table defined in the related table 303 based on the parameters passed from the transition source screen and the display condition 304, and the search is performed. It is a screen that displays the data.

  In the example illustrated in FIG. 5, an “input screen” that is a “normal” type screen is defined by the record 305.

  The record 306 defines a “dialog screen” that is a “dialog” type screen. This “dialog screen” searches the “division table” defined in the related table 303 based on the parameters passed from the transition source screen at the time of screen display and the conditions defined in the display conditions 304, and The screen displays the retrieved data.

  The screen item information table 400 in FIG. 6 stores information on items arranged on the screen in the definition information DB table.

  In this screen item information table 400, in addition to the screen name 401, an item name 402 which is a display name of an item arranged on the screen, and whether the item is a text input component (input field) or a button (ordinary button, related An item type 403 for setting whether the item is a registration button for registering data in a table, a delete button for deleting data from a related table, and the item is arranged in a detailed format “1” or a list format (matrix format) The item level 404 that is set to “2” arranged in the above, the next screen 405 that sets the screen to be displayed next when the item type is a button, and the next screen when the item type is a button are also passed to the next screen A next screen parameter 406 for setting an item name as a parameter is stored.

  In particular, as defined by the record 409 in FIG. 6, a button (select button) for displaying a “dialog screen” on the screen (input screen) that receives a value has “dialog screen” as the next screen parameter 406. Set the item name (in this case, “Department name”, “Section name”) of the item you want to set.

  In addition, as defined by the record 415 in FIG. 6, the item name (“department name”, “section name”) of the item to be set in the next screen parameter 406 is set with the selection button on the “dialog screen” side. To do.

  Note that the next screen parameters of the records 409 and 415 need to match the order of the items with each other (in this case, “Department name”, “Section name”).

  In addition, in the next screen parameter 406 of the button (select button) for displaying the dialog screen on the screen that receives the value (input screen), another item to be passed to the “dialog screen” (the item for initial display record search) ) Also has a meaning.

  Although not shown, by adding another screen definition to the screen information table 300 in FIG. 5 and the screen item information table 400 in FIG. 6, only the screen transitions of “input screen” and “dialog screen” can be achieved. It is also possible to easily define screen transition from “dialog screen” to another dialog screen. The present embodiment merely shows an example using a part of a function capable of moving a plurality of screen transitions in a hierarchy, and the present invention is not limited to this example.

  Hereinafter, the screen information table 300 shown in FIG. 5 and the screen item information table 400 shown in FIG. 6 will be described in detail using screen examples (FIGS. 7 and 8) of applications actually generated from the table. .

  FIGS. 7 and 8 are schematic diagrams showing examples of screens defined (designated) by the screen information table 300 shown in FIG. 5 and the screen item information table 400 shown in FIG. It is. In FIG. 7 and FIG. 8, the same components are denoted by the same reference numerals.

  The input screen 501 shown in FIGS. 7 and 8 is a record in which the screen name 301 in the screen information table 300 in FIG. 4 and the screen name 401 in the screen item information table 400 in FIG. 5 are “input screen” (FIG. 5). 305, corresponding to 407 to 411 in FIG.

  Further, the dialog screen 502 includes records in which the screen name 301 in the screen information table 300 in FIG. 4 and the screen name 401 in the screen item information table 400 in FIG. 5 are “dialog screen” (306 in FIG. 5 and FIG. 4). 412 to 417).

  The department name 505 and the section name 506, which are input fields on the input screen 501, correspond to the records 407 and 408 in FIG.

  Further, the selection button 507 on the input screen 501 corresponds to the record 409 in FIG. As defined in the next screen 405 of the record 409 in FIG. 6, when this selection button 507 is pressed (instructed), a dialog screen 502 is displayed. At this time, the parameter values set in the department name 505 and the section name 506 are passed to the dialog screen 502 as defined in the next screen parameter 406 of the record 409 in FIG. Furthermore, the parameter value set in the item defined by the next screen parameter 406 of the record 415 in FIG. 6 is also a parameter returned from the dialog screen 502 to the input screen 501.

  An employee name 508 that is an input field on the input screen 501 corresponds to the record 410 in FIG.

  Furthermore, an add button 509 on the input screen 501 corresponds to the record 411 in FIG. When this add button 509 is pressed (instructed), the screen remains as its own screen (input screen 501) as defined in the next screen 405 of the record 411 in FIG. Since the add button 509 is a “registration button” as defined in the record 411 in FIG. 6, the data (department name, section name, employee name) set on the input screen 501 is the record 305 in FIG. Will be registered in the “employee table” defined in.

  As defined in the record 306 in FIG. 3, the dialog screen 502 includes parameters (“Department name” and “Section name”) passed from the previous screen and display conditions 304 (the same department name or the same section name). Is the same), the department table 504 is searched and the search result is displayed.

  In the example shown in FIG. 7, since the department name 505 and the section name 506 that are the parameters are blank, all the records in the department table 504 are retrieved and displayed on the dialog screen 502.

  On the other hand, in the example shown in FIG. 8, an example is shown in which a dialog screen 502 is displayed with values entered for parameters in the department name 505 and the section name 506 that are the parameters.

  As shown in FIG. 8, when the selection button 507 is pressed while “HR” is entered in the department name 505 on the input screen 501, the department name 505 and the section name 506 are passed to the dialog screen 502 as parameters. In the dialog screen 502, the data whose department name is “Human Resources Department” is searched from the records of the department table 504 using this parameter value as a search condition and displayed.

  Although not shown, when the department table 504 is large, a display line is automatically limited to display only a selectable amount, or a search key is input to the dialog screen 502 and displayed. A program function such as narrowing down may be automatically generated.

  The department search 510 and section search 511, which are input fields on the dialog screen 502, correspond to the records 412 and 413 in FIG.

  Further, the search button 512 on the dialog screen 502 corresponds to the record 414 in FIG. When the search button 512 is pressed (instructed), as defined in the record 414 in FIG. 6, the values of the department search 510 and the section search 511 are set to the next screen as the own screen (dialog screen 502). To pass. As a result, the department table 504 is searched based on the values set in the department search 510 and the section search 511, and the search result is displayed in the department name 514 and the section name 515.

  The department name 514, section name 515, and selection button 513, which are input fields on the dialog screen 502, correspond to the records 412, 413, and 411 in FIG. 6 and are defined as “2” at the item level 404. As shown in the list format.

  When any selection button 513 arranged in the list format is pressed (instructed), an input screen 501 is displayed as defined in the next screen 405 of the record 415 in FIG. At this time, the parameter values of the department name 514 and the section name 515 corresponding to the pressed selection button 513 are passed to the input screen 501 as defined by the next screen parameter 406 of the record 415 in FIG. .

  When the user enters appropriate values for the search in the department search 510 and section search 511 on the dialog screen 502 and presses the search button 512, the values input in the department search 510 and section search 511 are displayed on the next screen (dialog. The department table 504 is searched using the values input to the department search 510 and section search 511 as keys, and the search results are displayed as a list of department names 514, section names 515, and selection buttons 513.

  Then, when the user finds a record to be selected from the search result, the user presses the corresponding selection button 513. Then, the dialog screen 502 is closed. The next screen parameter 406 (FIG. 6) passed from the input screen 501 to the dialog screen 502 is set to the department name 505 and the section name 506 of the input screen 501, but when returning from the dialog screen 502 to the input screen 501, Response parameters are stored in the parameter storage item. That is, for the department name 505 and the section name 506 on the input screen 501, the values of “part name” and “section name” in the row selected on the dialog screen 502 are set in order.

  In the example shown in FIG. 7, in the input screen 501, a record of “HR department” is selected as “Department name” and “Recruitment section” is selected as “Section name” on the dialog screen 502. In the name 505 and the section name 506, values of “HR department” and “recruitment section” are set.

  In the present embodiment, the department table 504 is illustrated, but it goes without saying that various dialogs can be formed by defining other data tables in the input / output table A109.

  In the following, with reference to FIG. 9, a parameter passing operation on each screen of an application defined (designated) in FIGS. 5 and 6 and generated by the code generation unit A107 will be described.

  FIG. 9 is a schematic diagram showing parameter passing operations on each screen of the application defined and designated in FIGS. 5 and 6 and generated and configured by the code generation unit A107.

  When the application program defined by the screen information table 300 shown in FIG. 5 and the screen item information table 400 shown in FIG. 6 and generated and configured by the code generation unit A107 is started, a dialog display screen (FIGS. 7 and 8). The input screen 501) is first displayed (601). When a dialog display button (selection button 507 in FIGS. 7 and 8) is pressed here, the application program performs processing for opening the dialog (602). At this time, the dialog screen 502 defined in the screen item information table 400 shown in FIG. 6 is displayed, and the next screen parameter is passed to the dialog screen 502.

  On the dialog screen 502 side, the passed parameters are used as display conditions for screen display processing on the dialog side (603). In other words, the application program that displays the dialog performs a data search on the related table 303 using the parameters passed from the input screen 501 as search keys and the display conditions specified in the display conditions 304 as search conditions, and displays records to be displayed. Narrow down. The related table in this case is a department table. These execution procedures are generated as an application program that displays a dialog.

  When the user wants to change the record displayed on the dialog screen 502, the user inputs search conditions (department search 510 and section search 511 in FIGS. 7 and 8) and presses the search button 512.

  Then, the application program redisplays its own dialog (dialog screen 502) (604). At this time, parameters are passed from the dialog screen 502 to the own dialog (dialog screen 502). The passed parameters are used as display conditions for the screen display process of the dialog screen 502, and data search is performed using the passed parameters to narrow down the records to be displayed.

  When the user finds a corresponding record on the dialog screen 502, the user presses a selection button 513 for that record. Then, the dialog screen 502 is closed and the information of the selected record is transferred to the original screen (input screen 501) (605).

  In the input screen 501, the passed data is set in the department name 505 and the section name 506. At this time, the setting position of each parameter item passed from the dialog screen 502 corresponds to the parameter item order passed to the dialog screen 502. That is, on the input screen 501, parameters passed from the dialog screen 502 are set in the items in the order of parameters passed to the dialog screen 502. As described above, the parameter passing operation is performed.

  The above description is based on the definition of the next screen parameter in FIG. 6, but in the embodiment, the next screen parameter storage item name of the input screen 501 and the next screen parameter storage item name of the dialog screen 502 happen to be “section name”. ”And“ Section Name ”, so that it is easy to understand, but one item may be different. However, the return parameters received by the next screen parameter storage item of the input screen 501 must have the same parameter order and data characteristics.

  Hereinafter, the code generation processing in the code generation unit A107 illustrated in FIG. 1 will be described with reference to FIGS.

  FIG. 10 is a flowchart showing an example of a second control processing procedure in the program generation apparatus of the present invention. In the code generation processing of the code generation unit A107 of the processing apparatus A103 shown in FIG. Corresponds to processing. That is, this flowchart is realized by the CPU 101 shown in FIG. 2 executing a program stored in the external storage device A 104 or the like on the RAM 102. S901 to S902 indicate each step.

  First, in step S901, the code generation unit A107 reads the screen information table 300 from the input / output table A109 of the external storage device A104, and performs screen generation processing (screen definition generation processing) from the information. Details of the screen generation process are shown in FIG.

  First, in step S902, the code generation unit A107 reads the screen information table 300 and the screen item information table 400 from the input / output table A109 of the external storage device A104, and generates screen item generation processing (screen item generation processing, and Processes for incorporating functions such as item selection conditions and screen transitions). Details of the screen item generation processing are shown in FIG.

  FIG. 11 is a flowchart showing an example of a third control processing procedure in the program generation apparatus of the present invention, and corresponds to the screen generation processing shown in step S901 of FIG. That is, this flowchart is realized by the CPU 101 shown in FIG. 2 executing a program stored in the external storage device A 104 or the like on the RAM 102. S1001 to S1008 indicate each step.

  First, in step S1001, the code generation unit A107 reads all records of the screen information table 300 from the input / output table A109 of the external storage device A104, and for all screen information records, as shown in S1002 to S1008, The processing of S1003 to S1007 is performed.

  First, in step S1003, the code generation unit A107 stores an intermediate file of a screen display program file (hereinafter referred to as a screen display program file) corresponding to the screen type 302 of the current record of the screen information table 300 in the external storage device A104. create. That is, this screen display program file is created for each screen. The screen display program file is created by creating a copy of the program template stored in the external storage device A104 having a predetermined program structure. That is, at this time, the screen display program file is still a template, and the process of embedding screen-specific information is performed in S1004 to S1007.

  In step S1004, the code generation unit A107 embeds a code for setting the screen name 301 of the current record in the screen information table 300 in the screen display program file created in S1003.

  In step S1005, the code generation unit A107 embeds a code for setting the screen type 302 of the current record in the screen information table 300 in the screen display program file created in step S1003. In the following, set the item table to be displayed on the screen and the display conditions and proceed to the procedure for embedding the corresponding code. If the screen type is “dialog”, this screen (dialog) will be displayed when this dialog is opened. As a code that realizes the display processing of, embed general-purpose processing code that "searches the data table related to this dialog using the parameters and display conditions received from the transition source screen as search conditions and obtains search results" Shall. This general-purpose processing code is a program generation template having a predetermined program structure, and is stored in the external storage device A104.

  In step S1006, the code generation unit A107 embeds a code for setting the relation table 303 of the current record in the screen information table 300 in the table displayed on this screen in the screen display program file created in S1003. When the screen type is “dialog”, the data table name specified in the related table 303 is embedded as the data table name to be searched in the general-purpose processing code for performing the above-described search processing.

  Finally, in step S1007, the code generation unit A107 embeds a code for setting the display condition 303 of the current record in the screen information table 300 in the screen display program file created in S1003. When the screen type is “dialog”, the display condition specified in the related table 303 is embedded as a search condition in the general-purpose processing code for performing the above-described search process. Then, the processing is shifted to the next screen information record.

  If the code generation unit A107 determines that the processing of S1003 to S1007 has been completed for all the screen information records read in S1001, the processing of this flowchart ends.

  FIG. 12 is a flowchart showing an example of a fourth control processing procedure in the program generation device of the present invention, and corresponds to the screen item generation processing shown in step S902 of FIG. That is, this flowchart is realized by the CPU 101 shown in FIG. 2 executing a program stored in the external storage device A 104 or the like on the RAM 102. S1101 to S1118 indicate each step.

  First, in step S1101, the code generation unit A107 reads all records of the screen information table 300 from the input / output table A109 of the external storage device A104, and for all screen information records, as shown in S1102 to S1118. The processing of S1103 to S1117 is performed.

  First, in step S1103, the code generation unit A107 reads all records of the screen item information table 400 from the external storage device A104, and as shown in S1104 to S1117, S1105 to S1116 for all screen item information records. Perform the process.

  First, in step S1105, the code generation unit A107 executes the current screen for the screen display program file (hereinafter, the current screen display program file) corresponding to the current screen information record generated in step S901 in FIG. A code for setting the item name 402 of the item information record is embedded.

  Next, in step S1106, the code generation unit A107 refers to the item type 403 of the current screen item information record and determines whether or not the current item is a “button”.

  If it is determined in step S1106 that the current item is not a “button”, the code generation unit A107 embeds a code for arranging the input field in the current screen display program file in step S1108. At this time, when the value of the item level 404 of the current item is “1”, it is in a detailed format, and in the case of “2”, it is in a list format (that is, all records to be dynamically changed are displayed in a list (matrix). Embed the placement code (as displayed in the format). That is, in the case of the list format (matrix format), this input field is arranged in a matrix format based on the search result of the related data table, and the input field arranged in the matrix format is set in each record of the search result. Embed the code that sets the value of the corresponding item. For example, the code is embedded so that the input field is arranged as in the department name 514 and the section name 515 in FIGS. Then, the process proceeds to step S1117 to shift the process to the next item.

  On the other hand, if it is determined in step S1106 that the current item is “button”, the code generation unit A107 embeds a code for arranging buttons in the current screen display program file in step S1107. At this time, if the value of the item level 404 of the current item is “1”, it is in the detailed format, and if it is “2”, it is in the list format (that is, the list corresponding to all the records to be dynamically changed) Embed the code to be placed (as displayed). In the case of the list format, for example, a code in which a button is arranged is embedded like a selection button 513 in FIGS. Then, the process proceeds to step S1109.

  In step S1109, the code generation unit A107 determines whether the next screen is a “dialog” based on the next screen 405 of the current screen item information record and the current screen information record.

  If it is determined in step S1109 that the next screen is “dialog”, in step S1110, the code generation unit A107 performs processing when the button is pressed (instructed), and the transition destination is a dialog. A processing code in a certain case (for example, 702 in FIG. 13) is set (embedded) in the current screen display program file. Further, in this processing code, the code generation unit A107 embeds a code for setting information (screen name of the next screen) of the next screen 405 of the current screen item information record. For example, a code indicated by 704 in FIG. 13 is embedded. This code makes it possible to open a dialog from its own screen.

  Further, in step S1111, the code generation unit A107 sets a code for setting the information of the next screen parameter 406 of the current screen item information record for the current screen display program file as the next screen parameter of the transition destination dialog. Embed. For example, the codes indicated by 701 and 703 in FIG. 13 are embedded. This code allows you to pass (and receive) parameters from your screen to the dialog. In this embodiment, since the same item name is set in 701 and 703, the parameter storage item to be passed to the dialog screen as the next screen parameter is also the parameter storage item when returning from the dialog screen. That is, in steps S1110 and S1111, as a code for realizing a screen transition to a dialog type screen, “call the transition destination screen as a dialog and enter the input field on the transition source screen specified as the next screen parameter at the time of screen transition”. Generate code that passes the set value to the transition destination screen. Then, the process proceeds to step S1117 to shift the process to the next item.

  In addition, in the process of returning from the dialog screen to the transition source screen, a code “set the value returned from the transition destination screen in the input field of the transition source screen specified as the next screen parameter” in steps S1113 and S1114 described later. Generate. In this way, it is possible to generate a process of transitioning from the input screen to the dialog screen together with the parameters, and returning to the input screen with the response parameters.

  FIG. 13 is a diagram illustrating an example of a processing code fragment of a button portion that transitions to a dialog output as a result of steps S1110 and S1111 of FIG.

  On the other hand, if it is determined in step S1109 that the next screen is not “dialog”, in step S1112, the code generation unit A107 determines that the own screen is “dialog” based on the screen type 302 of the current screen information record. It is determined whether or not there is.

  If it is determined in step S1112 that the own screen is a “dialog”, in step S1113, the code generation unit A107 performs processing code when the transition destination is not a dialog and the transition source is a dialog (for example, FIG. 14 803) is set (embedded) in the current screen display program file. This includes a process of returning from the dialog screen (originally the transition destination, now the transition source) to the input screen (original is the transition source, now the transition destination). This code makes it possible to transition from the own screen (dialog) to the normal screen. In other words, in steps S1113 and S1114, as the code for realizing the screen transition from the dialog to the normal screen, “input fields arranged in a matrix format corresponding to the pressed (instructed) button (the same as the pressed button). "Code of the input field specified as the next screen parameter in the input field of the row (or column)" is generated.

  Further, in step S1114, the code generation unit A107 embeds a code for setting the information of the next screen parameter 406 of the current screen item information record in the current screen display program file. For example, the codes indicated by 801 and 802 in FIG. 13 are embedded. This code makes it possible to pass parameters from the own screen (dialog) to the normal screen. Then, the process proceeds to step S1117 to shift the process to the next item.

  FIG. 14 is a diagram illustrating an example of a processing code fragment of a button portion that transitions from the dialog output as a result of steps S1113 and S1114 in FIG. 12 to the original screen.

  On the other hand, if it is determined in step S1112 that the own screen is not a “dialog”, in step S1115, the code generation unit A107 obtains a processing code (not shown) when the transition destination and the transition source are normal screens. Set (embed) the current screen display program file. The case of the record 411 of the screen item information table 400 (in the case of the add button 509) corresponds to this. Since this add button 509 is a “registration button”, a code corresponding to the registration process in the related table is embedded in this step. This processing code is also stored in the external storage device A104 as a part created in advance. Then, it is assumed that the information (here, “employee table”) of the related table 303 in the current image information record is embedded in the embedded processing code.

  Furthermore, in step S1116, the code generation unit A107 embeds a code for setting the information of the next screen parameter 406 of the current screen item information record in the current screen display program file. Then, the processing is shifted to the next item.

  If the code generation unit A107 determines that the processing of S1105 to S1116 has been completed for all the screen item information records read in step S1103, the code generation unit A107 shifts the processing to the next screen.

  If the code generation unit A107 determines that the processing of S1103 to S1117 has been completed for all the screen information records read in step S1101, the code generation unit A107 advances the processing to step S1118 and ends the processing of this flowchart. .

  As described above, in the present invention, the selection dialog as input assistance can be freely designed in the same way as the definition of the normal screen, and these are defined by simple designation information as shown in FIGS. Program code can be automatically generated.

  In addition, a user-friendly screen such as a list format (matrix format) can be designed freely, so that related items can be applied to the selection dialog as a list, easy to view, and multiple items can be selected at one time. Easy to select.

  For example, when there are input items of related hierarchies, the dialog is opened for the number of input items in each hierarchy and the items are displayed in a form such as a table that is easy to see, rather than determining the input items. , It is possible to design a dialog that makes it easy to find the corresponding item group.

  Furthermore, when a desired group can be found from the dialog, if a corresponding group is selected once, an effect can be set in which only a necessary item from the group of items included in the group is set as an input value. . That is, it is possible to enjoy the convenience of selecting a plurality of items at a time by one selection.

  As described above, in the generation of the input screen and the dialog screen which is the input assist at the time of application development, there is an effect that it is possible to easily construct a program that makes the hierarchical relationship between the input items and the display format of the related data user-friendly. .

  In addition, the dialog display data can be displayed by narrowing down the necessary items by specifying it by the designer, not the data of the wisdom.

  Similarly, when the selection items of the selection dialog are brought from an external data table or the like, if there is a large amount of data, the search function can be applied to the dialog screen, and the data can be displayed with a moderate amount of data.

  Therefore, the function to display only the part related to the items specified by the designer and display the dialog display data, and if there are many related item groups to be displayed, a search function is added to the dialog screen to complement the items to be displayed. Function can be set.

  For example, when existing data is used in a dialog, items unnecessary for the user are excluded and only necessary items are displayed. On the other hand, when there are many display groups, a significant selection candidate value is obtained by searching. Can be narrowed down within the same dialog screen, so that it is possible to construct a dialog screen that is useful for a large number of displays while maintaining the effect of narrowing down the list.

  Furthermore, it is possible to automatically generate a program that can display a screen in a dialog format with only a simple definition such as specifying a screen type without requiring a troublesome definition associated with screen transition.

  In this way, in the automatic program generation environment, a user-friendly display format such as a table format can be freely designed as an input assist function, which is the original role of the dialog, and a free dialog can be created without impairing the simplicity of the dialog definition. You can enjoy design and dialog screen transition functions.

  The configuration and contents of the various data described above are not limited to this, and it goes without saying that the various data and configurations are configured according to the application and purpose.

  Although one embodiment has been described above, the present invention can take an embodiment as, for example, a system, apparatus, method, program, or recording medium, and specifically includes a plurality of devices. The present invention may be applied to a system including a single device.

  The configuration of a data processing program that can be read by the program generation device according to the present invention will be described below with reference to the memory map shown in FIG.

  FIG. 15 is a diagram for explaining a memory map of a recording medium (storage medium) for storing various data processing programs that can be read by the program generating apparatus according to the present invention.

  Although not specifically shown, information for managing a program group stored in the recording medium, for example, version information, creator, etc. is also stored, and information depending on the OS on the program reading side, for example, a program is identified and displayed. Icons may also be stored.

  Further, data depending on various programs is also managed in the directory. In addition, when a program or data to be installed is compressed, a program to be decompressed may be stored.

  The functions shown in FIGS. 4, 10, 11, and 12 in this embodiment may be performed by a host computer by a program installed from the outside. In this case, the present invention is applied even when an information group including a program is supplied to the output device from a recording medium such as a CD-ROM, a flash memory, or an FD, or from an external recording medium via a network. Is.

  As described above, a recording medium in which a program code of software for realizing the functions of the above-described embodiments is recorded is supplied to the system or apparatus, and the computer (or CPU or MPU) of the system or apparatus is stored in the recording medium. It goes without saying that the object of the present invention can also be achieved by reading and executing the program code.

  In this case, the program code itself read from the recording medium realizes the novel function of the present invention, and the recording medium storing the program code constitutes the present invention.

  As a recording medium for supplying the program code, for example, a flexible disk, hard disk, optical disk, magneto-optical disk, CD-ROM, CD-R, DVD-ROM, magnetic tape, nonvolatile memory card, ROM, EEPROM, A silicon disk or the like can be used.

  Further, by executing the program code read by the computer, not only the functions of the above-described embodiments are realized, but also an OS (operating system) or the like running on the computer based on the instruction of the program code. It goes without saying that a case where the function of the above-described embodiment is realized by performing part or all of the actual processing and the processing is included.

  Furthermore, after the program code read from the recording medium is written in a memory provided in a function expansion board inserted in the computer or a function expansion unit connected to the computer, the function expansion is performed based on the instruction of the program code. It goes without saying that the case where the CPU or the like provided in the board or the function expansion unit performs part or all of the actual processing and the functions of the above-described embodiments are realized by the processing.

  Further, the present invention may be applied to a system composed of a plurality of devices or an apparatus composed of a single device. Needless to say, the present invention can be applied to a case where the present invention is achieved by supplying a program to a system or apparatus. In this case, by reading a recording medium storing a program represented by software for achieving the present invention into the system or apparatus, the system or apparatus can enjoy the effects of the present invention.

  Furthermore, by downloading and reading out a program represented by software for achieving the present invention from a server, database, etc. on a network using a communication program, the system or apparatus can enjoy the effects of the present invention. It becomes.

  In addition, all the structures which combined any one or all of embodiment mentioned above and its modification are also included in this invention.

It is a block diagram which shows one Embodiment of the program production | generation apparatus which can apply the application program automatic generation system which concerns on this invention. It is a block diagram which shows an example of the hardware constitutions of the program generation apparatus shown in FIG. FIG. 2 is a schematic diagram illustrating an example of an entire configuration of a web application system using a servlet code, a JSP code, and a bean code generated by the code generation unit illustrated in FIG. 1 and automatically generated from the program generation apparatus. . It is a flowchart which shows an example of the 1st control processing procedure in the program generator of this invention. It is a schematic diagram which shows an example of the information in the input / output table shown in FIG. It is a schematic diagram which shows an example of the information in the input / output table shown in FIG. FIG. 7 is a schematic diagram showing an example of a screen defined (designated) by the screen information table shown in FIG. 5 and the screen item information table shown in FIG. FIG. 7 is a schematic diagram showing an example of a screen defined (designated) by the screen information table shown in FIG. 5 and the screen item information table shown in FIG. FIG. 7 is a schematic diagram showing a parameter passing operation in each screen of an application defined (designated) in FIG. 5 and FIG. It is a flowchart which shows an example of the 2nd control processing procedure in the program generator of this invention. It is a flowchart which shows an example of the 3rd control processing procedure in the program generator of this invention. It is a flowchart which shows an example of the 4th control processing procedure in the program generator of this invention. It is a figure which shows an example of the fragment | piece of the process code of the button part which changes to the dialog output as a result of step S1110 of FIG. 12, and S1111. It is a figure which shows an example of the fragment | piece of the processing code of the button part which changes to the original screen from the dialog output as a result of step S1113, S1114 of FIG. It is a figure explaining the memory map of the recording medium (storage medium) which stores the various data processing program which can be read with the program generator which concerns on this invention.

Explanation of symbols

A101 Input device A102 Display device A103 Processing device A104 External storage device A105 Screen control unit A107 Code generation unit A108 Overall control unit A109 Input / output table A112 JSP code A113 Servlet code A114 Bean code

Claims (12)

In a program generation device for generating a program,
Definition of screen used in generated program, specification of related data table related to the screen, specification of input / output items to be arranged on the screen, specification of screen transition corresponding to instructions to the input / output items, screen transition Based on designation information including designation of parameters that are sometimes passed from the transition source screen to the transition destination screen, a generating means for generating a program code is provided.
The definition of the screen includes designation of whether the screen to be generated is an accompanying type screen accompanying the transition source screen or a non-accompanying type screen not accompanying the transition source screen,
The generating means includes
As a code for realizing the display processing of the screen specified as the accompanying type in the specification information, “search the related data table based on the parameter passed from the transition source screen and input the input / output items on the screen corresponding to the search result Generate code to set
The code that realizes the screen transition to the screen defined as the accompanying type in the designation information is “call the transition destination screen as the accompanying screen of the transition source screen and input on the transition source screen specified as the parameter at the time of screen transition. Generate code that passes the value set in the output item to the transition destination screen,
As a code that realizes the screen transition from the screen specified as the accompanying type in the specification information to the screen specified as the non-accompanying type, the value of the input / output item on the transition source screen specified as the parameter Generate code to pass to screen
A program generation device characterized by the above. The designation of the input / output items includes designation of whether or not the input / output items are arranged in a matrix format,
The generation means is a code that realizes display processing in a screen that is designated as an accompanying type in the designation information and in which arrangement of input / output items in a matrix format is designated as “related data based on parameters passed from the transition source screen” A table is searched, input / output items specified in a matrix format based on the search result are arranged in a matrix format, and each input / output item arranged in the matrix format corresponds to each record in the search result The program generation apparatus according to claim 1, wherein a code for setting each item value is generated.   The generating means is a code for realizing a screen transition from a screen designated as an accompanying type to a screen designated as a non-associated type in the designation information in response to an instruction for an entry / exit item designated in a matrix format by the designation information. As a feature of generating a code that "passes the value of the input / output item specified as a parameter to the transition destination screen among the input / output items arranged in a matrix format corresponding to the specified input / output item" The program generation device according to claim 2. The designation information includes a search condition of the related data table,
The generating means includes a code for “searching the related data table based on parameters and search conditions passed from the transition source screen” as a code for searching the related data table specified by the specification information. The program generation device according to claim 1, wherein the program generation device is a program generation device.   5. The method according to claim 1, wherein the generation unit generates the program code by incorporating information specified by the specification information into a program template having a predetermined program structure. The program generation device described. In a program generation method for generating a program,
Definition of screen used in generated program, specification of related data table related to the screen, specification of input / output items to be arranged on the screen, specification of screen transition corresponding to instructions to the input / output items, screen transition A generation step for generating a program code based on designation information including designation of a parameter sometimes passed from the transition source screen to the transition destination screen,
The definition of the screen includes designation of whether the screen to be generated is an accompanying type screen accompanying the transition source screen or a non-accompanying type screen not accompanying the transition source screen,
The generating step includes
As a code for realizing the display processing of the screen specified as the accompanying type in the specification information, “search the related data table based on the parameter passed from the transition source screen and input the input / output items on the screen corresponding to the search result Generate code to set
The code that realizes the screen transition to the screen defined as the accompanying type in the designation information is “call the transition destination screen as the accompanying screen of the transition source screen and input on the transition source screen specified as the parameter at the time of screen transition. Generate code that passes the value set in the output item to the transition destination screen,
As a code that realizes the screen transition from the screen specified as the accompanying type in the specification information to the screen specified as the non-accompanying type, the value of the input / output item on the transition source screen specified as the parameter Generate code to pass to screen
A program generation method characterized by the above. The designation of the input / output items includes designation of whether or not the input / output items are arranged in a matrix format,
In the generation step, a code that realizes display processing in a screen that is designated as an accompanying type in the designation information and in which arrangement of input / output items in a matrix format is designated as “related data based on parameters passed from transition source screen” A table is searched, input / output items specified in a matrix format based on the search result are arranged in a matrix format, and each input / output item arranged in the matrix format corresponds to each record in the search result The program generation method according to claim 6, wherein a code for setting each item value is generated.   The generating step is a code for realizing a screen transition from a screen designated as an accompanying type to a screen designated as a non-associated type in the designation information in response to an instruction for an entry / exit item designated in a matrix format by the designation information. As a feature of generating a code that "passes the value of the input / output item specified as a parameter to the transition destination screen among the input / output items arranged in a matrix format corresponding to the specified input / output item" The program generation method according to claim 7. The designation information includes a search condition of the related data table,
The generating step includes a code for “searching the related data table based on parameters and search conditions passed from the transition source screen” as a code for searching the related data table specified by the specification information. The program generation method according to any one of claims 6 to 8, wherein:   10. The program code according to claim 6, wherein the generating step generates a program code by incorporating information specified by the specified information into a program template having a predetermined program structure. 10. The program generation method described.   A program for causing a computer to execute the program generation method according to any one of claims 6 to 10.   A recording medium storing a computer-readable program for causing a computer to execute the program generation method according to claim 6.

Images