前端调controller接口(/foodController/selectFood)————》 controller调service-----> service调mapper;
@Slf4j
@RestController
@RequestMapping("/foodController")
public class FoodController {
@Autowired
private FoodService foodService;
//景点信息查询
@GetMapping("/selectFood")
public PageBean<Food> selectFood(int pageNum, int pageSize){
PageBean<Food> Foods= foodService.findAllTour(pageNum,pageSize);
return Foods;
}
}
public interface FoodService {
PageBean<Food> findAllTour(int startIndex, int pageSize);
}
@Service
public class FoodServiceImpl implements FoodService {
@Autowired
private FoodMapper foodMapper;
public PageBean<Food> findAllTour(int pageNum, int pageSize) {
List<Food> listTour=foodMapper.selectTour();
int totalRecord=listTour.size();
PageBean pageBean=new PageBean(pageNum,pageSize,totalRecord);
int startIndex=pageBean.getStartIndex();
pageBean.setList(foodMapper.findAllTour(startIndex,pageSize));
return pageBean;
}
@Mapper
@Repository
public interface FoodMapper {
List<Food> findAllTour(int startIndex, int pageSize);
}
<?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="com.software.mapper.FoodMapper">
<select id="selectTour" resultType="food">
select * from food
</select>
<select id="findAllTour" resultType="food">
select * from food limit #{startIndex},#{pageSize}
</select>
</mapper>