JP2005100198A - Programing device, programing method, program, and recording medium - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To dramatically enhance productivity, maintenability and versatility by defining the definition of the preparation of a tabulation table by a Web application in the framework of task specifications, and using the definition of the task application and the definition of the tabulation table which are identical. <P>SOLUTION: The information of a plurality of data items showing their arrangement in a database and information to designate the data items to be tabulated are preliminarily stored in an input/output table 109. A code generating part 107 is characterized by generating a "program code to generate and display a tabulation table to tabulate data corresponding to the data items" based on the information of each data item and the information to designate the data items to be tabulated stored in the input/output table 109. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a program generation apparatus, a program generation method, a program, and a recording medium that generate a summary table and a series of program codes of a web application that controls the summary table.

  Conventionally, when creating a summary table in an application, a dedicated program has been provided for creating a summary table by performing a data summary from a specific viewpoint, aiming to extract specific information from the information stored in the data table.

  However, with such a method, every time the specification of the data table is changed or the viewpoint of the required information is changed, it is necessary to create a program for creating a new tabulation and creating a tabulation table. There was a problem of being big.

  To solve this problem, the “tabulation table creation device and the tabulation table creation program storage medium” disclosed in Japanese Patent Application Laid-Open No. 2000-315242 reads items of a plurality of DBs, displays the items on the screen, and displays the totals. A technique has been proposed in which values are selected from data in a data table and displayed on a screen as a total table by selecting a necessary item as a table item and instructing what kind of processing is to be performed.

