JP4444634B2 - PROGRAM GENERATION DEVICE, PROGRAM GENERATION METHOD, PROGRAM, AND RECORDING MEDIUM - Google Patents

Description

  The present invention relates to a web application development support system, in which a program generation that can automatically generate a series of program codes of a web application program that allows a user to dynamically switch a database (DB) from within a framework of business specifications. The present invention relates to an apparatus, a program generation method, a program, and a recording medium.

  Conventionally, in the case of a database (DB) system stored in a plurality of tables such as a relational database system, it has been necessary to input data to a plurality of related tables constituting the DB.

  Further, in order to handle enormous amounts of data and appropriately access desired data, it is necessary to be aware of the data structure unique to the DB.

With respect to this problem, in “Database access method and apparatus” of Japanese Patent Laid-Open No. 6-68151 (Patent Document 1), the DB access means is controlled by browser means for managing and displaying a schema in which the data structure of the DB is logically constructed. Proposes a way to prepare. With this method, the user can efficiently operate the DB without being aware of the DB structure.
JP-A-6-68151

  However, in the above-mentioned patent document 1, the table can be switched only for a table having a relation in a single DB system, and no consideration is given to access means for the distributed DB. Not.

  Therefore, when trying to access a DB other than the target DB system, there is a problem in that an application for the DB must be developed from scratch.

The present invention has been made to solve the above problems, an object of the present invention, dynamically switches the connection to the distributed database by selection of the user, it can process of accessing of the database table Web application programs, or web application programs that can be accessed automatically by switching different tables in the same database according to the user's selection, can be automatically and selectively generated from the framework of business specifications, improving productivity and maintainability. To provide a program generation apparatus, a program generation method, a program, and a recording medium capable of constructing an excellent program generation environment capable of expanding the area of an excellent web application program.

The present invention is a program generation device for generating a web application program having a function capable of accessing a plurality of database tables, and a plurality of tables each defining a table by information including a combination of the database name and table name of the database A first storage unit that stores information; a second storage unit that stores group information defined as a group in which a plurality of tables defined by the plurality of table information can be switched on a single screen; and the database A third storage unit that stores connection information including a driver name, a connection destination, and authentication information used when connecting to the database, and the group information is used to define the group defined by the group information. Switch connection of one of multiple tables Information of a table selected as a connection switching destination by the operation of the operation screen displayed on the web browser, and a program code for displaying the operation screen selectable as a web browser Is received from the web browser, the connection information of the database corresponding to the selected table is used to switch the connection to the database corresponding to the selected table and to access the selected table It has the 2nd production | generation means to produce | generate a program code, It is characterized by the above-mentioned.

