JP2009043023A - Display control apparatus, display control method and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To achieve suitable page switching control capable without confusing a user. <P>SOLUTION: A terminal apparatus 30 retrieves an employee information DB 11 and displays a list of retrieved results in each page on a display part 35. When an operation part 31 is operated and operation for switching pages is performed, employee information is reaquired again in a retrieving condition equivalent to that of acquisition of the employee information being displayed at present. On the basis of the top data of the employee information being displayed at present, the employee information corresponding to the switched page is acquired from the reacquired employee information and displayed. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a display control apparatus, a display control method, and a program for displaying a list of data extracted by search in units of pages.

There is a search system in which a user inputs an arbitrary search condition, extracts data that matches the input search condition, and displays the list. This type of search system divides the data into a plurality of pages and displays them in page units when there is a lot of data to be displayed.
For example, Patent Document 1 discloses a system (karaoke performance system) that displays music data of a page corresponding to a position indicated by a scroll bar when music data that matches a search covers a plurality of pages.

In a conventional search system, while a user performs a search and displays a specific page of data that matches the search conditions, the data is modified by another user or administrator, and the original input is made Data that matches the search conditions may be changed.
JP-A-2005-300933

  In such a case, the data displayed after the page switching operation by the user is the data before the change is made. For this reason, the user may be confused by displaying wrong data.

The present invention has been made in view of the above circumstances, and provides a display control device, a display control method, and a program that enable page switching of appropriate data list display that does not confuse the user. Objective.
Another object of the present invention is to provide a display control device, a display control method, and a program that can always display the latest data.

In order to achieve the above object, a display control apparatus according to the first aspect of the present invention provides:
Data acquisition means for searching and acquiring data that matches a predetermined search condition;
List display means for displaying a list of data acquired by the data acquisition means in units of pages;
Page switching instruction means for instructing switching of the page of data displayed by the list display means;
In response to the page switching instruction by the page switching instruction means, the data acquisition means re-searches and acquires data that matches the predetermined search condition, and from among the acquired data again to the switching destination page Control means for extracting corresponding data and displaying the list on the list display means;
It is characterized by providing.

The data acquisition means searches and acquires data stored in a predetermined database,
The database may allow access to and update of data even when the data retrieved by the list display means is displayed as a list.

  The control means determines whether or not the data displayed as a list by the list display means is included in the data acquired again by the data acquisition means in order from the top, and first determines that it is included. The data corresponding to the switching destination page may be extracted based on the processed data.

  The control means determines whether or not the data displayed as a list by the list display means is included in the data acquired again by the data acquisition means in order from the end, and first determines that it is included. The data corresponding to the switching destination page may be extracted based on the processed data.

In order to achieve the above object, a display control method according to a second aspect of the present invention includes:
A data acquisition step of searching and acquiring data that matches a predetermined search condition;
A list display step of displaying a list of data acquired in the data acquisition step in units of pages;
A page switching instruction step for instructing switching of a page of data displayed in the list display step;
In response to the page switching instruction in the page switching instruction step, the data acquisition step re-searches and acquires data that matches the predetermined search condition, and from among the acquired data again to the switching destination page A control step of extracting corresponding data and displaying the list in the list display step;
It is characterized by providing.

In order to achieve the above object, a program according to the third aspect of the present invention provides:
Computer
Data acquisition means for searching and acquiring data that matches a predetermined search condition;
List display means for displaying a list of data acquired by the data acquisition means in units of pages;
Page switching instruction means for instructing switching of data pages displayed by the list display means;
In response to the page switching instruction by the page switching instruction means, the data acquisition means re-searches and acquires data that matches the predetermined search condition, and from among the acquired data again to the switching destination page Control means for extracting corresponding data and displaying the list on the list display means;
And make it work.

  According to the present invention, when the page switching operation is performed, the search process is performed again and then the page is switched. Therefore, it is possible to prevent a list of data different from the actually existing data from being displayed. , Enabling list display without confusing users.

Embodiments of the present invention will be described with reference to the drawings.
In the present embodiment, the present invention will be described by taking as an example a case where the present invention is applied to a database system built in a company.

  As shown in FIG. 1, the database system according to the present embodiment includes a DB (database) server 10, a LAN (Local Area Network) 20, and a terminal device 30.

