JP2013235388A - Application development support system and application development support program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To dynamically change items such as the appearance and attribute of a control that displays input/output items on a screen, without making a change to a generated source code.SOLUTION: An application development support system 1 having a code generation server 10 comprises a dictionary server 20 having a dictionary table 22 which holds information including parameter initial values of a part object 15 by using identification information of input/output items which is displayed on a screen as a key. The code generation server 10 includes a code generation unit 13 that constitutes a Web application program by invoking the part object 15 for respectively displaying each input/output item on the screen and that generates a source code 40. The part object 15 obtains parameters of the part object 15 from the dictionary table 22 during execution; and displays a label control and/or an input/output control.

Description

  The present invention relates to a technology for supporting the development of an application program, and in particular, an application development support system and an application development support program for automatically generating source code for a CRUD (Create, Read, Update, Delete) type application program for a database. It is related to technology effective when applied to.

  For the purpose of reducing development load and standardization when developing web application programs, for example, the so-called Integrated Development Environment (IDE) including GUI (Graphical User Interface) creation function, Ruby on Rails (RoR) In many cases, an application framework such as Non-Patent Document 1) is used. Moreover, using these in combination is also performed. By using such a development support tool or the like, it is possible to automatically generate source code for a Web application program having a user interface, for example.

  However, with these development support tools, changes and adjustments of the screen display contents (for example, display items and controls (components) on the screen, their attributes, etc.) are further changed for the application that automatically generated the source code. ), It is necessary to take a complicated procedure. For example, you can use the GUI creation function of the development support tool to modify the settings and definitions of the screen display contents, automatically generate the source code again, and build it as necessary. It is necessary to perform work such as replacing a new module. Such work is not only a burden for developers, but can also be a factor in inducing obstacles.

  On the other hand, for example, in Japanese Patent Application Laid-Open No. 2007-280189 (Patent Document 1), in a program generation device that generates a program for changing a setting of a screen displayed from a display screen provided in a server, When changing the screen, the screen item information management unit creates a display item file based on the screen item information, the input item / column correspondence unit creates the input item file based on the table item information, and the output item / Column corresponding section creates output item file based on table item information, and program generation section generates screen program and server program using display item file, input item file, and output item file Screen without changing the source code of the screen program and server program. Additional techniques are described.

JP 2007-280189 A

Internet <URL: http://rubyonrails.org/>

  By using the technique described in Patent Document 1, it is possible to change the contents of the screen display without changing the source code. However, with the technology described in Patent Document 1, it is possible to change what items are displayed as input / output items on the screen and the correspondence between the display items and the database columns. However, for example, the work of building a user interface while adjusting the appearance and attributes of each control that displays input / output items by trial and error, without changing the source code once created, or Even if a change is made, it is difficult to perform the change dynamically only by a simple change.

  Therefore, the object of the present invention is to automatically generate a source code for a CRUD type application program or the like for a database, and then, without any change to the generated source code, or only by a simple change, An object of the present invention is to provide an application development support system and an application development support program that can dynamically change the appearance and attributes of a control that displays input / output items on a screen.

  The above and other objects and novel features of the present invention will be apparent from the description of this specification and the accompanying drawings.

  Of the inventions disclosed in this application, the outline of typical ones will be briefly described as follows.

  An application development support system according to a typical embodiment of the present invention is a system having a code generation server that generates a source code of a Web application program running on an application server, and has the following features.

  In other words, the application development support system further uses the identification information of one or more input / output items displayed on the screen when the Web application program is executed as a key, and a display name indicating the label control text for the input / output items. A dictionary table that holds, as dictionary data, information consisting of initial values of one or more parameters for a part object having at least information on the input / output items and information relating to input / output control displayed to input or output the input / output items The code generation server configures the Web application program by calling the part object for displaying each of the input / output items on the screen, and the configured Web application. Having a code generator for generating a source code of the Deployment program.

  When the part object is called to display a corresponding input / output item on the screen when the web application program is executed on the application server, the dictionary server uses the identification information of the input / output item as a key. Information on part or all of the parameters for the part object is acquired from the dictionary table above, and the label control and / or the input / output control is displayed based on the acquired parameter. It is what.

  The present invention can also be applied to a program that causes a computer to operate as a code generation server in the application development support system as described above.

  Among the inventions disclosed in the present application, effects obtained by typical ones will be briefly described as follows.

  That is, according to a typical embodiment of the present invention, source code for a CRUD type application program or the like for a database is automatically generated, and then the generated source code is added or not changed. Even with simple changes, it is possible to dynamically change the screen contents such as the appearance and attributes of controls that display input / output items on the screen.

