JP2013008271A - List display automatic creation system and list display automatic creation method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To automatically create list display including paging processing utilizing a document.SOLUTION: Paging processing of an information acquisition function for acquiring information from a server-side database is packaged in the form of a common function, and contents to be described in a source of the information acquisition function are made irreducibly minimum. Elements of server/client interface specifications created by spreadsheet software are converted simply, thereby automatically creating a source code of a server-side state acquisition function. Furthermore, a client-side source is also configured to create only a function calling portion and to post-describe it to a client-side program. On the basis of the interface specifications, a program in a procedural language containing SQL and a program of the client calling it are outputted by using macro and the basic SQL for actually acquiring contents is only described, so that list display including paging processing can be implemented without caring of complicated processing.

Description

  The present invention relates to a list display automatic creation system, and more particularly to a list display automatic creation system for searching a server side database from a client side and displaying a list of search results on the client side.

  Currently, in order to efficiently manage a huge amount of data, a database is often designed based on a data management method called a relational database. Software for managing a relational database is a relational database management system (RDBMS: Relational DataBase Management System).

  As examples of RDBMS, “Oracle Database”, “Microsoft Access”, “Microsoft SQL Server”, “PostSQL”, “MySQL” (hereinafter, registered trademark) and the like are known.

  In RDBMS, SQL (Structured Query Language) is used as one of database languages (inquiry languages) for performing manipulation and definition of data in a database.

  List data is one of the solutions for avoiding the inconvenience of viewing and traffic due to the excessive number of lines when list data is acquired and displayed from a database using an SQL statement (SQL command line). There is a technique called paging processing in which the image is divided into a plurality of pages for display.

  However, in order to realize the above method, it is necessary to describe a process using a dynamic SQL statement, and the process is performed on the display screen for each list data in spite of the similar process. There is a problem that the SQL statement must be described.

  Also, accompanying the above problem, the SQL process for fetching data and the process for acquiring the page file (swap file) are mixed, and the created program has readability, expandability, etc. There is also the problem of becoming missing.

  In addition, a program that acquires data on the database side and a program that calls the program to display a list of data need to have the same interface (function, command, etc.) such as API (Application Program Interface). When there are many cases, it is necessary to prevent a difference in the description of the source code (source code) of these programs, so that a great amount of time may be spent on the creation of the programs.

  As a related technique, Patent Document 1 (Japanese Patent Laid-Open No. 2000-194593) discloses a record unit access method for heterogeneous distributed data. In this related technique, as the data access common function, a data reading function used for referring to (reading) a record from a binary file and a data writing used for outputting (writing) a record to the binary file Two functions are provided. The data read function specifies the file identification ID received as an argument, the position of the record (record number), etc., and calls the data conversion common function.

  Japanese Patent Laid-Open No. 2008-58826 discloses a cryptographic processing device, a cryptographic processing method, and a computer program. In this related technology, in an encryption processing configuration to which an extended “Feistel” structure in which the number of data series “d” is an integer “d ≧ 3” is applied, involution, that is, a function common to encryption processing and decryption processing Is applicable. By adopting a configuration for exchanging round keys and F functions in the decryption process, the swap function is set to the same processing mode in the encryption process and the decryption process, thereby enabling processing by a common function. In each round switching portion of the round function (F function), swap processing for exchanging each data series is executed. A function applied to the swap processing is a swap function. The swap function is one component of the encryption function. The swap function is applied to the output of each data series at the time of switching each round, and is a function for setting the input series in the next round corresponding to the output of each data series.

JP 2000-194593 A JP 2008-58826 A

  An object of the present invention is to provide an automatic list display creation system for automatically creating list display information (data list information) including paging processing using a document.

  The list display automatic creation system according to the present invention is based on the interface specifications between server and client, the source code of the server side program of the procedural language including SQL, and the client side program that calls the server side program. A development terminal that outputs source code, a common function that manages a database, executes the server-side program in response to the server-side program call, and packages the paging process according to the server-side program In accordance with the client-side program, the server-side program is called, the server-side program is searched, the database is searched, the search result is divided into a plurality of pages, and a list display including a paging process is performed. Delete and add data to a list with meaningful sequences While maintaining the sequence even if there is, including the client to perform a display by dividing the list of fixed line.

  A list display automatic creation method according to the present invention is a list display automatic creation method implemented by a computer, and based on interface specifications between server clients, source code of a server-side program of a procedural language including SQL And the source code of the client-side program that calls the server-side program, manages the database, executes the server-side program in response to the server-side program call, and A common function packaged with paging processing according to the program on the client side, and calls the server program according to the client side program, searches the database, and divides the search results into multiple pages. List display including paging process to display A list that has a sequence that is taste, while maintaining the sequence even when there is a deletion and addition of data, including possible to display by dividing the list of fixed line.

  The program according to the present invention is a program for causing a computer to execute the processing in the above list display automatic creation method. The program according to the present invention can be stored in a storage device or a storage medium.

  If only basic SQL for actually acquiring the contents is described, a list display system including a paging process can be created without being aware of complicated processes.

It is a figure showing an example of composition of a list display automatic creation system concerning the present invention. It is a figure which shows the example of an interface specification. It is a figure which shows the example of a SQL file. It is a flowchart which shows the process sequence of the list display automatic creation system which concerns on this invention. It is a figure which shows the procedure which produces the "WHERE" phrase of SQL according to the flow of a process of a common function.

