JP5418539B2 - Information processing system, information processing method thereof, program thereof, information processing apparatus, information processing method thereof, program thereof, developer terminal, information processing method thereof, program thereof - Google Patents

Description

  Tree display technology

  There is a need for an environment in which developers can develop applications easily and quickly.

  For example, by providing a development environment in the cloud, developers can easily develop, and by providing it as a development environment for developers with a certain degree of freedom but a certain skill, they have that skill Developers can develop applications in a short time.

  Here, some of the created applications include a tree display. However, in the conventional development environment, there are many items to be set although the degree of freedom is high, and various elements such as design and operability are included. The more you try to satisfy it, the more work it takes, such as designers and programmers, resulting in the problem of longer development time.

  Therefore, in order to realize the development of the tree screen in a short time, it is conceivable to narrow down to developers who have SQL knowledge. In other words, if a developer who knows the contents of the database in advance can provide a development environment that can display the contents of the processing results of the SQL statement for the database in a tree using the knowledge of the SQL, the SQL sentence executed on the client terminal It becomes possible to develop an application that displays the result of processing by a tree.

  This makes it possible to develop a tree screen in a short time although design freedom is low.

  Japanese Patent Application Laid-Open No. 2004-151858 discloses a technique that makes it easy to view a folder expanded in a tree structure diagram without performing a cumbersome operation, and allows a desired folder and its contents to be quickly searched.

JP 2005-190369 A

  However, the technique described in Patent Document 1 makes it easy to view a tree structure diagram or quickly search, and does not display a processing result by an SQL sentence in a tree display.

The present invention solves the above problem, and provides a development environment in which a tree is arranged and an SQL statement can be easily set for the tree. When executing the application, a target object is selected on the tree screen. In such a case, an object of the present invention is to provide a system capable of reflecting the processing result of the SQL sentence corresponding to the selected target object on the tree screen .

The present invention is an information processing system capable of communicating with a developer terminal that develops an application, a client terminal that can display data in which a hierarchical structure is defined as a tree , and a server, and the client terminal includes: Display control means for performing control to display a tree display screen using tree display screen data including a program for issuing a SQL statement corresponding to the selected target object each time a target object is selected; When it is determined that the target object is selected as a result of the determination by the determination unit and the determination by the determination unit through the tree display screen displayed by the display control unit, using the information corresponding to the selected target object, corresponding to the target object Comprising a requesting means for issuing requests for vignetting SQL statements to the server, wherein the developer terminal, place the tree to be displayed on the display screen of the application, the desired database during operation object in the tree that the arrangement A setting screen display means for displaying a setting screen capable of defining an SQL statement for searching for the object, and a tree composed of objects is arranged on the setting screen to generate a tree display screen of the application Object placement means, setting accepting means for accepting setting of an SQL sentence to be issued when an object of a tree placed by the object placing means is operated, and setting contents accepted by the setting accepting means are registered in a recording medium. comprising registration instruction means for performing instructions to the server, and the server In accordance with the registration instruction means, managing means for managing SQL statements of a recording medium SQL statements issued to the database is stored,
In accordance with the request for issuing the SQL statement by the request unit, the SQL statement corresponding to the issue request stored in the recording medium managed by the management unit is acquired, and information corresponding to the selected target object is obtained. Processing means for performing processing for issuing the SQL statement to the database using, and transmission means for transmitting the processing result obtained from the database as a result of processing by the processing means to the client terminal, and the display The control means uses the processing result transmitted by the transmission means of the server to display the tree display screen to which the processing result is applied according to the target object operated by the user .

According to the present invention, a development environment is provided in which a tree is arranged and an SQL statement can be easily set for the tree. In execution of the application, when a target object is selected on the tree screen, the selected environment is selected. A system capable of reflecting the processing result of the SQL sentence corresponding to the target object on the tree screen can be provided .

