创建子进程和创建子线程的区别_SpringCloud实战 - 第6课、创建服务端子模块-业务代码（中）-CSDN博客

整体结构

5编写业务代码；

5.1在mysql 中建库建表

数据库名称：srpingcloudDB

表名：payment

建表SQL:

DROP TABLE IF EXISTS `payment`;CREATE TABLE `payment`  (  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'ID',  `serial` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,  PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;# 插入和查询sqlINSERT INTO payment(serial) VALUES (20001);SELECT * FROM payment;

5.2 创建实体类

package com.znrt.springcloud.pojo;import lombok.AllArgsConstructor;import lombok.Data;import lombok.NoArgsConstructor;/** * @Author s.wong * @Create 2020-04-04-17:04 * @Description 支付的实体类 */@Data@AllArgsConstructor@NoArgsConstructorpublic class Payment {    private int id;    private String serial;}

定义给前端统一的返回格式

package com.znrt.springcloud.pojo;import lombok.AllArgsConstructor;import lombok.Data;import lombok.NoArgsConstructor;/** * @Author s.wong * @Create 2020-04-04-17:32 * @Description 返回给前端的统一信息格式 */@Data@AllArgsConstructor@NoArgsConstructorpublic class CommonResult {    private Integer code;    private String message;    private T data;    public CommonResult(Integer code,String message){        this.code=code;        this.message= message;    }}

5.3 编写dao层代码

java代码

package com.znrt.springcloud.dao;import com.znrt.springcloud.pojo.Payment;import org.apache.ibatis.annotations.Mapper;import org.apache.ibatis.annotations.Param;/** * @Author s.wong * @Create 2020-04-04-17:44 * @Description 支付的dao层 *///dao层的注解建议使用Mapper@Mapperpublic interface PaymentDao {    public int create(Payment payment);    public Payment getPaymentById(@Param("id") long id);}

mapper xml代码

<?xml version="1.0" encoding="UTF-8" ?>        INSERT INTO payment(serial) VALUES (#{serial});            select * from payment where id = #{id}

5.4编写service层代码

接口代码

public interface PaymentService {    public int create(Payment payment);    public Payment getPaymentById(@Param("id") long id);}

实现代码

@Servicepublic class PaymentServiceImpl {    @Resource    private PaymentDao paymentDao;    public int create(Payment payment){        return paymentDao.create(payment);    }    public Payment getPaymentById(@Param("id") long id){        return paymentDao.getPaymentById(id);    }}

5.5编写controller层代码

java代码

@RestController@Slf4jpublic class paymentController {    @Resource    private PaymentService paymentService;    @PostMapping("/payment/create")    public CommonResult create(Payment payment){        int i = paymentService.create(payment);        log.info("create 方法的执行结果是："+i);        if(i>0){            return new CommonResult(200,"执行成功",i);        }else{            return new CommonResult(401,"添加方法执行失败");        }    }    @PostMapping("/payment/get/{id}")    public CommonResult getPaymentById(@PathVariable("id") long id){        Payment payment = paymentService.getPaymentById(id);        log.info("查询方法的结果："+payment);        if(payment != null){            return new CommonResult(200,"执行成功",payment);        }else{            return new CommonResult(200,"执行失败，id:"+id,null);        }    }}