Struts2实现简单分页

最新推荐文章于 2016-12-11 23:38:47 发布

hoho_12

最新推荐文章于 2016-12-11 23:38:47 发布

阅读量1w

点赞数 3

分类专栏： Struts2 文章标签： java struts2.0 分页

本文链接：https://blog.csdn.net/hoho_12/article/details/51384881

版权

Struts2 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

Struts2+mysql实现简单分页

1.index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<a href='myaction?page=<%=2%>'>分页显示</a>
</body>
</html>

2.struts.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
	"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
	"http://struts.apache.org/dtds/struts-2.3.dtd">

<struts>
 <constant name="struts.enable.DynamicMethodInvocation" value="true" />
 <constant name="struts.devMode" value="true" />
 <constant name="struts.ui.theme" value="simple"/>
 <package name="default" namespace="/" extends="struts-default">
 	<action name="myaction" class="com.wxh.action.FenyeAction">
 		<result>/show.jsp</result>
 	</action> 
 </package>
</struts>

3.web.xml

 <filter>
        <filter-name>struts2</filter-name>
        <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
    </filter>

    <filter-mapping>
        <filter-name>struts2</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

4.FenyeAction.java

package com.wxh.action;

import java.util.*;
import com.wxh.bean.*;
import com.wxh.dao.*;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;

public class FenyeAction extends ActionSupport{
	private int page;

	public int getPage() {
		return page;
	}

	public void setPage(int page) {
		this.page = page;
	}
	public String execute() throws Exception{
		int current_page=getPage();
		ActionContext context=ActionContext.getContext();
		BooksDao booksDao=new BooksDao();
		List<Books> list=booksDao.find(current_page);
		int pages=booksDao.findCount();
		StringBuffer s=new StringBuffer();
		for(int i=1;i<pages;i++){
			if(i==current_page){
				s.append("["+i+"]");
			}
			else{
				s.append("<a href='myaction?page="+i+"'>"+i+"</a>");
			}
		}
		context.put("list", list);
		context.put("s",s);		
		return "success";		
	}
}

5.Books.java

package com.wxh.bean;

public class Books {
	public static final int  PAGE_SIZE=2;
	private int id;
	private String name;
	private double price;
	private int bookCount;
	private String author;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public double getPrice() {
		return price;
	}
	public void setPrice(double price) {
		this.price = price;
	}
	public int getBookCount() {
		return bookCount;
	}
	public void setBookCount(int bookCount) {
		this.bookCount = bookCount;
	}
	public String getAuthor() {
		return author;
	}
	public void setAuthor(String author) {
		this.author = author;
	}
	
}

6.BooksDao.java

package com.wxh.dao;

import java.sql.*;
import java.util.*;
import com.wxh.bean.*;

public class BooksDao {
	public Connection getConnection(){
		Connection conn=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url="jdbc:mysql://127.0.0.1:3306/db_books";
			String username="root";
			String password="111";
			conn=DriverManager.getConnection(url,username,password);
			
		} catch (Exception e) {
			e.printStackTrace();
		}
		return  conn;
	}	


//分页查询方法

public List<Books> find(int page){
	List<Books> list=new ArrayList<Books>();
	Connection conn=getConnection();
	String sql="select * from tb_books order by id limit ?,?";
	try {
		PreparedStatement ps= conn.prepareStatement(sql);
		ps.setInt(1, (page-1)*Books.PAGE_SIZE);
		ps.setInt(2,Books.PAGE_SIZE );
		ResultSet rs=ps.executeQuery();
		while(rs.next()){
			Books p=new Books();
			p.setId(rs.getInt("id"));
			p.setName(rs.getString("name"));			
			p.setPrice(rs.getDouble("price"));
			p.setBookCount(rs.getInt("bookCount"));
			p.setAuthor(rs.getString("author"));			
			list.add(p);	
			}
		rs.close();
		ps.close();
		conn.close();		
		
	} catch (Exception e) {
		e.printStackTrace();
	}
		return list;	
	}
//获取商品信息的总记录数，用于计算商品信息的总页数
	public int findCount(){
		int  count=0;
		Connection  conn=getConnection();
		String sql="select count(*) from tb_books";
		try {
			Statement stmt=conn.createStatement();
			ResultSet rs=stmt.executeQuery(sql);
			if(rs.next()){
				count=rs.getInt(1);
			}
			rs.close();
			conn.close();
			
		} catch (Exception e) {
			// TODO: handle exception
		}
		return count;
	}
}

7.show.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="java.util.*,com.wxh.bean.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<table width="500" border="1" align="center" cellpadding="5" cellspacing="0">
  <tr>
    <td colspan="5" align="center" valign="middle"><strong><font color="#FF00CC" size="5">所有商品信息</font></strong></td>
  </tr>
  <tr align="center" valign="middle">
    <td><strong>ID</strong></td>
    <td><strong>书名</strong></td>
    <td><strong>价格</strong></td>
    <td><strong>数量</strong></td>
    <td><strong>出版社</strong></td>
  </tr>
 <%
  	List<Books> list=(List<Books>)request.getAttribute("list");
 	for(Books p:list){
 %>
  <tr align="center" valign="middle">
    <td><%=p.getId() %></td>
    <td><%=p.getName() %></td>
    <td><%=p.getPrice() %></td>
    <td><%=p.getBookCount()%></td>
    <td><%=p.getAuthor() %></td>
  </tr>
  <%} %>
  
  <tr align="center" valign="middle">
    <td colspan="5">
    	<%=request.getAttribute("s") %>    
    </td>
  </tr>
</table>
</body>
</html>

开发工具：eclipse+mysql+tomcat8

源码下载地址：

http://download.csdn.net/detail/hoho_12/9518112