002-cloud8-8001子模块-改pom-建yml-建库建表

 

<dependencies>

        <!--web/actuator这两个一般一起使用，写在一起-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--监控-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-actuator</artifactId>
        </dependency>

        <!--Mybatis和SpringBoot的整合-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <!--如果没写版本,从父层面找,找到了就直接用,全局统一-->
        </dependency>

        <!--mysql-connector-java-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!--jdbc-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <!--热部署-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

 这里，需要先去建立一个db2019的数据库，设置的名字密码要保持一致。推荐用navicat软件，轻便简单。

 

# 微服务端口号
server:
  port: 8001

# 微服务名称
spring:
  application:
    name: cloud-payment-service

  datasource:
    type: com.alibaba.druid.pool.DruidDataSource      # 数据源
    driver-class-name: com.mysql.jdbc.Driver   # mysql驱动包  这里报错就在左侧External Libraries栏找mysql下的Driver
    url: jdbc:mysql://localhost:3306/db2019?useUnicode=true&characterEncoding=UTF-8&useSSL=false
    username: root
    password: 123456


mybatis:
  mapper-locations: classpath:mapper/*.xml  # 扫描类路径下mapper文件夹下的.xml配置文件
  type-aliases-package: com.atguigu.springcloud.entities  # 该包所有Entity类，取默认别名

 

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class PaymentMain8001 {
    public static void main(String[] args) {
        SpringApplication.run(PaymentMain8001.class,args);
    }
    
}

 

CREATE TABLE payment (
        id BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', 
        serial VARCHAR(200) DEFAULT'', 
        PRIMARY KEY(id)
    )ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8

这里要注意的是，有些工具是需要单引号，有些是需要双引号，而navicat里，字段，表名都是不需要引号的。

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;

/** 先在IDEA搜lombok插件安装，否则这三个用不了*/
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Payment implements Serializable {
    private Long id; //Long  非long
    private String serial;
}

 

package com.atguigu.springcloud.entities;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;


@Data
@AllArgsConstructor
@NoArgsConstructor
public class CommonResult<T> {

    //404 not_found：Integer String
    private Integer code;
    private String message;

    //这不是针对某一个实体类的Josn串封装类
    private T data;

    //当T是null时，定义一个两个参数的构造
    public CommonResult(Integer code, String message){
        this(code, message, null); //数据体 默认为null
    }

}

 

/**
 * 如果是用mybatis 建议用Mapper注解，  repository插入时容易翻车
 */
@Mapper
public interface PaymentDao {
//    常用的读写方法
    public int create(Payment payment);
    public Payment getPaymentById(@Param("id") Long id);

}

 

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.atguigu.springcloud.dao.PaymentDao">

   
</mapper>

 

            <!--这里 Payment报错 可以写全路径。 似乎是yml中的配置未生效  不确定是否还有其他问题-->
    <insert id="create" parameterType="com.atguigu.springcloud.entities.Payment" useGeneratedKeys="true" keyProperty="id">
        insert into payment(serial) values(#{serial});
    </insert>

    <!--定义一个结果接和实体类的映射表-->
    <resultMap id="BaseResultMap" type="com.atguigu.springcloud.entities.Payment">
        <id column="id" property="id" jdbcType="BIGINT"/>
        <id column="serial" property="serial" jdbcType="VARCHAR"/>
    </resultMap>

    <!-- 这里是long Long会报错  不知道是为何-->
    <select id="getPaymentById" parameterType="long" resultMap="BaseResultMap">
        select * from payment where id=#{id};
    </select>

这里 Payment 和Long 报错  改一下就好，具体见代码。 

　　【不过后期测试，即使Payment标红，项目也可以启动，也能正常使用该SQL给数据库插入，暂且搁置】

 

import com.atguigu.springcloud.entities.Payment;
import org.apache.ibatis.annotations.Param;

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




import com.atguigu.springcloud.dao.PaymentDao;
import com.atguigu.springcloud.entities.Payment;
import com.atguigu.springcloud.service.PaymentService;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

@Service
public class PaymentServiceImpl implements PaymentService {

    @Resource
    private PaymentDao paymentDao;

    public int create( Payment payment){
        return paymentDao.create(payment);
    }
    public Payment getPaymentById(Long id){
        return paymentDao.getPaymentById(id);
    }


}

实现类需要添加@Service注解

 

package com.atguigu.springcloud.controller;

import com.atguigu.springcloud.entities.CommonResult;
import com.atguigu.springcloud.entities.Payment;
import com.atguigu.springcloud.service.PaymentService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

@RestController
@Slf4j
public class PaymentController {
    @Resource
    private PaymentService paymentService;

    @PostMapping(value = "/payment/create")
    public CommonResult create(Payment payment) {
        int result = paymentService.create(payment);
        log.info("*****插入结果：" + result);
        if (result > 0) {
            return new CommonResult(200, "插入数据库成功", result);
        }
        return new CommonResult(444, "插入数据库失败", null);
    }

    @GetMapping(value = "/payment/get/{id}")    //写操作POST  读get    还有pull等等
    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(444, "查询ID:" + id + "没有对应记录", null);
        }
    }

}

@RestController=@Controller+@ResponseBody   @SLF4J是日志     这里有使用到RESFful接口风格设计思想。

 

关于浏览器只有get方式：建议下载utools，它里面有很多开发必备的小插件，包括postman。内网穿透等等。简直神器。

 

注：我的项目刚开始报错【At least one base package must be specified】，参考【MapperScan注解的使用】给主程序添加了扫包注解后正常运行。

后来，把那个注解删除后，还是正常的。

这里，似乎是yml中配置的路径并未生效的缘故。之前在【Payment】那里也报错了。也许是IDEA自动识别的问题？ 后期深入了解。