订单操作-查询所有订单代码实现_查询某某的所有订单代码-CSDN博客

本文链接：https://blog.csdn.net/Leon_Jinhai_Sun/article/details/104332636

本文详细介绍了如何在Spring MVC框架下实现订单查询与分页功能。通过OrdersController类处理findAll请求，调用IOrdersService服务层方法获取订单列表，并传递给order-list.jsp页面展示。同时，展示了MyBatis Dao层的IOrdersDao接口定义及产品ID关联查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

订单查询

订单查询页面 order-list.jsp

Controller

@Controller
@RequestMapping("/orders")
public class OrdersController {

	@Autowired
	private IOrdersService ordersService;
	
	//未分页
	@RequestMapping("/findAll.do")
	public ModelAndView findAll(@RequestParam(name = "page", required = true, defaultValue=
		"1") Integer page, @RequestParam(name = "pageSize", required = true, defaultValue = 
"10")
			Integer pageSize) throws Exception {
			List<Orders> ordersList = ordersService.findAllByPage(page, pageSize);
			ModelAndView mv = new ModelAndView();
			mv.setViewName("order-list");
			mv.addObject("ordersList", ordersList);
			return mv;
	}
}

Dao

IOrdersDao

public interface IOrdersDao {
	@Select("select * from orders")
		@Results({
		@Result(id=true,column = "id",property = "id"),
		@Result(column = "orderNum",property = "orderNum"),
		@Result(column = "orderTime",property = "orderTime"),
		@Result(column = "orderStatus",property = "orderStatus"),
		@Result(column = "peopleCount",property = "peopleCount"),
		@Result(column = "payType",property = "payType"),
		@Result(column = "orderDesc",property = "orderDesc"),
		@Result(column = "productId",property = "product",one = @One(select =
		"com.learn.ssm.dao.IProductDao.findById"))
	})
	List<Orders> findAll() throws Exception;
}

IProductDao的findById

@Select("select * from product where id=#{id}")
Product findById(String id) throws Exception;