The DB server 10 includes a plurality of databases (DB) that store various types of information related to a predetermined company.
For example, the DB server 10 includes an employee information DB 11 that stores information on employees belonging to a company. As shown in FIG. 2, the employee information DB 11 stores identification information (ID), information such as name and affiliation for each employee belonging to the company.
It is assumed that employee information is stored in the employee information DB 11 sequentially from top to bottom in the figure. For example, in FIG. 2, it means that records of the employee information DB 11 have been stored in the order of IDs “0001”, “0002”, “0003”.

  The DB server 10 is connected to other terminal devices other than the terminal device 30 and devices such as a server via the LAN 20. From these devices, it is possible to display a list of information stored in the DB server 10 or modify (delete, add, update, etc.) the information stored in the DB server 10 at any time. .

Returning to FIG. 1, the terminal device 30 is connected to the DB server 10 via a LAN (Local Area Network) 20 as shown in FIG.
The terminal device 30 includes an operation unit 31, a storage unit 32, a control unit 33, a communication control unit 34, and a display unit 35.

  The operation unit 31 includes a keyboard and a mouse, and receives operation information from the user. For example, the user can input search conditions for searching for employees by operating the operation unit 31.

The storage unit 32 includes a ROM (Read Only Memory), a RAM (Random Access Memory), a hard disk, and the like, stores various programs and data, and functions as a work area.
The storage unit 32 stores the search condition (for example, an SQL command) when the employee information DB 11 is searched under the specified search condition.
In addition, the storage unit 32 includes a search condition match table 321. The search condition match table 321 is a table for temporarily storing employee information that matches a specified search condition in an employee search display process described later. The search condition match table 321 has substantially the same data structure as the employee information DB 11 as shown in FIG.
Note that the search condition match table 321 will be described assuming that employee information is stored in order from top to bottom in FIG. For example, FIG. 5 shows a search condition matching table 321 in which a total of 15 records with IDs “0004”, “0005”, “0009”... “0025” are searched, and these records are stored in order.

  The control unit 33 controls the operation of the entire terminal device 30 by executing the program stored in the storage unit 32.

  The communication control unit 34 is connected to the LAN 20 and transmits / receives various information to / from the DB server 10. For example, the communication control unit 34 acquires employee information that meets the search condition from the DB server 10 via the LAN 20 under the control of the control unit 33.

  The display unit 35 is composed of a liquid crystal display or the like, and displays various information under the control of the control unit 33. For example, the display unit 35 displays a screen (search result display screen) for displaying a list of employee information that matches the search condition.

(Employee search display process)
Next, a process (employee search display process) for searching employee information stored in the DB server 10 and displaying employee information that matches the search condition will be described.
It is assumed that the employee information DB 11 of the DB server 10 stores employee information for 25 people as shown in FIG.
The maximum number of records that can be displayed on the search result display screen at once (the number that can be displayed) is 5.

The user operates the operation unit 31 to display a screen (employee search screen) for searching for employees as shown in FIG. Subsequently, the user operates the operation unit 31 to input a predetermined search condition on the employee search screen and presses a “search” button.
And the control part 33 of the terminal device 30 will start the employee search display process as shown in FIG. 4, if the input information from the said user is received.

  First, the control unit 33 acquires employee information that matches a predetermined search condition indicated by input information from the user from the employee information DB 11 of the DB server 10 (step S101). This process may be performed, for example, by creating and executing SQL (Structured Query Language) for acquiring employee information that matches the search conditions.

Subsequently, the control unit 33 stores the employee information acquired in step S101 in the search condition match table 321 (step S102). If there is employee information already stored in the search condition match table 321, the stored information is erased and newly stored.
For example, when searching with the search condition shown in FIG. 3 (affiliation “Human Resources Department”), as shown in FIG. 5, the employee information of the employee whose affiliation is “HR Department” is stored in the search condition match table 321. They are stored in the same order as the order stored in the information DB 11.

Returning to FIG. 4, the control unit 33 subsequently obtains the total number of pages (total number of pages) to be displayed on the search result display screen (step S103).
Specifically, the number of records in the search condition match table 321 divided by the maximum number of records that can be displayed on the search result display screen at one time (on one page) (hereinafter referred to as the number of displayable items) (however, If it is not divisible, it is incremented) as the total number of pages.
For example, as shown in FIG. 5, when a total of 15 records are stored in the search condition match table 321, the maximum number of data that can be displayed on one page is 5. By processing, the total number of pages is obtained as 3.