It is the figure which showed the outline | summary about the structural example of the application development assistance system which is one embodiment of this invention. It is the figure which showed the outline | summary about the example of the process at the time of displaying the input / output item of the column corresponding by the parts object in one embodiment of this invention on a screen. It is the figure which showed the outline | summary about the example of the process at the time of changing about the external appearance etc. of the control displayed by the parts object in one embodiment of this invention. It is the figure which showed the outline | summary about another example of the process at the time of changing about the external appearance of the control etc. which are displayed by the part object in one embodiment of this invention. It is the figure which showed the outline | summary about the production | generation of a source code when an entry is registered into the dictionary table in one embodiment of this invention.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. Note that components having the same function are denoted by the same reference symbols throughout the drawings for describing the embodiment, and the repetitive description thereof will be omitted.

  An application development support system according to an embodiment of the present invention includes, for example, an application framework such as the above-mentioned RoR, and software such as IDE that integrates this with development functions such as a GUI creation function, version management, and build. The system is configured as a system for operating a program and has a function of automatically generating source code for a Web application program having a user interface such as a CRUD type Web application for a database.

  Here, for example, by reading schema information managed in a DBMS (DataBase Management System) for a business database to be accessed by an application program by a known technique, information related to the column configuration of the target database (table) is obtained. get. Based on the contents, the source code of a CRUD type web application program having a predetermined screen design and operation contents by a known technique, such as Java (registered trademark), PHP (Hypertext Preprocessor), Ruby, etc. Automatically generated by an object-oriented programming language. At this time, as in the prior art, information relating to the mapping between each column of the database and the input / output items on the screen is held.

  In the present embodiment, for example, in a CRUD-type Web application program that accesses a business database, input / output items on the screen (for example, input items that specify the contents of search conditions for acquiring data from the business database, In order to display the contents related to the output items that display the contents of the search results), instead of directly using a standard control object (hereinafter sometimes simply referred to as “control”), as described later, It is assumed that a part object in which display name, control setting contents, control processing, and explanatory text data are integrated is used.

  This part object can specify what kind of control to display on the screen (for example, text control only, (text control and) input field, (text control and) drop-down list, etc.) as a parameter. Is possible. Control attribute values (for example, text content displayed in text controls, input field length, etc.), control information (for example, how to check validity of input data, etc.) It is also implemented to display and control controls according to specified content.

  In other words, the part object is displayed by combining an input / output control that handles input / output item data such as an input field, drop-down list, and text, and a label control that is a text control that displays the name of the input / output item. In this configuration, the output pattern of these controls can be specified.

  At this time, the attribute value such as the width of the control can be adjusted in a consistent manner for the label control and the input / output control at a time, so the attribute value etc. There is no need for a complicated process of designating, and the appearance of the displayed control can be adjusted. For this adjustment, for example, the display width of the label control and the input / output control is prevented so that the label control is not line-breaked at an unintended location or is not line-breaked at the intended location. For example, to adjust the unity.

  The application development support system according to the present embodiment generates source code on the assumption that the contents relating to each input / output item on the screen are displayed using the part object. That is, the control is indirectly displayed by using the part object (HTML (HyperText Markup Language) or script for displaying the target control when the part object is executed on the Web server system is dynamically generated). Information relating to the mapping between each column of the database to be accessed by the application program and the input / output items on the screen includes identification information (for example, column name) of each column of the database and identification information of the corresponding part object ( For example, it is stored on the source code as mapping information with an HTML ID attribute value).

  Furthermore, in this embodiment, as will be described later, the text displayed on the label control in each part object, the attribute value of the input / output control and the information related to the control processing, etc. are directly directly on the source code. Instead of specifying, it is configured to be stored as dictionary data associated with identification information such as part object ID or corresponding database column name. The part object reads dictionary data at the time of execution, and displays a label control and an input / output control based on the contents. By setting / changing the contents of this dictionary data, the control of the control displayed on the screen by the part object can be made without changing the source code once generated, or even if it is only added. Appearance and attributes can be changed dynamically.

