SSH分页

最新推荐文章于 2020-11-14 21:56:51 发布

ITCKY

最新推荐文章于 2020-11-14 21:56:51 发布

阅读量185

点赞数 1

分类专栏： Java 文章标签： Java 分页

本文链接：https://blog.csdn.net/cnmndyri/article/details/88982836

版权

Java 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

Struts2配置文件
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.i18n.encoding" value="UTF-8"></constant>

	<package name="FenYe" extends="struts-default">
		
		
		<!-- 获取商品详情信息 -->
		<action name="fenye" class="fenYeAction" method="Fenye">
			<result name="list">Fenye.jsp</result>
		</action>
		
	</package>

</struts>

hibernate配置文件
hibernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
	"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
	
<hibernate-configuration>
	<session-factory>
	
		<!-- hibernate方言 -->
		<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
		
		<!-- 是否打印sql语句 -->
		<property name="show_sql">true</property>
		
		<!-- 启动时更新数据库 -->
		<property name="hbm2ddl.auto">update</property>
	
		
	</session-factory>

</hibernate-configuration>

spring配置文件
applicationContext.xml

<!-- 配置数据源 -->
	<bean id="datasource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
		<property name="url" value="jdbc:mysql://localhost:3306/fenye"></property>
		<property name="username" value="root"></property>
		<property name="password" value="admin"></property>
	</bean> 
	
	<!-- 配置sessionFactory -->
	<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
		<property name="dataSource" ref="datasource"></property>
		<!-- hibernate配置文件 -->
		<property name="configLocation" value="classpath:hibernate.cfg.xml"></property>
		
		<!-- 扫描的hibernate注解类 -->
		<property name="packagesToScan">
			<list>
				<value>com.cky.entity</value>
			</list>
		</property>
		
	</bean>
	
	<!-- 配置事务管理器 -->
	<bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
	 	<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	
	<!-- 配置事务 -->
	<tx:advice id="txAdvie" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="add*" propagation="REQUIRED"/>
			<tx:method name="save*" propagation="REQUIRED"/>
			<tx:method name="get*" read-only="true"/>
			<tx:method name="*" propagation="REQUIRED"/>
		</tx:attributes>
	</tx:advice>
	
	<!-- 配置切面 -->	
	<aop:config>
		<aop:pointcut expression="execution(* com.cky.service.*.*(..))" id="pointcut"/>
		<aop:advisor advice-ref="txAdvie" pointcut-ref="pointcut"/>
	</aop:config>
	
	<!-- 设置自动扫描的包 -->
	<context:component-scan base-package="com.cky"></context:component-scan>

实体
FenYe

@Entity
@Table(name="fy")
public class FenYe {
	@Id
	@GeneratedValue(strategy=GenerationType.IDENTITY)
	private int id;
	@Column(name="name")
	private String name;
	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;
	}
	

}

Page

/**
 * 
 * @author Administrator
 *
 */
public class Page {

	private int startPage; 
	private int pageSize; 
	private int currentPage;
	
	public Page(int currentPage,int pageSize) {
		this.currentPage = currentPage;
		this.pageSize = pageSize;
	}
	
	public int getStartPage() {
		
		return (currentPage-1)*pageSize;
		
	}
	public void setStartPage(int startPage) {
		this.startPage = startPage;
	}
	public int getPageSize() {
		return pageSize;
	}
	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}
	public int getCurrentPage() {
		return currentPage;
	}
	public void setCurrentPage(int currentPage) {
		this.currentPage = currentPage;
	}
	
}