<Embodiment>
Embodiments of the present invention will be described below with reference to the accompanying drawings.

  In the present invention, a mechanism for performing paging processing is configured in the form of a server client system.

  The paging process in the present invention is a process of displaying a list having a meaningful sequence, such as date order, by dividing it into a list of fixed lines while maintaining the sequence even when data is deleted or added. Point to. For example, when the line following the last line of the page is deleted, the next page displays a list for one page from the next line.

[System configuration]
With reference to FIG. 1, the detail of the structural example of the list display automatic creation system which concerns on this invention is demonstrated.

  The list display automatic creation system according to the present invention includes a development terminal 10, a server 20, and a client 30.

[Development terminal configuration]
The development terminal 10 includes a specification creation unit 11 and a source code creation unit 12.

  The specification creation unit 11 creates the interface specification 1 by using spreadsheet software (spread sheet software). The spreadsheet software is a spreadsheet application software used for tabulating and analyzing numerical data.

  The source code creation unit 12 creates and outputs the source code 2 for the server 20 and the source code 3 for the client 30 by a macro based on the interface specification 1. The macro is a function for automating a specific processing procedure as a program in spreadsheet software or the like. Here, the source code creation unit 12 reads the interface specification 1, creates source code 2 and source code 3 using macros, provides the source code 2 to the server 20, and provides the source code 3 to the client 30.

[Server configuration]
The server 20 includes a database 21 and a database management unit 22.

  The database 21 is a relational database.

  The database management unit 22 functions as a database management system (DBMS: DataBase Management System) and can register functions created in a procedural programming language. Further, the database management unit 22 executes the information acquisition function 4 and the common function 6 based on the source code 2, reads the SQL file 5, and performs paging processing.

[Client Configuration]
The client 30 includes a list display processing unit 31 and a display screen 32.

  The list display processing unit 31 accesses a function registered in the server 20 based on the source code 3, and uses a list display control (display control) for data obtained by using the function. List display information (data list information) including paging processing using a document is automatically created and displayed in a list on the display screen 32.

  The display screen 32 displays GUI (Graphical User Interface) for accessing the function registered in the server 20 and searching the database 21 and list display information (data list information) based on the search result.

[File / Function]
In the list display automatic creation system according to the present invention, the interface specification 1, the source code 2, the source code 3, the information acquisition function 4, the SQL file 5, and the common function 6 are used.

  The interface specification 1 is a specification used when creating a source code, and is a specification describing a function to be an interface such as an API (Application Program Interface) and setting of variables used in this function. It is.

  The source code 2 is a source code for processing a function for data acquisition executed on the server 20. Specifically, the source code 2 is a source code for processing of the information acquisition function 4 described later.

  The source code 3 is a source code of a process for setting information necessary for calling the information acquisition function 4 on the server 20 side from the client 30 side using a list display control function.

  The information acquisition function 4 is a function created in a procedural programming language that can describe an SQL statement (SQL command line). In response to a request from the client 30 side, the information acquisition function 4 reads the SQL file 5 and performs paging processing. This function returns the result to the 30th side. Here, the information acquisition function 4 is obtained by compiling (or building) and converting the source code 2 and is registered in the server 20. That is, the information acquisition function 4 is one of “functions registered in the server 20”.

  The SQL file 5 is a file in which an SQL statement for data acquisition is described, and is read by the information acquisition function 4. Since the SQL file 5 is an external file, it can be easily updated / modified.

  The common function 6 is a package of paging processing in the form of a common function among the processing of the information acquisition function 4. Here, the common function 6 is a function that actually reads a SQL statement from the SQL file 5, rewrites the SQL statement, and performs processing such as data acquisition and parameter creation, and paging processing. The arguments used for these processes are written in the source code 2 and given from the information acquisition function 4 to the common function 6. The common function 6 is not limited to a function (embedded function) described directly in the source code 2 but may be a function described in an external file called by the information acquisition function 4. For example, the common function 6 may be held in a reusable format such as a library.

  The information acquisition function 4, the SQL file 5, and the common function 6 may be a shell script or the like.

