Maven--SSM使用PageHelper分页

最新推荐文章于 2024-03-05 22:43:19 发布

吴声子夜歌

最新推荐文章于 2024-03-05 22:43:19 发布

阅读量566

点赞数 2

分类专栏： Maven Mybatis web 文章标签： Maven SSM PageHelper

本文链接：https://blog.csdn.net/cold___play/article/details/103075747

版权

web 同时被 3 个专栏收录

41 篇文章 4 订阅

订阅专栏

Mybatis

35 篇文章 3 订阅

订阅专栏

Maven

19 篇文章 1 订阅

订阅专栏

SSM使用PageHelper分页

1.准备表和数据

CREATE TABLE `goods` (
  `goods_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品id',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `goods_type` varchar(255) DEFAULT NULL COMMENT '商品分类',
  `goods_price` double(255,0) DEFAULT NULL COMMENT '商品单价',
  `goods_count` int(11) DEFAULT NULL COMMENT '商品数量',
  PRIMARY KEY (`goods_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

在这里插入图片描述

2. 新建Maven工程
在这里插入图片描述

3. 配置
db.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/ssm?characterEncoding=utf8&useSSL=true
username=root
password=123456
initialSize=5
maxActive=20
maxIdle=20
minIdle=1
maxWait=60000

log4j.properties

### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.err
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
 
### direct messages to file mylog.log ###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=c:\mylog.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
 
### set log levels - for more verbose logging change 'info' to 'debug' ###
 
log4j.rootLogger=DEBUG, stdout

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans.xsd
         http://www.springframework.org/schema/context 
         http://www.springframework.org/schema/context/spring-context.xsd">
 
 
	<bean id="propertyConfigurer"
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="location" value="classpath:db.properties" />
	</bean>
	<bean id="dataSource"
		class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<property name="driverClassName" value="${driver}" />
		<property name="url" value="${url}" />
		<property name="username" value="${username}" />
		<property name="password" value="${password}" />
		<!-- 初始化连接大小 -->
		<property name="initialSize" value="${initialSize}"></property>
		<!-- 连接池最大数量 -->
		<property name="maxActive" value="${maxActive}"></property>
		<!-- 连接池最大空闲 -->
		<property name="maxIdle" value="${maxIdle}"></property>
		<!-- 连接池最小空闲 -->
		<property name="minIdle" value="${minIdle}"></property>
		<!-- 获取连接最大等待时间 -->
		<property name="maxWait" value="${maxWait}"></property>
	</bean>
 
	<!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->
	<bean id="sqlSessionFactory"
		class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<!-- 自动扫描mapping.xml文件 -->
		<property name="mapperLocations"
			value="classpath:pers/zhang/dao/*.xml"></property>
		<!-- 配置分页插件 -->
		<property name="plugins">
			<array>
				<bean class="com.github.pagehelper.PageHelper">
					<property name="properties">
						<value>
							dialect=mysql
							reasonable=true
						</value>
					</property>
				</bean>
			</array>
		</property>
	</bean>
	<!-- DAO接口所在包名，Spring会自动查找其下的类 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="pers.zhang.dao" />
	</bean>
	<!-- 事务管理-->
	<bean id="transactionManager"
		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource" />
	</bean>
</beans>

spring-mvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
         http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
         http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
         http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
 
 
	<context:component-scan base-package="pers.zhang" />
 
	<!-- 定义跳转的文件的前后缀 ，视图模式配置 -->
	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/jsp/" />
		<property name="suffix" value=".jsp" />
	</bean>
</beans>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
<!-- 1.配置加载Spring文件的监听器 -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
    <listener>
        <listener-class>
            org.springframework.web.context.ContextLoaderListener
        </listener-class>
    </listener>
    
    <!-- 2.编码过滤器 -->
    <filter>
        <filter-name>encoding</filter-name>
        <filter-class>
            org.springframework.web.filter.CharacterEncodingFilter
        </filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>encoding</filter-name>
        <url-pattern>/</url-pattern>
    </filter-mapping>
    
    <!-- 3.配置SpringMVC前端核心控制器 -->
    <servlet>
        <servlet-name>springmvc</servlet-name>
        <servlet-class>
            org.springframework.web.servlet.DispatcherServlet
        </servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring-mvc.xml</param-value>
        </init-param>
        
        <!-- 4.服务器启动后立即加载SpringMVC配置文件 -->
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>springmvc</servlet-name>
        <url-pattern>*.do</url-pattern>
    </servlet-mapping>
</web-app>

4. 编码
po:Goods.java

package pers.zhang.po;

public class Goods {

	private Integer goods_id;
	private String goods_name;
	private String goods_type;
	private Double goods_price;
	private Integer goods_count;
	
	public Integer getGoods_id() {
		return goods_id;
	}
	public void setGoods_id(Integer goods_id) {
		this.goods_id = goods_id;
	}
	public String getGoods_name() {
		return goods_name;
	}
	public void setGoods_name(String goods_name) {
		this.goods_name = goods_name;
	}
	public String getGoods_type() {
		return goods_type;
	}
	public void setGoods_type(String goods_type) {
		this.goods_type = goods_type;
	}
	public Double getGoods_price() {
		return goods_price;
	}
	public void setGoods_price(Double goods_price) {
		this.goods_price = goods_price;
	}
	public Integer getGoods_count() {
		return goods_count;
	}
	public void setGoods_count(Integer goods_count) {
		this.goods_count = goods_count;
	}
	
	
}

controller层：GoodsController.java

package pers.zhang.controller;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;

import pers.zhang.po.Goods;
import pers.zhang.service.GoodsService;

@Controller
public class GoodsController {
 
	@Resource(name="goodsService")
	private GoodsService goodsService;
	
	@RequestMapping("goods.do")
	  public String userList(@RequestParam(required=true,defaultValue="1") Integer page,
			  Model model){
	      //PageHelper.startPage(page, pageSize);这段代码表示，程序开始分页了，
		 //page默认值是1，pageSize默认是10，意思是从第1页开始，每页显示10条记录。
	      PageHelper.startPage(page, 3);
	      //查询
	      List<Goods> goods = goodsService.queryAll();
	      //创建PageInfo对象，保存查询出的结果，PageInfo是pageHelper中的对象
	      PageInfo<Goods> p=new PageInfo<Goods>(goods);
	      model.addAttribute("page", p);
	      model.addAttribute("goods", goods);
	      //返回页面
	      return "show";
	  }
}

service层：GoodsService.java

package pers.zhang.service;

import java.util.List;

import pers.zhang.po.Goods;


public interface GoodsService {

	List<Goods> queryAll();//查询所有
}

GoodsServiceImpl.java

package pers.zhang.service;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import pers.zhang.dao.GoodsDao;
import pers.zhang.po.Goods;

@Service("goodsService")
public class GoodsServiceImpl implements GoodsService{
 
	@Resource
	private GoodsDao goodsDao;
 
	public List<Goods> queryAll() {
		return goodsDao.queryAll();
	}
	
}

dao层：GoodsDao.java

package pers.zhang.dao;

import java.util.List;

import pers.zhang.po.Goods;

public interface GoodsDao {

	List<Goods> queryAll();
}

GoodsDao.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- namespace的值是dao层接口的全路径 -->
<mapper namespace="pers.zhang.dao.GoodsDao">
	<!-- 配置实体类与数据表映射关系 
		type：实体类全路径
		id：名字
	-->
	<resultMap type="pers.zhang.po.Goods" id="goodsMap">
		<!--
			id标签：配置唯一字段，一般是主键
				property：与实体类属性名一致
				column：与数据表字段名一致
		  -->
		<id property="goods_id" column="goods_id"/>
		<!-- result标签配置非唯一字段 -->
		<result property="goods_name" column="goods_name"/>
		<result property="goods_type" column="goods_type"/>
		<result property="goods_price" column="goods_price"/>
		<result property="goods_count" column="goods_count"/>
	</resultMap>
	<!-- 定义表中字段 -->
	<sql id="key">GOODS_ID,GOODS_NAME,GOODS_TYPE,GOODS_PRICE,GOODS_COUNT</sql>
	<!-- 查询语句，查询所有 
	resultMap：与上边的resultMap标签的id属性值一致，将查出的数据按照配置的对应关系，封装到实体类中
	-->
	<select id="queryAll" resultMap="goodsMap">
		SELECT <include refid="key"/> FROM GOODS
	</select>
</mapper>

5. 页面
show.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>商品列表</title>
</head>
<body>
 
	<div align="center">
		<table border="1" cellspacing="0">
			<caption>商品列表</caption>
			<tbody>
				<tr>
					<td>商品编号</td>
					<td>商品名称</td>
					<td>商品类型</td>
					<td>商品价格</td>
					<td>剩余数量</td>
				</tr>
				<c:forEach items="${goods }" var="good">
					<tr>
						<td>${good.goods_id }</td>
						<td>${good.goods_name }</td>
						<td>${good.goods_type }</td>
						<td>${good.goods_price }</td>
						<td>${good.goods_count }</td>
					</tr>
				</c:forEach>
			</tbody>
		</table>
 
		<p>一共${page.pages}页</p>
		<a href="goods.do?page=${page.firstPage}">第一页</a> <a
			href="goods.do?page=${page.nextPage}">下一页</a> <a
			href="goods.do?page=${page.prePage}">上一页</a> <a
			href="goods.do?page=${page.lastPage}">最后页</a>
	</div>
</body>
</html>

6. 测试
在这里插入图片描述

吴声子夜歌

关注

2
点赞
踩
0

收藏

觉得还不错? 一键收藏
1
评论
Maven--SSM使用PageHelper分页

SSM使用PageHelper分页1.准备表和数据CREATE TABLE `goods` ( `goods_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品id', `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称', `goods_type` varchar(255) DEFA...
复制链接

扫一扫