Returning to FIG. 4, the control unit 33 subsequently acquires employee information for the number of items that can be displayed on one page in order from the first record stored in the search condition match table 321 (step S <b> 104).
For example, as shown in FIG. 5, when employee information is stored in the search condition match table 321, employee numbers “0004”, “0005”, “0009”, “0010”, “0011” are sequentially executed from the top by the processing in step S104. Records for the number of items that can be displayed (5 items).

  Returning to FIG. 4, the control unit 33 then displays the employee information acquired in step S104 and the total number of pages obtained in step S103 on an employee information list screen as shown in FIG. 6A (step S105). .

  Subsequently, the control unit 33 saves the search conditions used to obtain the search results displayed on the employee information list screen in the storage unit 32 (step S106). This is because, as will be described later, every time the display page is switched, the search is performed again using this search condition. Instead of storing the search condition itself, the executed SQL or the like may be stored.

Here, the employee information list screen will be described with reference to FIG.
The employee information staff list screen has a page information display area P1 for displaying information related to pages, an employee information display area P2, and a page switching button display area P3 in which various buttons for switching employee information to be displayed are arranged.

In the page information display area P1, “page number to be displayed / total number of pages” is displayed.
In the employee information display area P2, employee information corresponding to the page number to be displayed among the employee information that matches the search condition is displayed in a list.

In the page switching button display area P3, various buttons for switching the displayed page, that is, a “previous page” button P31, a “next page” button P32, a “sort” button P33, and “move to page”. A button P34 and a “latest display” button P35 are arranged.
The “Previous page” button P31 is a button for displaying the page immediately before the currently displayed page.
The “next page” button P32 is a button for displaying a page immediately after the currently displayed page.
The “sort” button P33 is a button for sorting the currently displayed records in descending order of ID.
The “move to page” button P34 is a button for moving to the page specified in the input field IN.
The “latest display” button P35 is a button for displaying the latest search results.

  Next, a process of switching the display by pressing various buttons arranged in the page switching button display area P3 from a state where one page of employee information is displayed in a list on the employee information list screen will be described.

(Previous page display process)
While the employee information is displayed in ascending order of ID in the employee information display area P2 of the employee information list screen, the user presses the “Previous Page” button P31 in the page switching button display area P3 and is currently displayed. Processing for displaying the page immediately before the page (previous page display processing) will be described with reference to FIG.

First, when receiving information indicating that the “Previous page” button P31 has been pressed, the control unit 33 starts the previous page display process shown in the flowchart of FIG. 7, and first displays a list on the current employee information list screen. The identification information of the current record is acquired in the display order (that is, the ascending order of ID) (step S201).
For example, when the employee information list screen is displayed as shown in FIG. 6A, the employee IDs “0004”, “0005”, “0009”, “0010”, “0011” are obtained by the processing in step S201. In order.

  Returning to FIG. 7, the control unit 33 reads the search condition for searching the currently displayed employee information from the storage unit 32, searches the employee information DB 11 again with the read search condition, and stores the employee information that matches the search condition. Is acquired (step S202).

  If no employee information that matches the search condition can be acquired in step S202 (step S203; No), the control unit 33 displays a display of zero search results as shown in FIG. (Step S204), and the process ends.

  When the employee information can be acquired in step S202 (step S203; Yes), the control unit 33 once deletes the stored information in the search condition match table 321 and displays the employee information acquired this time in the display order (that is, ascending order of ID). Store (step S205).

  Next, the control unit 33 determines whether or not the IDs acquired in the display order (that is, the ascending order of IDs) in step S201 are stored in the search condition match table 321 one by one in the acquired order. When a certain ID is found, the record having that ID is specified as the top record of the page (step S206). That is, the ID displayed at the top is matched with the ID stored in the updated search condition match table 321. If it is found, the record is set as the top record of the page. The ID is matched with the ID stored in the updated search match table 321. Thereafter, the same operation is repeated.

Subsequently, the control unit 33 obtains page information (page number to be displayed and total number of pages) of the display page from information stored in the search condition match table 321 (step S207).
A general method for obtaining page information will be described with reference to FIG.
First, the control unit 33 groups the records above the first record (the nth record in the figure) specified in step S206 upward by the number of displayable pages (5 records) in order from the bottom. Next, the control unit 33 groups the records below the first record in the downward direction by the number of displayable pages (5 records) in order from the top. After the grouping is completed, the control unit 33 assigns consecutive page numbers (1, 2, 3,...) In order from the first group. And, among the allocated page numbers, the maximum page number is the total number of pages (m in the figure), and the number (k in the figure) assigned to the group that includes the record one record higher than the first record is displayed Page number.

Subsequently, the control unit 33 specifies a record to be displayed in the employee information display area P2 (step S208).
Specifically, a record included in the group to which the page number of the display target obtained in step S207 is assigned is set as a display target. In the example of FIG. 8, the employee information display of the records (“n-5th record” to “n−1th record”) included in the group to which the page number “k” is assigned by the process of step S208. It is assumed that the record is displayed in the area P2.