[Relationship between file / function and each part]
The specification creation unit 11 of the development terminal 10 performs paging processing by reading the SQL file 5 and the argument information necessary for creating the information acquisition function 4 for data acquisition in the interface specification 1 Describe necessary information.

  The source code creation unit 12 of the development terminal 10 sets information of the interface specification 1 as an argument of the common function 6 when creating the source code 2. As a result, when the server 20 calls the common function 6 using the information acquisition function 4 based on the source code 2, the server 20 performs paging processing according to the common function 6, and uses the acquired information based on the source code 2 that is the caller. Return to get function 4.

  Here, as a description language of the source code 2, “PL / SQL” (Procedural Language Extensions to SQL) in which SQL, which is a non-procedural language, is expanded to a procedural language, is assumed. ing. However, actually, it is not limited to these examples.

  The processing by PL / SQL is a procedural language, and similarly to the processing by embedded SQL, variables can be used, and the business logic can be implemented in the database by describing the control structure.

  PL / SQL includes a stored procedure, a stored function, a stored package, and the like. The stored procedure is a user program (Procedure) stored in a database. A stored function includes a function of the stored procedure or a stored procedure itself having a return value. A stored package is a collection of stored procedures and stored functions.

  In PL / SQL, stored procedures, stored functions, and stored packages are usually automatically compiled at the time of registration creation or call. However, if the change of the program affects other programs, it is preferable to compile in advance.

  When the source code 2 is described in a compiler language (VB, C, C ++, Java, etc.), the database management unit 22 of the server 20 compiles (or builds) the source code 2 and generates an object code (object code). : Executable program) and register this object code. This object code may always be operated on the server 20 as software such as a daemon or an agent. When the source code 2 is described in an interpreter language (Perl, PHP: Hypertext Preprocessor, etc.), it is not necessary to compile.

  For example, when executing the information acquisition function 4 by “Java Servlet” or “JSP” (Java Server Pages), the database management unit 22 compiles (or builds) the source code 2 and converts it into an object code. Register the code.

  On the other hand, the database management unit 22 overwrites the existing source code 2 with the new source code 2 when executing the information acquisition function 4 by “CGI” (Common Gateway Interface) or the like. That is, the difference (changed part) from the new source code 2 is reflected in the existing source code 2.

  Further, the source code creating unit 12 of the development terminal 10 adds the source code 3 to the display screen program of the client 30. Thereby, the client 30 can maintain consistency with the server 20 side with respect to the initial setting necessary for the list display control.

  The list display processing unit 31 of the client 30 prepares an independent small screen area (window) in the display screen 32 in accordance with the display screen program, and displays list display information (data list information) therein. To do.

  The display screen program is a program for displaying a window in the display screen 32. The list display control exists in the display screen program and is a function or function for displaying a list of data in a window.

  As an example of the display screen program, application software capable of displaying data in a window is assumed. As an example of such application software, a browser that displays a structured document using a markup language such as HTML (HyperText Markup Language) or XML (Extensible Markup Language) can be considered. However, actually, it is not limited to these examples.

  Based on the contents of the source code 3, the list display processing unit 31 adds information necessary for calling the information acquisition function 4 on the server 20 side from the client 30 side to the display screen program on the client 30. For example, the list display processing unit 31 passes predetermined arguments to the display screen program or changes the setting information of the list display control based on the contents of the source code 3.

  Note that the display screen program may exist on the server 20 in the case of the structured document as described above. When accessing the display screen program on the server 20 using a browser or the like, the list display processing unit 31 acquires (downloads) and temporarily stores the display screen program, and displays contents based on the display screen program. It is displayed on the screen 32. In this case, the list display processing unit 31 adds the contents of the source code 3 to the display screen program temporarily stored on the client 30.

  Further, when the source code 3 is described in a compiler language, the list display processing unit 31 compiles (or builds) the source code 3 to convert it into an object code, and converts the object code as a new display screen program. The existing display screen program may be updated. For example, if a function or code embedded in the display screen program calls an object code based on the source code 3, it is not necessary to update the display screen program as long as this object code is updated.

[Hardware example]
Below, the example of the concrete hardware which comprises the list display automatic creation system which concerns on this invention is demonstrated.

  As examples of the development terminal 10, the server 20, and the client 30, a computer such as a PC (personal computer), an appliance, a thin client server, a workstation, a mainframe, and a supercomputer is assumed. The development terminal 10, the server 20, and the client 30 are not limited to terminals and servers, and may be relay devices or peripheral devices. The development terminal 10, the server 20, and the client 30 may be an expansion board mounted on a computer or the like, or a virtual machine (VM: Virtual Machine) built on a physical machine. The development terminal 10, the server 20, and the client 30 may be mounted on a moving body such as a vehicle, a ship, or an aircraft.

  Further, the list display automatic creation system itself according to the present invention may be a single computer or the like. That is, the development terminal 10, the server 20, and the client 30 may be the same computer.

  Although not shown, the computer as described above is realized by a processor that is driven based on a program and executes predetermined processing, a memory that stores the program and various data, and an interface used for communication with a network.

  Examples of the processor include a CPU (Central Processing Unit), a network processor (NP), a microprocessor, a microcontroller, or a semiconductor integrated circuit (IC: Integrated Circuit) having a dedicated function. Conceivable.

  Examples of the memory include semiconductor storage devices such as a RAM (Random Access Memory), a ROM (Read Only Memory), an EEPROM (Electrically Erasable and Programmable Read Only Memory), a flash memory, and an HDD (Hold SMD). An auxiliary storage device such as State Drive), a removable disk such as a DVD (Digital Versatile Disk), a storage medium such as an SD memory card (Secure Digital memory card), or the like is conceivable. Further, a buffer or a register may be used. Alternatively, DAS (Direct Attached Storage), FC-SAN (Fibre Channel-Storage Area Network), NAS (Network Attached Storage), IP-SAN (IP-Storage Area), etc. may be used.

  Note that the processor and the memory may be integrated. For example, in recent years, a single chip such as a microcomputer has been developed. Therefore, a case where a one-chip microcomputer mounted on an electronic device or the like includes the processor and the memory can be considered.

  Examples of the interfaces include semiconductor integrated circuits such as substrates (motherboards and I / O boards) and chips that support network communication, network adapters such as NIC (Network Interface Card), and similar expansion cards and communication devices such as antennas. A communication port such as a connection port (connector) is conceivable.

  Examples of the network include the Internet, a LAN (Local Area Network), a wireless LAN (Wireless LAN), a WAN (Wide Area Network), a backbone (Backbone), a cable television (CATV) line, a fixed telephone network, a mobile phone network, WiMAX (IEEE 802.16a), 3G (3rd Generation), dedicated line (lease line), IrDA (Infrared Data Association), Bluetooth (registered trademark), serial communication line, data bus, and the like can be considered.

  Each unit (internal configuration) in the development terminal 10, the server 20, and the client 30 may be a module, a component, a dedicated device, or an activation (calling) program thereof.

  Examples of the specification creation unit 11 of the development terminal 10 include input devices such as a KVM (keyboard / video / mouse), a console (console), a keypad (keypad), a touch panel (touch panel), and a tablet (tablet). Alternatively, various information transmission medium readers can be considered. Alternatively, the specification creation unit 11 may be an interface (I / F: interface) for acquiring information from an external input device or storage device.

  Examples of the display screen 32 of the client 30 include a display device such as an LCD (Liquid Crystal Display), a PDP (Plasma Display), and an organic EL display (Organic Electroluminescence Display), and a printing device such as a printer that prints output contents on paper. Alternatively, a projection device such as a projector that projects the output content on a wall or a screen can be considered. Alternatively, the display screen 32 may be an interface (I / F) for outputting information to an external display device or storage device. That is, the display screen 32 may be any output device.

  However, actually, it is not limited to these examples.

