![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/8bf5023ba7efeaa45079f06d512eb66e.png)
package com.demo.controller;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.demo.pojo.EasybuyProduct;
import com.demo.pojo.R;
import com.demo.pojo.vo.ProductVo;
import com.demo.service.EasybuyProductService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.*;
import java.util.List;
@Controller
@RequestMapping("/easybuy")
public class EasybuyProductController{
@Autowired
private EasybuyProductService easybuyProductService;
@RequestMapping("/index")
public String index(Model model) {
List<EasybuyProduct> list = easybuyProductService.list(null);
System.out.println(list);
model.addAttribute("list",list);
return "easybuy/index";
}
@RequestMapping("/getProductById/{id}")
@ResponseBody
public R getProductById(@PathVariable Integer id) {
EasybuyProduct easybuyProduct=easybuyProductService.getById(id);
if(easybuyProduct!=null){
return R.ok().data("product",easybuyProduct);
}else {
return R.error().message("查询不到此商品");
}
}
@RequestMapping("/getProductAll")
@ResponseBody
public R getProductAll() {
List<EasybuyProduct> list = easybuyProductService.list(null);
return R.ok().data("products",list);
}
@RequestMapping("/show")
public String show(ProductVo productVo, Model model) {
String name = productVo.getName();
Integer id = productVo.getId();
QueryWrapper<EasybuyProduct>wrapper=new QueryWrapper<>();
if (!StringUtils.isEmpty(name)) {
wrapper.like("name", name);
}
if (!StringUtils.isEmpty(id)) {
wrapper.eq("id", id);
}
List<EasybuyProduct> list = easybuyProductService.list(wrapper);
System.out.println("------------"+list);
model.addAttribute("list",list);
model.addAttribute("id",id);
model.addAttribute("name",name);
return "easybuy/index";
}
}
<%@ page contentType="text/html;charset=UTF-8" isELIgnored="false" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<form action="/easybuy/show" method="post">
<input type="text" name="id" placeholder="商品id" autocomplete="off" value="${id}">
<input type="text" name="name" placeholder="商品名称关键词" autocomplete="off" value="${name}">
<button type="submit">查询</button>
</form>
<table border="1" cellspacing="0">
<thead>
<th>id</th>
<th>名称</th>
<th>价格</th>
</thead>
<tbody>
<c:forEach items="${list}" var="lists">
<tr>
<td>${lists.id}</td>
<td>${lists.name}</td>
<td>${lists.price}</td>
</tr>
</c:forEach>
</tbody>
</table>
</body>
</html>