The control unit 33 creates an employee information list screen for displaying the page information obtained in step S207 in the page information display area P1 and the record specified in step S208 in the employee information display area P2, and displays them on the display unit 35. (Step S209).
This completes the previous page display process.

Next, the “previous page display process” will be described with a specific example.
For example, it is assumed that employee information is stored in the search condition match table 321 as shown in FIG. In addition, it is assumed that the records displayed in the employee information display area P2 at this time are records corresponding to IDs “0012” to “0019” surrounded by a thick frame. Also, it is assumed that, among the displayed records, records with IDs “0012” and “0015” have been deleted by other users after display. Assume that the user presses the “Previous page” button P31 in such a state.
In this case, as shown in FIG. 9B, “0016”, which is the next record after the deleted record, is identified as the first record in step S206. The records above the top record are grouped from bottom to top, the records below the top record are grouped by the number of displayable pages (5 records) from top to bottom, and page numbers are assigned to each group in order from the top. Then, the page number “1” assigned to the group to which the record “0011” immediately above the first record belongs is set to the page number to be displayed, and the record surrounded by the thick frame belonging to the group (that is, the ID “0004”). ”To“ 0011 ”) are records displayed in the employee information display area P2 after the“ Previous page ”button P31 is pressed. The maximum page number “3” among the page numbers assigned to the group is the total number of pages.

(Next page display process)
While the employee information is displayed in ascending order of ID in the employee information display area P2 of the employee information list screen, the user presses the “next page” button P32 in the page switching button display area P3 and is currently displayed. Processing for displaying the next page of the page (next page display processing) will be described with reference to FIG.

When the control unit 33 receives the information indicating that the “next page” button P32 has been pressed, the control unit 33 starts the next page display process shown in FIG. 10. First, the control unit 33 displays the list of records currently displayed on the employee information list screen. Identification information is acquired in the reverse order of display (that is, descending order of ID) (step S301).
For example, when the employee information list screen is displayed as shown in FIG. 6A, the employee IDs “0011”, “0010”, “0009”, “0005”, “0004” are obtained through the processing in step S301. In order.

  Returning to FIG. 10, the control unit 33 reads the search condition for searching the currently displayed employee information from the storage unit 32, searches the employee information DB 11 again with the read search condition, and stores the employee information that matches the search condition. Is acquired (step S302).

  If no employee information that matches the search condition can be acquired in step S302 (step S303; No), the control unit 33 displays a display of 0 search results as shown in FIG. (Step S304), and the process ends.

  When the employee information can be acquired in step S302 (step S303; Yes), the control unit 33 temporarily deletes the stored information in the search condition match table 321 and displays the employee information acquired this time in the display order (that is, the ascending order of ID). Store (step S305).

  Next, the control unit 33 determines whether the IDs acquired in the reverse order of display (that is, the descending order of the IDs) in step S301 are stored in the search condition match table 321 one by one in the acquired order. At the time when the assigned ID is found, the record having the ID is specified as the end record of the page (step S306). That is, the ID displayed at the end is matched with the ID stored in the updated search condition match table 321, and if found, that record is set as the end record of the page, and if not found, it is displayed second from the end. The registered ID is matched with the ID stored in the updated search match table 321. Thereafter, the same operation is repeated.

Subsequently, the control unit 33 obtains page information (page number to be displayed and the total number of pages) of the display page from information stored in the search condition match table 321 (step S307).
A general method for obtaining page information will be described with reference to FIG.
First, the control unit 33 groups the records below the end record (the nth record in the figure) specified in step S306 downward by the number of displayable pages (5 records) in order from the top. Next, the control unit 33 groups the records that are equal to or more than the last record in the upward direction by the number of displayable pages (5 records) in order from the bottom. After completing the grouping, the control unit 33 assigns consecutive page numbers (1, 2, 3,...) In order from the first group. And, among the allocated page numbers, the maximum page number is the total number of pages (m in the figure), and the number (k in the figure) assigned to the group that includes the record immediately below the last record is displayed Page number.

Subsequently, the control unit 33 specifies a record to be displayed in the employee information display area P2 (step S308).
Specifically, a record included in the group to which the page number of the display target obtained in step S307 is assigned is set as a display target. In the example of FIG. 11, records (“n + 1th record” to “n + 5th record”) included in the group to which the page number “k” is assigned are displayed in the employee information display area P2 by the process of step S308. The record to be displayed.

The control unit 33 creates an employee information list screen that displays the page information obtained in step S307 in the page information display area P1 and the record specified in step S308 in the employee information display area P2, and displays them on the display unit 35. (Step S309).
The next page display process is thus completed.

