Spring-SSM的整合(下)

简介: Spring-SSM的整合(下)

Ajax分页查询

Controller层

注意扫描业务逻辑层的注解是否正确否则SpringMVC无法识别

@Controller
@RequestMapping("/xinmiao/v1/TStorageRecord")
@ResponseBody
public class TStorageRecordController {
    @Autowired
    private TStorageRecordService recordService;
    @RequestMapping("/getlist")
    public String getlist(TStorageRecord record, HttpServletRequest request){
        Page page=new Page();
        String currPageNoStr=request.getParameter("currPageNo");
        if(currPageNoStr==null||"".equals(currPageNoStr)){
            page.setCurrPageNo(1);
        }else{
            page.setCurrPageNo(Integer.parseInt(currPageNoStr));
        }
        String pageSizeStr=request.getParameter("pageSize");
        if (pageSizeStr==null||"".equals(pageSizeStr)){
            page.setPageSize(2);
        }else{
            page.setPageSize(Integer.parseInt(pageSizeStr));
        }
        page.setTotalCount(recordService.getStudentCount());
        page.setStudents(recordService.getStudentList(page.getCurrPageNo(),page.getPageSize()));
        String result= JSON.toJSONString(page);
        return result;
    }
}

Mapper层

注意扫描mapper接口是否正确否则Spring无法识别

public interface TStorageRecordMapper {
    int getStudentCount();
    List<TStorageRecord> getStudentList(@Param("currPageNo") int currPageNo, @Param("pageSize")int pageSize);
}

Service层

注意扫描业务逻辑层的注解是否正确否则SpringMVC无法识别

public interface TStorageRecordService {
    int getStudentCount();
    List<TStorageRecord> getStudentList(@Param("currPageNo") int currPageNo, @Param("pageSize")int pageSize);
}

Serviceimpl层

@Service
public class TStorageRecordServiceimpl implements TStorageRecordService {
    @Autowired
    private TStorageRecordMapper RecordMapper;
    @Override
    public int getStudentCount() {
        return RecordMapper.getStudentCount();
    }
    @Override
    public List<TStorageRecord> getStudentList(int currPageNo, int pageSize) {
        int num=(currPageNo-1)*pageSize;
        return RecordMapper.getStudentList(num,pageSize);
    }
}

until层

public class Page {
    private int totalPageCount = 0;     //总页数 计算 根据每页展示记录数和记录总数计算出来的
    private int pageSize = 10;      //每页展示记录数。用户指定,通常有默认值
    private int totalCount;     // 记录总数。 数据库查询
    private int currPageNo = 1;     //当前页码 用户指定,默认显示第一页
    private List<TStorageRecord> records;    //每页微博集合 数据库查询
    public int getTotalPageCount() {
        if (totalCount%pageSize==0){
            return totalCount/pageSize;
        }else {
            return totalCount/pageSize+1;
        }
    }
    public void setTotalPageCount(int totalPageCount) {
        this.totalPageCount = totalPageCount;
    }
    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 getCurrPageNo() {
        return currPageNo;
    }
    public void setCurrPageNo(int currPageNo) {
        this.currPageNo = currPageNo;
    }
    public List<TStorageRecord> getStudents() {
        return records;
    }
    public void setStudents(List<TStorageRecord> students) {
        this.records = students;
    }
}

mappers层

<?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="xinmiao.mapper.TStorageRecordMapper">
    <select id="getStudentCount" resultType="java.lang.Integer">
        select count(1) from t_storage_record
    </select>
    <select id="getStudentList" resultType="xinmiao.bean.TStorageRecord">
        SELECT * FROM `t_storage_record`
             limit #{currPageNo},#{pageSize}
    </select>
</mapper>
相关文章
|
2月前
|
Java 关系型数据库 MySQL
ssm(Spring+Spring mvc+mybatis)
ssm(Spring+Spring mvc+mybatis)
20 0
|
2月前
|
JSON Java 数据库连接
【spring(五)】SpringMvc总结 SSM整合流程
【spring(五)】SpringMvc总结 SSM整合流程
|
4月前
|
Java 数据库连接 数据格式
SSM-Spring+SpringMVC+MyBatis整合案例从0到1
SSM-Spring+SpringMVC+MyBatis整合案例从0到1
49 0
|
5月前
|
SQL Java 数据库连接
【SSM】Spring + SpringMVC +MyBatis 框架整合
【SSM】Spring + SpringMVC +MyBatis 框架整合
33 0
|
5月前
|
Java 应用服务中间件 Maven
Spring&SpringMVC&SpringBoot
Spring&SpringMVC&SpringBoot
41 0
|
5月前
|
Java 数据库连接 Spring
SpringBoot中Spring IOC的运用
SpringBoot中Spring IOC的运用
39 0
|
9月前
|
SQL Java 数据库连接
Spring-SSM的整合(上)
Spring-SSM的整合(上)
|
12月前
|
XML Java 数据库
SSM 之 Spring (下)
SSM 之 Spring (下)
67 0
|
12月前
|
XML SQL Java
SSM 之 Spring(上)
SSM 之 Spring(上)
55 0
|
12月前
|
XML 监控 前端开发
SpringBoot - Spring Boot 应用剖析
SpringBoot - Spring Boot 应用剖析
93 0