How to implement pagination display in the Struts database application
[Related Links]
"JavaWebstudio Series Development Tools Visaul Struts Version" http://dev.9cbs.net/develop/Article/28/28871.shtm
"How to achieve the simplest Struts program" http://dev.9cbs.net/develop/Article/28/28946.shtm
"The implementation of the Struts drop-down box" http://dev.9cbs.net/develop/Article/28/28956.shtm
"The implementation of the Sruts radio box" http://dev.9cbs.net/develop/Article/29/29042.shtm
"Struts check box" http://dev.9cbs.net/develop/Article/29/29043.shtm
"The relationship between the Struts programs (1)" http://dev.9cbs.net/develop/Article/29/29131.shtm
The relationship between the "Struts program each file (2)" http://dev.9cbs.net/develop/Article/29/29133.shtm
"How to implement Struts database application (1)" http://dev.9cbs.net/develop/Article/29/29135.shtm
"How to implement Struts database applications (2)" http://dev.9cbs.net/develop/Article/29/29138.shtm
"How to implement pagination in the Struts database application"
"How to implement records, updates, and links in Struts database applications"
"How to implement records in the Struts database application"
"How to build a Struts database application with landing page"
"How to build a Struts database application with landing page and role"
The above example development environment: Java Web Studio Series Development Environment Visual Strutst version.
The latest JavaWebStudio download address: ftp: //210.36.64.79/kui
The above example source program download address: ftp: //210.36.64.79/kui
Key Tip: The setting of the JSPOUT property page is that this example is different from the steps in "How to Implement Struts Database Application", which is the core content of this example. We have to do just to select the "Auto Pagination" selection and enter the number of records per page in the settings of the JSPOUT property page.
[the goal]
The goal of this example is to implement a simple Struts database application. Its function is to read data from SQL Server 2000 and displayed in the output page in the form of a table.
Define a field named "Test" table:
Enter some test data:
[effect]
Enter the page (select "All Display"):
Output page:
Select page 4:
[background knowledge]
For Struts's paging display issues, generally do not use the
In addition, it is generally recommended not to adopt a dedicated paging label, mainly the distribution label standards of each company, the version is different, and the program is not easy to grasp. In this case, the form of a paging string can be freely changed by the program by the method implemented by a method of generating a paging string in a DAO file. Of course, in the development environment: Java Web Studio Series Development Environment Visual Strutst version, you only need to select the "Page" function, and the code is automatically completed. [step]
In addition to the steps in the Struts Database Application, this example is except for the Struts Database Application File Wizard, other steps are exactly the same, so the same steps details "How to implement the struts database application".
1. Open the Visual Struts development environment:
Start JavaWebStudio.exe files from the desktop JavaWebstudio fast or bin directory launched the Visual Struts development environment of JavaWebStudio.
2. Create an "empty Struts database application template application" application:
Select the menu "File" - "New" - "New Project", pop up the new project dialog, as shown in Figure 3-1:
Select "Empty Struts Database Application Template" in the dialog box, enter "DBAPP", Package (Package Name) and location in the project name, using the default value, and certainly can be changed as needed. Finally, click the "OK" button to complete the establishment of the new project.
In the root of the DBAPP project, you contain four subdirectories and two files, which is the standard structure of the JSPStudio project, it is best not to change their default names, otherwise there will be problems.
3. Use the Struts Database Application File Wizard to establish a new application:
At the JSPStudio file manager, click the right mouse button. In the pop-up menu, select "Struts Database Application File Wizard" into the Struts File Wizard dialog, or select the menu "file" - "New" - "Struts Database Application File Wizard" The Struts File Wizard dialog box.
Enter the "Hellword" file name in the filename input field under the Struts file wizard dialog jsp file, other files use the default settings.
(1) Enter the file name:
(2) Import the field information of the SQL statement and the data table from the data source (field name, and field type):
(3) Select the desired table "Test" from the data table.
It is important to note that the "Field information of the SQL statement and data table from the data source" and "Select the table from the data table" is merely generated to automatically generate SQL statements and read field information, here Complete can be manually entered directly, unrelated to the configuration of the database connection pool, below, and then configure the database connection pool separately.
Next, configure the database connection pool, and other property pages can be used by default, and the data connection configuration property page is directly turned directly.
(4) JSPOUT property page settings:
The setting of the JSPOUT property page is the only step in the "How to Implement Struts Database Application", which is the core content of this example. As can be seen from the above figure, we have to do it just to select the "Automatic Page" selection and enter the number of records per page. Since the test data record is less, only 3 records are displayed per page.
(5) Configure the database connection pool:
(Omit)
4, project file structure
Project directory structure analysis See "How to achieve the simplest struts program", this Struts database application file wizard automatically generates six files, where the web directory is input, output two JSP files, the SRC directory is a Java file. All program source code is automatically generated by the file wizard except that the file name is automatically generated, and all configurations are also automatically completed. Refresh the JSPStudio file manager, then discover two files automatically in the web directory, which is dblist.jsp and dblist.jsp, the former is an input JSP file, the latter is an output JSP file; SRC / EMPTYPRJ directory automatically generated Four files, are dblist action.java and dblist form.java, the former is an action file, the latter is a formaction file; there is a database operation file dblist.java and dblistdao.java, the former is used to save data table recorded Bean The latter is a database operation DAO file.
5, compile, start the server, run:
Compile the project and start the server separately by the button on the toolbar, then the dblist.jsp runs dblist.jsp by the "Run" button on the toolbar:
First try all the display functions, click the "All Display" button, if shown in the following figure:
Let's try to switch to page 5:
Through the above steps, the estimated target function is achieved.
[Program source code]
For program source code, this example is unique to the program source code in "How to Implement Struts Database Application" is a dblistout.jsp file. The difference is that in the form of the final plus, this line is used to display the paging string, the content is as follows:
Other files are identical, the next page is dblistout.jsp file source code:
<% @ page contenttype = "text / html; charset = GB2312" Language = "java"%>
<% @ Taglib URI = "/
Web
-
Inf
/struts-bean.tld "prefix =" bean "%>
<% @ Taglib URI = "/
Web
-
Inf
/struts-html.tld "prefix =" html "%>
<% @ Taglib URI = "/
Web
-
Inf
/struts-logic.tld "prefix =" Logic "%>
<% @ Taglib URI = "/
Web
-
Inf
/struts-template.tld "prefix =" Template "%>