Next, the “next page display process” will be described with a specific example.
For example, it is assumed that employee information is stored in the search condition match table 321 as shown in FIG. In addition, it is assumed that the records displayed in the employee information display area P2 at this time are records corresponding to IDs “0012” to “0019” surrounded by a thick frame. Further, it is assumed that among the displayed records, records with IDs “0017” and “0019” have been deleted by other users. Assume that the user presses the “next page” button P32 in such a state.
In this case, as shown in FIG. 12B, “0016”, which is the record before the deleted record, is specified as the last record in step S306. The records below the end record are grouped by the number of displayable pages (5 records) from the top to the bottom and the records above the end record from the bottom to the top, and page numbers are assigned to each group in order from the top. . Then, the page number “3” assigned to the group to which the record “0020” immediately below the last record belongs is set as the page number to be displayed, and the record surrounded by the thick frame belonging to the group (that is, the ID “0020”). ”To“ 0025 ”) are records displayed in the employee information display area P2 after the“ next page ”button P32 is pressed. The maximum page number “3” among the page numbers assigned to the group is the total number of pages.

(Specified page display processing)
In a state where employee information is displayed in ascending order of ID in the employee information display area P2 of the employee information list screen, the user presses the “move to page” button P34 in the page switching button display area P3, and the input field IN A process for displaying a page designated in the above (designated page display process) will be described with reference to FIG.

  In this case, the user inputs the page number to jump to the input field IN and presses the “move to page” button 34. Then, the control unit 33 starts the designated page display process shown in FIG. 13. First, the search condition for searching the currently displayed employee information is read from the storage unit 32, and the employee information DB 11 is read again with the read search condition. The employee information that matches the search condition is acquired by searching (step S401).

  As a result of the search in step S401, when no employee information that matches the search condition has been acquired (step S402; No), the control unit 33 returns 0 search results as shown in FIG. Display is performed (step S403), and the process is terminated.

  When employee information can be acquired in step S401 (step S402; Yes), the control unit 33 temporarily deletes the information stored in the search condition match table 321 and displays the employee information acquired this time in the display order (that is, IDs). (In ascending order) (step S404).

Subsequently, the control unit 33 obtains the total number of pages for display from the information stored in the search condition match table 321 (step S405).
A specific method for obtaining the total number of pages will be described with reference to FIG.
First, the control unit 33 groups the records in the search condition match table 321 in order from the top in the downward direction by the number of displayable items per page (5 records). Then, after the grouping is completed, the control unit 33 assigns consecutive page numbers (1, 2, 3,...) In order from the first group. And the control part 33 makes the largest number among the allocated page numbers the total number of pages (m in a figure).

Subsequently, the control unit 33 specifies a record to be displayed in the employee information display area P2 (step S406).
Specifically, the record included in the group assigned the same page number as the number input by the user in the input field IN is specified. For example, if “2” is entered in the input field IN, the “sixth record included in the group to which the group number“ 2 ”is assigned is obtained by the processing in step S406 as shown in the example of FIG. ”To“ 10th record ”are specified as records to be displayed in the employee information display area P2.

Then, the control unit 33 displays in the page information display area P1 the total number of pages obtained in step S405 and the page number to be displayed, which is the number input in the input field IN, and displays the step in the employee information display area P2. An employee information list screen for displaying the record specified in S406 is created and displayed on the display unit 35 (step S407).
Thus, the designated page display process ends.

Next, the “designated page display process” will be described with a specific example.
For example, in the first search process, employee information is stored in the search condition match table 321 as shown in FIG. 15A, and records corresponding to IDs “0020” to “0025” surrounded by a thick frame are employees. It is assumed that it is displayed in the information display area P2. Of the displayed records, records with IDs “0012” and “0015” are currently deleted by other users. In this state, it is assumed that the user inputs “2” in the input field IN and presses the “move to page” button.
In this case, as shown in FIG. 15B, the deleted records are excluded and the records are grouped in order from the top by the displayable number of one page (5 records), and a page number is assigned to each group. . Then, a record surrounded by a thick frame (that is, records with IDs “0016” to “0021”) belonging to the group to which the page number “2” input in the input field IN is assigned is moved to the “page. The record is displayed in the employee information display area P2 after the "" button is pressed. The total number of pages is the maximum page number “3” assigned to the group.

(Refresh processing)
While the employee information is displayed in ascending order of IDs in the employee information display area P2 of the employee information list screen, the user presses the “Refresh” button P35 in the page switching button display area P3 and is currently displayed. The process of displaying the page in the latest (the latest display process) will be described with reference to FIG.

