技术标签: springboot的商城后台实现
先来看看order表的结构
目录
首先是实现实体类,具体操作参考前面的博客( 商城后台之user表的实现(二)---(1))
然后别忘了加
@GeneratedValue(strategy = GenerationType.IDENTITY)
如果没有加的话,后面运行的时候会报找不到主键的错误,
@GeneratedValue注释定义了标识字段生成方式。
IDENTITY:主键由数据库自动生成(主要是自动增长型)
注解@Service
有了此注解,应用程序将会自动扫描此类
DAO 里的 @Transactional
是表示这个 DAO 里的方法有事务,即单表的操作也有事务
基础的 Repository 提供了最基本的数据访问功能,其几个子接口则扩展了一些功能。它们的继承关系如下:
Repository: 仅仅是一个标识,表明任何继承它的均为仓库接口类
(1) CrudRepository: 继承 Repository,实现了一组 CRUD 相关的方法
(2)PagingAndSortingRepository: 继承 CrudRepository,实现了一组分页排序相关的方法
(3)JpaRepository: 继承 PagingAndSortingRepository,实现一组 JPA 规范相关的方法
ctrl+鼠标左键点击jpaRepository,即可查看相关的方法
补充一下:
在这里写个查询单一数据的方法:
Order findOrderById(Long orderId);
@Resource(这个注解属于J2EE的),默认安照名称进行装配,名称可以通过name属性进行指定,
如果没有指定name属性,当注解写在字段上时,默认取字段名进行按照名称查找,如果注解写在setter方法上默认取属性名进行装配。 当找不到与名称匹配的bean时才按照类型进行装配。但是需要注意的是,如果name属性一旦指定,就只会按照名称进行装配。
Java代码 收藏代码
@Resource(name="baseDao")
private BaseDao baseDao;
首先,写一下create方法,先看一下jpaReposity的源码:
Order create(long userId, long productId, Long orderNo, Integer payment, Integer paymentType, Integer postage, Integer status, Timestamp paymentTime,Timestamp sendTime,Timestamp endTime,Timestamp closeTime){
Order order = new Order();
order.setUserId(userId);
order.setProductId(productId);
order.setOrderNo(orderNo);
order.setPayment(payment);
order.setPaymentType(paymentType);
order.setPostage(postage);
order.setStatus(status);
order.setPaymentTime(paymentTime);
order.setSendTime(sendTime);
order.setEndTime(endTime);
order.setCloseTime(closeTime);
return orderDAO.save(order);
}
其次,写查询单一数据的getById方法:
Order getById(Long order){
return orderDAO.findOrderById(order);
}
然后写一个查询所有数据的getOrderList方法:
List<Order> getOrderList(){
return orderDAO.findAll();
}
再然后写删除的方法deleteOrder:
void deleteOrder(Long orderId){
Order order = orderDAO.findOrderById(orderId);
if( orderId!=0){
orderDAO.delete(order);
}
}
还有一个更新方法,我需要在OrderRequest重新写一遍bean
Order updateOrder(Long orderId, OrderRequestDTO body){
Order order = orderDAO.findOrderById(orderId);
if(body.getCloseTime() != null){
order.setCloseTime(body.getCloseTime());
}
if(body.getEndTime() != null){
order.setEndTime(body.getEndTime());
}
if(body.getOrderNo() != null){
order.setOrderNo(body.getOrderNo());
}
if(body.getPayment()!=null){
order.setPayment(body.getPayment());
}
if(body.getPaymentTime()!=null){
order.setPaymentTime(body.getPaymentTime());
}
if(body.getPostage()!=null){
order.setPostage(body.getPostage());
}
if(body.getPaymentType()!=null){
order.setPaymentType(body.getPaymentType());
}
if(body.getSendTime()!=null){
order.setSendTime(body.getSendTime());
}
if(body.getStatus()!=null){
order.setStatus(body.getStatus());
}
order=orderDAO.save(order);
return order;
}
更新的方法会调用这里的get方法,注意,这里是没有OrderId的,更新数据并不需要更新id,所以没有写,剩下的大致跟bean差不多
package com.wayknew.demo.order.request;
import java.sql.Timestamp;
public class OrderRequestDTO {
private long userId;
private long productId;
private Long orderNo;
private Integer payment;
private Integer paymentType;
private Integer postage;
private Integer status;
private Timestamp paymentTime;
private Timestamp sendTime;
private Timestamp endTime;
private Timestamp closeTime;
private Timestamp createdAt;
private Timestamp updatedAt;
public long getUserId() {
return userId;
}
public void setUserId(long userId) {
this.userId = userId;
}
public long getProductId() {
return productId;
}
public void setProductId(long productId) {
this.productId = productId;
}
public Long getOrderNo() {
return orderNo;
}
public void setOrderNo(Long orderNo) {
this.orderNo = orderNo;
}
public Integer getPayment() {
return payment;
}
public void setPayment(Integer payment) {
this.payment = payment;
}
public Integer getPaymentType() {
return paymentType;
}
public void setPaymentType(Integer paymentType) {
this.paymentType = paymentType;
}
public Integer getPostage() {
return postage;
}
public void setPostage(Integer postage) {
this.postage = postage;
}
public Integer getStatus() {
return status;
}
public void setStatus(Integer status) {
this.status = status;
}
public Timestamp getPaymentTime() {
return paymentTime;
}
public void setPaymentTime(Timestamp paymentTime) {
this.paymentTime = paymentTime;
}
public Timestamp getSendTime() {
return sendTime;
}
public void setSendTime(Timestamp sendTime) {
this.sendTime = sendTime;
}
public Timestamp getEndTime() {
return endTime;
}
public void setEndTime(Timestamp endTime) {
this.endTime = endTime;
}
public Timestamp getCloseTime() {
return closeTime;
}
public void setCloseTime(Timestamp closeTime) {
this.closeTime = closeTime;
}
public Timestamp getCreatedAt() {
return createdAt;
}
public void setCreatedAt(Timestamp createdAt) {
this.createdAt = createdAt;
}
public Timestamp getUpdatedAt() {
return updatedAt;
}
public void setUpdatedAt(Timestamp updatedAt) {
this.updatedAt = updatedAt;
}
}
package com.wayknew.demo.order;
import com.alibaba.fastjson.annotation.JSONField;
import javax.persistence.*;
import java.sql.Timestamp;
public class OrderDTO {
private long orderId;
private long userId;
private long productId;
private Long orderNo;
private Integer payment;
private Integer paymentType;
private Integer postage;
private Integer status;
private Timestamp paymentTime;
private Timestamp sendTime;
private Timestamp endTime;
private Timestamp closeTime;
@JSONField(format = "yyyy-MM-dd HH:mm")
private Timestamp createdAt;
@JSONField(format = "yyyy-MM-dd HH:mm")
private Timestamp updatedAt;
public long getOrderId() {
return orderId;
}
public void setOrderId(long orderId) {
this.orderId = orderId;
}
public long getUserId() {
return userId;
}
public void setUserId(long userId) {
this.userId = userId;
}
public long getProductId() {
return productId;
}
public void setProductId(long productId) {
this.productId = productId;
}
public Long getOrderNo() {
return orderNo;
}
public void setOrderNo(Long orderNo) {
this.orderNo = orderNo;
}
public Integer getPayment() {
return payment;
}
public void setPayment(Integer payment) {
this.payment = payment;
}
public Integer getPaymentType() {
return paymentType;
}
public void setPaymentType(Integer paymentType) {
this.paymentType = paymentType;
}
public Integer getPostage() {
return postage;
}
public void setPostage(Integer postage) {
this.postage = postage;
}
public Integer getStatus() {
return status;
}
public void setStatus(Integer status) {
this.status = status;
}
public Timestamp getPaymentTime() {
return paymentTime;
}
public void setPaymentTime(Timestamp paymentTime) {
this.paymentTime = paymentTime;
}
public Timestamp getSendTime() {
return sendTime;
}
public void setSendTime(Timestamp sendTime) {
this.sendTime = sendTime;
}
public Timestamp getEndTime() {
return endTime;
}
public void setEndTime(Timestamp endTime) {
this.endTime = endTime;
}
public Timestamp getCloseTime() {
return closeTime;
}
public void setCloseTime(Timestamp closeTime) {
this.closeTime = closeTime;
}
public Timestamp getCreatedAt() {
return createdAt;
}
public void setCreatedAt(Timestamp createdAt) {
this.createdAt = createdAt;
}
public Timestamp getUpdatedAt() {
return updatedAt;
}
public void setUpdatedAt(Timestamp updatedAt) {
this.updatedAt = updatedAt;
}
}
package com.wayknew.demo.order.response; import com.wayknew.demo.order.OrderDTO; import java.util.List; public class OrderResponseDTO { private Integer code; private String message; private OrderDTO order; private List<OrderDTO> orders; public List<OrderDTO> getOrders() { return orders; } public void setOrders(List<OrderDTO> orders) { this.orders = orders; } public Integer getCode() { return code; } public void setCode(Integer code) { this.code = code; } public String getMessage() { return message; } public void setMessage(String message) { this.message = message; } public OrderDTO getOrder() { return order; } public void setOrder(OrderDTO order) { this.order = order; } }
package com.wayknew.demo.order.response; import com.wayknew.demo.order.OrderDTO; import java.util.List; public class OrderListResponseDTO { private Integer code; private String message; private List<OrderDTO> orders; public Integer getCode() { return code; } public void setCode(Integer code) { this.code = code; } public String getMessage() { return message; } public void setMessage(String message) { this.message = message; } public List<OrderDTO> getOrders() { return orders; } public void setOrders(List<OrderDTO> orders) { this.orders = orders; } }
package com.wayknew.demo.order.response; import com.wayknew.demo.order.OrderDTO; import java.util.List; public class OrderResponseDTO { private Integer code; private String message; private OrderDTO order; private List<OrderDTO> orders; public List<OrderDTO> getOrders() { return orders; } public void setOrders(List<OrderDTO> orders) { this.orders = orders; } public Integer getCode() { return code; } public void setCode(Integer code) { this.code = code; } public String getMessage() { return message; } public void setMessage(String message) { this.message = message; } public OrderDTO getOrder() { return order; } public void setOrder(OrderDTO order) { this.order = order; } }
暂且不说这两个类的作用,我们来看看后续调用这两个类是怎么用的
package com.wayknew.demo.order;
import com.sun.javafx.scene.control.skin.IntegerFieldSkin;
import com.wayknew.demo.order.response.OrderResponseDTO;
import java.util.ArrayList;
import java.util.List;
public class OrderFactory {
static OrderDTO toOrderDTO(Order order) {
OrderDTO orderDTO = new OrderDTO();
orderDTO.setOrderId(order.getOrderId());
orderDTO.setUserId(order.getUserId());
orderDTO.setProductId(order.getProductId());
orderDTO.setCloseTime(order.getCloseTime());
orderDTO.setEndTime(order.getEndTime());
orderDTO.setOrderNo(order.getOrderNo());
orderDTO.setPayment(order.getPayment());
orderDTO.setPaymentTime(order.getPaymentTime());
orderDTO.setPostage(order.getPostage());
orderDTO.setSendTime(order.getSendTime());
orderDTO.setPaymentType(order.getPaymentType());
orderDTO.setStatus(order.getStatus());
orderDTO.setCreatedAt(order.getCreatedAt());
orderDTO.setUpdatedAt(order.getUpdatedAt());
return orderDTO;
}
static OrderResponseDTO successResponse(){
OrderResponseDTO res = new OrderResponseDTO();
res.setCode(0);
res.setMessage("success");
return res;
}
static OrderResponseDTO successResponse(Order order){
OrderDTO orderDTO = toOrderDTO(order);
OrderResponseDTO res = new OrderResponseDTO();
res.setCode(0);
res.setMessage("success");
res.setOrder(orderDTO);
return res;
}
static OrderResponseDTO successResponse(List<Order> orders){
List<OrderDTO> orderDTOList = new ArrayList<>();
orders.forEach(order -> {
orderDTOList.add(toOrderDTO(order));
});
OrderResponseDTO res = new OrderResponseDTO();
res.setCode(0);
res.setMessage("success");
res.setOrders(orderDTOList);
return res;
}
static OrderResponseDTO errorResponse(Integer code, String message){
OrderResponseDTO res = new OrderResponseDTO();
res.setCode(code);
res.setMessage(message);
return res;
}
}
package com.wayknew.demo.order; import com.wayknew.demo.order.request.OrderRequestDTO; import com.wayknew.demo.order.response.OrderResponseDTO; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import java.util.List; @RestController @RequestMapping(value="/api/v2") public class OrderController { @Resource private OrderBO orderBO; @RequestMapping(value = "/order",method = RequestMethod.POST) public OrderResponseDTO createOrder(@RequestBody OrderRequestDTO body){ try{ Order order = orderBO.create(body.getUserId(),body.getProductId(),body.getOrderNo(),body.getPayment(),body.getPaymentType(),body.getPostage(),body.getStatus(),body.getPaymentTime(),body.getSendTime(),body.getEndTime(),body.getCloseTime()); return OrderFactory.successResponse(order); }catch (Exception e){ return OrderFactory.errorResponse(1,e.toString()); } } @RequestMapping(value = "/order", method = RequestMethod.GET) public OrderResponseDTO getOrderList() { try { List<Order> orders = orderBO.getOrderList(); return OrderFactory.successResponse(orders); } catch (Exception e) { return OrderFactory.errorResponse(2, e.toString()); } } @RequestMapping(value = "/order/{orderId}", method = RequestMethod.GET) public OrderResponseDTO getOrderById(@PathVariable("orderId") Long orderId) { try { Order order = orderBO.getById(orderId); return OrderFactory.successResponse(order); } catch (Exception e) { return OrderFactory.errorResponse(3, e.toString()); } } @RequestMapping(value = "/order/{orderId}", method = RequestMethod.PATCH) public OrderResponseDTO updateOrder(@PathVariable("orderId") Long orderId, @RequestBody OrderRequestDTO body) { try { Order order = orderBO.updateOrder(orderId, body); return OrderFactory.successResponse(order); } catch (Exception e) { return OrderFactory.errorResponse(3, e.toString()); } } @RequestMapping(value = "/order/{orderId}", method = RequestMethod.DELETE) public OrderResponseDTO deleteOrder(@PathVariable("orderId") Long orderId) { try { orderBO.deleteOrder(orderId); return OrderFactory.successResponse(); } catch (Exception e) { return OrderFactory.errorResponse(3, e.toString()); } } }
之后就可以用postman去测试crud了
文章浏览阅读2.5k次。package com.jing.struct;import java.util.Scanner;public class Dome08 { //简易计算机实现加减乘除 public static void main(String[] args) { Scanner scanner = new Scanner(System .in) ; System.out.println("请输入你要计算的数,按空格继续" ); //输入第一个_用switch语句编写加减乘除计算器
文章浏览阅读118次。https://blog.csdn.net/weixin_43281394/article/details/112341592_idapython strings
文章浏览阅读736次。1.如何通过元数据拿到数据库的信息?2.如何用Java生成Excel表?3.将数据库中的表导出生成Excel案例如何通过元数据拿到数据库的信息元数据:描述数据的数据Java中使用元数据的两个方法DatabaseMetaData 通过连接可以拿到的信息:数据库软件,所有数据库名,所有数据库里面的表名,描述数据库的元数据ResultSet..._数据库数据自动生成excel
文章浏览阅读1.5k次,点赞4次,收藏2次。读取和写入首先要创建一个variant,将读写的值和节点绑定,指定节点需要节点id和作用域idvoid* CXNOpc::GetOpcValueNumberic(UA_UInt16 nsIndex, UA_UInt32 identifier, int Type, int& length){ UA_Variant *val = UA_Variant_new(); if(..._miloopclinux 服务器
文章浏览阅读974次。本模块主要用于实现各行业的报名、预约、加盟申请、调查等应用在微信端的实现,支持创建N个表单主题,每个表单主题功能设置均独立。01.自定义表单模型(自定义字段支持字符串、数字、单选、多选、下拉、日历、时间、邮件、省市区、上传图片),每个自定义字段支持自定义描述(输入提示),上传图片支持自定义示例图(Amaze版不支持);02.支持多图上传;(Amaze版不支持)03.录音:在线录制60秒语音,使用第..._万能表单源码
文章浏览阅读116次。郸城科技职专,是经省教育厅备案,周口市教育局批准的一所正规化职业中等专业学校,目前拥有两个校区,老校区位于郸城县交通路与西环路交叉口,新汽车站西400米,新校区位于郸城县科技大道西段与公园西路交汇处,交通十分便利。郸城科技职业中等专业学校办学情况学校于2008年与北京大学青鸟集团IT教育联合,依托高校IT优势资源,享受先进教学理念,普通高中管理模式,职业学校教学模式。学校具有较强的师资队伍,先进的..._郸城县科技职专待遇怎么样
文章浏览阅读2k次。在Linux下,如果需要编写界面应用,并且此界面应用对性能的要求不是很高,一般可以使用Python解决。Python中可以使用自带的Tkinter库或者是第三方的Wxpython库,当然Tkinter的移植性更好。 安装Tkinter非常简单,只需要输入下面命令即可:sudo apt-get install python-tk 即可安装成功Tkinter。 下_unbuntu pmw
文章浏览阅读5.4k次。苹果近期在其官网技术支持页面发布了「适用于声音问题的 AirPods Pro 服务计划」,表示已经确认一小部分的 AirPods Pro 可能会遇到声音问题。受影响设备的生产日期为 2020 年 10 月之前。受影响的 AirPods Pro 可能会出现以下一种或多种状况:● 发出爆裂声或静电噪音,并在嘈杂环境中、运动时或通话时增大;● 主动降噪功能无法正常工作,出现例如缺失低音效果,或..._airpodspro生产批次
文章浏览阅读2.4w次,点赞12次,收藏14次。现象正常情况下修改完代码,运行项目就会立即生效的。但是突然有一天发现运行的还是老的代码,新代码根本没有生效。通过 mvn clean、 install 后,再运行就可以了,但是这样明显是不正常的,而且也非常麻烦。解决方案重新 import project 导入项目,就可以解决问题。..._idea重启程序不生效
文章浏览阅读209次。JSON(JavaScript Object Notation)是一种轻量级的数据交换格式。因为采用独立于语言的文本格式,也使用了类似于C语言家族的习惯,拥有了这些特性使使JSON称为理想的数据交换语言,作用是易于阅读和编写,同时也易于机器解析和生成(一般用于网络传输速率)(1)JSON.parse函数作用:将json字符串转换成json对象。语法:JSON.parse(text[,reviver]).参数:text 必须;一个有效的js..._json.stringify去转义
文章浏览阅读4.8k次,点赞3次,收藏24次。python 实现81个人脸关键点实时检测文章目录:一、81个关键点介绍二、81 个关键点的使用该库也是基于dlib实现的,还有face_recognition也同样是基于dlib来实现的一、81个关键点介绍先来仔细看一看这只斯嘉丽,脸上81个关键点的分布:0-67是dlib既有的68个脸部关键点;68-80是程序猿新增的13个前额关键点。程序猿说,他是从Patrick Hube..._面部关键点检测 python
文章浏览阅读2.4k次,点赞11次,收藏13次。1.题目源码<?phpinclude("flag.php");highlight_file(__FILE__);class FileHandler { protected $op; protected $filename; protected $content; function __construct() { $op = "1"; $filename = "/tmp/tmpfile"; $content_[网鼎杯 2020 青龙组]areuserialz