[Details of interface specifications]
Details of the interface specification 1 will be described with reference to FIG.

  The interface specification 1 describes “function name”, “content”, “input parameter”, “output parameter”, and “sort key” (sort parameter).

  “Function name” indicates the name of the function. Here, “func_test” indicating “TEST information acquisition function” is described in “function name”.

  “Content” indicates a description of the processing content of the function. Here, in the “content”, an explanation that “acquires test information” is described.

  “Input parameter” indicates information defining a variable input to the function. In “input parameter”, “Japanese name”, “variable name”, “classification of whether to use in SQL”, “variable type”, and “number of digits” are described in a table format. Here, the first line of the input parameter table includes “Japanese name: input 1”, “variable name: input 1”, “classification of whether to use in SQL: yes”, “variable type: CHAR”. “Number of digits: 5” is described. In the second row of the input parameter table, “Japanese name: input 2”, “variable name: input2”, “classification of whether to use in SQL: no”, “variable type: INT”, “Number of digits: 2” is described.

  “Output parameter” indicates information defining a variable output from the function. In “output parameter”, “Japanese name”, “variable name”, “variable type”, “number of digits”, and “SQL column order” are described in a table format. Here, the first line of the output parameter table includes “Japanese name: item A”, “variable name: output_a”, “variable type: INT”, “number of digits: 1”, “SQL column”. "Order: 1" is described. In the second row of the output parameter table, “Japanese name: item B”, “variable name: output_b”, “variable type: CHAR”, “number of digits: 4”, “SQL column order” : 3 "is described. In the third row of the output parameter table, “Japanese name: item C”, “variable name: output_c”, “variable type: CHAR”, “number of digits: 5”, “SQL column order” : 4 "is described.

  “Sort key” (sort parameter) indicates information defining a variable to be a key necessary for sorting. In “sort key”, “Japanese name”, “variable name”, “variable type”, “number of digits”, “SQL column order”, and “ascending / descending order” are in table format in descending order of priority. It is described in. Here, the first line of the sort key (sort parameter) table includes “Japanese name: key A”, “variable name: key_a”, “variable type: INT”, “number of digits: 1”, “SQL”. Column order: 1 ”and“ ascending order / descending order: ascending order ”are described. In the second row of the sort key (sort parameter) table, “Japanese name: key B”, “variable name: key_b”, “variable type: CHAR”, “number of digits: 4”, “SQL” “Order of column: 2” and “Ascending order / Descending order: Descending order” are described. In the third row of the sort key (sort parameter) table, “Japanese name: key C”, “variable name: key_c”, “variable type: CHAR”, “number of digits: 4”, “SQL” “Order of column: 3” and “Ascending order / Descending order: Descending order” are described.

[Details of SQL file]
Details of the SQL file 5 will be described with reference to FIG.

  In the SQL file 5, an SQL statement for data acquisition is described.

  The SQL statement is described in a syntax of “SELECT“ table alias ”.“ Field 1 ”“ field alias ”FROM“ table name ”“ table alias ”WHERE“ conditional expression 1 ”AND“ conditional expression 2 ”.

  The SQL statement shown in FIG. 3 includes “SELECT t1.a a, t2.b b, t1.c c, t2.d d FROM test1_table t1, test2_table t2 WHERE t1.key1 = t2.key1 AND1> 1. It is described.

  A variable having “:” at the beginning of the character string indicates a “bind variable”. The bind variable is a variable of the program that is embedded in the SQL statement when a program for operating the database is created. Here, the bind variable is the variable “input1” of the input parameter “input 1” of the interface specification 1 shown in FIG.

  That is, in the SQL statement shown in FIG. 3, the records of two tables “test_table1” (table alias “t1”) and “test_table2” (table alias “t2”) are searched, and the table “t1” is searched. When the condition that the value of the field “key1” of the table is equal to the value of the field “key1” of the table “t2” and the value of the field “a” of the table “t1” is greater than the value of the bind variable “input1” is satisfied It describes that the field “a” of “t1”, the field “b” of the table “t2”, the field “c” of the table “t1”, and the field “d” of the table “t2” are output. .

[Processing procedure]
With reference to FIG. 4, the processing procedure of the list display automatic creation system according to the present invention will be described in detail.

