左侧thymeleaf动态绑定li,右侧layuitable
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; } }
实体类:Gradepackage 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 和SubjectMapperpublic 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; } }
前台页面: Title