左侧thymeleaf 动态绑定li，右侧layui table

pom.xml 添加pagehelper 依赖

 
    
      com.github.pagehelper
      pagehelper
      5.3.0
    

MyBatisConfig 添加 注解 （ssm java类注解，可以看我前面的文章）

 @Bean
    public PageHelper pageHelper(){
        //分页插件
        PageHelper pageHelper = new PageHelper();
        Properties properties = new Properties();
        properties.setProperty("helperDialect", "mysql");
        properties.setProperty("reasonable", "true");
        pageHelper.setProperties(properties);
        return pageHelper;

    }

实体类 subject:

package com.pojo;

public class Subject {
    private Integer id;
    private String sname;
    private Integer gradelevel;

    public Integer getId() {
        return id;
    }

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

    public String getSname() {
        return sname;
    }

    public void setSname(String sname) {
        this.sname = sname;
    }

    public Integer getGradelevel() {
        return gradelevel;
    }

    public void setGradelevel(Integer gradelevel) {
        this.gradelevel = gradelevel;
    }
}

实体类:Grade

package com.pojo;

public class Grade {
    private Integer id;
    private String gname;

    public Integer getId() {
        return id;
    }

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

    public String getGname() {
        return gname;
    }

    public void setGname(String gname) {
        this.gname = gname;
    }
}

数据层接口: GradeMapper 和SubjectMapper

public interface GradeMapper {
    @Select("select * from grade")
    public List getAll();
}

public interface SubjectMapper {
    @Select("select * from subject")
    public ListfindAlls();
    @Select({
        ""
    })
    public ListFy(@Param("page") Integer page,
                           @Param("limit")Integer limit,@Param("gradelevel") int gradelevel);
   
}

GradeServiceImpl 和SubjectServiceImpl 实现接口（service 层的接口就不赘述了，把mapper的接口复制粘贴即可，顺便把@Param() 这玩意干掉）

@Service
public class GradeServiceImpl implements GradeService {
    @Autowired
    private GradeMapper mapper;
    @Override
    public List getAll() {
        return mapper.getAll();
    }
}

package com.service.impl;

import com.mapper.SubjectMapper;
import com.pojo.Subject;
import com.service.SubjectService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class SubjectServiceImpl implements SubjectService {
    @Autowired
    private SubjectMapper mapper;

    @Override
    public List findAlls() {
        return mapper.findAlls();
    }

    @Override
    public List Fy(Integer page, Integer limit,int id) {
        return mapper.Fy(page,limit, id);
    }
}

Controller 控制器层 （thymeleaf 模板引擎这些，可以看前面的文章）

@Controller
public class SubjectController {
    @Autowired
    private SubjectService service;
    @Autowired
    private GradeService gservice;
    @GetMapping("/subjectshow")
    public String subjectshow(HttpSession session){
        List all = gservice.getAll();
        session.setAttribute("all", all);
        return "views/subjectshow.htm";
    }
    @GetMapping("/subjectshows")
    @ResponseBody
    public Object subjectshows(Integer page,Integer limit,String id){
        PageHelper.startPage(page,limit);
        List all=service.findAlls();//得到所有
        PageInfo pageInfo=new PageInfo(all);
        int ids=Integer.parseInt(id)>0?Integer.parseInt(id):0;
        List list = service.Fy((page-1)*limit, limit,ids);
        int count=(int)pageInfo.getTotal();//得到总条数
        String str= ConvertUtil.ConvertPageJson(list,count);
        JSONObject object = JSON.parseObject(str);
        return object;
    }
}

前台页面：

    
    
    
    
    
    
    
    
    
    
    



    
        
        
            
                

                

                    
                        

                            
                              
                        
                    
                

            
        
        
        
            
                添加