(1) Step S101
The specification creation unit 11 creates the interface specification 1 using spreadsheet software.

  At this time, the specification creating unit 11 describes the information of “input parameter”, “output parameter”, and “sort key” (key necessary for sorting) in the interface specification 1 as shown in FIG. .

  Here, the specification creating unit 11 describes “Japanese name”, “variable name”, “classification of whether to use in SQL”, “variable type”, “number of digits” in “input parameter”. To do.

  In addition, the specification creation unit 11 describes “Japanese name”, “variable name”, “variable type”, “number of digits”, and “SQL column order” in “output parameter”. The “SQL column order” indicates “the order number of the elements in the SQL SELECT clause for acquiring data”.

  In addition, the specification creating unit 11 sets “sort key” in descending order of priority, “Japanese name”, “variable name”, “variable type”, “number of digits”, “SQL column order”, Describe "ascending / descending order". “Ascending order / descending order” indicates “whether they are arranged in ascending order or descending order”.

(2) Step S102
The source code creation unit 12 extracts the “function name” and “argument” from the interface specification 1, and converts the source code 2 and source code 3 including the “function declaration statement” and “processing statement” into a macro. Produced by etc.

  At this time, the source code creation unit 12 adds, in addition to “value described in the input parameter” and “value described in the output parameter” as “argument”, the following “common input argument / output argument” "Is added.

  Here, the source code creation unit 12 adds “the maximum number of rows to be acquired” and “a sum of the values of the sort keys in the first row” (hereinafter referred to as position keys) as “common input arguments”.

  In addition, the source code creation unit 12 sets, as “common output argument”, “number of acquired lines”, “classification of whether data exists before acquired data (with / without data)” (hereinafter referred to as top flag) Called), “classification of whether data exists after acquired data (with / without data)” (hereinafter referred to as end flag), and “last position key of acquired data” (hereinafter referred to as end position key) Add).

  In addition, the source code creation unit 12 outputs, as the “process statement”, “call of the common function 6”, “substitution of the value set to the argument of the common function 6”, and “data acquired by the common function 6” "Process to assign to argument" is described.

(3) Step S103
The source code creation unit 12 outputs the source code 2. The server 20 inputs the source code 2. Here, it is assumed that the source code 2 is described in a compiler language. The database management unit 22 of the server 20 functions as a DBMS, compiles (or builds) the source code 2 of the function created from the interface specification 1 and converts it into the information acquisition function 4, and registers this information acquisition function 4 To do.

(4) Step S104
The source code creation unit 12 outputs the source code 3. The client 30 inputs the source code 3. Based on the source code 3, the list display processing unit 31 of the client 30 sets information necessary for calling the information acquisition function 4 on the server 20 side using a list display control function.

(5) Step S105
The list display processing unit 31 uses the list display control to access the server 20 and call the information acquisition function 4 registered in the server 20.

(6) Step S106
The database management unit 22 executes the process of the information acquisition function 4 in response to the call from the client 30 side.

(7) Step S107
The database management unit 22 calls the common function 6 when the information acquisition function 4 is executed. The common function 6 is included in the information acquisition function 4. The information acquisition function 4 and the common function 6 may be described in separate files.

(8) Step S108
When executing the process of the common function 6, the database management unit 22 creates the “WHERE” phrase and the “ORDER BY” phrase of SQL based on the information of the sort key of the input argument, and the SQL statement of the SQL file 5 Processing to add and create a SQL statement to be executed, and to assign a value to a bind variable, execute the SQL statement, and acquire the execution result of the SQL statement.

(9) Step S109
The list display processing unit 31 automatically creates list display information including paging processing using a document and displays the list on the display screen 32.

[Create and output client-side source code]
Hereinafter, an example of processing for creating and outputting the source code 3 in step S102 and step S104 in FIG. 4 will be described.

  The control for list display that is a program on the client 30 side has a function for specifying an argument necessary for calling the information acquisition function 5, calls the information acquisition function 5 registered in the server 20, and acquires it from the information acquisition function 5. Has the ability to display data in tabular form.

  The source code creation unit 12 of the development terminal 10 uses macros to extract argument values from the interface specification 1 and put these argument values in the argument designation function of the list display control. Then, source code 3 is created and output.

[Information acquisition function call processing]
Hereinafter, an example of the calling process of the information acquisition function 5 in step S105 in FIG. 4 will be described.

  The list display processing unit 31 of the client 30 adds the source code 3 to the display screen program that uses the list display control, and reads the function that calls the information acquisition function 5 and the next page into the list display control. Prepare a function that performs the operation, and set the position key, the maximum number of rows to be acquired, etc.

  The list display processing unit 31 executes the display screen program and calls the information acquisition function 5 registered in the server 20 by executing the display screen program.

[Common function processing]
Hereinafter, the flow of processing of the common function 6 in step S108 in FIG. 4 will be described.

  Here, the interface specification 1 is as shown in FIG. The SQL file 5 is as shown in FIG.

[Create “WHERE” phrase]
The database management unit 22 of the server 20 performs the procedure for creating the “WHERE” phrase with the number of steps corresponding to the number of “sort keys” (sort parameters) in the interface specification 1 shown in FIG.

  Here, the database management unit 22 describes the SQL statement to be added to the “WHERE” phrase in the SQL file 5 shown in FIG.

