投稿
  1. 极客之音首页
  2. 技术随笔

Spring框架下分页功能的java实现（使用注解）

小半 • • 技术随笔 • 阅读 220

导读：本篇文章讲解 Spring框架下分页功能的java实现（使用注解），希望对大家有帮助，欢迎收藏，转发！站点地址：www.bmabk.com

分页功能

之前写分页功能时，网上的很多都不完整，不容易看明白，解释不清楚。现在自己实现了之歌功能，便详细写写，供大家参考。

注解层

用于自动定位到数据库进行数据的查找。
<关联表>

package cn.itsource.annotation;


import java.lang.annotation.Documented;
import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;

@Documented
/*
 * @Target表示当前注解的适用目标
 * 	ElementType.TYPE 表示适用于类和接口
 *  ElementType.FIELD 表示适用于字段（成员变量）
 *  ElementType.METHOD 表示适用于方法	
 */
@Target(ElementType.TYPE)
/*
 * @Retention表示当前注解对象的生命周期
 * 	RetentionPolicy.SOURCE 生命周期最短，仅在源码中有效
 *  RetentionPolicy.CLASS 生命周期居中， 在源码和编译后的字节码中有效
 *  RetentionPolicy.RUNTIME 生命周期最长，保留到代码运行时
 */
@Retention(RetentionPolicy.RUNTIME)
public @interface Table {
	//关联表名称或视图名称
	String value();
}

<关联列>

package cn.itsource.annotation;


import java.lang.annotation.Documented;
import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;

@Documented
@Target(ElementType.FIELD)
@Retention(RetentionPolicy.RUNTIME)
public @interface Column {
	
	//domain实体类属性关联的表或视图的列名称
	String value();
	
	//SQL语句的比较运算符  < <= > >= = != like等，默认值是“=”
	String operation() default "=";

}

以Job对象为例

package cn.itsource.domain;

import java.io.Serializable;
import java.util.Date;

import cn.itsource.annotation.Column;
import cn.itsource.annotation.Table;

@Table("v_job")//select * from xxxx where 1=1
public class Job implements Serializable{
	
	private Long id;
	//职位名称  and jobName like '%+字段值+%'
	@Column(value="jobName",operation="like")
	private String jobName;
	//外键，关联t_address表的主键
	private Long addrId;
	//招聘人数
	private Integer number;
	//薪资待遇
	private Integer salary;
	//职位描述
	private String intro;
	//任职要求
	private String requires;
	//1表示全职  0表示兼职  and jobType = 字段值
	@Column("jobType")
	private Integer jobType;
	//是否启用  1表示启用  0表示禁用
	@Column("isEnabled")
	private Integer isEnabled;
	//发布时间
	private Date publishTime;
	//工作地名
	private String addrName;
	
	//添加一个职位详情静态页面路径字段[后台]
	private String detailsPath;
	//添加一个职位详情静态页面路径字段[前台]
	private String detailsPath2;
	
	
	//薪资范围搜索
	@Column(value="salary",operation=">=")
	private Integer salary1;
	@Column(value="salary",operation="<=")
	private Integer salary2;
	public Integer getSalary1() {
		return salary1;
	}
	public void setSalary1(Integer salary1) {
		this.salary1 = salary1;
	}
	public Integer getSalary2() {
		return salary2;
	}public void setSalary2(Integer salary2) {
		this.salary2 = salary2;
	}
	
	
	
	
	public String getDetailsPath2() {
		return detailsPath2;
	}
	public void setDetailsPath2(String detailsPath2) {
		this.detailsPath2 = detailsPath2;
	}
	public String getDetailsPath() {
		return detailsPath;
	}
	public void setDetailsPath(String detailsPath) {
		this.detailsPath = detailsPath;
	}
	public String getAddrName() {
		return addrName;
	}
	public void setAddrName(String addrName) {
		this.addrName = addrName;
	}
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	public String getJobName() {
		return jobName;
	}
	public void setJobName(String jobName) {
		this.jobName = jobName;
	}
	public Long getAddrId() {
		return addrId;
	}
	public void setAddrId(Long addrId) {
		this.addrId = addrId;
	}
	public Integer getNumber() {
		return number;
	}
	public void setNumber(Integer number) {
		this.number = number;
	}
	public Integer getSalary() {
		return salary;
	}
	public void setSalary(Integer salary) {
		this.salary = salary;
	}
	public String getIntro() {
		return intro;
	}
	public void setIntro(String intro) {
		this.intro = intro;
	}
	public String getRequires() {
		return requires;
	}
	public void setRequires(String requires) {
		this.requires = requires;
	}
	public Integer getJobType() {
		return jobType;
	}
	public void setJobType(Integer jobType) {
		this.jobType = jobType;
	}
	public Integer getIsEnabled() {
		return isEnabled;
	}
	public void setIsEnabled(Integer isEnabled) {
		this.isEnabled = isEnabled;
	}
	public Date getPublishTime() {
		return publishTime;
	}
	public void setPublishTime(Date publishTime) {
		this.publishTime = publishTime;
	}
	@Override
	public String toString() {
		return "Job [id=" + id + ", jobName=" + jobName + ", addrId=" + addrId + ", number=" + number + ", salary="
				+ salary + ", intro=" + intro + ", requires=" + requires + ", jobType=" + jobType + ", isEnabled="
				+ isEnabled + ", publishTime=" + publishTime + ", addrName=" + addrName + ", detailsPath=" + detailsPath
				+ "]";
	}
	

}