First, when receiving information indicating that the “latest display” button P35 has been pressed, the control unit 33 displays the identification information of the records currently displayed in the list on the employee information list screen in the display order (that is, the descending order of the IDs). (Step S501).
For example, when the employee information list screen is displayed as shown in FIG. 6A, the employee IDs “0004”, “0005”, “0009”, “0010”, “0011” are obtained by the processing in step S501. In order.

  Subsequently, returning to FIG. 16, the control unit 33 reads the search condition for searching the currently displayed employee information from the storage unit 32, searches the employee information DB 11 again with the read search condition, and matches the search condition. Employee information is acquired (step S502).

  When no employee information that matches the search condition can be acquired in step S502 (step S503; No), the control unit 33 displays that the search result is 0 as shown in FIG. (Step S504), and the process ends.

  When the employee information can be acquired in step S502 (step S503; Yes), the control unit 33 temporarily deletes the stored information in the search condition match table 321 and displays the employee information acquired this time in the display order (that is, the ascending order of ID). Store (step S505).

  Next, the control unit 33 determines whether or not the IDs acquired in the display order (that is, the descending order of the IDs) in step S501 are stored in the search condition match table 321 one by one in the acquired order. When a certain ID is found, the record having that ID is specified as the first record (step S506).

Subsequently, the control unit 33 obtains page information (page number to be displayed and the total number of pages) of the display page from the information stored in the search condition match table 321 (step S507).
A general method for obtaining page information will be described with reference to FIG.
First, the control unit 33 groups the records above the first record (the nth record in the figure) specified in step S506 upward by the number of displayable pages (5 records) in order from the bottom. Next, the control unit 33 groups the records below the first record in the downward direction by the number of displayable pages (5 records) in order from the top. After the grouping is completed, the control unit 33 assigns consecutive page numbers (1, 2, 3,...) In order from the first group. Of the allocated page numbers, the maximum page number is the total number of pages (m in the figure), and the number (k + 1 in the figure) allocated to the group including the first record is the display target page number.

Returning to FIG. 16, subsequently, the control unit 33 specifies a record to be displayed in the employee information display area P2 (step S508).
Specifically, a record included in the group to which the page number of the display target obtained in step S507 is assigned is set as a display target. In the example of FIG. 8, the records (“nth record” to “n + 4th record”) included in the group assigned the page number “k + 1” are displayed in the employee information display area P2 by the process of step S508. To record.

The control unit 33 creates an employee information list screen for displaying the page information obtained in step S507 in the page information display area P1 and the record specified in step S508 in the employee information display area P2, and displays them on the display unit 35. (Step S509).
This is the end of the latest display process.

Next, the “latest display process” will be described with a specific example.
For example, it is assumed that employee information is stored in the search condition match table 321 as shown in FIG. In addition, it is assumed that the records displayed in the employee information display area P2 at this time are records corresponding to IDs “0012” to “0019” surrounded by a thick frame. Also, it is assumed that among the displayed records, records with IDs “0012” and “0015” are currently deleted by other users. In such a state, it is assumed that the user presses the “Refresh” button P35.
In this case, as shown in FIG. 17B, “0016”, which is the next record after the deleted record, is identified as the first record in step S506. The records above the top record are grouped from bottom to top, the records below the top record are grouped by the number of displayable pages (5 records) from top to bottom, and page numbers are assigned to each group in order from the top. . Then, the page number “2” assigned to the group to which the first record “0016” belongs is the page number to be displayed, and the records surrounded by the thick frames belonging to the group (that is, IDs “0016” to “0021”). Record) is a record displayed in the employee information display area P2 after the “latest display” button P31 is pressed. The maximum page number “3” among the page numbers assigned to the group is the total number of pages.

(Sort processing)
In a state where employee information is displayed in the employee information display area P2 of the employee information list screen, the user presses the “sort” button P33 in the page switching button display area P3, and the displayed records are in ascending order of ID. Processing for sorting (sorting processing) will be described with reference to FIG.

First, when receiving information indicating that the “sort” button P33 has been pressed, the control unit 33 obtains identification information of the record that is the head of the display among the records currently displayed in the employee information display area P2. (Step S601).
For example, when it is displayed in the employee information display area P2 as shown in FIG. 6A, the employee ID “0004” is acquired by the process of step S601.

  Returning to FIG. 18, subsequently, the control unit 33 reads the search condition for searching the currently displayed employee information from the storage unit 32, searches the employee information DB 11 again with the read search condition, and matches the search condition. Employee information to be acquired is acquired (step S602).

  If no employee information that matches the search condition can be acquired in step S602 (step S603; No), the control unit 33 displays a display of zero search results as shown in FIG. (Step S604), and the process ends.