According to the present invention, dynamically switches the connection to the distributed database by selection of the user, the access process is capable web application program into the database tables, or by selection of a user different tables of the same database An excellent program generation environment that can automatically and selectively generate web application programs that can be accessed by dynamically switching from the framework of business specifications, and can expand the area of web application programs that are highly productive and maintainable. There are effects such as construction.

  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. Reference numeral 104 denotes an external storage device such as a hard disk, an input / output table 109 for storing input business specifications (definition information defining each of a plurality of tables on the database), and connection information for connecting to the input database The login information 110 is stored, the application name 111 of the input web application to be generated, the generated program code (JSP code 112, servlet code 113, bean code 114), and the like are stored.

  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 internal database 311a and the external database 311b using the DB access object 310a and the DB access object 310b in response to a request from the servlet 307, and holds the processing result in the Bean 308.

  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 databases 311a and 311b.

  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 (or using only the JSP 309 without using the servlet 307 or Bean 308), the Bean 308 or JSP 309 can be processed. By clearly separating each role using the function, it is possible to grasp the functional division in a concise manner.

  The bean 308 may be separately implemented for a bean for accessing an internal database and a bean for accessing an external database.

  Further, there may be a plurality of internal databases or a plurality of external databases.

  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 an input / output table (details of which are shown in FIG. 4). Are received, input of login information (details are shown in FIG. 5), input of the application name 111 of the web application to be generated, and the like are stored in the external storage device 104 (input / output table 109, login information 110). , Application name 111), the process is terminated.

  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, and a DB dynamic switching function in a web application and the display thereof. Corresponds to the business specifications that describe the screen definition in the form of an input / output table.

  Column 1 shows the DB system name, which is used for identification when the DB system is used.

  Column 2 shows the data file number, and there is a data file item branch number of column 3 as a data item constituting the data file.

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

  Column 6 is an IO category indicating the type of the item. Each of the IO categories is “F” indicating a file, “D” indicating a display item, “G1” and “G1” indicating that there is a function that can control a plurality of tables together on one screen. G2 ". This control will be described separately below.

  That is, when “F” is specified in the IO classification of column 6, the data of the row defines a data item, and when “D” is specified, the data of the row is displayed on the screen. When an item is defined and “G1” and “G2” are designated, the data in the row defines a DB / table switching function.

  Column 7 represents the number of digits of each item. Column 8 shows the display method. When “S” is displayed, the item is displayed as a search item, and when “H” is displayed, the search result is displayed. The item used for both the search and the result is defined as “S, H”. Column 9 shows the item number of the item.

  FIG. 5 is a schematic diagram for explaining the login information shown in FIG.

  In the figure, reference numeral 601 denotes a DB system name, which corresponds to the name of a DB system connected by a generated application. A JDBC driver 602 is a driver used when connecting to the DB system. Reference numeral 603 denotes a URL, 604 denotes a user name, and 605 denotes a password, which correspond to the URL, user name, and password used when connecting to the DB system.

  The input / output table 109, the login information 110, and the application name 111 may be configured to be input from a business specification input screen (not shown) displayed by the business specification description unit 116, or by any other arbitrary application. It may be a generated text file, CSV file, or other file format file.

  Hereinafter, the dynamic switching of the DB will be described with reference to FIGS.

  6 to 8 are DB configuration diagrams for explaining DB connection switching by an application generated by the program generation apparatus of the present invention. In particular, FIG. 6 corresponds to an external (remote) distributed DB configuration diagram. 7 corresponds to an internal (local) identical DB configuration diagram, and FIG. 8 corresponds to a distributed DB configuration diagram using an internal (local) DB and an external (remote) DB.

  Dynamic DB switching refers to a function that can switch the target DB / table by selecting the DB / table to be searched or updated by operating the screen on one generated screen. Yes.

  In the present invention, as shown in FIGS. 6 to 8, a means for virtually controlling the DB / table to be switched as one table is taken (virtual DB 401 shown in FIGS. 6 to 8).

  Specifically, the login information 110 (JDBC driver, URL, user name, and password) defined in advance is set to a row in which “G2” is defined in column 6 of the input / output table 109 (in the example of FIG. 2 ”,“ Row 3 ”) and the value in column 3 (“ CliDB / ClinicM ”,“ DruDB / DrugstoreM ”in the example of FIG. 4), and the information is added to the application. If the user selects a table from the screen after generating the application, it is possible to access the DB system table using the above information.

  At the time of this switching, when switching between different external DB systems as shown in FIG. 6 and when switching between the external DB system and the internal DB system as shown in FIG. 8 (that is, in the case of a distributed DB) The switching of the DB system itself is performed within the generated application.

  In addition, in the case of switching within the same DB system as shown in FIG. 7, in the same manner as the switching of the external DB described above, an application generated to switch and select a table in the DB system each time. Will be done within.

  By such a control method, the user of the generated application can perform switching without being aware of the physical configuration and connection of the DB system.

  For example, as shown in FIG. 6, the tables connected to the external DB system are alternately switched, as shown in FIG. 7, the table in the internal DB is switched, or as shown in FIG. Even a combination of an external DB system can be switched without being aware of that.

  The DB / table to be switched is the column 3 in the row in which “G2” is designated in the column 6 of the input / output table 109 shown in FIG. 4 (“row 2” and “row 3” in the example of FIG. 4). (“CliDB / ClinicM”, “DruDB / DrugstoreM” in the example of FIG. 4). The description rule of this value is expressed by delimiting with “/” symbol like DB system name / table name.

  If this DB switching function is used, for example, when a user wants to search for a medicine, a hospital table (ClinicM) connected to a CLIDB (for example, an internal DB system) and a DRUDB (for example, an external network connected to an external network) When the user selects a pharmacy table connected to the (DB system) from an operation screen (shown in FIG. 9 described later), the DB can be switched and the search target can be switched in real time.

  In this way, the generation of a virtual table that groups a plurality of DBs / tables is performed by reading the definitions of “row 1” to “row 3” of the input / output table 109 shown in FIG.

  First, in the input / output table 109, a row in which the IO classification in column 6 is “G1” (“row 1” in the example of FIG. 4) is selected. This line is an item for virtually grouping the target DB / table into one. The target DB / table is described in line 2 and line 3 in which “G2” is specified in the IO section.

  The data file item branch number in the column 3 of the row 2 and the row 3 in which “G2” is designated as the IO section indicates the DB / table name. The table names (201a and 201b in FIG. 9 to be described later) displayed on the operation screen of the generated application are the data file item names specified in the column 5 (in the example of FIG. 4, “hospital”, “pharmacy” ]).

  FIG. 9 is a schematic diagram showing an example of an operation screen in a web application generated by the program generation apparatus of the present invention.

  In the operation screen generated by the above-described generation method, a pull-down selection menu 201 and a switching search button 202 as shown in the upper left of FIG. 9 are automatically generated, and the selection menu 201 includes 201a and 201b. As shown in FIG. 4, the data file item name of the line in which “G2” is defined in column 6 of FIG. 4 is displayed as the table name. When a table name (201a or 201b) is selected from the selection menu 201 and the switch search button 202 is pressed, the connection between the DB and the table is switched, and the selected table is a target for search / update.

  The search process is performed by inputting a value in the search condition input field 203 and instructing the search button 204.

  Further, the processing for updating is performed by changing and inputting the value in the search result display input list 205 and instructing the update button 206.

  Further, when the switch search button 202 is instructed while a value is entered in the search condition input field 203, the connection of the DB / table is switched, and the switched DB / table is input to the search condition input field 203. The search process with the specified search condition is executed. Thereby, it is possible to sequentially search by switching the DB / table under the same search condition.

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

  FIG. 10 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 S207 indicate each step.

  First, in step S201, one row (one data item) is read from the input / output table 109 stored in the external storage device 104. In step S202, the value of the IO section in column 6 is acquired. In step S203, the acquired value is acquired. It is checked whether or not the value of the IO section is “G1”.

  If it is determined in step S203 that “G1” is not defined as the value of the IO section in column 6, the process directly proceeds to step S205.

  On the other hand, if it is determined in step S203 that “G1” is defined as the IO section value in column 6, the IO section value in column 6 is set to “G2” from the input / output table 109 in step S204. All the rows are acquired and grouped, and the information in columns 2, 3, and 4 is written in the work area in the RAM as “DB information” of the group.

  In step S205, screen display item and file item information acquisition processing (FIG. 11) is performed, and the flow advances to step S206.

  In step S206, it is determined whether or not the processing in steps S201 to S205 has been completed for all the rows (all data items) in the input / output table 109. Return to processing.

  On the other hand, if it is determined in step S206 that the processes in steps S201 to S205 have been completed for all rows (all data items) in the input / output table 109, the process proceeds to step S207.

  Next, in step S207, JSP, servlet, and bean generation processing is performed, the processing ends, and the process returns to the flowchart of FIG.

  FIG. 11 is a flowchart showing an example of the third control processing procedure of the present invention, and corresponds to the screen display item / file item information acquisition processing in step S205 shown in FIG. S301 to S304 indicate each step.

  First, in step S301, it is checked whether or not the value of the IO section in column 6 is “D”.

  If it is determined in step S301 that “D” is defined as the IO category value in column 6, it is determined as “screen display item designation information”, and the process proceeds to step S302. In step S201 of FIG. One line of data (columns 2 to 8) read from the input / output table 109 is acquired as “screen display item designation information”, written in the work area in the RAM, and the process proceeds to step S303.

  On the other hand, if it is determined in step S301 that “D” is not defined as the value of the IO section in column 6, the process directly proceeds to step S303.

  If it is determined in step S303 that “F” is defined as the value of the IO section in column 6, it is determined as file item definition information, and the process proceeds to step S304. In step S201 of FIG. One row of data (column 1 to column 7) read from 109 is acquired as “file item definition information” and written to the work area in the RAM.

  On the other hand, if it is determined in step S303 that “F” is not defined as the value of the IO section in column 5, the process is terminated as it is, and the process returns to the flowchart of FIG.

  FIG. 12 is a flowchart showing an example of the fourth control processing procedure of the present invention, and corresponds to the JSP, servlet, and bean generation processing shown in step S207 of FIG. S401 to S403 indicate each step.

  First, in step S401, based on the login information 110, application name 111, DB information stored in the work area in the RAM, and file item information stored in the external storage device 104, connection to each database, data search, A Bean 114 for updating data is generated (details are shown in FIG. 13).

  Next, in step S402, based on the application name 111 stored in the external storage device 104, the DB information stored in the RAM, and the screen information, the input data from the web browser is acquired, and the Bean 114, JSP 112 is called to call the web A servlet 113 that controls the entire application is generated (details are shown in FIG. 14).

  Next, in step S403, based on the application name 111 stored in the external storage device 104, DB information stored in the RAM, screen information, and file item information, the operation screen shown in FIG. A JSP 112 for controlling the display is generated (details are shown in FIG. 15), the process is terminated, and the process returns to the flowchart of FIG.

  FIG. 13 is a flowchart showing an example of the fifth control processing procedure of the present invention, and corresponds to the bean generation processing shown in step S401 of FIG. S501 to S505 indicate each step.

  First, in step S501, a Bean file 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, code for declaring a database connection object, declaration of an SQL statement object, declaration of a result set object, etc. are stored.

  Next, in step S502, “each code corresponding to each DB connection method for each DB” is generated in the Bean file based on the login information 110 stored in the external storage device 104 and the DB information stored in the RAM. To do.

  More specifically, “a driver class is loaded using the JDBC driver 602 corresponding to the DB system name 601 in the login information 110, and the URL 603, user name 604, password corresponding to the DB system name 601 in the login information 110 is loaded. 605 is used to perform processing for connecting to the database, and further, a code corresponding to a DB connection method for each DB that performs processing for generating an SQL statement object is generated in the Bean file.

  Next, in step S503, based on the DB information stored in the RAM, “each code corresponding to each DB cutting method for each DB” is generated in the Bean file.

  Specifically, “a code corresponding to a DB disconnection method for each DB that performs processing for closing the SQL statement object and the database connection object” is generated in the Bean file.

  Next, in step S504, based on the DB information and file item information stored in the RAM, “code corresponding to each data retrieval method for each table” is generated in the Bean file.

  Specifically, “a SQL statement for searching table data according to a set search condition is generated using a data file number as a table name, a data item branch number in the data file number as an item name in the table, and the SQL statement The code corresponding to the data search method for each table for executing the above query and obtaining the search result is generated in the Bean file.

  In step S505, based on the DB information and file item information stored in the RAM, “each data update method for each table” is generated in the Bean file.

  More specifically, “a SQL statement for updating the table data with the set update data is generated using the data file number as the table name and the data item branch number in the data file number as the item name in the table. The code corresponding to the data update method for each table that executes the query is generated in the Bean file.

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

  FIG. 14 is a flowchart showing an example of the sixth control processing procedure of the present invention, and corresponds to the servlet creation processing (step S402 in FIG. 12) by the code generation unit 107 shown in FIG. In addition, S601-S607 shows each step.

  First, in step S601, 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 S602, based on the screen display item information stored in the RAM, a “code for receiving transmission information from the web browser” is generated in the servlet file.

  In step S603, based on the DB information stored in the RAM, “a code for performing table switching search processing using a Bean method when a switching search is instructed” is generated in the servlet file.

  Specifically, when it is determined that “switching search is instructed based on an instruction from the user based on transmission information from the web browser (the switching search button 202 is instructed by the user), a switching destination table is further displayed. Is not the currently connected DB, if it is not the currently connected DB, it is disconnected by the DB disconnection method for the currently connected DB, and the switching destination DB is specified by the DB connection method for the DB of the switching destination table. Connects to the DB of the table, saves the information of the connected DB in a predetermined storage area (session object), and uses the data search method of the table at the switching destination to perform search processing with the search conditions acquired from the web browser On the other hand, if the switch-destination table is a currently connected DB, the switch-destination table By using the data search method, to generate a code "in which to perform search operations in the search conditions obtained from the web browser to the servlet within the file.

  Next, in step S604, based on the DB information stored in the RAM, a “code for performing a data search process using a Bean method when a search is instructed” is generated in the servlet file.

  Specifically, “when it is determined that a search is instructed based on an instruction from the user based on transmission information from the web browser (the search button 204 is instructed by the user), the DB of the current table is further updated. It is determined whether or not the DB of the current table is connected. When the DB of the current table is not connected, the DB connection method corresponding to the DB of the current table is connected to the DB of the current table, and information on the connected DB When the data is saved in the storage area (session object) and the search process using the search method obtained from the web browser is executed using the data search method for the current table, while the DB of the current table is connected Executes the search process with the search conditions obtained from the web browser using the data search method of the current table as it is To generate that code "to the servlet within the file.

  Next, in step S605, based on the DB information stored in the RAM, “a code for performing data update processing using a Bean method when an update is instructed” is generated in the servlet file.

  Specifically, “when it is determined that the update is instructed based on the instruction from the user based on the transmission information from the web browser (the update button 206 is instructed by the user), the DB of the current table is further updated. It is determined whether or not the DB of the current table is connected. When the DB of the current table is not connected, the DB connection method corresponding to the DB of the current table is connected to the DB of the current table, and information on the connected DB If it is stored in the storage area (session object) and the update process for the update data obtained from the web browser is executed using the data update method for the current table, while the DB of the current table is connected As is, the code that executes the update processing of the update data obtained from the web browser of the current table " To generate in the Le.

  Next, in step S606, “code for saving Bean in a predetermined storage area (for example, session object)” is generated in the servlet file.

  Next, in step S607, “code for calling JSP” is generated in the servlet file, the process is terminated, and the process returns to the flowchart of FIG.

  FIG. 15 is a flowchart showing an example of the seventh control processing procedure of the present invention, and corresponds to the JSP creation processing (step S403 in FIG. 12) by the code generation unit 107 shown in FIG. In addition, S701-S710 shows each step.

  First, in step S701, 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 S <b> 702, “a code for obtaining a Bean from a predetermined storage area (session object)” is generated in the JSP file.

  Next, after storing the html tag “</ head> <body>” and the like, in step S703, “code for specifying a servlet to be activated when a form parameter is transmitted” is generated. Specifically, a code such as “<form method =“ post ”action = url of servlet” ”which is an html tag is stored.

  Next, in step S704, “a code for generating the selection menu 201” is generated in the JSP file based on the DB information stored in the RAM.

  Next, in step S705, “a code for generating a switching search button 202 having a function of transmitting a form parameter” is generated in the JSP file.

  Next, in step S706, “code for generating search condition input field 203” is generated in the JSP file based on the screen display item information stored in RAM (particularly, items having “S” and “S, H”). To do. The code for generating the search condition input field 203 is a code for generating an input field for each item in accordance with the number of digits of each item specified in the screen display item information.

  Next, in step S707, “a code for generating the search button 202 having a function of transmitting a form parameter” is generated in the JSP file.

  Next, in step S708, based on the screen display item information stored in the RAM (particularly, items having “S, H” and “H”), a “code for generating the search result display input field 205” is stored in the JSP file. Generate. The code for generating the search result display input field 205 is a code for generating a display input field for each item according to the number of digits of each item specified in the screen display item information.

  Next, in step S709, “a code for generating an update button 206 having a function of transmitting a form parameter” is generated in the JSP file.

  Next, in step S710, based on the screen display item information stored in the RAM, “if the search condition information is stored in the bean, the search condition information is set in the search condition input field 203; If search result information is stored in the bean, a code for setting the search result information in the search result display input field 205 is generated in the JSP file.

  Finally, “</ form> </ body> </ html>” or the like, which is an html tag, is stored, the process ends, and the process returns to the flowchart of FIG. The JSP may include various script codes such as Java (registered trademark) Script.

  As shown in FIG. 4, by defining the table definition and the screen configuration as a part of the business specification, it is possible to automatically generate a DB connection switching and operation code and screen. As a result, it is possible to flexibly respond to changes in business specifications, etc., and it is possible to develop high-quality and speedy web applications by centrally managing design, implementation and management.

  Hereinafter, with reference to the contents of the input / output table 109 shown in FIG. 4, an example of generating an operation screen (FIG. 9) by which the user can dynamically switch the DB / table by the processing shown in FIGS. 10 to 15. Show.

  In row 1 of the input / output table 109 shown in FIG. 4, “G1” is defined in column 6 and the items in rows 2 and 3 in which “G2” is defined in the same column 6 are virtually combined. One table is processed.

  Further, in row 2, since “G2” is defined in column 6, it indicates that “CliDB / ClinicM” defined in column 3 can be used as a selectable table on the screen.

  Similarly, row 3 is also defined as a table in which “DruDB / DrugstoreM” can be selected.

  Further, in rows 4 to 10, since “D” is defined in column 6, it indicates that it actually becomes a display item on the screen. The data file item names in column 5 are displayed on the screen, and input items for the number of digits specified in column 7 are generated. The generated screen is configured for searching and displaying the result. For search (search condition input field 203 in FIG. 9), items from row 4 to row 7 in which “S” or “S, H” is specified in column 8 are displayed, and the results are displayed (FIG. 9). In the search result display input field 205), items 6 to 10 in which "H" or "S, H" is designated are displayed.

  In lines 11 to 24, “F” is defined in column 6, which indicates a file definition. This file definition defines two DB tables “hospital” and “pharmacy” defined in line 2 and line 3, line 11 to line 17 indicate “hospital”, and line 18 to line 24. Indicates “pharmacy”.

  Then, as a result of the processing shown in FIGS. 10 to 15 based on the input / output table 109 shown in FIG. 4, a web application that displays an operation screen as shown in FIG.

  First, from the definition of line 1 of the input / output table 109 shown in FIG. 4, this screen is a screen having a function capable of dynamically switching the DB table, and the DB table as shown in FIG. The selection menu 201 and the switching search button 202 for switching confirmation are automatically generated by the code generation unit 107 shown in FIG.

  The tables 201a and 201b displayed on the selection menu 201 are DB tables defined in row 2 and row 3 of FIG. For example, when “Clinic (hospital)” 201a is selected and the switching search button 202 is pressed, the search target is “CliDB” defined in the lines 11 to 17 of the input / output table 109 shown in FIG. It becomes the “ClinicM” table of the DB system.

  The items for inputting the key for searching are the items in the lines 4 to 7 of the input / output table 109 shown in FIG.

  When a necessary value is input to the generated search condition input field 203 and a search button 204 is designated, the specified table is searched, and a result list is displayed in the search result display input field 205 shown in FIG. .

  In the search result display input field 205, items defined in line 6 to line 10 of the input / output table 109 shown in FIG. 4 are displayed. The DB configuration in the application used in the input / output table 109 shown in FIG. 4 corresponds to the DB configuration shown in FIG.

  The generation example using the input / output table 109 shown in FIG. 4 corresponds to switching between different external DB systems. However, if the definition of the input / output table 109 shown in FIG. 4 is changed, FIG. In addition to the function of switching the external DB as shown in FIG. 8, a function of switching the table in the internal DB as shown in FIG. 8 or a function of switching between the internal and external DB as shown in FIG. 9 is added. It is possible.

  FIG. 16 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, and performs table switching within the same DB system (internal DB or external DB). Corresponds to the case.

  For example, the input / output definition is the input / output table shown in FIG. 16 and the values of column 3 in row 2 and row 3 are “CliDB / ClinicM” and “CliDB / DrugstoreM”, and the DB system before the “/” symbol. The name is described as the same “CliDB”, and the file definition in the rows 11 to 24 in FIG. 16 also has the same DB system name in column 1 as “CliDB”. When the definition is changed in this way, the “ClinicM” table and the “DrugstoreM” table of the same DB (only the internal DB or only the external DB) are switched alternately. A DB configuration with only an internal DB corresponds to the example shown in FIG.

  Further, “CliDB” shown in column 3 of row 2 of FIG. 4 is an external DB, and “DruDB” of column 3 of row 3 of FIG. 4 is an internal DB. The distinction between the internal DB and the external DB is defined by the URL 603 of the login information 110 shown in FIG.

  In the case of such a DB configuration, the table “ClinicM” of the external DB “CliDB” and the table “DrugstoreM” of the internal DB “DruDB” can be switched alternately. Such a DB configuration including an external DB and an internal DB corresponds to the example illustrated in FIG.

  As described above, a DB selection screen program (JSP112) is generated by inputting a DB connection method (URL designation (network connection or local) or the like) and DB table configuration with business specifications as input, and DB In the web application development support system, there are provided a plurality of network connection (assignment) processing program (servlet 113) and a DB access processing program (Bean 114). Define the function to dynamically switch and access DB by user selection, or the function to dynamically switch and access multiple tables on the same DB by user selection, and program code Can be generated automatically.

  Therefore, an application program having a function that allows the user to dynamically switch the assignment to the table on the target DB and the access processing on the generated operation screen, and the definition for DB connection are defined in the framework of the business specification. It can be defined and automatically generated in the network, and productivity, maintainability, and manageability can be remarkably improved.

  In addition, it is possible to dynamically switch the connection to the distributed DB according to the user's selection, and to automatically generate the access processing to the table, so that a web application program area with excellent productivity and maintainability can be created. Can be spread.

  Within the same definition / generation scheme framework, connection to different tables and access processing can be automatically generated in the same DB.

  In the above-described embodiment, a method for generating a web application that can switch between two DBs / tables has been described as an example. However, the number of DB / tables that can be switched is limited to two. 3 or more DB tables that can be switched to the I / O table 109 are defined, and 3 or more DB tables can be switched by defining DB connection information corresponding to the login information 110. A simple web application.

  In the above description, the DB system name, the JDBC driver name, the URL, the user name, and the password are stored in the login information 110. However, instead of the JDBC driver name, the URL, the user name, and the password, the object name of the DB system is used. You may comprise so that it may memorize | store. In this case, a DB connection method that searches and connects the DB system from the object name of the DB system is generated.

  Also, the configurations and contents of the various data in FIGS. 4, 5, and 16 are not limited to this, and it is needless to say that they are configured with various configurations and contents according to applications and purposes.

  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.

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

  Further, in the above embodiment, based on a plurality of definition information respectively defining a plurality of tables on the database designated by the input / output table 109, and connection information for connecting to the database designated by the login information 110. The program generation apparatus that generates “the program code that can be accessed by dynamically switching the plurality of tables” has been described, but the database access apparatus (method) that can be accessed by dynamically switching the plurality of tables is also provided. It is included in the present invention.

  Further, in each of the embodiments described above, the program generation device that generates the web application program that operates on the web application server has been described. However, instead of the web application server as middleware, a Notes (product name) application server or Domino (product) is used. Name)-An application using groupware such as an application server may be generated.

  In this case, instead of a servlet, a program created by Java (registered trademark) called an agent is generated by a program generation device and placed on an application server of groupware. The input / output screen displayed by JSP is generated by a program generation device as content called a form and registered in a groupware database. Further, the same bean can be used as in the above embodiment.

  The application generated by the program generation apparatus of the present invention may be an application using a mobile terminal such as a PDA (personal digital assistant) or a mobile phone as a client.

  The protocol between the client and the client is not only HTTP but also WAP (Wireless Application Protocol), and the code generated by JSP is not limited to HTML, but other structured languages such as XML and WML. Such a program may be configured to be generated by the program generation device of the present invention.

  Further, in the above embodiment, the program generation apparatus receives the bean for accessing the database, the JSP for displaying the input / output screen of each data item in the selected screen pattern, and the input information from the input / output screen. The description has been given of the case where a web application configured by a servlet that controls the execution of the Bean and JSP based on the input information and controls the entire application is generated, but includes the functions of the Bean and JSP. Needless to say, it may be configured to generate a web application including only a servlet, only a servlet and JSP including the above-mentioned Bean function, or only a servlet and Bean including the above-mentioned JSP function. Absent.

  Furthermore, the present invention includes all configurations in which the modified examples described in the above embodiments are combined.

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

  FIG. 17 is a diagram illustrating a memory map of a recording medium (storage medium) that stores various data processing programs that can be read (read) by the program generation apparatus according to the present invention.

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

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

  The functions shown in FIGS. 3, 10, 11, 12, 13, 14, and 15 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 a program represented by software for achieving the present invention from a server, database, etc. on a network using a communication program and reading it, the system or apparatus can enjoy the effects of the present invention. It becomes.

  By generating the program code generated by the program generation apparatus of the present invention as an application using a program other than Java (registered trademark) such as ASP (Active Server Pages), PHP (Hypertext Preprocessor), etc. The device can also be applied to generate various 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 information (input / output table shown in FIG. 1) in the program generation apparatus of the present invention. It is a schematic diagram for demonstrating the login information shown in FIG. It is a figure which shows DB structure (external (remote) distributed DB structure) for demonstrating DB connection switching by the application produced | generated by the program production | generation apparatus of this invention. It is a figure which shows DB structure (internal (local) same DB structure) for demonstrating DB connection switching by the application produced | generated by the program production | generation apparatus of this invention. It is a figure which shows DB structure (distributed DB structure by internal (local) DB and external (remote) DB) for demonstrating DB connection switching by the application produced | generated by the program production | generation apparatus of this invention. It is a schematic diagram which shows an example of the operation screen in the web application produced | generated by the program production | generation apparatus of this invention. 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 schematic diagram explaining the business specification information (input / output table shown in FIG. 1) in the program generation apparatus of the present 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 (read) with 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 110 Login Information 111 Application Name 112 JSP Code 113 Servlet Code 114 Bean Code