1 is a system configuration diagram illustrating an example of configurations of a program development apparatus, a program development server, a database, an application client, and an application server according to the present invention. It is a block diagram which shows an example of each hardware constitutions applicable as a program development apparatus, a program development server, a database, an application client, and an application server concerning this invention. It is a figure which shows an example of the database which a database server manages. It is a flowchart which shows an example of the flow of the process which produces the application screen in embodiment of this invention. It is an example of a development screen. It is a flowchart which shows an example of the flow of the development process in embodiment of this invention. It is an example of a development screen. It is an example of a development screen. It is an example of a development screen. It is an example of a development screen. It is a flowchart which shows the flow of the tree screen display in embodiment of this invention. It is a figure which shows the example of a display of a tree screen. It is a figure which shows the example of a display when a folder is selected. It is a flowchart which shows the flow of the tree screen display in 2nd embodiment of this invention.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.

  FIG. 1 is a system configuration diagram (information processing system) showing an example of configurations of a program development apparatus (developer terminal), a program development server, a database, an application client (client terminal), and an application server according to the present invention.

  The program development apparatus 101 (information processing apparatus) defines a screen layout, a database search action, and the like according to a developer's operation. The program development apparatus 101 alone may accept user input, cause the program development server 102 described later to perform actual program generation processing, or the program development apparatus alone may perform processing up to program generation.

  The program development servers 102a to 102b (information processing apparatuses) develop a program in accordance with a developer instruction input by the program development apparatus 101. The program development server 102a may be arranged in a network 106 such as a LAN, and the program development server 102b may be arranged on the Internet or the cloud.

  Databases 103a to 103c (information processing apparatuses) are databases used by developed applications, and are also used during development in the present invention. For example, the database 103a for use by a developer may be configured by the same device as the program development device 101, may be arranged in a network 106 such as a LAN (database 103b), or may be connected to the Internet. It may be arranged on the cloud or on the cloud (database 103c). When the program development apparatus 101 cooperates with the program development server 102, the program development server 102 and the database may be configured in the same apparatus.

  Application servers 105a to 105b (information processing apparatuses) execute applications developed by the program development apparatus 101. It may be arranged in a network 106 such as a LAN (application server 105a), or may be arranged on the Internet or in the cloud (application server 105b). Further, it is possible to operate by connecting to the database 103 on the network 106, the Internet, or the cloud.

  The application clients 104a to 104b (information processing apparatuses) are user input terminals that operate application programs developed by the program development apparatus 101 in cooperation with the application server 105. It may be arranged in a network 106 such as a LAN (application client 104a), or may be arranged on the Internet or in the cloud (application client 104b). An information processing apparatus such as a portable terminal may be used.

  FIG. 2 is a block diagram showing an example of each hardware configuration applicable as the program development apparatus, program development server, database, application client, and application server according to the present invention.

  In FIG. 2, the CPU 201 comprehensively controls each device connected to the system bus 204.

  The ROM 203 or the external memory 211 stores an operating system (OS) that is a control program of the CPU 201 and programs for realizing various functions described later of the information processing apparatus such as each server, client, and device.

  The RAM 202 functions as a main memory, work area, temporary save area, and the like for the CPU 201.

  The input controller 205 controls input from the input unit 209. Examples of the input unit 209 include pointing devices such as a keyboard and a mouse in information processing apparatuses such as servers, clients, and apparatuses. Moreover, in a printing apparatus etc., a touch panel, a button, a switch, etc. are mentioned.

  The output controller 206 controls the display of the output unit 210. Examples of the output unit 210 include a CRT and a liquid crystal display.

  The external memory controller 207 controls access to the external memory 211 that stores a boot program, various applications, font data, user files, edit files, printer drivers, and the like. In addition, various tables and parameters for realizing various functions of each server, client, and device are stored. Examples of the external memory 211 include a hard disk (HD), a floppy (registered trademark) disk (FD), a compact flash (registered trademark) connected to a PCMCIA card slot via an adapter, and smart media.

  The communication I / F controller 208 executes communication control processing with an external device via a network.

  A program 212 for realizing the present invention is recorded in the external memory 211 and is executed by the CPU 201 by being loaded into the RAM 202 as necessary.

  FIG. 3 is a diagram illustrating an example of a database managed by the database server.

  In the database server, tables of “deptTable” 31, “PCTable” 32, and “SoftTable” 33 are managed.

  The “deptTable” 31 includes items of “dept” 311, “name” 312, and “parent” 313. “DeptTable” 31 is a table indicating an organization. According to this table, “DEF section” and “GHI section” are located under “ABC headquarters”, and “JKL section” and “MNO section” are located under “DEF section”. It shows that there is.

  The “PCTable” 32 includes items of “PCNo” 321, “owner” 322, and “dept” 323. For example, it is understood that the PC No “C123” is a PC of the owner “A” corresponding to the dept “d1”, “d2”, and “d4”.

  The “SoftTable” 33 includes items of “Softname” 331, “owner” 332, and “dept” 333. For example, it is understood that Softname “XXX” is the software possessed by owner “A” corresponding to dept “d1”, “d2”, and “d4”.

  FIG. 4 is a flowchart showing an example of a process flow for creating an application screen according to the embodiment of the present invention.

  FIG. 4 shows a flow of processing in which the developer operates the program development apparatus to develop an application screen. In this embodiment, a flow for creating a tree display screen will be described.

  In S401, the program development apparatus requests a development screen from the program development server.

  In S402, the program development server receives a request for a development screen.

  In S403, the program development server transmits a development screen to the program development apparatus.

  In S404, the program development device receives a development screen.

  In S405, the program development device displays a development screen. An example of the development screen is shown in FIG. The development screen is composed of three screens: an object definition field 51, an object selection field 52, and a definition setting field 53.

  As a development method, an arbitrary object is selected from the object selection field 52 and registered in the object definition field 51, and an operation for the object is performed from the definition setting field 53. When the creation of the screen is finished, the registration is finished by pressing the registration button 54.

  In S406, the program development device performs development processing. The flow of this development process will be described in detail with reference to FIGS. Although various screen developments are possible, in this embodiment, a screen for displaying a tree of folders and items obtained as a result of a query request (SQL search) to the database when the displayed folder is selected are displayed in a grid An example of creating a screen to be displayed is shown below.

  FIG. 6 is a flowchart showing an example of the flow of development processing in the embodiment of the present invention.

  In step S601, the program development apparatus determines whether a tree object has been selected. In the case of Yes, it progresses to S602, and in No, it progresses to S603. Specifically, it is determined whether the tree button 71 shown in FIG. 7 has been selected. After the tree button 71 is selected, the developer can place the tree object 72 in the object definition field 51 by dragging and dropping the mouse (S602).

  In S603, the program development device determines whether a grid object has been selected. If Yes, the process proceeds to S604, and if No, the process proceeds to S607. Specifically, it is determined whether the grid button 81 shown in FIG. 8 has been selected. After the grid button 81 is selected, the developer can place the grid object 82 in the object definition field 51 by dragging and dropping the mouse (S604). After placement, the number of items can be specified. For example, when the number of items is 5 by default, the number of items can be deleted to 2 (S604).

  Next, in S605, the program development device defines a grid. Specifically, as shown in FIG. 9, a grid name and an item name for specifying the selected grid 91 are defined. Here, “Grid name” 92 is defined as “1”, “Item name 1” 93 is defined as “PCNo”, and “Item name 2” 94 is defined as “owner”. By defining in this way, it becomes possible to apply a search result by SQL described later to this grid. When a plurality of grids are arranged, each grid is defined.

  Finally, in S605, the program development device performs action definition. Specifically, as shown in FIG. 10, an action definition for the selected tree 101 is performed. Here, three action definitions are performed: SQL for initial display (ACT1), SQL for child node display (ACT2), and node selection action SQL (ACT3).

  The initial display SQL (ACT1) is defined in the 102 column. The initial display SQL (ACT1) defines an SQL statement to be executed when the tree display screen is first displayed. As an example of the present embodiment, it is defined as “select depth from depth Table where parent =‘ Top ’”.

  This indicates that “dept” of a record in which “parent” of “deptTable” is “Top” is the initial display of the tree.

  Next, the child node display SQL (ACT2) is defined in the 103rd column. The child node display SQL (ACT2) defines an SQL statement to be executed when the “+” button is selected on the tree display screen. As an example of the present embodiment, it is defined as “select depth from depthTable where parent =: P1”.

  This indicates that “dept” of a record in which “parent” of “deptTable” is “P1” is displayed as a tree. “P1” is a variable indicating the focused node data. Therefore, when “deptTable” 31 shown in FIG. 3 is taken as an example, “d1” and “d2” are substituted for “P1”.

  Next, the node selection action SQL (ACT3) is defined in columns 104 and 106. The node selection action SQL (ACT3) defines an SQL statement to be executed when a folder is selected on the tree display screen. Here, one or a plurality of node selection actions SQL (ACT3) can be defined. The columns 104 and 106 are displayed by default, but if only one is defined, the definition is made to 104. In the case of defining a plurality, when the definition is made to 106, a new definition column is additionally displayed, so that the necessary number can be defined. As an example of the present embodiment, “select PCNo, owner from PCTable where depth =: P1” is input to 104, “1” is input to 105, and “select Softname, owner from Table wherePt: 106” is set to 106. Define “2”.

  “P1” is a variable indicating the focused node data.

  First, “select PCNo, owner from PCTable where depth =: P1” indicates that “PCNo” and “owner” of the record in which “dept” of “PCTable” is “P1” are displayed in the grid name “1”. Show.

  In addition, “select Softname, owner from SoftTable where depth =: P1” displays “Softname” and “owner” in the grid name “2” in the record where “dept” of “SoftTable” is “P1”. Show.

  When ending the definition, the developer presses the registration button 54. In the present embodiment, it is assumed that ACT1 and ACT2 are accepted as the first setting and ACT3 is accepted as the second setting.

  On the other hand, in S607, the program development apparatus determines whether another object has been selected, and if selected, accepts the definition of that object (S608), returns to S601, and if not selected, it remains as it is. Return to S601.

  The flow of the development process has been described above with reference to FIGS.

  In step S407, the program development apparatus determines whether a registration instruction has been issued. In the case of Yes, it progresses to S408, and in No, it returns to S406.

  In S408, the program development apparatus instructs the program development server to register the developed screen definition.

  In S408, the program development server accepts an instruction to register the developed screen definition.

  In S409, the program development server performs a registration process for registering the developed screen definition. Here, the defined SQL sentence is stored in a recording medium managed by the application server by this registration processing.

  A tree screen display program, which is a program for executing tree display, is stored in advance in the application server, and provides tree display screen data including the tree screen display program in response to a request from a general user. The tree screen display program includes a program that requests the application server to execute an SQL statement in accordance with the definition registered in S409. Here, for example, the tree screen data is screen data described in a structured language such as HTML, and the tree screen display program is a program described in a script language such as JavaScript. The tree display screen data includes table data for displaying the processing result.

  The flow of processing in FIG. 4 has been described above.

  Next, the flow of processing for a general user to display the developed tree display screen will be described.

  FIG. 11 is a flowchart showing a flow of tree screen display according to the embodiment of the present invention.

  Here, the user operates the application client to display a tree screen. The tree screen is acquired as tree screen data, and the tree screen data is displayed on the browser.

  In S1101, the application client requests a tree screen (tree screen data including a tree screen display program) from the application server.

  In S1102, the application server accepts a request for a tree screen.

  In S1103, the application server transmits tree screen data including a tree screen display program that can be executed by the application client. The tree screen display program includes a program that instructs the application server to issue SQL statements ACT1 to ACT3. Further, the application server manages SQL statements from ACT1 to ACT3.

  Asynchronous communication can be realized in the application client by providing it as a dynamic Web application without screen transition by Ajax.

  In S1104, the application client receives tree screen data.

  In step S1105, the application client requests the application server to execute the SQL statement of ACT1.

  In step S1106, the application server receives an ACT1 SQL statement execution request made from the application client, and issues a ACT1 SQL statement stored in the managed storage medium to the database server.

  In S1107, the database server performs processing for executing the issued SQL statement.

  In S1108, the database server transmits the processing result.

  In S1109, the application server transmits the acquired processing result to the application client as the result of ACT1.

  In S1110, the application client receives the execution result of ACT1.

  In S1111, the application client displays a tree screen.

  In this embodiment, since ACT1 is defined as “select depth from depthTable where parent = 'Top'”, the SQL statement is executed on the database shown in FIG. 3 managed by the database server. Thus, the tree screen (d1) indicated by 1201 in FIG. 12 is initially displayed.

  Next, in S1112, the application client determines whether the “+” button (selection target object 1) has been selected. In the case of Yes, it progresses to S1113, and in No, it progresses to S1120.

  In S1113, the application client requests the application server to execute the SQL statement of ACT2.

  In step S <b> 1114, the application server receives an ACT2 SQL statement execution request made from the application client, and issues a ACT2 SQL statement stored in the managed storage medium to the database server.

  In S1115, the database server performs processing for executing the issued SQL statement.

  In S1116, the database server transmits the processing result.

  In S1117, the application server transmits the acquired processing result to the application client as the result of ACT2.

  In S1118, the application client receives the execution result of ACT2.

  In S1119, the application client displays a tree screen.

  Here, in the present embodiment, ACT2 is defined as “select depth from depthTable where parent =: P1”. Therefore, by executing this SQL statement on the database shown in FIG. 3 managed by the database server, The tree screens 1202 and 1203 in FIG. 12 are displayed.

  1202 is an example displayed when “+” on the left side of “d1” in 1201 is pressed (an example in which the tree display screen is updated and displayed), but on the left side of “d1” in 1201 Since the focused node data becomes “d1” by pressing the “+” button, an SQL statement (query) is issued accordingly. Further, 1203 is an example displayed when “+” on the left side of “d2” in 1202 is pressed. Focusing is performed when the “+” button on the left side of “d2” in 1202 is pressed. Since the obtained node data is “d2”, the SQL statement is issued accordingly.

  In step S1120, the application client determines whether a folder (selection target object 2) has been selected. In the case of Yes, it progresses to S1121, and in No, it returns to S1112.

  In S1121, the application client requests the application server to execute the SQL statement of ACT3.

  In step S1122, the application server receives an ACT3 SQL statement execution request made from the application client, and issues a ACT3 SQL statement stored in the managed storage medium to the database server.

  In S1123, the database server performs processing for executing the issued SQL statement.

  In S1124, the database server transmits the processing result.

  In S1125, the application server transmits the acquired processing result to the application client as the result of ACT3.

  In S1126, the application client receives the execution result of ACT3.

  In S1127, the application client displays the execution result in the table.

  Here, in the present embodiment, ACT3 applies “select PCNo, owner from PCTable where depth =: P1” to the grid name “1”, and “select Softname, owner fromTabletable: P1”. Since it was defined to apply to “2”, when the SQL statement is executed on the database shown in FIG. 3 managed by the database server, the tables 1301 to 1303 in FIG. 13 are displayed. .

  1301 is an example when the “d1” folder is selected, but since the focused node data becomes “d1”, the SQL statement is issued accordingly. The results of the two SQL statements are respectively applied to the table of grid name “1” 131 and grid name “2” 132.

  1302 is an example when the “d2” folder or the “d3” folder is selected. Since the focused node data becomes “d2” or “d3”, an SQL statement is issued accordingly. The

  1303 is an example when the “d4” folder or the “d5” folder is selected. Since the focused node data becomes “d4” or “d5”, an SQL statement is issued accordingly. The

  In step S1128, the application client determines whether an instruction to end tree screen display has been issued. In the case of Yes, it progresses to S1123, and in No, it returns to S1110.

  In step S1129, the application client issues an end instruction to the application server.

  In S1130, the application server receives an end instruction and performs an end process.

  In S1131, the application server notifies the application client of the end.

  In S1132, the application client receives the end notification and ends the tree display screen.

  As described above, when a target object is selected on the tree screen, the processing result of the SQL sentence corresponding to the selected target object can be reflected on the tree screen.

  Next, a second embodiment will be described with reference to FIG.

  FIG. 14 is a flowchart showing the flow of the tree screen display in the second embodiment of the present invention.

  In the tree screen display according to the second embodiment of the present invention, the processing for applying the processing result of the SQL statement obtained from the database server to the tree display screen is performed not on the application client but on the application server. Note that the same processes as those in FIG. 11 are denoted by the same step numbers and description thereof is omitted.

  In S1401, the application server receives the processing result from the database server.

  In S1402, the application server transmits tree screen data reflecting the execution result of ACT1 to the application client.

  In S1403, the application client displays a tree screen using the received tree screen data.

  Similarly, in S1404 to S1406, screen data reflecting the processing result of ACT2 and in S1407 to S1409 is generated by the application server, and the generated screen data is transmitted to the application client.

  Therefore, also in the second embodiment of the present invention, when a target object is selected on the tree screen, the processing result of the SQL sentence corresponding to the selected target object can be reflected on the tree screen.

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

  The program according to the present invention is a program that can be executed by a computer according to the processing method of the flowchart shown in the present invention. The storage medium according to the present invention stores a program that can be executed by a computer. The program in the present invention may be a program for each processing method of each device.

  As described above, a recording medium that records a program that implements 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 program stored in the recording medium. It goes without saying that the object of the present invention can also be achieved by executing the reading.

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

  As a recording medium for supplying the program, 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, silicon A disk, solid state drive, or the like can be used.

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

  Furthermore, after the program read from the recording medium is written to the memory provided in the function expansion board inserted into the computer or the function expansion unit connected to the computer, the function expansion board is based on the instructions of the program code. It goes without saying that the case where the CPU or the like provided in 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 for achieving the present invention into the system or apparatus, the system or apparatus can enjoy the effects of the present invention. The form of the program may be in the form of object code, program code executed by an interpreter, script data supplied to an OS (operating system), and the like.

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

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