封装的Condition

package cn.itsource.utils;

/**
 * 封装查询条件参数
 * @author Administrator
 *
 */
public class Condition {
	
	private String id;
	
	//isEnabled为1表示前台访问，为null表示后台访问
	private Integer isEnabled;

	private Long pageNo = 1L;
	
	private Long pageSize = 5L;
	
	//以后如果遇到还要通过其他条件去查询数据的时候，只需要在这儿添加字段和set、get方法即可
	private String jobName;
	private Integer jobType = -1;
	
	//薪资范围
	private Integer salary1;
	private Integer salary2;

	public Integer getSalary1() {
		return salary1;
	}

	public void setSalary1(Integer salary1) {
		this.salary1 = salary1;
	}

	public Integer getSalary2() {
		return salary2;
	}

	public void setSalary2(Integer salary2) {
		this.salary2 = salary2;
	}

	public String getJobName() {
		return jobName;
	}

	public void setJobName(String jobName) {
		this.jobName = jobName;
	}

	public Integer getJobType() {
		return jobType < 0 ? null : jobType;
	}

	public void setJobType(Integer jobType) {
		this.jobType = jobType;
	}

	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	public Integer getIsEnabled() {
		return isEnabled;
	}

	public void setIsEnabled(Integer isEnabled) {
		this.isEnabled = isEnabled;
	}

	public Long getPageNo() {
		return pageNo;
	}

	public void setPageNo(Long pageNo) {
		this.pageNo = pageNo;
	}

	public Long getPageSize() {
		return pageSize;
	}

	public void setPageSize(Long pageSize) {
		this.pageSize = pageSize;
	}

	@Override
	public String toString() {
		return "Condition [id=" + id + ", isEnabled=" + isEnabled + ", pageNo=" + pageNo + ", pageSize=" + pageSize
				+ "]";
	}

	
}

封装page工具类

package cn.itsource.utils;

import java.util.List;

public class Page<T> {
	//当前页码
	private Long pageNo;
	//每页显示的数据行数
	private Long pageSize;
	//总页数
	private Long pageCount;
	//总行数
	private Long total;
	//当前页要显示的数据集合
	private List<T> list;
	//上一页
	private Long prevPage;
	//下一页
	private Long nextPage;
	public Page() {}
	public Page(Long pageNo, Long pageSize, Long total, List<T> list) {
		this.pageNo = pageNo;
		this.pageSize = pageSize;
		this.total = total;
		this.list = list;
		this.pageCount = total % pageSize == 0 ? total/pageSize : total/pageSize + 1;
		this.prevPage = this.pageNo == 1 ? 1 : this.pageNo - 1;
		this.nextPage = this.pageNo == this.pageCount ? this.pageCount : this.pageNo + 1;
	}
	public Long getPageNo() {
		return pageNo;
	}
	public void setPageNo(Long pageNo) {
		this.pageNo = pageNo;
	}
	public Long getPageSize() {
		return pageSize;
	}
	public void setPageSize(Long pageSize) {
		this.pageSize = pageSize;
	}
	public Long getPageCount() {
		return pageCount;
	}
	public void setPageCount(Long pageCount) {
		this.pageCount = pageCount;
	}
	public Long getTotal() {
		return total;
	}
	public void setTotal(Long total) {
		this.total = total;
	}
	public List<T> getList() {
		return list;
	}
	public void setList(List<T> list) {
		this.list = list;
	}
	public Long getPrevPage() {
		return prevPage;
	}
	public void setPrevPage(Long prevPage) {
		this.prevPage = prevPage;
	}
	public Long getNextPage() {
		return nextPage;
	}
	public void setNextPage(Long nextPage) {
		this.nextPage = nextPage;
	}
	@Override
	public String toString() {
		return "Page [pageNo=" + pageNo + ", pageSize=" + pageSize + ", pageCount=" + pageCount + ", total=" + total
				+ ", list=" + list + "]";
	}
	

}

前端分页功能