<System configuration>
FIG. 1 is a diagram showing an outline of a configuration example of an application development support system according to an embodiment of the present invention. The application development support system 1 includes a code generation server 10 and a dictionary server 20 configured by computer devices such as a PC (Personal Computer), a server device, and a virtual server in a cloud computing environment, for example. The source code 40 generated by the code generation server 10 is applied to the application server 30 that provides a service by executing a Web application program including a module including the source code 40.

  The code generation server 10 has a function of automatically generating a source code 40 for a CRUD type Web application program that accesses a business database on the application server 30. For example, middleware such as an OS (Operating System) or DBMS (not shown) is used. In addition, each component includes a schema acquisition unit 11, a mapping generation unit 12, and a code generation unit 13 that are implemented by software. In addition to these units, for example, a configuration that has a development function such as a GUI creation function, version management, and build, and functions as an IDE may be used.

  The schema acquisition unit 11 reads schema information about the business database (DB) 33 on the application server 30 using, for example, a known technique, and acquires information related to the column configuration of each table in the business DB 33. The information to be acquired includes, for example, identification information such as the name of each column and attribute values such as data type and length.

  The mapping generation unit 12 corresponds to identification information such as a column name, for example, for each column information acquired by the schema acquisition unit 11 (that is, displays an input / output item corresponding to the column on the screen). A correspondence relationship with the ID information set in the object 15 is generated as mapping information. Note that the content of the mapping information is output to the source code 40 by the code generation unit 13 described later.

  Based on the information of each column acquired by the schema acquisition unit 11 and the mapping information generated by the mapping generation unit 12, the code generation unit 13 uses, for example, the above-described RoR or the like by the CRUD type framework 14. As in the existing technology such as the application framework, a standard CRUD type Web application program for the business DB 33 is constructed, and the source code 40 is generated and output. By deploying the output source code 40 to the application server 30, a CRUD-type Web application program that accesses the business DB 33 can be operated.

  In the CRUD-type Web application generated in the present embodiment, as described above, when the contents related to the input / output items corresponding to each column of the business DB 33 are displayed on the screen, the standard on the source code 40 is Instead of directly calling a typical control, the part object 15 is called to indirectly display the control.

  On the other hand, the dictionary server 20 stores the dictionary data including the text to be displayed on the label control in each part object 15 arranged on the source code 40, the attribute value of the input / output control, the information related to the control processing, and the like. And a dictionary table 22 held in association with identification information such as the ID of the database or the column name of the corresponding database, and has a function of managing this.

  The dictionary server 20 includes, for example, a dictionary registration unit 21 implemented by software in addition to middleware such as an OS and DBMS (not shown). The dictionary registration unit 21 has a function of registering entries in the dictionary table 22. The contents and format of the dictionary data corresponding to the key (column name) are not particularly limited. In the present embodiment, as a simple method, for example, as will be described later, various data necessary for performing input / output processing of data to the target column of the business DB 33 via a screen (for input / output). It is assumed that the attribute value of the part object 15 and parameters necessary for control are specified in a predetermined order by comma separation or the like.

  As such data, for example, the display name that is the content when displaying the label control in the corresponding part object 15, the length (number of characters) when the input field is displayed as the input / output control, the validity check Specification related to the contents of control processing such as type and IME (Input Method Editor: character conversion program) mode, abbreviated display name and display width which are shortened text when listing output data in a table, drop-down list For example, a value list may be used when displaying the information.

  The processing for registering the above dictionary data in the dictionary table 22 using each column name of the business DB 33 as a key may be performed manually by a developer or the like via the dictionary registration unit 21, as will be described later. The dictionary registration unit 21 matches the mapping information held on the source code 40 with the current registration status of the dictionary table 22 to determine unregistered columns, and additionally registers them in the dictionary table 22. Also good. At this time, a user (developer, etc.) may select and specify a column to be registered.

  Normally, a plurality of screens and source codes are created in an application program, but there are many cases where the same column of the business DB 33 is accessed repeatedly between these screens and source codes. That is, for the same column, information such as parameters to be specified for the part object 15 that displays this as an input / output item can be registered in the dictionary table 22 once as dictionary data. Can be reused. Therefore, it is possible to improve work efficiency when developing a large number of screens and source code 40 that access the same business DB 33.

  In the dictionary table 22, the column name of the business DB 33 is used as a key, but as described above, the mapping information held on the source code 40 corresponds to identification information such as the name of each column (ie, The input / output items corresponding to the column are displayed on the screen), and the correspondence relationship with the ID information set in the part object 15 is held. By using this, in the source code 40, each part object 15 does not need to directly specify the corresponding column name as information such as a key in the HTML data generated at the time of execution, and its own ID is a key or the like. Therefore, it is possible to conceal the actual column name from the HTML data to enhance security.

  That is, as will be described later, each part object 15 first obtains a column name corresponding to its own ID on the HTML data via mapping information on the source code 40, and then uses the column name as a key to obtain a dictionary. The table 22 is accessed and corresponding dictionary data is acquired. Note that the ID conversion as described above is not performed by mapping information on the source code 40, and the column name of the business DB 33 corresponding to each part object 15 (control displayed by) on the HTML data is used as information such as a key. You may make it specify directly.

  The application server 30 is a web server that provides a service by executing a CRUD type web application program that is configured by a module including the source code 40 generated by the code generation server 10 and that accesses the business DB 33. The application server 30 includes, for example, middleware such as a Web server program 31 in addition to an OS and a DBMS (not shown). In addition, it includes a dictionary processing unit 32 implemented by software.

  The dictionary processing unit 32 stores a dictionary for a specified key (in this embodiment, a column name of the business DB 33 corresponding to a target input / output item (part object 15) on the screen) from the dictionary table 22 of the dictionary server 20. It has a function of acquiring and outputting data (text displayed by the part object 15 on the label control, attribute values of the input / output control, information related to control processing, etc.).

  Thus, when the source code 40 is called and executed on the Web server program 31, each part object 15 arranged on the source code 40 is sourced from its own ID on the HTML data, as will be described later. The column name of the corresponding business DB 33 is acquired based on the mapping information held on the code 40, and the dictionary data is accessed by accessing the dictionary table 22 of the dictionary server 20 via the dictionary processing unit 32 using this value as a key. get. Based on the contents of the dictionary data, HTML data for displaying label control and input / output control is generated.

  Note that the code generation server 10 sets information on whether or not the part object 15 arranged on the source code 40 uses dictionary data (whether or not to access the dictionary table 22) when executing on the application server 30. You may be able to do it. The code generation unit 13 generates the source code 40 according to the setting contents. If the dictionary data is set not to be used, the label control or the contents using the contents directly specified in the source code 40 for the part object 15 or the default values previously defined in the part object 15 are used. Displays input / output controls. The same applies to the case where there is no dictionary data corresponding to the key specified in the dictionary table 22 in a state where the dictionary data is set to be used.

