查询数据很简答, 关键是怎么把数据循环放在option标签中,一直尝试在option中进行数据循环,后来换了个方向,直接在取值的位置,进行数据循环,随后将数据放在option中,简直不要太合适。
废话不讲,直接上代码:
首先是pojo
package demo.pojo;
import lombok.Data;
import lombok.ToString;
@Data
@ToString
public class Product {
private String productCode;
private Integer categoryID;
private String name;
private String unitName;
private Double price;
private String createDate;
private String remark;
private Integer num;
private Integer ponum;
private Integer sonum;
}
接下来mapper
package demo.mapper;
import demo.pojo.Product;
import demo.pojo.Vender;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface ProductMapper {
void save(Product product);
List findAll();
List findAlls();
Product findById(@Param("ProductCode") String productCode);
void deletesource(@Param("productCode") String productCode);
void updata(Product product);
List findAllCode();
}
接下来是Service
package demo.service;
import demo.pojo.Product;
import demo.pojo.Vender;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface ProductService {
void save(Product product);
List findAll();
List findAlls();
Product findById(@Param("ProductCode") String productCode);
void deletesource(@Param("ProductCode") String productCode);
void updata(Product product);
List findAllCode();
}
接下来是:impl
package demo.service.impl;
import demo.mapper.ProductMapper;
import demo.mapper.VenderMapper;
import demo.pojo.Product;
import demo.service.ProductService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service("productService")
public class ProducyServiceImpl implements ProductService {
@Autowired
private ProductMapper productMapper;
@Override
public List findAlls() {
return productMapper.findAlls();
}
@Override
public void save(Product product) {
productMapper.save(product);
}
@Override
public List findAll() {
return productMapper.findAll();
}
@Override
public Product findById(String productCode) {
return productMapper.findById(productCode);
}
@Override
public void deletesource(String productCode) {
productMapper.deletesource(productCode);
}
@Override
public void updata(Product product) {
productMapper.updata(product);
}
@Override
public List findAllCode() {
return productMapper.findAllCode();
}
}
接下来是xml文件
接下来:Controller
package demo.controller;
import com.alibaba.fastjson.JSONObject;
import demo.pojo.Product;
import demo.pojo.Vender;
import demo.result.Result;
import demo.service.ProductService;
import demo.service.VenderService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@RestController
@RequestMapping("/sys/pro")
public class ProductController {
@Autowired
private ProductService productService;
@RequestMapping("/all")
public Result get() {
return Result.ok(productService.findAll());
}
@RequestMapping("/proall")
public Result getter() {
return Result.ok(productService.findAlls());
}
@RequestMapping("/save")
public Result add(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String s = req.getReader().readLine();
Product product = JSONObject.parseObject(s, Product.class);
productService.save(product);
Result ok = Result.ok(s);
return ok;
}
@RequestMapping("/del")
public Result dele(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String s = req.getReader().readLine();
Product product = JSONObject.parseObject(s, Product.class);
productService.deletesource(product.getProductCode());
Result ok = Result.ok("");
return ok;
}
@RequestMapping("/up")
public Result updates(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String s = req.getReader().readLine();
Product product = JSONObject.parseObject(s, Product.class);
productService.updata(product);
Result ok = Result.ok("");
return ok;
}
@RequestMapping("/findcode")
public Result findcode(HttpServletRequest req) throws IOException {
return Result.ok(productService.findAll());
}
}
接下来是:
Insert title here
位置:
- 报表
- 月度出库报表