[Create “Key A” part]
First, the database management unit 22 creates “AND” and “a character string enclosed in parentheses” in order to avoid mixing the “WHERE” phrase in the SQL file 5 with the processing, and FIG. The “key A” portion described at the top in the “sort key” (sort parameter) of the interface specification 1 shown in FIG.

  In the “sort key” (sort parameter) of the interface specification 1 shown in FIG. 2, the database management unit 22 designates the “variable name” of “key A” as “key_a” and the “SQL column” of “key A”. “Order” is designated as “1” (first row of the SQL file 5), and “ascending / descending order” of “key A” is designated as “ascending order”. Therefore, “((t1.a>: key_a)” is designated. ) ”. The variable “key_a” is a bind variable because “:” is at the beginning of the character string.

  That is, the database management unit 22 describes “AND (((t1.a>: key_a)))” as shown in (1) of FIG.

[Create “Key B” part]
Next, the database management unit 22 creates a portion of “key B” described second in “sort key” (sort parameter) of the interface specification 1 shown in FIG.

  In the “sort key” (sort parameter) of the interface specification 1 shown in FIG. 2, the database management unit 22 designates “variable name” of “key B” as “key_b”, and “SQL column” of “key B”. Is specified as “2” (second row of the SQL file 5), and “ascending / descending order” of “key B” is specified as “descending order”, so “((t2.b <: key_b )) ”. The variable “key_b” is a bind variable because “:” is at the beginning of the character string.

  “Key B” is a value to be considered only when the order is not determined by the condition of “Key A”, that is, when “Key A” is the same as the value assigned to the bind variable. .A =: key_a) AND (t2.b <: key_b)) ”is enclosed by“ OR ”and added after the“ key A ”portion.

  That is, as shown in (2) of FIG. 5, the database management unit 22 adds the “key B” portion after the “key A” portion, thereby obtaining “AND (((t1.a>: key_a). )) OR ((t1.a =: key_a) AND (t2.b <: key_b)) ”.

[Create “Key C” part]
Next, the database management unit 22 creates a part of “key C” described third by “sort key” (sort parameter) of the interface specification 1 shown in FIG.

  In the “sort key” (sort parameter) of the interface specification 1 shown in FIG. 2, the database management unit 22 designates “variable name” of “key C” as “key_c”, and “SQL column” of “key C”. Is specified as “3” (third column of the SQL file 5), and “ascending / descending order” of “key C” is specified as “descending order”, so “((t1.c <: key_c )) ”. The variable “key_c” is a bind variable because “:” is at the beginning of the character string.

  “Key C” is a value considered only when the order of “Key B” is not determined, that is, when “Key A” and “Key B” are the same as the values assigned to the bind variables. “((T1.a =: key_a) AND (t2.b =: key_b) AND (t1.c <: key_c))” indicating a condition is enclosed with “OR” and added after the part of “key B”. .

  That is, as shown in (3) of FIG. 5, the database management unit 22 adds the “key C” portion after the “key B” portion, thereby obtaining “AND (((t1.a>: key_a). )) OR ((t1.a =: key_a) AND (t2.b <: key_b)) OR ((t1.a =: key_a) AND (t2.b =: key_b) AND (t1.c <: key_c) ) ”.

[End of creation of “WHERE” phrase]
Here, there are only three keys “key A”, “key B”, and “key C” described in the “sort key” (sort parameter) of the interface specification 1 shown in FIG. Even if there is a key, the process of creating and adding the key part is performed in the same manner. When the description of all the key parts described in the “sort key” (sort parameter) of the interface specification 1 shown in FIG. 2 is finished, the process of creating the “WHERE” phrase is finished.

[Create “ORDER BY” phrase]
Further, when creating the “ORDER BY” phrase, the database management unit 22 considers the order of the SQL columns specified by the “sort key” (sort parameter) in the interface specification 1 shown in FIG. Create an “ORDER BY” phrase.

  The “ORDER BY” phrase is described in a syntax of “ORDER BY“ field 1 ”[ASC, DESC],“ field 2 ”[ASC, DESC],“ field 3 ”[ASC, DESC]”.

  Here, the database management unit 22 describes “ORDER BY 1 ASC, 2 DESC, 3 DESC” as the “ORDER BY” phrase.

  “ASC” (ascending: ascending order) indicates that the results are arranged in ascending order, and “DESC” (descending: descending order) indicates that the results are arranged in descending order. If neither of them is described, “ASC” is used.

  When executing the SQL statement, the database management unit 22 divides the position key into “sort key” (sort parameter) units according to the number of digits as processing of the “sort key” (sort parameter), assigns each to the bind variable, and adds Thus, the input parameters of the interface specification 1 shown in FIG.

  After executing the SQL statement, the database management unit 22 connects the value of the acquired last line as the “end position key”, and when the position key is specified, the “top flag” is set to “data present”. If there are more data than the number of acquired rows, the “end flag” is set to “data present”, and the data acquired by executing the SQL statement (SQL execution result) is returned as an array to the calling function. . Here, the caller function is a function that calls the information acquisition function 5 prepared in the list display control of the client 30.

[List processing]
An example of the list display process in step S109 in FIG. 4 will be described below.

  The list display processing unit 31 of the client 30 appends the data (SQL execution result) acquired from the information acquisition function 5 to the original display contents by the display screen program, and includes a paging process using a document. Information is automatically created and displayed in a list on the display screen 32, whereby the call processing of the information acquisition function 5 is completed.

  The list display processing unit 31 realizes page transition by calling a function that performs an operation of reading the next page prepared in the list display control in response to an event such as a button press in the display screen program. .

  The list display processing unit 31 displays / validates a button for transitioning to the previous page if the “top flag” is “data present”, and if the “end flag” is “data present”, Displays / validates a button for transitioning to the next page.