<!--分页-->
			<nav class="navbar-right">
				<ul class="pagination" id="paging">
					<li>
						<span>当前第${page.pageNo}页</span>
					</li>
					<li><a href="${basePath}show/index?pageNo=1&pageSize=${page.pageSize}"><span aria-hidden="true">首页</span></a></li>
					<li><a href="${basePath}show/index?pageNo=${page.prevPage}&pageSize=${page.pageSize}" aria-label="上一页"><span aria-hidden="true">上一页</span></a></li>
					<li><a href="${basePath}show/index?pageNo=${page.nextPage}&pageSize=${page.pageSize}" aria-label="下一页"><span aria-hidden="true">下一页</span></a></li>
					<li><a href="${basePath}show/index?pageNo=${page.pageCount}&pageSize=${page.pageSize}" aria-label="尾页"><span aria-hidden="true">尾页</span></a></li>
					<li>
						<span>总页数：共${page.pageCount}页</span>
						<span>总数据：共${page.total}条</span>
					</li>
				</ul>
			</nav>
		</div>

后端分页接口

这里condition是封装了数据对象，传参进去使用，带有page的数据。

package cn.itsource.ibase;

import java.util.List;

import cn.itsource.utils.Condition;

public interface IBaseDao<T> extends IBase<T> {

	/**
	 * 分页查询多个对象信息
	 * @param con  封装的查询条件
	 * @return
	 */
	List<T> loadEntitys(Condition con);
	
	/**
	 * 分页查询-总行数
	 * @param con	封装的查询条件
	 * @return
	 */
	Long loadCount(Condition con);
	
}

service层接口

package cn.itsource.ibase;



import cn.itsource.utils.Condition;
import cn.itsource.utils.Page;

public interface IBaseService<T> extends IBase<T> {

	/**
	 * 分页查询数据 		
	 * @param con	封装的查询条件
	 * @return
	 */
	Page<T> loadEntitys(Condition con);
	
	
	
	
}

dao层接口实现

package cn.itsource.dao.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import cn.itsource.dao.IJobDao;
import cn.itsource.domain.Job;
import cn.itsource.utils.Condition;
import cn.itsource.utils.SqlGenerator;

@Repository
public class JobDaoImpl implements IJobDao {

	@Autowired
	private JdbcTemplate jt;
	
	@Override
	public List<Job> loadEntitys(Condition con) {
		String sql = SqlGenerator.generate(con, Job.class, true);
		System.out.println(sql);
		return jt.query(sql, new BeanPropertyRowMapper(Job.class), (con.getPageNo()-1)*con.getPageSize(), con.getPageSize());
	}

	@Override
	public Long loadCount(Condition con) {
		String sql = SqlGenerator.generate(con, Job.class, false);
		System.out.println(sql);
		return jt.queryForLong(sql);
	}

}

service层接口实现

package cn.itsource.service.impl;


import java.util.List;

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.itsource.dao.IJobDao;
import cn.itsource.domain.Job;
import cn.itsource.service.IJobService;
import cn.itsource.utils.Condition;
import cn.itsource.utils.EhcacheUtil;
import cn.itsource.utils.FreeMarkerUtils;
import cn.itsource.utils.Page;
import net.sf.ehcache.CacheManager;

@Service
public class JobServiceImpl implements IJobService {

	@Autowired
	private IJobDao jobDao;
	
	@Override
	public Page<Job> loadEntitys(Condition con) {
		//List<Job> list = jobDao.loadEntitys(con);
		//Long total = jobDao.loadCount(con);
		Long total = (Long)EhcacheUtil.getCacheData(cm, "jobCache", "totalOfJob:"+con.toString(), jobDao, "loadCount", con);
		List<Job> list = (List<Job>)EhcacheUtil.getCacheData(cm, "jobCache", "pageOfJob:"+con.toString(), jobDao, "loadEntitys", con);
		return new Page<Job>(con.getPageNo(), con.getPageSize(), total, list);
	}
	
}

Controller层调用

package cn.itsource.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;

import cn.itsource.domain.Carousel;
import cn.itsource.domain.Job;
import cn.itsource.service.ICarouselService;
import cn.itsource.service.IJobService;
import cn.itsource.utils.Condition;
import cn.itsource.utils.Page;

@Controller
@RequestMapping("/show")
public class ShowController {
	
	@Autowired
	private ICarouselService carouselService;
	@Autowired
	private IJobService jobService;
	
	
	@RequestMapping("/{path}")
	public String index(@PathVariable("path")String path, Model model, Condition con){
			con.setPageSize(10L);
			Page<Job> page = jobService.loadEntitys(con);
			//保存
			model.addAttribute("page", page);
			//保存Condition对象，为了在搜索表单中回填搜索条件【方便查看】
			model.addAttribute("con", con);
		//因为springMVC.xml中配置了视图解析器，所以会跳转到/WEB-INF/admin/之下的jsp页面中，所以不能直接return
		return "forward:/" + path + ".jsp"; // /index.jsp
	}

}

版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。

文章由极客之音整理，本文链接：https://www.bmabk.com/index.php/post/75239.html

赞 (0)
小半的头像小半
0 0

相关推荐

极客之音——专业性很强的中文编程技术网站，欢迎收藏到浏览器，订阅我们！