算法部分，创建一个帮助类PageUtil

	/**
	 * 
	 * @param url 请求路径
	 * @param para 查询参数
	 * @param pageCount 显示多少页
	 * @param currentPage  当前页
	 * @param pageSize 页大小
	 * @param totalNum 总记录
	 * @return
	 */
	public static String getPageInfo(String url,String param,int pageCount,int currentPage,int pageSize,long totalNum) {
	    //总页数    /  %
		long totalPage = totalNum%pageSize == 0 ? totalNum/pageSize : totalNum/pageSize + 1;
		
		StringBuffer pageSB = new StringBuffer();
		
		if(totalPage == 0) {
			
			pageSB.append("没有查询到数据");
			
		}else {
			//共多少页
			pageSB.append("共"+totalPage+"页&nbsp;&nbsp;");
			
			//首页
			pageSB.append("<a href='"+url+"?page=1"+param+"'>首页&nbsp;</a>");
			//上一页
			if(currentPage > 1) {
				pageSB.append("<a href='"+url+"?page="+(currentPage-1)+param+"'>&nbsp;上一页&nbsp;</a>");	
			}

			//如果没有5页数据
			if(totalPage <= pageCount ) {
				for(long i=1;i<= totalPage;i++) {
					pageSB.append("<a href='"+url+"?page="+i+param+"'>&nbsp;"+i+"&nbsp;</a>");	
				}
			}
			
			//超过5页数据
			if(totalPage > pageCount) {
				
				if(currentPage <= pageCount/2+1) {
					for(int i=1;i<=pageCount;i++) {
						
						if(i == currentPage) {
							pageSB.append("<a style='color:red' href='"+url+"?page="+i+param+"'>&nbsp;"+i+"&nbsp;</a>");
						}else {
							pageSB.append("<a href='"+url+"?page="+i+param+"'>&nbsp;"+i+"&nbsp;</a>");	
						}
					}
				}
				
				if(currentPage > pageCount/2 + 1 && currentPage <= totalPage - pageCount/2) {
					
					for(int i=currentPage - pageCount/2;i <= currentPage+pageCount/2;i++) {
						if(i == currentPage) {
							pageSB.append("<a style='color:red' href='"+url+"?page="+i+param+"'>&nbsp;"+i+"&nbsp;</a>");
						}else {
							pageSB.append("<a href='"+url+"?page="+i+param+"'>&nbsp;"+i+"&nbsp;</a>");	
						}
					}
					
				}
				
				if(currentPage > totalPage - pageCount/2) {
					for(long i= totalPage-pageCount + 1;i<=totalPage;i++) {
						if(i == currentPage) {
							pageSB.append("<a style='color:red' href='"+url+"?page="+i+param+"'>&nbsp;"+i+"&nbsp;</a>");
						}else {
							pageSB.append("<a href='"+url+"?page="+i+param+"'>&nbsp;"+i+"&nbsp;</a>");	
						}
					}
				}	
				
			}
			
			//下一页
			//当前页 小于 总页数
			if(currentPage < totalPage) {
				pageSB.append("<a href='"+url+"?page="+(currentPage+1)+param+"'>&nbsp;下一页&nbsp;</a>");
			}
			
			//尾页
			pageSB.append("<a href='"+url+"?page="+totalPage+""+param+"'>&nbsp;尾页</a>");
		}
		
		
		return pageSB.toString();
	}

Dao层
FenYeDao

@Repository("fenYeDao")
public class FenYeDao {

	
	@Autowired
	private SessionFactory sessionFactory;
	
	public Session getSession() {
		
		return sessionFactory.getCurrentSession();
		
	}
	
	public List<FenYe> getListPage(String hql, List<Object> paraList, Page page) {
		// TODO Auto-generated method stub
		Query query = this.getSession().createQuery(hql);
		
		if(null != paraList && paraList.size() > 0) {
			for(int i=0;i<paraList.size();i++) {
				query.setParameter(i, paraList.get(i));
			}
		}
		
		return query.setFirstResult(page.getStartPage()).setMaxResults(page.getPageSize()).list();
	}
	
}

action层
FenYeAction

@Controller("fenYeAction")
@Scope(value="prototype")
public class FenYeAction implements ServletRequestAware {

	@Resource(name="fenYeService")
	private FenYeService fenYeService;
	private FenYe fenYe;
	public FenYe getFenYe() {
		return fenYe;
	}
	public void setFenYe(FenYe fenYe) {
		this.fenYe = fenYe;
	}

	private int page = 1;
	public int getPage() {
		return page;
	}
	public void setPage(int page) {
		this.page = page;
	}
		
		public String Fenye() throws UnsupportedEncodingException {
	
			List<FenYe> productList = fenYeService.getProductListPage(fenYe,new Page(page,8));
			
			//分页查询参数
			StringBuffer paramSB = new StringBuffer();
			
			
			String pageCode = PageUtil.getPageInfo("fenye", paramSB.toString(), 5, page, 8, 10);
			
			
			request.setAttribute("productList", productList);
			
			request.setAttribute("pageCode", pageCode);
			
			return "list";
			
		}
	
	private HttpServletRequest request;
	@Override
	public void setServletRequest(HttpServletRequest arg0) {
		// TODO Auto-generated method stub
		this.request = arg0;
	}

}

页面代码

index.jsp
<%
	response.sendRedirect(request.getContextPath()+"/fenye.action");
%>

Fenye.jsp
<table border="1">
				
				<tr>
				<td>测试</td>
				<td>测试</td>
				</tr>
				
				<c:forEach items="${productList}" var="product">
					<!-- <li> -->
				<tr>
				<td>${product.id}</td>
				<td>${product.name }</td>
				
				</tr> 
					
				</c:forEach>
					<tr >
					<td colspan="2">${pageCode}</td>
					</tr>
					
			</table>

效果图

ITCKY

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SSH分页

Struts2配置文件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/...
复制链接

扫一扫