[Effect of this embodiment]
In the present invention, complicated paging processing is described in the common function, and SQL is described in the SQL file. Therefore, only the minimum necessary information described in the interface specification 1 is described in the source that calls the common function. Therefore, the readability is greatly improved, which leads to expandability.

  In addition, since the files are divided according to their roles, the correction range is minimized.

  In addition, by creating the client-side source at the same time, it is possible to prevent discrepancies between the sources.

  In conventional similar systems, even if interface specifications are made, the server and client programs are mostly written in different programming languages, and each program needs to be created separately. Come. When the number of arguments increases, it may be very time consuming to match the names, types, and digits of variables used in each program.

  In the present invention, both the server side program and the client side program simplify the part that describes the interface part, and when creating each program, it has a mechanism to extract necessary information from the interface specification. There is no worry about discrepancies in each program.

<Features of the present invention>
The list display automatic creation system according to the present invention automatically creates list display information including paging processing.

  The list display automatic creation system according to the present invention uses a macro to output a procedural language program including SQL and a client program that calls the program from an interface specification between server and client.

  The list display automatic creation system according to the present invention can create list display information including paging processing without being aware of complicated processing, as long as basic SQL for actually acquiring contents is described. it can. That is, an individual display screen can be realized for each list data only by creating / changing the SQL file.

  Specifically, in the list display automatic creation system according to the present invention, a paging process of an information acquisition function for acquiring information from a database created on the server side is packaged in the form of a common function and described in the source of the information acquisition function. Minimize content.

  In this way, the source code of the server-side state acquisition function is automatically created by simply converting the elements of the interface specification between the server and client created by the spreadsheet software. Also, only the function call part is created for the client-side source so that it can be added to the client-side program.

  That is, the gist of the system for automatically creating a list display according to the present invention is that “the mechanism of a common function in which paging processing is packaged” and “the source code of both the server side and client side programs are created from the specifications. "It is in.

<Appendix>
Part or all of the above-described embodiments can be described as in the following supplementary notes. However, actually, it is not limited to the following description examples.

(Appendix 1)
A development terminal that outputs the source code of the server-side program of the procedural language including SQL and the source code of the client-side program that calls the server-side program based on the interface specifications between the server and the client;
A server that manages a database, executes the server-side program in response to the server-side program call, and executes a common function process in which a paging process is packaged according to the server-side program;
In accordance with the client-side program, the server-side program is called, the database is searched, the search result is divided into a plurality of pages, and a list display including a paging process is performed. A list display automatic creation system that includes a client that displays data by dividing it into a list of fixed lines while maintaining the order even when data is deleted or added.

(Appendix 2)
It is a list display automatic creation system according to appendix 1,
The development terminal is
Means for creating the interface specification using spreadsheet software;
The element of the interface specification is simply converted, the source code of the state acquisition function for acquiring information from the database on the server side is automatically created and provided to the server, and the state acquisition is performed as the source code on the client side Means for creating source code for the function call part and providing it to the client;
Means for packaging the paging process in the information acquisition function in the form of a common function when automatically creating the source code of the state acquisition function and minimizing the content described in the source code of the information acquisition function; Equipped with a list display automatic creation system.

(Appendix 3)
It is a list display automatic creation system described in appendix 2,
The development terminal is
When creating the interface specifications using the spreadsheet software, means for describing input parameters, output parameters, sort key information necessary for sorting in the interface specifications,
Based on the interface specification, a function name and an argument are extracted, and a function declaration statement and a processing statement are created using a macro;
In addition to the value described in the input parameter and the value described in the output parameter, add a position key that summarizes the maximum number of rows acquired and the sort key value of the first row as a common input argument. As an output argument of, means for adding the number of acquired rows, an end flag indicating whether there is data after the acquired data, an end position key indicating the last position key of the acquired data,
The processing statement further comprises means for describing a process of calling the common function, assigning a value set to the argument of the common function, and substituting data acquired by the common function into an output argument of the function Automatic creation system.

(Appendix 4)
A list display automatic creation system according to any one of appendices 1 to 3,
The server
Means for invoking the common function according to the processing of the information acquisition function when the processing of the information acquisition function is executed in response to a call from the function on the client side;
Means for reading an SQL file according to the processing of the common function;
Means for creating a SQL “WHERE” phrase and an “ORDER BY” phrase based on the sort key information of the input argument, adding to the SQL sentence of the SQL file, and creating an SQL sentence to be executed;
Means for assigning a value to a bind variable and executing the SQL statement;
A list display automatic creation system comprising means for performing processing for returning data acquired by execution of the SQL statement to the caller function.

(Appendix 5)
An automatic list display creation system according to appendix 4,
The server
Means for dividing the position key into sort key units according to the number of digits, substituting each sort key into a bind variable, and executing the SQL statement when executing the SQL statement;
After execution of the SQL statement, the value obtained by connecting the values of the last acquired lines is set as the “end position key”, and when the position key is specified, the “top flag” is set as “with data” and the number of acquired lines or more If there is data, the “end flag” is set to “data present”, and the data acquired by executing the SQL statement is returned to the calling function as an array, respectively. .

(Appendix 6)
A list display automatic creation system according to any one of appendices 1 to 5,
The client
Means for performing processing for setting information for calling the information acquisition function on the server side using a function of the list display control based on the source code on the client side;
Means for preparing a function for reading the next page for the list display control on the client side, and setting a position key as a value to be input to an argument used in the function and a maximum number of rows to be acquired An automatic list display creation system.