By simplifying the creation of the summary table in this way, productivity has improved, and it has become possible to flexibly cope with changes in the specifications of data tables and changes in the viewpoint of information.
JP 2000-315242 A

  However, the conventional summary table creation device disclosed in Patent Document 1 prepares a dedicated application for creating a summary table separately from the original business application, and the definition of the summary table is not defined separately from the business application. It must not be very complicated.

  In addition, the conventional tabulation table creation apparatus disclosed in Patent Document 1 requires a conversion / import program or the like for cooperation with a business application, which takes time for development and is inefficient. It was.

  Further, the conventional summary table creation device disclosed in Patent Document 1 has a problem that the summary table must be defined again when there is a simple specification change such as a change in the sort order of the summary table. There are problems with productivity, maintainability, and versatility.

  The present invention has been made in order to solve the above-described problems, and an object of the present invention is to arrange a plurality of data items in a database and totalize designating one of the data items as a data item to be totaled. The item designation information is stored in the storage means, and based on the information of each data item and the summary item designation information stored in the storage means, a “summary table for summing up data corresponding to the data items is generated. "Program code to be displayed" is generated, so the generation and display of summary tables can be defined and automatically generated within the framework of business specifications. Another object of the present invention is to provide a program generation device, a program generation method, a program, and a recording medium that can significantly improve productivity and maintainability because the same business application definition and summary table definition can be used. .

  According to a first aspect of the present invention, in a program generation device for generating a web application program, storage means for storing information on a plurality of data items indicating arrangement in a database and information for designating data items to be aggregated (FIG. 1 and business process information (FIG. 10) stored in the input / output table 109 in the external storage device 104, information specifying each data item stored in the storage means, and information specifying the data items to be aggregated Based on the above, generation means (code generation unit 107 shown in FIG. 1, steps S503, S504 in FIG. 16, steps S503, FIG. 17) that generates “a program code for generating and displaying a summary table for aggregating data corresponding to the data items” , FIG. 18).

  According to a second aspect of the present invention, the storage means also stores information indicating the type of the tabulation table (display classification of column 5 in the input / output table 109 shown in FIG. 4), and the generation means Generates “a program code for generating and displaying a summary table corresponding to the information indicating the type” based on the information indicating the type of the summary table stored in the storage unit (steps S603 to S607 in FIG. 17). It is characterized by that.

  According to a third aspect of the present invention, the generating means generates "program code for generating and displaying a summary table that can be sorted and displayed by the data items" based on the data items stored in the storage means ( Step S610 in FIG. 17 is characterized.

  According to a fourth aspect of the present invention, for each piece of information of each data item, the storage means specifies information specifying whether or not the data item is the target of the sort display process (the input / output table shown in FIG. 4). 109 is also stored, and the generation unit generates “a program code for generating and displaying a summary table that can be sorted and displayed by the data item to be sorted and displayed”. (Steps S609 and S610 in FIG. 17).

  According to a fifth aspect of the present invention, in the program generation method for generating the web application program, the storage means stores in advance information on a plurality of data items indicating arrangement in the database and information specifying data items to be aggregated. A generation step of generating “a program code for generating and displaying an aggregation table for aggregating data corresponding to the data items” based on the stored information on each data item and information specifying the data items to be aggregated ( Steps S503 and S504 in FIG. 16 and FIGS. 17 and 18) are provided.

  A sixth invention of the present invention is a program for executing the program generation method described in the fifth invention.

  A seventh aspect of the present invention is characterized in that a program for executing the program generation method described in the fifth aspect is stored in a recording medium so as to be readable by a computer.

  According to the present invention, information on a plurality of data items indicating arrangement in a database and information specifying data items to be aggregated are stored in a storage means, and each of the data items stored in the storage means is stored. Based on the information and the information that specifies the data items to be aggregated, a "program code for generating and displaying a summary table for aggregating data corresponding to the data items" is generated. Generation and display can be defined and automatically generated.

  In addition, when generating a summary table by a web application, the definition can be defined within the framework of business specifications, and the same business application definition and summary table definition can be used, thus improving productivity, maintainability, and versatility. It can be significantly improved.

  Furthermore, in the generated summary table, code that can be changed in real time is automatically generated from the displayed screen without having to change the definition for sorting items again, leading to improved productivity and maintainability. .

  In addition, it is possible to switch between the list display and the summary table without changing the definition of the summary table, and the mechanism is automatically generated so that the productivity and versatility can be greatly improved. Play.

  The application development system of the present invention will be described below with reference to the drawings.

  FIG. 1 is a block diagram showing a configuration of a program generation apparatus showing an embodiment of the present invention.

  In the figure, reference numeral 101 denotes an input device, which corresponds to a pointing device such as a keyboard or a mouse, and has business specification information (arrangement of data items in a database and the relationship between data items, that is, under what conditions certain data is present) It is possible to input information indicating what kind of data is to be obtained.

  Reference numeral 102 denotes a display device, which is composed of a CRT, LCD, or the like, and can display a business specification information input screen, business specification information input from the input screen, a generated program code, and the like. An external storage device 104 such as a hard disk stores an input / output table 109 for storing input business specifications, generated program codes (JSP code 112, servlet code 113, bean code 114), and the like. Is.

  A processing unit 103 includes a CPU, a ROM, a RAM, and the like, and is realized by the CPU loading and executing a program stored in the ROM, the external storage device 104, or other recording medium on the RAM. And includes a screen control unit 105 and a code generation unit 107.

  The screen control unit 105 includes a business specification description unit 116 that controls a screen (not shown) of the display device 102 in order to input business specification information from the input device 101.

  The code generation unit 107 generates a program code (JSP code 112, servlet code 113, bean code 114) based on the business specification information input from the input device 101 or read from the external storage device 104. And stored in the external storage device 104.

  An overall control unit 108 controls each unit such as the screen control unit 105 and the code generation unit 107.

  FIG. 2 is a diagram showing an example of the entire configuration of a web application system using a servlet, JSP, and Bean generated by the code generation unit 107 shown in FIG.

  The servlet, JSP, and Bean generated by the code generation unit 107 are arranged on the application server 306 on the server 304 side in an executable state.

  This Web application system is used by the Web browser 302 from the client 301. By accessing the JSP 309 from the web browser 302, an HTML page 303 is generated and returned to the client 301 side. Then, an HTML page 303 transmitted from the JSP 309 is displayed on the web browser 302.

  A request from the Web browser 302 is transmitted to the server 304 side via HTTP. The server 304 includes an HTTP server 305 and an application server 306, and the application server 306 includes a servlet and JSP execution environment.

  When a request is transmitted to the server 304 side, the corresponding servlet 307 is activated according to the request. The servlet 307 requests the corresponding Bean 308 to perform processing. Further, the Bean 308 accesses the database 311 using the DB access object 310, performs business-related processing and data processing, and holds the processing result. The DB access object 310 is a class created as a result of analyzing and designing a business, or an existing class that can be reused.

  Next, the Bean 308 is passed from the servlet 307 to the JSP 309 and the JSP 309 is called. The JSP 309 refers to the processing result held by the Bean 308, generates an HTML page, and returns it to the client 301 side. The HTML page returned to the client 301 is displayed on the Web browser 302.

  The servlet 307 has a role of controlling the connection between receiving requests from the Web browser 302, processing requests to the Bean 308, and calling the JSP 309. The JSP 309 is responsible for the display for outputting the HTML page, and the Bean 308 is responsible for processing related to operations such as access to the database 311. Although it is possible to process a request from the Web browser 302 using only the servlet 307 without using the Bean 308 or JSP 309, the role sharing is simplified by clearly separating each role using the Bean 308 or JSP 309. Can grasp.

  FIG. 3 is a flowchart showing an example of a first control processing procedure in the program generation apparatus of the present invention, and corresponds to the operation of the overall control unit 108 of the processing apparatus 103 shown in FIG. In addition, S101-S105 show each step.

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

  First, when the overall control unit 108 is activated, in step S101, it is determined whether the mode selected by the operator's instruction from the input device 101 is the generation mode or the input mode, and if it is determined that the input mode has been selected. In step S102, the overall control unit 108 activates the screen control unit 105.

  In step S103, the activated screen control unit 105 causes the business specification description unit 116 to display a business specification input screen (not shown), and the application name of the web application to be generated, which is a form of business specifications from the operator. An item input to the output table is accepted, the input / output table is stored in the external storage device 104, and the process ends.

  On the other hand, if it is determined in step S101 that the mode selected by the operator's instruction from the input device 101 is the generation mode, the process proceeds to step S104, and the overall control unit 108 receives the input stored in the external storage device 104. The output table is read, and code generation is performed based on the business specification information in the read input / output table.

  In step S <b> 105, the overall control unit 108 performs an output process of displaying the generated code on the display device 102 or writing to the external storage device 104 in accordance with an operator instruction.

  Hereinafter, with reference to FIG. 4, the business specification information (input / output table) in the program generation apparatus of the present invention will be described. Business specification information input from an input screen (not shown) is stored internally in the form of an input / output table as shown in FIG.

  FIG. 4 is a schematic diagram for explaining the business specification information (the input / output table 109 shown in FIG. 1) in the program generation apparatus of the present invention.

  In FIG. 4, column 1 indicates the data file number, and there is a data file item branch number of column 2 as a data item constituting the data file.

  Column 3 is the name of the data file, and column 4 is the name of each data item corresponding to the data file item branch number.

  Column 5 shows the display classification for designating the form of the tabulation table, “H1” indicating a one-dimensional table (shown in FIGS. 8 and 9 described later), or a two-dimensional table (described later). "H2" indicating that the data is a list (shown in FIG. 12 to be described later) or "H0" is specified. Note that an item for which any one of “H1”, “H2”, and “H0” is specified in column 5 indicates a route item that is not displayed in the table.

  Column 6 shows the items for actually counting the numbers and the calculation classification for specifying the counting method. When “T1” is specified, the vertical total calculation is performed in the one-dimensional table or the two-dimensional table. When “T2” is designated, the horizontal total calculation is performed in the two-dimensional table.

  Column 7 shows the processing formula. As shown in FIG. 5, when "<" is specified in this processing formula, the contents of the table are displayed in ascending order using the specified item as a key. When “>” is designated, the contents of the table are displayed in descending order using the designated item as a key. In addition, when “*” or “**” is designated in this processing formula, the item of which “T1” or “T2” is designated in the operation classification of column 6 as the unit of the designated parent item. Indicates that the values are aggregated and displayed (however, “*” indicates that only two or more target data are displayed).

  Column 8 indicates the order in which items are processed, and items whose numbers are described in this order are processed in the order of the described numbers.

  Column 9 shows a key function. When the order of other items (shown in column 11) is designated for this key function, the item is displayed in the order of the order indicated by the key function. Indicates that the item is a key item.

  Column 10 indicates the designation of the sort function. When “ON” is designated for this sort function, the value is rearranged by clicking the item name and using that item as a key. Indicates that processing will be added.

  The column 11 indicates the arrangement order (1, 2, 3,...) Of corresponding items in the arrangement order.

  The program generation apparatus of the present embodiment generates a tree as shown in FIG. 7 to be described later from the business specification information (input / output table) shown in FIG. 4, and based on the generated tree data, a tabulation table (FIG. 8). (Shown in FIG. 12).

  FIG. 6 shows the processing order of processing each item in the input / output table when this tree is created.

  As shown in FIG. 6, the item whose display classification in the column 5 is “H1”, “H2”, or “H0” is the processing order “1”, and is set as the root element of the tree. The root element of this tree is single and represents the summary table itself. In addition, each component of the summary table is related in a form leveled to the root.

  For example, FIG. 7 shows a tree generated from the input / output table shown in FIG.

  The tree level arrangement method shown in FIG. 7 will be described below with reference to FIG.

  As shown in FIG. 6 described above, the item with the processing order “1” is the item whose display classification in the column 5 is “H1”, “H2”, or “H0”, and is arranged in the root (level 0). The In the example shown in FIG. 4, the “sales list code” in the order “1” is arranged in the route (level 0).

  Next, the item having the processing order “2” is an item in which the processing formula in the column 7 is “<” or “>”, and is arranged in the level 1. When "<" or ">" is specified for multiple items, the parent is given priority when the parent-child relationship is established, and the younger in the order of arrangement (column 11) is given priority when it is not established (however, all levels 1). In the example shown in FIG. 4, “sales store code” in the order “2” is arranged at level 1.

  Next, the item with the processing order “3” is an item in which the order in column 8 is described, and is sequentially arranged from the item with the smallest order (note that a parent-child relationship (one-to-many relationship in the database) is established. If you lower the level).

  In the example shown in FIG. 4, the order of the “product classification code” in the arrangement order “5” is “1”, so the “product classification code” is first arranged after the “sales store code”. . However, since “sales store code” and “product classification code” have a one-to-many relationship in an input / output table that defines a data file number “SalesList” (not shown), the “product classification code” is “sales It is arranged at level 2 one level lower than the “store code”.

  Furthermore, the order of the “product code” in the arrangement order “4” is “2”, which is arranged after the “product classification code”. However, since the “product classification code” and the “product code” have a one-to-many relationship in the input / output table that defines the data file number “SalesList” (not shown), the “product code” is the above-mentioned “product classification code”. It is placed at level 3 which is one lower than the “code”.

  Here, although not shown in FIG. 6, items not specified in any of columns 5 to 9 are arranged at a level one level lower than the current or at the same level according to the parent-child relationship. In addition, when there are a plurality of similar items, priority is given to the younger of the arrangement order (column 11). Note that there is no corresponding item in FIG.

  Finally, the item with the processing order “4” is an item whose operation classification in the column 6 is “T1” or “T2”, and is arranged at a level one level lower than or equal to the current level depending on the parent-child relationship. The In the example shown in FIG. 4, the operation classification of “number of sales” in the order of arrangement “8” is “T1”. Since “sales number” and “product code” have a one-to-one relationship in an input / output table that defines a data file number “SalesList” (not shown), the “sales number” is “product code”. Arranged at the same level (level 3).

  Although not shown in FIG. 6, when the arrangement order of other items (column 11) is designated for the key function in column 9, the item is an item in the arrangement order shown in the key function. Next (same level). In the example shown in FIG. 4, since the key function of “sales store” in the order “3” is “2”, the “sales store” is the same as the “sales store code” in the order “2”. Located at level 1. Also, since the key function of “product category name” in the order “6” is “5”, the “product category name” is arranged at the same level 2 as the “product category code” in the order “5”. Is done. Furthermore, since the key function of “product name” in the order “7” is “4”, the “product name” is arranged at the same level 3 as the “product code” in the order “4”.

  Although not shown in FIG. 6, the operation classification of column 6 is set to the same level as the item for which “*” or “**” is specified in the processing formula of column 7 and the unit of the parent item of the item is the operation classification. A label “total” for totalizing and displaying the value of the item “sales number” for which “T1” or “T2” is designated and the total value “sales number” are generated and arranged. In the example shown in FIG. 4, since the processing formula of “product code” in the order “4” is “**”, the parent item “product classification code” is at the same level 3 as the “product code”. ”And“ Product category name ”are arranged in units of“ total ”for totaling“ number of sales ”.

  Furthermore, since the processing formula of the “product classification code” in the order “5” is also “**”, the parent items “sales store code” and “sales” are at the same level 2 as the “product classification code”. A label “total” for totalizing and displaying “number of sales” and “total number of sales” as the total value are arranged in the “store” unit.

  In addition, it is assumed that the processing order of items having the same processing order shown in FIG. That is, items with the same level are displayed in the order of arrangement.

  As described above, the tree structure data shown in FIG. 7 is created by performing the processing in the processing order shown in FIG. Based on the data of the tree structure, a program code for creating the display of FIGS.

  Referring to FIG. 8 as an example, “sales store code” arranged at level 1 in FIG. 7 is displayed in the first column of FIG. 8, and then the level is similarly displayed in the second column of FIG. “Sales store” arranged in 1 is displayed. The “sales store” displayed in the second column in FIG. 8 is at the same level as the “sales store code” displayed in the first column, and has a one-to-one relationship.

  Further, the “product classification code” arranged at level 2 is displayed in the third column of FIG. 8, and then the “product classification name” arranged in level 2 is also displayed in the fourth column of FIG. Is displayed. Note that the “product classification code” displayed in the third column in FIG. 8 is one level lower than the “sales store” displayed in the second column. The “sales store” 1 can display “product classification code” (multiple) (that is, a parent-child relationship).

  Next, in the fourth column in FIG. 8, “product category names” arranged in level 2 are displayed. Note that the “product category name” displayed in the fourth column in FIG. 8 is at the same level as the “product category name” displayed in the third column, and has a one-to-one relationship.

  In addition, “product code” arranged at level 3 is displayed in the fifth column of FIG. 8, and then “product name” arranged in level 3 is displayed in the sixth column of FIG. Is done. Note that the “product code” displayed in the fifth column in FIG. 8 is one level lower than the “product category name” displayed in the fourth column, and “product category name” and “product code” are displayed. The number of “product code” can be displayed for “product category name” 1 (ie, a parent-child relationship).

  Next, in the seventh column of FIG. 8, “number of sales” arranged in level 3 is displayed. Note that the “sales number” displayed in the seventh column in FIG. 8 is at the same level as the “product name” displayed in the sixth column, and has a one-to-one relationship.

  In lines 4, 7, 14, 18, 24, 27, 30, and 33 in FIG. 8, the label “total” arranged at level 3 and “sales number” corresponding to the subtotal display for each product classification code are displayed. The

  In rows 8, 10, 20, and 34 of FIG. 8, the label “total” arranged at level 2 and “number of sales” corresponding to the subtotal display for each sales store code are displayed.

  In the row 35 of FIG. 8, the label “total” arranged at level 2 and the “number of sales” corresponding to the total display of the route are displayed.

  In the table shown in FIG. 8, the sales list code arranged at level 0 in FIG. 7 is not displayed, but this is a root element representing the aggregation table itself defined in the input / output table shown in FIG. Because.

  FIG. 8 is a schematic diagram showing an example of a one-dimensional table generated from the input / output table shown in FIG. 4 and the tree shown in FIG.

  When the title item “product classification code” is clicked on the screen in the state of FIG. 8, the sort function automatically generated from the definition of the column 10 in FIG. 4 changes the order of the table contents as shown in FIG. .

  FIG. 9 is a schematic diagram showing a display example when the one-dimensional table shown in FIG. 8 is sorted by the “product classification code” in the third column.

  FIG. 10 is a schematic diagram illustrating an example of the two-dimensional table generated from the tree illustrated in FIG. 7, and the display classification of the input / output table arrangement order “1” illustrated in FIG. 4 is “H2”. This corresponds to the case where the calculation classification “8” is generated as “T2”.

  In the tabulation table shown in FIG. 10, product classification codes designated as keys are displayed on the left, and child elements are arranged on the right from there. In addition, the “sales store code” in the order “2”, which has been designated as a key in the definition of the one-dimensional table, is displayed in the tabulation table as a vertical item key.

  When the title of “product classification name” is clicked on the screen in the state of FIG. 10, the sort processing is performed in the same manner as the one-dimensional table, and the display is as shown in FIG.

  FIG. 11 is a schematic diagram illustrating a display example when the two-dimensional table illustrated in FIG. 10 is sorted by “product classification name” in the second column.

  FIG. 12 is a schematic diagram illustrating an example of the list generated from the tree illustrated in FIG. 7, where the display classification of the input / output table arrangement order “1” illustrated in FIG. 4 is “H0”, and the arrangement order “ This corresponds to the case where the operation classification “8” is generated as a blank.

  Hereinafter, the code generation process by the code generation unit 107 illustrated in FIG. 1 will be described with reference to the flowcharts of FIGS.

  FIG. 13 is a flowchart showing an example of the second control processing procedure of the present invention, and corresponds to the code generation processing by the code generation unit 107 shown in FIG. S201 to S203 indicate steps.

  First, in step S201, a bean code 114 for performing processing for obtaining the value of each data file item from the database is generated based on the input / output table 109 (details are shown in FIG. 14).

  Next, in step S202, based on the input / output table 109, the servlet code 113 that acquires input data from the web browser and starts the JSP is generated (details are shown in FIG. 15).

  Next, in step S203, the JSP code 112 for controlling the display on the web browser is generated (details are shown in FIG. 16), the process is terminated, and the process returns to the flowchart of FIG.

  FIG. 14 is a flowchart showing an example of the third control processing procedure of the present invention, and corresponds to the bean creation processing (step S201 in FIG. 13) by the code generation unit 107 shown in FIG. S301 to S303 indicate each step.

  First, in step S301, a bean file for database operation is generated. The bean file name is, for example, a bean file in which a character string “Bean” is added to an application name input from an input screen (not shown) and an extension is “java (registered trademark)”. At this time, at the top of the created Bean file, a declaration of “package name (for example, an application name added with a character string“ Bean ”), an import of a“ Java (registered trademark) .sql ”package, a Java (Registered trademark) “code for implementing an interface necessary for using Beans” is stored.

  Next, in step S302, the input / output table 109 is read, and in step S303, a search processing code for each data file in the input / output table 109 is generated in the bean file. Specifically, “Connect to database, execute query of SQL statement for processing to acquire data from table corresponding to corresponding data file number for each data file, return acquisition result, and disconnect from database Code (data acquisition method) "is generated in the Bean file.

  Then, the process ends and the process returns to the flowchart of FIG.

  Note that the code generated in the Bean file in step S303 includes the following: “Process to load driver class, process to connect to database, process to generate SQL statement object, SQL statement based on data passed from servlet” The code for performing the process of executing the above query to acquire the result, the process of setting the result, and the process of closing the SQL statement object and the database connection object are described.

  The data acquisition processing code generated in step S303 is generated as a data acquisition method in a business processing class defined in the Bean file (for example, class name: character string “DBAccess” added to application name). Shall.

  FIG. 15 is a flowchart showing an example of the fourth control processing procedure of the present invention, and corresponds to the servlet creation processing (step S202 in FIG. 13) by the code generation unit 107 shown in FIG. S401 to S403 indicate each step.

  First, in step S401, a servlet file is generated. As for the file name of the servlet file, for example, a character string “Servlet” is added to the application name and the extension is set to “java (registered trademark)”. At this time, at the top of the servlet file, “code to import the Bean package to be used and other necessary packages, access modifier, class definition, inheritance of class (for example, HTTP Servlet class), web browser (HTML form) ”) Is stored in the“ code indicating the method for receiving the parameter (transmission information) transmitted from () ”.

  Next, in step S402, “code for receiving transmission information from the web browser” is generated in the servlet file.

  Next, in step S403, a “code for calling the corresponding JSP” is generated in the servlet file, the process ends, and the process returns to the flowchart of FIG.

  FIG. 16 is a flowchart showing an example of the fifth control processing procedure of the present invention, and corresponds to the JSP creation processing (step S203 in FIG. 13) by the code generation unit 107 shown in FIG. S501 to S504 indicate each step.

  First, in step S501, a JSP file is generated. The file name of the JSP file is, for example, an application name with an extension “jsp”. The JSP file includes “a code for setting a MIME type of the JSP page and a character set to be encoded, a code for instantiating a Bean corresponding to the data file, and an html tag“ <html> <head> < It is assumed that a code such as “title> application name </ title>” is generated and stored.

  Next, in step S502, a “code for calling and executing a method for acquiring a Bean data and acquiring the processing result of the search method from the Bean” is generated.

  Next, in step S503, data having a tree structure as shown in FIG. 7 (hereinafter simply referred to as a tree) is generated. In step S504, a summary table generation process (details are shown in FIG. 17) based on the generated tree. ) To finish the process and return to the flowchart of FIG.

  FIG. 17 is a flowchart showing an example of the sixth control processing procedure of the present invention, and corresponds to the tabulation table generation processing (step S502 in FIG. 16) by the code generation unit 107 shown in FIG. In addition, S601-S612 shows each step.

  First, in step S601, one item is read from the upper level of the tree. In step S602, it is determined whether the read item is level 0. If it is determined that the item is level 0, in step S603, It is determined whether or not the display classification (column 5) of the item is “H1”, and if it is determined that the display classification (column 5) is “H1”, in step S604, FIG. The process for creating the one-dimensional table as shown is started, and the process returns to step S601.

  On the other hand, if it is determined in step S603 that the display classification of the item (column 5) = “H1”, it is determined in step S605 whether the display classification of the item (column 5) = “H2”. If it is determined that the display classification (column 5) is “H2”, a process of creating a two-dimensional table as shown in FIG. 10 is started in step S606, and the process returns to step S601. .

  On the other hand, if it is determined in step S605 that the display classification (column 5) of the item is not “H2”, processing for creating a list as shown in FIG. 12 is started in step S607, and step S601 is executed. Return to.

  On the other hand, if it is determined in step S602 that the read item is not level 0, in step S608, a “code for displaying the title item” is generated in the JSP file.

  Next, in step S609, it is determined whether or not the item is a sort function (column 10) = “ON” item, and it is determined that the item is not a sort function (column 10) = “ON” item. In that case, the process proceeds to step S611 as it is.

  On the other hand, if it is determined in step S609 that the item is an item of sort function (column 10) = “ON”, in step S610, “corresponding item when the title of the corresponding item is designated. Is generated in the JSP file, and the process advances to step S611.

  Next, in step S611, a data display creation process for creating a code for displaying the data acquired from the database in step S502 of FIG. 16 is performed, and the process proceeds to step S612.

  Next, in step S612, it is determined whether or not the processing of S601 to S611 has been completed for all items in the tree. If it is determined that the processing has not ended, the processing returns to step S601.

  On the other hand, if it is determined in step S612 that the processes in S601 to S611 have been completed for all items in the tree, the process is terminated and the process returns to the flowchart of FIG.

  FIG. 18 is a flowchart showing an example of the seventh control processing procedure of the present invention, and corresponds to the data display creation processing (step S611 in FIG. 17) by the code generation unit 107 shown in FIG. In addition, S701-S715 show each step.

  First, in step S701, it is determined whether or not the item is an item of processing formula (column 7) = “<”. If it is determined that the item is processing formula (column 7) = “<”, In step S702, “a code for setting the item as the default sort key and“ ascending order ”as the default sort direction” is generated in the JSP file. In step S703, “the sort key and the sort direction are designated in the request object”. When information is stored, the sort key and sort direction are used. On the other hand, when information specifying the sort key and sort direction is not stored in the request object, the default sort key and sort direction are used. A code for sorting and displaying the data of the item ”is generated in the JSP file, the process is terminated, and the flow of FIG. Back to the chart.

  On the other hand, if it is determined in step S701 that the item is not an item of processing formula (column 7) = “<”, the item is an item of processing formula (column 7) = “>” in step S704. In step S705, "set the item as the default sort key and set" descending order "as the default sort direction. Is generated in the JSP file. In step S706, if the information specifying the sort key and sort direction is stored in the request object, the sort key and sort direction are used. If the information specifying the sort key and sort direction is not stored in the default sort key and sort direction, Generate code "to sort Show over data in JSP files, end the process returns to the flowchart of FIG. 17.

  On the other hand, if it is determined in step S704 that the item is not an item of processing formula (column 7) = “>”, in step S707, the item is an item of processing formula (column 7) = “**”. If it is determined whether or not it is an item of processing formula (column 7) = “**”, in step S708, “information specifying the sort key and the sort direction is stored in the request object. If there is no information specifying the sort key and sort direction in the request object, the default sort key and sort direction are used to store the data of the item. Are generated in the JSP file, and in step S709, “corresponding to“ T1 ”or“ T2 ”corresponding to the parent item unit of the item”. Performs arithmetic processing of the items, to generate code "for displaying the calculation result with a label" meter "to JSP file, and terminates the processing returns to the flowchart of FIG. 17.

  On the other hand, if it is determined in step S707 that the item is not an item of processing formula (column 7) = “**”, the item is an item of processing formula (column 7) = “*” in step S710. If it is determined whether or not it is an item of processing formula (column 7) = “*”, in step S711, “information specifying the sort key and the sort direction is stored in the request object. If there is no information specifying the sort key and sort direction in the request object, the default sort key and sort direction are used to store the data of the item. “Code for sorting display” is generated in the JSP file. In step S712, “when there are two or more items, the parent item unit of the item is set to“ T1 Or performs arithmetic processing of items corresponding to the "T2", generates a code "for displaying the calculation result with a label" meter "to JSP file, and terminates the processing returns to the flowchart of FIG. 17.

  On the other hand, if it is determined in step S710 that the item is not an item of processing formula (column 7) = “*”, in step S713, “information specifying the sort key and sort direction is stored in the request object. If there is no information specifying the sort key and sort direction in the request object, the default sort key and sort direction are used to store the data of the item. “Code to be sorted” is generated in the JSP file, and in step S714, it is determined whether or not the item is an operation classification (column 6) = “T1” or “T2” item. ) = “T1” or “T2”, if it is determined that the item is “T1” or “T2”, in step S715 “ Generate code "to be displayed on the JSP file, and terminates the processing returns to the flowchart of FIG. 17. Specifically, when the calculation classification (column 6) = “T1”, only vertical calculation is performed, and when “T2”, vertical and horizontal two-dimensional calculation is performed, and the calculation result is displayed together with the label “total”. Generate code to

  On the other hand, if it is determined in step S714 that the item is not an operation classification (column 6) = “T1” or “T2” item, the process ends and the process returns to the flowchart of FIG.

  Note that the code for adding the sort function shown in step S610 in FIG. 17 is Java (registered trademark) that transmits information indicating which item is used for sorting to the servlet and displays the screen again. This corresponds to the Script code.

  Further, the code generated in steps S703, S706, S708, S711, and S713 in FIG. 18 is “the item corresponding to the sort key based on the sort key stored in the request object when displaying item data”. The code for sorting and displaying data using as a key.

  Hereinafter, the summary table generation process will be described more specifically by taking the input / output table shown in FIG. 4 as an example.

  First, an item “sales list code” (arrangement order 1) at level 0 is processed from the tree shown in FIG.

  In the item of “sales list code” (arrangement order 1), “H1” is designated in column 5, indicating that the subsequent items are to be included in the tabulation table, and are treated as root elements at the same time.

  Next, the level 1 item “sales store code” (arrangement order 2) is processed.

  In the item of “sales store code” (arrangement order 2), “<” is specified in the processing formula of column 7, indicating that the contents of the summary table are displayed in ascending order based on this value. Yes. In addition, a code for generating the data file item name “sales store code” in column 4 as the title item at the upper left corner is generated. Moreover, the code | cord | chord which displays the value under the display is produced | generated.

  Furthermore, since “ON” is specified as the value of the sort function in column 10, a code added by clicking the title item “sales store code” adds a function that rearranges the table in ascending or descending order using the value of that item as a key. Is generated.

  Next, processing is performed on the item “sales store” (level 3) which is also level 1. In the item “sales store” (arranged order 3), “sales store” in column 4 is displayed as the title item to the right of the above “sales store code”, and a code is displayed in which the value is displayed below. . Furthermore, since “ON” is designated in the column 10, a code for adding a sorting function to the title item is generated.

  Next, the level 2 item “product classification code” (arrangement order 5) is processed. In the “product classification code” (arrangement order 5), the “product classification code” is displayed as a title on the right side of the above “sales store”, and a code is displayed in which a value is displayed below.

  In addition, since “**” is specified in the processing formula of column 7 of “product classification code” (arrangement order 5), “T1” is specified in column 6 based on the sales store of the parent element. Calculate the value of “Number of units sold” and insert the item name of “Total” below the value of the product classification code. The calculated value is displayed in the same row as “Total” in the column of the item for which “T1” is specified in column 6 (that is, the item at the right end of the table, in this case, the “Sales Unit” column). Generate code (corresponds to level 2 “total”). Furthermore, since “ON” is designated in the column 10, a code for adding a sorting function to the title item is generated.

  Next, the processing of the item “product classification name” (arrangement order 6) which is also level 2 is performed.

  In the “product category name” (arrangement order 6), a “product category name” in column 4 is displayed as a title item to the right of the above “product category code”, and a code in which the value is displayed below is generated. . Furthermore, since “ON” is designated in the column 10, a code for adding a sorting function to the title item is generated.

  Next, level 3 item “product code” (arrangement order 4) is processed.

  In “product code” (arrangement order 4), “product code” is displayed as a title to the right of the above “product classification name”, and a code is displayed in which a value is displayed below.

  In addition, since “**” is specified in the processing formula of column 7 of “product code” (arrangement order 4), “T1” is set in column 6 based on “product classification name” that is higher than “product code”. Is calculated, and the code for inserting the item name of “total” under the value of the product code is generated. A code is generated that is displayed in the same row as the “total” in the column of the item for which the calculated value “T1” is specified in column 6 (that is, the column “item sales” at the right end of the table) ( Corresponds to level 3 “total”). Furthermore, since “ON” is designated in the column 10, a code for adding a sorting function to the title item is generated.

  Next, the processing of the item “product name” (arrangement order 7) which is also level 3 is performed.

  In the “product name” (arrangement order 7), a “product name” in column 4 is displayed as a title item on the right side of the above “product code”, and a code is displayed in which a value is displayed below. Further, since “ON” is designated in the column 10, a code for adding a sort function to the title item is generated.

  Finally, the processing of the item “number of sales” (order 8) at level 4 is performed.

  In “Sales Volume” (arrangement order 8), “Sales Volume” in column 4 is displayed as a title item to the right of the above “Product Name”, and a value is displayed below it. Since “T1” is designated as the operation classification in the column 6, the value of the number of sales is totaled and the total is displayed at the bottom of the table. The item name “total” is displayed on the left side of the same line in the total display of the number of sales.

  As described above, in the generation of the summary table by the web application, the definition can be defined within the framework of the business specification and can be automatically generated, so that productivity, maintainability, and versatility can be significantly improved.

  In addition, in the generated summary table, code that can be changed in real time from the screen displayed in a tabulated view without needing to change the definition again for item sorting is automatically generated, greatly improving productivity and maintainability. can do.

  In addition, the list display and the summary table can be switched between each other without changing the definition of the summary table, and the mechanism is automatically generated, so the productivity and versatility can be greatly improved. Play.

  In the present embodiment, the case where a web application using a server-side Java (registered trademark) program is generated has been described. However, the generated program code is not limited to Java (registered trademark), but ASP. It may be a web application based on other programs such as (Active Server Pages) and PHP (Hypertext Preprocessor).

  Moreover, although the case where Java (trademark) Script was used was demonstrated, you may use another script language.

  Furthermore, the contents of the input / output table shown in FIG. 4 are not limited to these, and it is needless to say that the contents of the input / output table are configured in various configurations and contents depending on the application and purpose.

  Although not shown in the flowchart, the data file item defined by designating “F” in the input / output item display classification (column 5) is shown. A table having the data file item branch number as the item name and the data file number as the table name may be created in the database.

  In addition, the program generation apparatus of the present embodiment may be configured to create a web application (business application) that performs new / update / search / deletion to the created database.

  In this way, since the same business application definition and summary table definition can be used, productivity and maintainability can be significantly improved.

  Moreover, all the structures which combined each modification of the said embodiment are also contained in this invention.

  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.

  As described above, since the business specification is input and the program code related to the summary table is generated, the definition of the summary table generated by the web application can be defined within the framework of the business specification and can be automatically generated.

  In addition, since the business specification is input and program code for displaying the summary table or list is selectively generated, the list display and summary table can be switched between each other without changing the definition of the summary table. The mechanism can be automatically generated.

  Furthermore, since the attribute information in the business specification is used as input and a program code related to the item sorting process is generated, a mechanism that can change the item sorting in the generated summary table in real time from the displayed screen is automatically generated. be able to.

  Therefore, it is possible to generate a web application that displays and displays a tabulation table that has greatly improved productivity, maintainability, and versatility.

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

  FIG. 19 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.

  3, 13, 14, 15, 16, 17, and 18 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 recording software program codes for realizing the functions of the above-described embodiments is supplied to a system or apparatus, and a computer (or CPU or MPU) of the system or apparatus stores the recording medium in the recording medium. It goes without saying that the object of the present invention can also be achieved by reading and executing the programmed 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.

  The program code generated by the program generation device of the present invention is a web application using a program other than Java (registered trademark) such as ASP (Active Server Pages), PHP (Hypertext Preprocessor), etc. The generation apparatus can also be applied to generation of various web applications.