<Screen display processing>
FIG. 2 shows an outline of an example of processing when the input / output items of the corresponding column are displayed on the screen by the part object 15 in the CRUD type application running on the application server 30 based on the generated source code 40. It is a figure. In the example of FIG. 2, an example in which an input field for specifying “customer name” is displayed on a screen for inputting a search condition when data is read from the business DB 33 is shown.

  In the source code 40 of the Web application program shown in the upper part of the figure, the part object 15 is called to display an input field for designating “customer name”. Specifically, first, the column name corresponding to the ID (“A01”) from the mapping information held in the source code 40 (in the example of FIG. 2, the correspondence is held by array ()). Get "customer_name") information.

  Thereafter, for example, the subclass inherited in each development environment from the class in which the function of the part object 15 is implemented is called in the form of creating an instance (“CF_itemDic ();”). In the example of FIG. 2, as part of the parameters, the type of dictionary table 22 to be called (“common dictionary”), the type of input / output control to be displayed (“input field”), the ID attribute value of HTML (“A01”), etc. The state called by specifying is simplified. The HTML ID attribute value (“A01”) is dynamically converted into a column name (“customer_name”) by mapping information.

  The part object 15 called by such a code holds data including at least a display name (label control text) and information related to the contents of the input / output control to be displayed. As shown in FIG. 2, other information such as explanatory text may be further held. In the example of FIG. 2, among the above three pieces of information of the part object 15, since “input field” is specified as a parameter in the source code 40 for the control, this is set.

  The part object 15 further accesses the target dictionary table 22 (“common dictionary”) on the dictionary server 20 via the dictionary processing unit 32 by using a predetermined function or method, and sets the column name (“customer_name”). Corresponding dictionary data (in this embodiment, a set of a plurality of values such as “customer name”, 40 characters, 20 characters,...) Is acquired.

  In the example of FIG. 2, as the dictionary data of the dictionary table 22, in order from the top, the name (text to be displayed on the label control), the length in the case of the input field (number of characters in half-width), and the maximum length in the case of the input field (Number of characters), validation type of input data, initial mode of IME, explanatory comment, text (display name) for list display in table, display width (pixel value) for list display in table, etc. Information shall be retained. As an output format when acquiring these dictionary data, for example, a series of character strings in which these values are separated by a comma or the like may be used, or easily accessible data such as an associative array may be used.

  As for the dictionary table 22, in consideration of processing efficiency, it is desirable to expand the contents of the dictionary data on the memory at the time of initial processing or first access. In this case, if all the dictionary data is expanded, the processing efficiency may be reduced due to the pressure on the memory usage or the time required for the expansion processing. Therefore, in terms of implementation, it is desirable that dictionary data in a necessary range can be expanded on a memory when necessary.

  Therefore, in the present embodiment, a hierarchical structure including a plurality of dictionary tables 22 having different application ranges is used, and these are appropriately selected and used. For example, a dictionary common to all applications developed by the application development support system 1 (“common dictionary”), a dictionary common only within a specified website (“site dictionary”), and common only within a subsystem It is assumed that a plurality of types of dictionary tables 22 having different application ranges such as a dictionary (“library dictionary”) and a dictionary in units of screens (“controller dictionary”) are provided.

  In this case, for example, when the corresponding dictionary data is not obtained by referring to a dictionary having a narrow application range such as the “controller dictionary”, the upper order is “library dictionary” → “site dictionary” → “common dictionary”. Reference may be made retrospectively to the dictionary table 22 (which has a wide application range). Further, a default value may be used or an error may be assumed if dictionary data is not obtained.

  The part object 15 extracts necessary data from the acquired dictionary data, and is set as a parameter when displaying or controlling the control. For example, the length of the field acquired from the dictionary data is set as an attribute value when displaying the input field as an input / output control, and the value of the validity check type, the initial mode of IME, the contents of the explanatory text, etc. Set. The parts object 15 has processes related to input / output control such as validity checking of input data and IME mode setting, for example, defined as a method in a class that inherits the part object 15. Alternatively, it is assumed to be implemented as a function that can be called by the part object 15.

  As a result, as shown in the lower screen example of FIG. 2, the part object 15 can generate the HTML data 41 so as to display the control of the input field for designating “customer name” at the time of execution. At this time, for example, the description text information of the part object 15 can be used as help information about the input / output item.

  When displaying the input field, it is unclear what should be input if only the control of the input field is displayed. Therefore, in the present embodiment, as shown in FIG. A text control ("customer name") that displays the display name of the input / output item is displayed adjacent to the input field as a label (label control). The text sets the display name information in the retained data of the part object 15, that is, the name value (“customer name”) of the dictionary data acquired by the part object 15 from the dictionary table 22.

  Such processing related to the generation of the HTML data 41 is implemented as a function that the part object 15 has or can be called by, for example, defining it as a method in a class that inherits the part object 15. Shall be kept. Here, as described above, the attribute values relating to the appearance and the like are adjusted in a consistent manner for the three elements of the label control, input / output control, and explanatory text to be displayed. .

  Thus, in this embodiment, it is possible to generate HTML data 41 that displays input / output items by the part object 15. Therefore, in order for the code generation server 10 to automatically configure the CRUD type application, for example, based on the column configuration information of the business DB 33 acquired by the schema acquisition unit 11, the code generation unit 13 uses each column of the business DB 33. A part object 15 is arranged on the screen as an input / output item corresponding to the above, and the source code 40 is generated so as to be combined with implementation of standard functions and operations previously defined as the CRUD type framework 14 Can be realized.

  For example, as an application for registering an entry in the business DB 33 (C: Create), a part object 15 for displaying an input field for designating data to be registered for each column of the business DB 33 is displayed on the screen. Source code 40 is generated so as to be arranged according to the column arrangement order of DB33. At this time, the correspondence between the ID of the control displayed on the screen and the name of the column is held as mapping information as necessary. Furthermore, as a standard function, a “registration” button, a “cancel” button, and the like for executing entry registration in the business DB 33 are arranged. Furthermore, information such as attribute values and control information used when displaying the control for each part object 15 is held in the dictionary table 22 as dictionary data. At this time, each item is set with a default value unless otherwise specified.

  Further, for example, as an application for performing a search (R: Read) with respect to the business DB 33, a part object 15 for displaying an input field for specifying a condition for searching the business DB 33 on the screen is arranged in the same manner as described above. The source code 40 is created to At this time, if all the columns of the target table of the business DB 33 can be specified as a search condition, it becomes excessive. For example, the input field is temporarily displayed only for the first five columns, and the subsequent process is simplified. It is good also as changeable from. Further, the correspondence between the ID of the control displayed on the screen and the column name is stored as mapping information as necessary. Further, as a standard function, a “search” button or the like for searching for entries in the business DB 33 is arranged.

  Further, for example, a table control for displaying the search result is automatically arranged below the area for inputting the search condition. Here, for example, the contents corresponding to the call of the part object 15 corresponding to each column of the business DB 33 are set in the item definition array of the table control object. Thus, the CRUD type framework 14 or the part object 15 can be mounted so that the contents of each column of the business DB 233 are displayed in each column of the table control.

  As described above, it is possible to automatically generate the source code 40 of the CRUD type Web application including the screen configuration and the implementation of standard functions from the schema information of the business DB 33 according to a predetermined rule. However, in actual use of the application, there are cases where it is desired to add changes or adjustments to the standard screen configuration. For example, there may be a demand to add / delete / change a part of the input / output items, or to change / adjust attribute values such as the size of the input field. On the other hand, in the present embodiment, the appearance of the control displayed on the screen by the part object 15 is not changed, or even if it is added, even if the source code 40 once generated is changed. It is possible to dynamically change attributes and the like.

  FIG. 3 is a diagram showing an outline of an example of processing when changing the appearance or the like of the control displayed by the part object 15. Here, the contents of the source code 40 shown in the example of FIG. 2 are not changed, but only the contents of the dictionary data in the dictionary table 22 are changed. Specifically, the name (“customer name” → “customer name”), the length for the input field (40 characters → 60 characters), the maximum length for the input field (20 characters → 30 characters), IME The contents of the initial mode ("full-width kana" → "full-width katakana") have been changed.

  Thus, when the Web application is executed, the part object 32 refers to the contents of the entry in the dictionary table 22, and the text of the label control as a display name is displayed according to the contents as shown in the lower screen example of FIG. Not only the data but also the input / output control attributes and the like (the length (width) of the input field, the IME mode, etc. in the example of FIG. 3) can be dynamically changed.

  FIG. 4 is a diagram showing an outline of another example of processing when changing the appearance or the like of the control displayed by the part object 15. Here, simple changes are made to the contents of the source code 40 shown in the example of FIG. Specifically, when the part object 15 is called, the input / output control type parameter to be displayed is changed from “input field” to “drop-down list”. The dictionary table 22 additionally defines the contents of the value list (“Tanaka: 1, Yamamoto: 2,...”) Set in the drop-down list at the end of the dictionary data.

  Thereby, when the Web application is executed, the part object 15 can generate the HMTL data 41 so as to change the display contents of the input / output items by the specified type of input / output control. In the example of FIG. 4, the input / output control is changed from the input field to the drop-down list for the same part object 15. For example, when the input / output control type parameter is set to “text”, the part The object 15 displays the value as text. Only one of the label control and the input / output control can be displayed. If the parameter is set to “Hide”, data is retained internally, but no control is displayed for the input / output item on the screen display.

  As described above, according to the application development support system 1 according to the embodiment of the present invention, the code generation server 10 reads the schema information of the business DB 33 to be accessed on the application server 30, thereby Based on the contents of the DB 33 column information obtained, the standard CRUD-type Web application program source code 40 for the business DB 33 is obtained according to a predetermined screen design and operation contents based on the contents. Generate automatically. At this time, the source code is assumed to display the standard control indirectly using the part object 15 instead of directly using the standard control to display the contents relating to the input / output items on the screen. 40 is generated.

  Further, parameters such as attribute values and control information for actually displaying controls in each part object 15 are not specified on the source code 40 except for a part, and are associated with the ID of the part object 15 and the like. The dictionary data is held in the dictionary table 22 on the dictionary server 20. As a result, by changing the contents of the dictionary data in the dictionary table 22, the source code 40 once generated can be executed on the application server 10 without any change, or even with a simple change. Sometimes, it is possible to adopt a development technique in which an application is completed while dynamically changing or adjusting the appearance and attributes of the control displayed on the screen by the part object 15.

  In addition, the entry corresponding to each column of the business DB 33 is registered and maintained in the dictionary table 22, so that the efficiency of development work can be improved. FIG. 5 is a diagram showing an outline of generation of the source code 40 when entries are registered in the dictionary table 22. When the source code 40a in the figure is generated, it is shown that the texts of the display names corresponding to the three items A, B, and C are newly registered in the dictionary table 22. After that, when the source code 40b is generated for another screen, an entry is registered in the dictionary table 22 for the items A, D, and E included therein, but since the item A is already registered, it is registered. Work becomes unnecessary.

  Similarly, when the source code 40c is generated for another screen, the items B, C, and D included therein are all already registered in the dictionary table 22, so that the registration work is unnecessary. As described above, such exclusion of duplicate registration may be determined manually by the developer, or the dictionary registration unit 21 of the dictionary server 20 may perform mapping information on the source code 40 and the dictionary table 22. Input / output items that need to be registered may be determined by matching the entries. In this way, as the contents of the dictionary table 22 are improved, it is no longer necessary to set attribute values for displaying controls for the same input / output items each time the source code 40 is generated for the screen. , Development efficiency is improved.

  As mentioned above, the invention made by the present inventor has been specifically described based on the embodiment. However, the present invention is not limited to the embodiment, and various modifications can be made without departing from the scope of the invention. Needless to say. For example, in this embodiment, the source code is automatically generated for a standard CRUD type Web application, but the present invention is not limited to this. A unique application constructed by the user combining access to the part object 15 and the dictionary table 22 including the operation contents such as the user interface and business logic (not limited to Web applications, client / server type, stand-alone type, etc. Alternatively, the source code may be automatically generated based on the same concept.

  The present invention is applicable to an application development support system and an application development support program that automatically generate source code for a CRUD type application program for a database.

1 ... Application development support system,
DESCRIPTION OF SYMBOLS 10 ... Code generation server, 11 ... Schema acquisition part, 12 ... Mapping generation part, 13 ... Code generation part, 14 ... CRUD type framework, 15 ... Part object,
20 ... Dictionary server, 21 ... Dictionary registration unit, 22 ... Dictionary table,
30 ... Application server, 31 ... Web server program, 32 ... Dictionary processing unit,
40, 40a to c ... source code, 41, 41a to c ... HTML data.

Claims (7)

An application development support system having a code generation server that generates a source code of a Web application program running on an application server,
Further, with the identification information of one or more input / output items displayed on the screen when the Web application program is executed as a key, the display name information indicating the label control text for the input / output items and the input / output items are displayed. A dictionary server having a dictionary table that holds, as dictionary data, information consisting of initial values of one or more parameters for a part object having at least information on input / output control to be displayed for input or output;
The code generation server configures the Web application program by calling the part object for displaying each of the input / output items on the screen, and generates source code of the configured Web application program A code generator,
When the part object is called to display a corresponding input / output item on the screen when the web application program is executed on the application server, the dictionary server uses the identification information of the input / output item as a key. Information on part or all of the parameters for the part object is acquired from the dictionary table above, and the label control and / or the input / output control is displayed based on the acquired parameter. Application development support system. The application development support system according to claim 1,
The code generation server further reads schema information of a business database accessed by the Web application program on the application server and acquires information relating to a configuration of each column of the business database;
A mapping generation unit that generates mapping information related to the mapping between the identification information about the part object and the identification information of the input / output item;
The mapping generation unit registers the dictionary data using the identification information of each column of the business database acquired by the schema acquisition unit as the identification information of the input / output items in the dictionary table. Development support system. In the application development support system according to claim 2,
The code generation unit of the code generation server generates a CRUD type application for the business database based on a CRUD type application framework. In the application development support system according to any one of claims 1 to 3,
The part object is displayed by combining the label control and the specified type of the input / output control when the web application program is executed on the application server, or the label control and / or the input / output control. Display control not to display,
When generating the source code of the Web application program, the code generation unit of the code generation server generates the part object to be called by specifying a predetermined initial value that specifies the content of the display control. Feature application development support system. In the application development support system according to any one of claims 1 to 4,
The part object implements a control process according to the input / output control to be displayed,
The dictionary development table of the dictionary server can register information for designating the content of the control process as the parameter for the part object in the dictionary data. In the application development support system according to claim 2,
The dictionary server has a dictionary registration unit for registering an entry including a key and dictionary data in the dictionary table;
The dictionary registration unit needs to be registered in the dictionary table based on the mapping information on the source code generated by the code generation unit of the code generation server and the entry registered in the dictionary table. An application development support system characterized by discriminating identification information of the input / output items. The code generation server that generates the source code of the Web application program that runs on the application server, and the input / output item using the identification information of one or more input / output items displayed on the screen when the Web application program is executed as a key The initial value of one or more parameters for a part object having at least information on a display name indicating text of a label control and information on an input / output control to be displayed to input or output the input / output item An application development support program for operating a computer as the code generation server in an application development support system having a dictionary server having a dictionary table that holds information as dictionary data,
For each of the input / output items, the web application program is configured by calling the part object for displaying each of the input / output items on the screen, and a code generation process for generating a source code of the configured web application program is executed. ,
When the part object is called to display a corresponding input / output item on the screen when the web application program is executed on the application server, the dictionary server uses the identification information of the input / output item as a key. Information on part or all of the parameters for the part object is acquired from the dictionary table above, and the label control and / or the input / output control is displayed based on the acquired parameter. Application development support program.

Images