基于SSM+layui实现用户列表展示以及分页功能

基于SSM+layui实现了用户列表的展示以及分页管理的功能，其中分为bean层，mapper层，service层，controller层，以及jsp前端页面的实现

一、实现效果

注：该列表展示使用了layui中数据表格的样式框架，Layui table模块 | 数据表格 | datatable - 在线演示 (layuion.com)，其中底部实现的分页功能需额外引入jar包—pageHelper

二、数据准备 1、MySQL表构建：user

2、添加数据

三、代码编写 1、bean层—UserInfo.java

@AllArgsConstructor
@NoArgsConstructor
@Data
public class UserInfo implements Serializable{
	
	private static final long serialVersionUID = -6943242013517012358L;
	private Integer id;
	private String userId;
	private String userName;
	private String password;
	@JsonFormat(timezone = "GMT+8", pattern="yyyy-MM-dd HH:mm:ss")
	private Date registerTime;
	private Boolean state;
}

2、mapper层—UserInfoMapper.java UserInfoMapper.xml

注意：mapper层的两个方法名必须相同

UserInfoMapper.java

public interface UserInfoMapper {
    public List findAllUsers();
}

UserInfoMapper.xml

		
		
		
		
		
		


		select * from user where user_name=#{userName}

3、service层—UserInfoService.java UserInfoServiceImpl.java UserInfoService.java

public interface UserInfoService {
    public PageInfo findAllUsers(int pageIndex,int pageSize);
}

UserInfoServiceImpl.java

@Transactional
@Service
public class UserInfoServiceImpl implements UserInfoService{
    @Autowired
	private UserInfoMapper userInfoMapper;
    
    
	@Override
	public PageInfo findAllUsers(int pageIndex,int pageSize) {
		PageHelper.startPage(pageIndex, pageSize);//拦截功能，返回了当前页的最多数据
		List list = userInfoMapper.findAllUsers();
		PageInfo pageInfo = new PageInfo(list);
		return pageInfo;
	}
}

4、controller层—UserInfoController.java

@Controller
public class UserInfoController {

	@Autowired
	private UserInfoService userInfoService;
    
    @RequestMapping("/findAllUsers")
	@ResponseBody
	public Map findAllUsers(int page,int limit) {
		Map map = new HashMap();
		PageInfo pageInfo = userInfoService.findAllUsers(page,limit);
		map.put("code", 0);
		map.put("msg", "success");
		map.put("count", pageInfo.getTotal());
		map.put("data", pageInfo.getList());
		return map;
	}
}

5、list_user.jsp是基于layui中数据表格部分代码

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>













	
	
	
	
	
	
	
	

四、若无需分页操作，则只需修改service层和controller层即可 1、service层—UserInfoService.java UserInfoServiceImpl.java UserInfoService.java

public interface UserInfoService {
    public List findAllUsers();
}

UserInfoServiceImpl.java

@Transactional
@Service
public class UserInfoServiceImpl implements UserInfoService {
    @Autowired
	private UserInfoMapper userInfoMapper;
    
    @Override
	public List findAllUsers() {
		return userInfoMapper.findAllUsers();
	}
}

2、controller层—UserInfoController.java

@Controller
public class UserInfoController {
	@Autowired
	private UserInfoService userInfoService;
	
    @RequestMapping("/findAllUsers")
	@ResponseBody //返回json数据：必须是layui指定的格式
	public Map findAllUsers(){
		Map map = new HashMap();
		List list = userInfoService.findAllUserInfo();
		map.put("code",0);
		map.put("msg","success");
		map.put("count",list.size());
		map.put("data",list);
		return map;
	}
}