It is a block diagram which shows the structure of the program production | generation apparatus which shows one Embodiment of this invention. It is a figure which shows an example of the whole structure of the web application system using the servlet produced | generated by the code production | generation part shown in FIG. 1, JSP, and Bean. 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 explaining the business specification (input / output table shown in FIG. 1) in the program generation device of the present invention. It is a figure which shows the process type classification | category list of 7 columns of the input-output table shown in FIG. It is a figure which shows the processing order of the input / output table shown in FIG. FIG. 5 is a schematic diagram illustrating an example of a tree generated from the input / output table illustrated in FIG. 4. FIG. 8 is a schematic diagram illustrating an example of a one-dimensional table generated from the input / output table illustrated in FIG. 4 and the tree illustrated in FIG. 7. It is a schematic diagram which shows the example of a display at the time of sorting the one-dimensional table | surface shown in FIG. 8 by the "product classification code" of the 3rd column. It is a schematic diagram which shows an example of the two-dimensional table produced | generated from the tree shown in FIG. FIG. 11 is a schematic diagram illustrating a display example when the two-dimensional table illustrated in FIG. 10 is sorted by “product classification name” in the second column. FIG. 8 is a schematic diagram illustrating an example of a list generated from the tree illustrated in FIG. 7. It is a flowchart which shows an example of the 2nd control processing procedure of this invention. It is a flowchart which shows an example of the 3rd control processing procedure of this invention. It is a flowchart which shows an example of the 4th control processing procedure of this invention. It is a flowchart which shows an example of the 5th control processing procedure of this invention. It is a flowchart which shows an example of the 6th control processing procedure of this invention. It is a flowchart which shows an example of the 7th control processing procedure of this invention. 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 by the program generator which concerns on this invention.