Claims (7)

A program generating device for generating a web application program that have a accessible functions to a plurality of database tables,
First storage means for storing a plurality of table information each defining a table with information including a combination of a database name and a table name of the database;
Second storage means for storing group information defining a plurality of tables defined by the plurality of table information as groups that can be switched on one screen;
Third storage means for storing connection information including a driver name, a connection destination, and authentication information used when connecting to the database for each database;
Using the group information, a program code for displaying, on a web browser, an operation screen that can be selected as one of the plurality of tables defined as a group in the group information as a connection switching destination is generated. Means for generating
When the information of the table selected as the connection switching destination by the operation of the operation screen displayed on the web browser is received from the web browser, the connection information of the database corresponding to the selected table is used, and a second generating unit configured program code for accessing the selected table by switching a connection to a database corresponding to the selected table to generate,
A program generation apparatus comprising: 2. The program generating apparatus according to claim 1, wherein the tables defined by the table information are arranged on the same database or different databases. The operation screen includes a search instruction unit for performing a search instruction by specifying a search condition for a table selected as a connection switching destination on the operation screen,
The program code generated by the second generation means is “selected when the search instruction for the table selected as the connection switching destination on the operation screen is received from the web browser by operating the operation screen. If it is not connected to the database corresponding to the selected table, the connection information of the database corresponding to the selected table is used. When the database is connected to the database and executes the search process with the search conditions specified in the search instruction, and connected to the database corresponding to the selected table, it is directly specified in the search instruction. Program code for executing search processing under different search conditions " Program generating apparatus according to claim 2, wherein. The operation screen includes an update instruction unit for designating update data for a table selected on the operation screen and performing an update instruction,
The program code generated by the second generation unit corresponds to “the selected table when the update instruction for the table selected on the operation screen is received from the web browser by the operation of the operation screen”. If it is not connected to the database corresponding to the selected table, it is determined whether the database is connected to the database using the connection information of the database corresponding to the selected table. In order to execute the update process with the update data, and on the other hand, when connected to the database corresponding to the selected table, to execute the update process with the update data instructed by the update instruction as it is 4. The program according to claim 2, further comprising: Generating device. A program generation method in a computer for generating a web application program that have a table accessible functions of several databases,
A plurality of table information each defining a table based on information including a combination of a database name and a table name of the database can be switched to a storage unit of the computer on a single screen. Group information defined as a secure group, for each database, a driver name used when connecting to the database, a connection destination, and connection information including authentication information is stored, respectively.
Using the group information, the computer uses the group information to display a program code for displaying, on a web browser, an operation screen that can be selected as a connection switching destination of any of the plurality of tables defined as a group in the group information. A first generating step to generate;
When the computer receives, from the web browser, information on a table selected as a connection switching destination by an operation on the operation screen displayed on the web browser, the connection information of the database corresponding to the selected table is displayed. A second generation step of generating program code for switching to a database corresponding to the selected table and accessing the selected table ;
A program generation method characterized by comprising: Order of the program to execute the program generating method according to claim 5 on a computer. Program generating method a recording medium which the order of the program computer has readable recorded cause the computer to execute according to claim 5.

Images