构建服务提供者 springcloud-study-provider-dept-8001

构建服务提供者 springcloud-study-provider-dept-8001

• pom文件

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>springcloud-study</artifactId>
        <groupId>com.blj</groupId>
        <version>1.0.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>springcloud-study-provider-dept-8001</artifactId>
    <dependencies>
        <dependency>
            <artifactId>springcloud-study-api</artifactId>
            <groupId>com.blj</groupId>
            <version>${project.version}</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
        </dependency>
        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-core</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jetty</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
        </dependency>
        <!--热部署 修改后立即生效-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>springloaded</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
        </dependency>

    </dependencies>

</project>

• 编写配置文件application.yml

#配置服务器信息
server:
  port: 8001

#数据库信息配置
spring:
  application:
    name: study-springcloud-dept  #微服务名称
  datasource:
    url: jdbc:mysql://localhost:3306/clouddb01?useUnicode=true&characterEncoding=utf-8&useSSL=false
    username: root
    password: root1234
    driver-class-name: com.mysql.jdbc.Driver #mysql驱动包
    type: com.alibaba.druid.pool.DruidDataSource #当前数据源操作类型

    #druid连接池配置
    initialSize: 5  #初始化连接数
    minIdle: 5      #数据库连接池最小连接维持数
    maxActive: 20   #数据库最大活动连接数
    maxWait: 60000
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 300000
    validationQuery: SELECT 1 FROM DUAL
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    poolPreparedStatements: true
    # 配置监控统计拦截的filters,去掉监控界面sql无法统计，‘wall’用于防火墙
    filters: stat,wall,log4j
    maxPoolPreparedStatementPerConnectionSize: 20
    userGlobalDataSourceStat: true
    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

#Mybatis配置
mybatis:
  type-aliases-package: com.blj.springcloud.entities        #所有Entities实体类别名所在包
  mapper-locations: classpath:mybatis/mapper/**/*.xml        #mapper映射文件

  configuration:
    map-underscore-to-camel-case: true #开启驼峰命名
    cache-enabled: true #开启二级缓存

• Dao层

package com.blj.springcloud.dao;

import com.blj.springcloud.entities.Dept;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface DeptDao {

    //增加部门
    public boolean addDept(Dept dept);

    //通过id查询部门信息
    public Dept findById(Long id);

    //查询所有部门信息
    public List<Dept> findAll();

}

• Dao层实现

<?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.blj.springcloud.dao.DeptDao">

    <!-- resultType="Dept" 会变红，测试过并不是报错，应该是idea编译的问题-->
    <select id="findById" resultType="Dept" parameterType="Long">
       SELECT * FROM  dept WHERE  deptno = #{deptno}
    </select>

    <select id="findAll" resultType="Dept">
        SELECT * FROM  dept;
    </select>

    <insert id="addDept">
        INSERT INTO dept(dname,db_source) VALUE (#{dname},DATABASE());
    </insert>

</mapper>

• service层

package com.blj.springcloud.service;

import com.blj.springcloud.entities.Dept;

import java.util.List;

public interface DeptService {
    //增加部门
    public boolean addDept(Dept dept);

    //通过id查询部门信息
    public Dept findById(Long deptno);

    //查询所有部门信息
    public List<Dept> findAll();
}

• service实现类

package com.blj.springcloud.service.impl;

import com.blj.springcloud.dao.DeptDao;
import com.blj.springcloud.entities.Dept;
import com.blj.springcloud.service.DeptService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class DeptServiceImpl implements DeptService {

    @Autowired
    private DeptDao deptDao;

    @Override
    public boolean addDept(Dept dept) {
        return deptDao.addDept(dept);
    }

    @Override
    public Dept findById(Long deptno) {
        return deptDao.findById(deptno);
    }

    @Override
    public List<Dept> findAll() {
        return deptDao.findAll();
    }
}

• controller层

package com.blj.springcloud.controller;

import com.blj.springcloud.entities.Dept;
import com.blj.springcloud.service.DeptService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
@RequestMapping(value = "dept")
public class DeptController {

    @Autowired
    private DeptService deptService;

    @PostMapping(value ="/add")
    public Boolean addDept(@RequestBody Dept dept){
       return deptService.addDept(dept);
    }

    @GetMapping(value ="/get/{deptno}")
    public Dept findById(@PathVariable("deptno") Long deptno){
        return deptService.findById(deptno);
    }

    @GetMapping(value ="/list")
    public List<Dept> findAll(){
        return deptService.findAll();
    }


}

• 启动类

package com.blj.springcloud;

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

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