Explanation of symbols

101 Input device 102 Display device 103 Processing device (CPU, RAM, ROM)
104 External storage device (hard disk)
105 Screen Control Unit 116 Business Specification Description Unit 107 Code Generation Unit 108 Overall Control Unit 109 Input / Output Table 112 JSP Code 113 Servlet Code 114 Bean Code

Claims (7)

In a program generation device for generating a web application program,
Storage means for storing arrangement of a plurality of data items in a database and aggregate item designation information for designating any one of the data items as a data item to be aggregated;
Generating means for generating “program code for generating and displaying a summary table for aggregating data corresponding to the data items” based on the information of each data item and the summary item designation information stored in the storage means;
A program generation apparatus comprising: The storage means also stores information indicating the type of the summary table,
The generating unit generates "a program code for generating and displaying a summary table corresponding to the information indicating the type" based on information indicating the type of the summary table stored in the storage unit. Item 2. The program generation device according to Item 1.   The generation unit generates a "program code for generating and displaying a summary table that can be sorted and displayed by the data items" based on the data items stored in the storage unit. The program generation device described. The storage means also stores, for each information of each data item, information for specifying whether or not the data item is the target of the sort display process,
The said production | generation means produces | generates "the program code which produces | generates and displays the totalization table which can be sorted and displayed by the data item used as the said sort display process", The Claim 1 characterized by the above-mentioned. Program generator. In a program generation method for generating a web application program,
Information for each of the data items and information for specifying the data items to be aggregated stored in a storage means for storing information on a plurality of data items indicating arrangement in the database in advance and information for designating the data items to be aggregated; And a generating step of generating “a program code for generating and displaying a summary table for aggregating data corresponding to the data item”.   A program for executing the program generation method according to claim 5.   A recording medium storing a computer-readable program for executing the program generating method according to claim 5.

Images