SSM框架之数据分页，模糊查询

1、创建springMVC项目，搭建环境
2、创建Page.java，存储信息

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class Page {
	//显示第几页
	private int pageNow = 1;
	//每页显示条数
	private int pageSize = 3;
	//查询总条数
	private int totalCount;
	//查询总页数
	private int totalPages;
	
	//坐标
	private int offSet;
	//返回查询数据
	private List<?> datas;
	
	//装载查询条件
	Map<String,Object> query = new HashMap();

	public int getPageNow() {
		return pageNow;
	}

	public void setPageNow(int pageNow) {
		this.pageNow = pageNow;
	}

	public int getPageSize() {
		return pageSize;
	}

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

	public int getTotalCount() {
		return totalCount;
	}

	public void setTotalCount(int totalCount) {
		this.totalCount = totalCount;
	}

	public int getTotalPages() {
		//直接返回总页数
		return this.totalCount%this.pageSize==0?this.totalCount/this.pageSize:this.totalCount/this.pageSize+1;
	}

	public void setTotalPages(int totalPages) {
		this.totalPages = totalPages;
	}

	public List<?> getDatas() {
		return datas;
	}

	public void setDatas(List<?> datas) {
		this.datas = datas;
	}

	public Map<String, Object> getQuery() {
		return query;
	}

	public void setQuery(Map<String, Object> query) {
		this.query = query;
	}

	public int getOffSet() {
		//显示在数据库里是第几条
		return (this.pageNow-1)*this.pageSize;
	}

	public void setOffSet(int offSet) {
		this.offSet = offSet;
	}
	
	
}

3、创建pojo类，User.java

public class User {
	private String userId;
	private String userName;
	private Integer userAge;
	private String userSex;
	private String userRoleId;
	private Integer userStatus;
	private String userDeptId;
	private String userDesc;
	private String account;
	private String password;
	public String getUserId() {
		return userId;
	}
	public void setUserId(String userId) {
		this.userId = userId;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public Integer getUserAge() {
		return userAge;
	}
	public void setUserAge(Integer userAge) {
		this.userAge = userAge;
	}
	public String getUserSex() {
		return userSex;
	}
	public void setUserSex(String userSex) {
		this.userSex = userSex;
	}
	public String getUserRoleId() {
		return userRoleId;
	}
	public void setUserRoleId(String userRoleId) {
		this.userRoleId = userRoleId;
	}
	public Integer getUserStatus() {
		return userStatus;
	}
	public void setUserStatus(Integer userStatus) {
		this.userStatus = userStatus;
	}
	public String getUserDeptId() {
		return userDeptId;
	}
	public void setUserDeptId(String userDeptId) {
		this.userDeptId = userDeptId;
	}
	public String getUserDesc() {
		return userDesc;
	}
	public void setUserDesc(String userDesc) {
		this.userDesc = userDesc;
	}
	public String getAccount() {
		return account;
	}
	public void setAccount(String account) {
		this.account = account;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	@Override
	public String toString() {
		return "User [userId=" + userId + ", userName=" + userName + ", userAge=" + userAge + ", userSex=" + userSex
				+ ", userRoleId=" + userRoleId + ", userStatus=" + userStatus + ", userDeptId=" + userDeptId
				+ ", userDesc=" + userDesc + ", account=" + account + ", password=" + password + "]";
	}
	
	
	

}

4、编写UserMapper.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">
<mapper namespace="com.znn.dao.UserMapper">
	<resultMap type="com.znn.model.User" id="resultUser">
		<!-- id在数据库中用uuid()方法创建的 -->
		<id property="userId" javaType="String" column="user_id" jdbcType="VARCHAR"/>
		<result property="userName" javaType="String" column="user_name" jdbcType="VARCHAR"/>
		<result property="userAge" javaType="Integer" column="user_age&#