<Remarks>
As mentioned above, although embodiment of this invention was explained in full detail, actually, it is not restricted to said embodiment, Even if there is a change of the range which does not deviate from the summary of this invention, it is included in this invention.

DESCRIPTION OF SYMBOLS 1 ... Interface specification 2 ... Source code 3 ... Source code 4 ... Information acquisition function 5 ... SQL file 6 ... Common function 10 ... Development terminal 11 ... Specification creation part 12 ... Source code creation part 20 ... Server 21 ... Database 22 ... Database management unit 30 ... Client 31 ... List display processing unit 32 ... Display screen

Claims (9)

A development terminal that outputs the source code of the server-side program of the procedural language including SQL and the source code of the client-side program that calls the server-side program based on the interface specifications between the server and the client;
A server that manages a database, executes the server-side program in response to the server-side program call, and executes a common function process in which a paging process is packaged according to the server-side program;
In accordance with the client-side program, the server-side program is called, the database is searched, the search result is divided into a plurality of pages, and a list display including a paging process is performed. A list display automatic creation system that includes a client that displays data by dividing it into a list of fixed lines while maintaining the order even when data is deleted or added. A list display automatic creation system according to claim 1,
The development terminal is
Means for creating the interface specification using spreadsheet software;
The element of the interface specification is simply converted, the source code of the state acquisition function for acquiring information from the database on the server side is automatically created and provided to the server, and the state acquisition is performed as the source code on the client side Means for creating source code for the function call part and providing it to the client;
Means for packaging the paging process in the information acquisition function in the form of a common function when automatically creating the source code of the state acquisition function and minimizing the content described in the source code of the information acquisition function; Equipped with a list display automatic creation system. A list display automatic creation system according to claim 2,
The development terminal is
When creating the interface specifications using the spreadsheet software, means for describing input parameters, output parameters, sort key information necessary for sorting in the interface specifications,
Based on the interface specification, a function name and an argument are extracted, and a function declaration statement and a processing statement are created using a macro;
In addition to the value described in the input parameter and the value described in the output parameter, add a position key that summarizes the maximum number of rows acquired and the sort key value of the first row as a common input argument. As an output argument of, means for adding the number of acquired rows, an end flag indicating whether there is data after the acquired data, an end position key indicating the last position key of the acquired data,
The processing statement further comprises means for describing a process of calling the common function, assigning a value set to the argument of the common function, and substituting data acquired by the common function into an output argument of the function Automatic creation system. A list display automatic creation system according to claim 3,
The server
Means for invoking the common function according to the processing of the information acquisition function when the processing of the information acquisition function is executed in response to a call from the function on the client side;
Means for reading an SQL file according to the processing of the common function;
A means for creating a SQL WHERE statement by creating a SQL WHERE clause and an ORDER BY clause based on the sort key information of the input argument, and adding to the SQL statement in the SQL file;
Means for dividing the position key into sort key units according to the number of digits, substituting each sort key into a bind variable, and executing the SQL statement;
After execution of the SQL statement, the end position key is the value obtained by connecting the acquired values of the last line. If the position key is specified, the top flag is set as data, and there is more data than the number of acquired lines. Includes a means for returning an end flag as data and returning data obtained by executing the SQL statement as an array to the caller function. The list display automatic creation system according to any one of claims 1 to 4,
The client
Means for performing processing for setting information for calling the information acquisition function on the server side using a function of the list display control based on the source code on the client side;
Means for preparing a function for reading the next page for the list display control on the client side, and setting a position key as a value to be input to an argument used in the function and a maximum number of rows to be acquired An automatic list display creation system.   A computer used as at least one of a development terminal, a server, and a client in the list display automatic creation system according to any one of claims 1 to 5. Means for outputting a server-side program source code of a procedural language including SQL and a client-side program source code for calling the server-side program based on an interface specification between server and client;
Means for managing a database, executing the server-side program in response to a call of the server-side program, and executing a process of a common function in which a paging process is packaged according to the server-side program;
In accordance with the client-side program, the server-side program is called, the database is searched, the search result is divided into a plurality of pages, and a list display including a paging process is performed. A computer comprising means for dividing and displaying a list of fixed lines while maintaining the arrangement even when data is deleted or added. A list display automatic creation method performed by a computer,
Outputting a source code of a server-side program of a procedural language including SQL and a source code of a client-side program that calls the server-side program based on an interface specification between server and client;
Managing a database, executing the server-side program in response to a call of the server-side program, and executing a process of a common function in which a paging process is packaged according to the server-side program;
In accordance with the client-side program, the server-side program is called, the database is searched, the search result is divided into a plurality of pages, and a list display including a paging process is performed. A list display automatic creation method that includes dividing and displaying a list of fixed lines while maintaining the arrangement even when data is deleted or added. Outputting a source code of a server-side program in a procedural language including SQL and a source code of a client-side program that calls the server-side program based on an interface specification between server and client;
Managing a database, executing the server-side program in response to a call of the server-side program, and executing a process of a common function in which a paging process is packaged according to the server-side program;
In accordance with the client-side program, the server-side program is called, the database is searched, the search result is divided into a plurality of pages, and a list display including a paging process is performed. A program that allows a computer to execute a step of displaying data by dividing it into a list of fixed lines while maintaining the arrangement even when data is deleted or added.

Images