When employee information can be acquired in step S602 (step S603; Yes), the control unit 33 sorts the employee information acquired in step S602 in ascending order of the IDs (step S605).
Note that this sort processing may be performed using a known sort method such as bubble sort or shaker sort.

  Then, the control unit 33 temporarily deletes the stored information in the search condition match table 321 and stores the employee information sorted in step S605 in the sorted order (that is, descending ID) (step S606).

  Subsequently, the control unit 33 determines whether or not the record having the identification information acquired in step S601 is stored in the search condition match table 321 (step S607).

When determining that the record is stored (step S607; Yes), the control unit 33 identifies the record as the first record (step S608), and proceeds to step S610.
If it is determined that no record is stored (step S607; No), the control unit 33 identifies the record stored in the search condition match table 321 next to that record as the first record (step S609), and step S610. Move on.

In step S610, the control unit 33 obtains page information (page number and total number of pages to be displayed) of a display page from information stored in the search condition match table 321.
A general method for obtaining page information will be described with reference to FIG.
First, the control unit 33 groups the records in the search condition match table 321 in order from the top by the number of displayable pages (5 records). Then, after the grouping is completed, the control unit 33 assigns consecutive page numbers (1, 2, 3,...) Sequentially from the first group. Of the allocated page numbers, the largest page number is set as the total number of pages (m in the figure). Further, the control unit 33 sets the page number (k + 1 in the figure) allocated to the group including the first record (nth record in the figure) specified in step S608 or S609 as the page number to be displayed.

Returning to FIG. 18, subsequently, the control unit 33 specifies a record to be displayed in the employee information display area P2 (step S611).
Specifically, a record included in the group to which the page number of the display target obtained in step S610 is assigned is set as a display target. In the example of FIG. 19, by the processing of step S611, records included in the group to which the page number k + 1 is assigned ("nth record" to "n + 4th record") are displayed in the employee information display area P2. Identified as a record for display.

Then, the control unit 33 creates and displays an employee information list screen in which the page information obtained in step S610 in the page information display area P1 and the record specified in step S611 in the employee information display area P2 are displayed. It is displayed on the part 35 (step S612).
This completes the sort process.

Next, the “sort process” will be described with a specific example.
For example, it is assumed that employee information is stored in the search condition match table 321 as shown in FIG. It is assumed that the record displayed in the employee information display area P2 at this time is a record corresponding to the IDs “0015”, “0021”, “0022”, and “0023” surrounded by a thick frame. In addition, it is assumed that the records with IDs “0012” and “0015” stored in the search condition match table 321 at the time of the display are currently deleted by other users. Assume that the user presses the “sort” button P33 in such a state.
In this case, as shown in FIG. 20B, among the employee information sorted in the order of ID, “0016” that is the next record after the first record “0015” of the display before the “sort” button P33 is pressed is newly added. Specify as the first record. The sorted records are grouped from the top by the number of displayable pages (5 records) per page, and a page number is assigned to each group. Then, the page number “2” assigned to the group including the first record “0016” is displayed as the page number to be displayed, and the records surrounded by the thick frame belonging to the group (ie, ID “0016” to “0021”) are displayed. Records are displayed in the employee information display area P2 after the “sort” button P33 is pressed. The maximum page number “3” among the page numbers assigned to the group is the total number of pages.

As described above, in the present embodiment, when the page to be displayed is switched, data is obtained by searching again under the same conditions.
Further, according to various processes, pages are divided based on the top data or the last data of the currently displayed data. For this reason, there is no flaw between the displayed data before and after switching the displayed page. Therefore, an appropriate display that does not confuse the user is possible.

In addition, this invention is not limited to the said embodiment, A various deformation | transformation and application are possible.
For example, in the present embodiment, the present invention is applied to search for employee information. However, the present invention is not limited to this, and data to be searched is arbitrary. Further, the present invention is not limited to a search system, and the present invention can be applied to any system that can update data being displayed while data is being searched and displayed.

  Further, in the previous page display process, the next page display process, the designated page display process, and the latest display process of the present embodiment, the display order of display in the employee information display area P2 is descending ID. The present invention is not limited to this, and each of the above processes may be applied in the same manner even when the IDs are displayed in the ascending order, the employee names are displayed in order, or in the order of birthday.

  In addition, as the sorting process of the present embodiment, the process of sorting in ascending order of ID has been described, but the sorting of the present embodiment is similarly applied to the process of sorting in descending order of ID, the process of sorting in order of employee name, and the like Processing may be applied.