101 Program Development Device 102 Program Development Server 103 Database 104 Application Client 105 Application Server

Claims (16)

An information processing system capable of communicating between a developer terminal that develops an application, a client terminal that can display a hierarchically defined data as a tree, and a server,
The client terminal is
Display control means for performing control to display a tree display screen using tree display screen data including a program for issuing a SQL statement corresponding to the selected target object each time a target object is selected;
Determination means for determining whether a target object is selected by a user operation via a tree display screen displayed by the display control means;
As a result of the determination by the determination means, when it is determined that the target object has been selected, an issuance request for an SQL sentence associated with the target object is issued to the server using information corresponding to the selected target object. Requesting means to perform;
With
The developer terminal is
A setting screen display unit that arranges a tree to be displayed on an application display screen and displays a setting screen capable of defining a SQL statement for searching a desired database when an object of the arranged tree is operated;
In the setting screen, in order to generate a tree display screen of the application, object placement means for placing a tree composed of objects;
Setting accepting means for accepting the setting of an SQL sentence to be issued when an object of the tree placed by the object placing means is operated;
Registration instruction means for instructing the server to register the setting content received by the setting reception means in a recording medium;
With
The server
A management unit that manages the SQL statement of the recording medium in which the SQL statement issued to the database is stored according to the registration instruction unit;
In accordance with the request for issuing the SQL statement by the request unit, the SQL statement corresponding to the issue request stored in the recording medium managed by the management unit is acquired, and information corresponding to the selected target object is obtained. Processing means for performing processing for issuing the SQL statement to the database using the database;
Transmitting means for transmitting a processing result obtained from the database as a result of processing by the processing means to the client terminal;
With
The display control means displays the tree display screen in which the processing result is applied according to the target object operated by a user, using the processing result transmitted by the transmission means of the server. Information processing system.   The information processing system according to claim 1, wherein the display control unit of the client terminal updates and displays the tree display screen using the processing result transmitted by the transmission unit of the server. The server
A processing means obtained from the database as a result of the processing by the processing means, further comprising a fitting means for applying to the screen data for displaying the tree screen;
The transmission means of the server transmits the screen data fitted by the fitting means to the client terminal,
The information processing system according to claim 1, wherein the display control unit of the client terminal displays a tree display screen using screen data transmitted by the transmission unit of the server. The setting accepting means in the developer terminal is:
It is possible to accept the setting of the SQL sentence for displaying the tree,
Registration instruction means for instructing the server to register the setting contents in accordance with a request for registering the setting contents received by the setting receiving means to the server;
With
The information processing system according to any one of claims 1 to 3, wherein the management unit of the server manages an SQL sentence stored in the recording medium in accordance with the registration instruction unit. The setting accepting means in the developer terminal further includes:
5. When a folder displayed by tree display is selected, it is possible to accept a setting of an SQL sentence for displaying data contents in a table associated with the folder. Information processing system described in 1. When the determination unit of the client terminal determines that the target object for updating the tree display has been selected, the request unit of the client terminal supplies information corresponding to the selected target object to update the tree display. A request for issuing the used SQL sentence is made to the server,
The server processing unit stores an SQL statement obtained by substituting information indicating the selected target object into an SQL statement corresponding to the issue request stored in the recording medium managed by the management unit. The information processing system according to any one of claims 1 to 5, wherein a process of issuing is performed. The tree display screen data includes table data for displaying the processing result,
When the determination unit of the client terminal determines that a folder is selected as a target object, the request unit of the client terminal uses information corresponding to the selected target object to display the contents of the folder. A request to issue a SQL statement to the server,
The server processing unit stores an SQL statement obtained by substituting information indicating the selected target object into an SQL statement corresponding to the issue request stored in the recording medium managed by the management unit. The information processing system according to any one of claims 1 to 6, wherein a process of issuing is performed. The program included in the tree display screen data can issue a plurality of SQL statements when a single folder is selected as a target object.
When the determination unit of the client terminal determines that a folder has been selected as the target object, the request unit of the client terminal is selected to display the contents of one or more tables associated with the folder. A request to issue a plurality of SQL statements using information corresponding to the target object,
The processing unit of the server stores a plurality of SQL statements obtained by substituting information corresponding to the selected target object into an SQL statement corresponding to the issue request stored in the recording medium managed by the management unit. The information processing system according to claim 7, wherein a process issued to the information processing unit is performed. An information processing method of an information processing system capable of communicating with a developer terminal that develops an application, a client terminal that can display data in which a hierarchical structure is defined as a tree, and a server,
The client terminal is
Display in which the display control means performs control to display the tree display screen using tree display screen data including a program that issues a SQL statement issue request corresponding to the selected target object each time the target object is selected. Control steps;
A determination step for determining whether a target object is selected by a user operation via the tree display screen displayed by the display control step;
If it is determined that the target object has been selected as a result of the determination in the determination step, the requesting unit uses the information corresponding to the selected target object to issue an SQL statement associated with the target object. Requesting to the server;
Including
The developer terminal is
The setting screen display means arranges a tree to be displayed on the application display screen, and displays a setting screen capable of defining an SQL statement for searching a desired database when an object of the arranged tree is operated. A screen display step;
An object placement step for placing a tree composed of objects in order to generate a tree display screen of the application on the setting screen;
A setting accepting step for accepting a setting of an SQL statement to be issued when the setting accepting unit operates an object of the tree placed in the object placing step;
A registration instruction step in which the registration instruction means instructs the server to register the setting content received in the setting reception step in a recording medium;
Including
The server
A management step in which the management means manages the SQL statement of the recording medium storing the SQL statement to be issued to the database in accordance with the registration instruction step;
The processing means acquires an SQL statement corresponding to the issuance request stored in the recording medium managed by the management step in accordance with the issuance request of the SQL statement by the requesting step, and selects the selected target object. A processing step for performing processing for issuing the SQL statement to the database using corresponding information;
A transmitting step for transmitting a processing result obtained from the database to the client terminal as a result of the processing by the processing step;
Including
The display control step displays the tree display screen in which the processing result is applied according to the target object operated by a user, using the processing result transmitted by the transmission step of the server. Information processing method. A program that can be executed in an information processing system capable of communicating with a developer terminal that develops an application, a client terminal that can display hierarchically defined data as a tree, and a server,
The client terminal is
Display control means for performing control to display a tree display screen using tree display screen data including a program for issuing a SQL statement corresponding to the selected target object each time a target object is selected;
Determination means for determining whether a target object is selected by a user operation via the tree display screen displayed by the display control means;
As a result of the determination by the determination means, when it is determined that the target object has been selected, an issuance request for an SQL sentence associated with the target object is issued to the server using information corresponding to the selected target object. Request means to perform,
Function as
The developers terminal,
A setting screen display means for displaying a setting screen capable of defining a SQL statement for arranging a tree to be displayed on an application display screen and for searching a desired database when an object of the arranged tree is operated;
An object placement means for placing a tree composed of objects to generate a tree display screen of the application in the setting screen;
Setting accepting means for accepting setting of an SQL sentence to be issued at the time of operating an object of the tree placed by the object placing means;
Registration instruction means for instructing the server to register the setting content received by the setting reception means in a recording medium;
Function as
The server,
Management means for managing the SQL sentence of the recording medium in which the SQL sentence issued to the database is stored in accordance with the registration instruction means;
In accordance with the request for issuing the SQL statement by the request unit, the SQL statement corresponding to the issue request stored in the recording medium managed by the management unit is acquired, and information corresponding to the selected target object is obtained. Processing means for performing processing for issuing the SQL statement to the database by using,
Transmitting means for transmitting a processing result obtained from the database as a result of processing by the processing means to the client terminal;
Function as
The display control means displays the tree display screen in which the processing result is applied according to the target object operated by a user, using the processing result transmitted by the transmission means of the server. program. Display control means for performing control to display a tree display screen using tree display screen data including a program for issuing a SQL statement corresponding to the selected target object each time a target object is selected; When it is determined that the target object is selected as a result of the determination by the determination unit and the determination by the determination unit through the tree display screen displayed by the display control unit, A client terminal capable of tree display, and a display screen for displaying an application, comprising: request means for requesting the information processing apparatus to issue an SQL statement associated with the target object using information corresponding to the selected target object Place the tree to be displayed in, and operate the objects of the placed tree A setting screen display means for displaying a setting screen capable of defining an SQL statement for searching a desired database, and an object for generating a tree display screen of the application in the setting screen. Object placement means for placing a tree, setting accepting means for accepting settings of an SQL statement to be issued when an object of the tree placed by the object placing means is operated, and setting contents accepted by the setting accepting means are recorded. An information processing apparatus capable of communicating with a developer terminal comprising: a registration instruction unit that instructs the information processing apparatus to register with a medium;
A management unit that manages the SQL statement of the recording medium in which the SQL statement issued to the database is stored according to the registration instruction unit;
In accordance with the request for issuing the SQL statement by the request unit, the SQL statement corresponding to the issue request stored in the recording medium managed by the management unit is acquired, and information corresponding to the selected target object is obtained. Processing means for performing processing for issuing the SQL statement to the database using the database;
Transmitting means for transmitting a processing result obtained from the database as a result of processing by the processing means to the client terminal;
An information processing apparatus comprising: Display control means for performing control to display a tree display screen using tree display screen data including a program for issuing a SQL statement corresponding to the selected target object each time a target object is selected; When it is determined that the target object is selected as a result of the determination by the determination unit and the determination by the determination unit through the tree display screen displayed by the display control unit, A client terminal capable of tree display, and a display screen for displaying an application, comprising: request means for requesting the information processing apparatus to issue an SQL statement associated with the target object using information corresponding to the selected target object Place the tree to be displayed in, and operate the objects of the placed tree A setting screen display means for displaying a setting screen capable of defining an SQL statement for searching a desired database, and an object for generating a tree display screen of the application in the setting screen. Object placement means for placing a tree, setting accepting means for accepting settings of an SQL statement to be issued when an object of the tree placed by the object placing means is operated, and setting contents accepted by the setting accepting means are recorded. A registration instruction means for instructing the information processing apparatus to register to a medium, and a developer terminal comprising: an information processing method in an information processing apparatus capable of communication;
A management step in which the management means manages the SQL sentence of the recording medium in which the SQL sentence issued to the database is stored according to the registration instruction means;
The processing means acquires an SQL sentence corresponding to the issuance request stored in the recording medium managed by the management step in accordance with the issuance request of the SQL sentence by the requesting means, and sets the selected target object A processing step for performing processing for issuing the SQL statement to the database using corresponding information;
A transmitting step for transmitting a processing result obtained from the database to the client terminal as a result of the processing by the processing step;
An information processing method comprising: Display control means for performing control to display a tree display screen using tree display screen data including a program for issuing a SQL statement corresponding to the selected target object each time a target object is selected; When it is determined that the target object is selected as a result of the determination by the determination unit and the determination by the determination unit through the tree display screen displayed by the display control unit, A client terminal capable of tree display, and a display screen for displaying an application, comprising: request means for requesting the information processing apparatus to issue an SQL statement associated with the target object using information corresponding to the selected target object Place the tree to be displayed in, and operate the objects of the placed tree A setting screen display means for displaying a setting screen capable of defining an SQL statement for searching a desired database, and an object for generating a tree display screen of the application in the setting screen. Object placement means for placing a tree, setting accepting means for accepting settings of an SQL statement to be issued when an object of the tree placed by the object placing means is operated, and setting contents accepted by the setting accepting means are recorded. A registration instruction means for instructing the information processing apparatus to register to a medium; a developer terminal comprising: a program executable on an information processing apparatus capable of communication;
Management means for managing the SQL sentence of the recording medium in which the SQL sentence issued to the database is stored in accordance with the registration instruction means;
In accordance with the request for issuing the SQL statement by the request unit, the SQL statement corresponding to the issue request stored in the recording medium managed by the management unit is acquired, and information corresponding to the selected target object is obtained. Processing means for performing processing for issuing the SQL statement to the database by using,
Transmitting means for transmitting a processing result obtained from the database as a result of processing by the processing means to the client terminal;
A program for causing the information processing apparatus to function. Display control means for performing control to display a tree display screen using tree display screen data including a program for issuing a SQL statement corresponding to the selected target object each time a target object is selected; When it is determined that the target object is selected as a result of the determination by the determination unit and the determination by the determination unit through the tree display screen displayed by the display control unit, using the information corresponding to the selected target object, the request means for issuing requests for SQL statements associated with the target object to the server, and a client terminal tree displayable comprise, according to the registration instruction means, the database For managing the SQL statement of the recording medium storing the SQL statement issued to In accordance with the SQL statement issuance request by the request unit, the SQL statement corresponding to the issuance request stored in the recording medium managed by the management unit is acquired and corresponds to the selected target object. Processing means for performing processing for issuing the SQL statement to the database using information to be transmitted, and transmission means for transmitting the processing result obtained from the database as a result of processing by the processing means to the client terminal. A developer terminal that can communicate with the server,
A setting screen display unit that arranges a tree to be displayed on an application display screen and displays a setting screen capable of defining a SQL statement for searching a desired database when an object of the arranged tree is operated;
In the setting screen, in order to generate a tree display screen of the application, object placement means for placing a tree composed of objects;
Setting accepting means for accepting the setting of an SQL sentence to be issued when an object of the tree placed by the object placing means is operated;
Registration instruction means for instructing the server to register the setting content received by the setting reception means in a recording medium;
A developer terminal characterized by comprising: Display control means for performing control to display a tree display screen using tree display screen data including a program for issuing a SQL statement corresponding to the selected target object each time a target object is selected; When it is determined that the target object is selected as a result of the determination by the determination unit and the determination by the determination unit through the tree display screen displayed by the display control unit, using the information corresponding to the selected target object, the request means for issuing requests for SQL statements associated with the target object to the server, and a client terminal tree displayable comprise, according to the registration instruction means, the database For managing the SQL statement of the recording medium storing the SQL statement issued to In accordance with the SQL statement issuance request by the request unit, the SQL statement corresponding to the issuance request stored in the recording medium managed by the management unit is acquired and corresponds to the selected target object. Processing means for performing processing for issuing the SQL statement to the database using information to be transmitted, and transmission means for transmitting the processing result obtained from the database as a result of processing by the processing means to the client terminal. An information processing method in a developer terminal capable of communicating with a server,
The setting screen display means arranges a tree to be displayed on the application display screen, and displays a setting screen capable of defining an SQL statement for searching a desired database when an object of the arranged tree is operated. A screen display step;
An object placement step for placing a tree composed of objects in order to generate a tree display screen of the application on the setting screen;
A setting accepting step for accepting a setting of an SQL statement to be issued when the setting accepting unit operates an object of the tree placed in the object placing step;
A registration instruction step in which the registration instruction means instructs the server to register the setting content received in the setting reception step in a recording medium;
An information processing method comprising: Display control means for performing control to display a tree display screen using tree display screen data including a program for issuing a SQL statement corresponding to the selected target object each time a target object is selected; When it is determined that the target object is selected as a result of the determination by the determination unit and the determination by the determination unit through the tree display screen displayed by the display control unit, using the information corresponding to the selected target object, the request means for issuing requests for SQL statements associated with the target object to the server, and a client terminal tree displayable comprise, according to the registration instruction means, the database For managing the SQL statement of the recording medium storing the SQL statement issued to In accordance with the SQL statement issuance request by the request unit, the SQL statement corresponding to the issuance request stored in the recording medium managed by the management unit is acquired and corresponds to the selected target object. Processing means for performing processing for issuing the SQL statement to the database using information to be transmitted, and transmission means for transmitting the processing result obtained from the database as a result of processing by the processing means to the client terminal. A program that can be executed on a developer terminal that can communicate with a server,
A setting screen display means for displaying a setting screen capable of defining a SQL statement for arranging a tree to be displayed on an application display screen and for searching a desired database when an object of the arranged tree is operated;
An object placement means for placing a tree composed of objects to generate a tree display screen of the application in the setting screen;
Setting accepting means for accepting setting of an SQL sentence to be issued at the time of operating an object of the tree placed by the object placing means;
Registration instruction means for instructing the server to register the setting content received by the setting reception means in a recording medium;
A program for causing the developer terminal to function as:

Images