springboot配置druid

1.pom文件

 <dependencies>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.4</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.25</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
        <!--<resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>-->
    </build>

2.application.yml

spring:
  datasource:
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/bbs?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true
    username: root
    password: root
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      stat-view-servlet:
        url-pattern: /druid/*
        reset-enable: true
        login-username: admin
        login-password: admin
      validation-query: SELECT 'x'

3实体类

public class Sort {
    private Integer id; //分类编号
    private String name;//分类名称

  public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }
}

4.Mapper文件

@Mapper
public interface SortMapper {
    //根据id查询集合
    Sort getSortList(@Param("id") Integer id);
    //插入一条数据
    int addSort(String name);
    //删除一条数据
    int delSort(@Param("id") Integer id);
    @Update("UPDATE `bbs_sort` SET `name`=#{name} WHERE id=#{id}")
    int updateSort(Sort sort);
}

5.Controller

@RestController
public class sortController {

    @Autowired
    SortMapper sortMapper;


    @GetMapping("/dept")
    public Sort sortList(){
        return sortMapper.getSortList(1);
    }
    @PostMapping("/add")
    public int addSort(String name){
        return sortMapper.addSort(name);
    }
   @GetMapping("/delSort/{id}")
    public int delSort(@PathVariable("id") Integer id){
        return sortMapper.delSort(id);
    }

    @GetMapping("/updateSort")
    public int updateSort(Sort sort){
        return  sortMapper.updateSort(sort);
    }
}

6.mapper.xml

<?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.bdqn.springboot06mybatis.mapper.SortMapper">

    <select id="getSortList" resultType="com.bdqn.springboot06mybatis.bean.Sort">
        SELECT * FROM bbs_sort WHERE id=#{id}
    </select>

    <insert id="addSort" parameterType="String">
      insert into bbs_sort(name) values(#{name})
    </insert>
    <delete id="delSort">
      DELETE FROM bbs_sort WHERE id = #{id}
    </delete>
</mapper>