Note that the page segmentation method is not limited to the above example.
For example, when “move” to the page after the current display page in the “specified page display process”, the page is divided based on the end record as in the “next page display process”. When “moving” to the previous page, the page may be divided based on the first record as in the “previous page display process”, and the corresponding page may be displayed.
Further, pages may be divided based on the first record in the “next page display process”, and pages may be divided based on the last record in the “previous page display process”, and the corresponding pages may be displayed.

  Further, the terminal device 30 according to the above-described embodiment can be configured by a general-purpose device as well as realized by a dedicated device. In this case, it is possible to cause the general-purpose device to function as the terminal device 30 by installing a program for realizing each of the processes in the general-purpose device and executing the program in cooperation with an OS (Operation System).

  Further, the method for providing the program for realizing the above-described functions is arbitrary, and the program can be provided by being stored in a recording medium such as a CD-ROM, or via a communication medium such as the Internet. .

It is a figure which shows the structure of the database system which concerns on this Embodiment. It is a figure which shows the structure of employee information DB. It is a figure which shows the example of an employee search screen. It is a flowchart for demonstrating operation | movement of an employee search display process. It is a figure which shows the structure of a search condition agreement table. It is a figure which shows the example of an employee information list screen. It is a flowchart for demonstrating operation | movement of a previous page display process. It is a figure for demonstrating the method for calculating | requiring page information in a previous page display process or the latest display process. It is a figure for demonstrating the previous page display process concretely. It is a flowchart for demonstrating operation | movement of a next page display process. It is a figure for demonstrating the method for calculating | requiring page information in a next page display process. It is a figure for demonstrating the next page display process concretely. It is a flowchart for demonstrating operation | movement of a designated page display process. It is a figure for demonstrating the method for calculating | requiring page information in a designated page display process. It is a figure for demonstrating a specific page display process concretely. It is a flowchart for demonstrating operation | movement of the latest display process. It is a figure for demonstrating the latest display process concretely. It is a flowchart for demonstrating operation | movement of a sort process. It is a figure for demonstrating the method for calculating | requiring page information in a sort process. It is a figure for demonstrating a sort process concretely.

Explanation of symbols

10 DB server 11 Employee information DB
20 LAN
30 terminal device 31 operation unit 32 storage unit 321 search condition match table 33 control unit 34 communication control unit 35 display unit

Claims (6)

Data acquisition means for searching and acquiring data that matches a predetermined search condition;
List display means for displaying a list of data acquired by the data acquisition means in units of pages;
Page switching instruction means for instructing switching of data pages displayed by the list display means;
In response to the page switching instruction by the page switching instruction means, the data acquisition means re-searches and acquires data that matches the predetermined search condition, and from among the acquired data again to the switching destination page Control means for extracting corresponding data and displaying the list on the list display means;
A display control apparatus comprising: The data acquisition means searches and acquires data stored in a predetermined database,
The database is capable of accessing and updating the data even when the data retrieved by the list display means is displayed as a list.
The display control apparatus according to claim 1, wherein: The control means determines whether or not the data displayed as a list by the list display means is included in the data acquired again by the data acquisition means in order from the top, and first determines that it is included. Extract the data corresponding to the page to switch to based on the data
The display control apparatus according to claim 1, wherein the display control apparatus is a display control apparatus. The control means determines whether or not the data displayed as a list by the list display means is included in the data acquired again by the data acquisition means in order from the end, and first determines that it is included. Extract the data corresponding to the page to switch to based on the data
The display control apparatus according to claim 1, wherein the display control apparatus is a display control apparatus. A data acquisition step of searching and acquiring data that matches a predetermined search condition;
A list display step of displaying a list of data acquired in the data acquisition step in units of pages;
A page switching instruction step for instructing switching of a page of data displayed in the list display step;
In response to the page switching instruction in the page switching instruction step, the data acquisition step re-searches and acquires data that matches the predetermined search condition, and from among the acquired data again to the switching destination page A control step of extracting corresponding data and displaying the list in the list display step;
A display control method comprising: Computer
Data acquisition means for searching and acquiring data that matches a predetermined search condition;
List display means for displaying a list of data acquired by the data acquisition means in units of pages;
Page switching instruction means for instructing switching of data pages displayed by the list display means;
In response to the page switching instruction by the page switching instruction means, the data acquisition means re-searches and acquires data that matches the predetermined search condition, and from among the acquired data again to the switching destination page Control means for extracting corresponding data and displaying the list on the list display means;
Program to make it function.

Images