测试
package com.sky.test;
import com.sky.controller.UserController;
import com.sky.pojo.Emp;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import java.util.List;
public class Demo {
public static void main(String[] args) {
ApplicationContext applicationContext = new ClassPathXmlApplicationContext("applicationContext.xml");
UserController userController = (UserController) applicationContext.getBean("userController");
List emps = userController.getEmps(2,5);
System.out.println(emps);
}
}
controller
package com.sky.controller;
import com.sky.pojo.Emp;
import com.sky.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import java.util.List;
@Controller
public class UserController {
@Autowired
private UserService userService;
public List getEmps(int pageNum,int pageSize){
return userService.getEmps(pageNum,pageSize);
}
}
service
package com.sky.service;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.sky.mapper.EmpMapper;
import com.sky.pojo.Emp;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class UserService {
@Autowired
private EmpMapper empMapper;
public List getEmps(int pageNum,int pageSize) {
// 开启分页查询
// pageNum:第几页 ; pageSize:一页有几条数据
PageHelper.startPage(pageNum,pageSize);
List emps = empMapper.getEmps();
// 用PageInfo对结果进行封装
// PageInfo包含非常全面的分页属性
PageInfo page = new PageInfo(emps);
System.out.println(page);
return emps;
}
}
mapper
package com.sky.mapper;
import com.sky.pojo.Emp;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface EmpMapper {
List getEmps();
}
mapperxml
select * from emp
spring、Mybatis选一个配置
MybatisConfig.xml配置分页
spring配置分页
classpath:mapper/*.xml dialect=hsqldb reasonable=true



