<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
 <modelVersion>4.0.0</modelVersion>
 <parent>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-parent</artifactId>
  <version>1.5.9.RELEASE</version>
  <relativePath/> <!-- lookup parent from repository -->
 </parent>
 <groupId>com.example</groupId>
 <artifactId>demo</artifactId>
 <version>0.0.1-SNAPSHOT</version>
 <name>demo</name>
 <description>Demo project for Spring Boot</description>

 <properties>
  <java.version>1.8</java.version>
 </properties>

 <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.1</version>
  </dependency>

  <!--Druid 數(shù)據(jù)庫(kù)連接池-->
  <dependency>
   <groupId>com.alibaba</groupId>
   <artifactId>druid</artifactId>

# 配置數(shù)據(jù)庫(kù)連接 8.0
spring:
 datasource:
 # =====================MySQL相關(guān)配置=====================
 # 數(shù)據(jù)庫(kù)類型
 name: mysql
 #數(shù)據(jù)庫(kù)連接驅(qū)動(dòng)
 driver-class-name: com.mysql.cj.jdbc.Driver
 #數(shù)據(jù)庫(kù)連接url
 url: jdbc:mysql://127.0.0.1:3306/數(shù)據(jù)庫(kù)名?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false
 #數(shù)據(jù)庫(kù)連接賬號(hào)
 username: root
 #數(shù)據(jù)庫(kù)連接密碼
 password: root
 #使用druid數(shù)據(jù)源
 type: com.alibaba.druid.pool.DruidDataSource
 #==================druid相關(guān)配置=========================================
 druid:
  #監(jiān)控統(tǒng)計(jì)用的filter：stat 日志用filter:log4j 防御sql注入用filter：wall
  filters: stat,log4j,wall
  #最大鏈接數(shù)量
  max-active: 20
  #初始化時(shí)建立物理連接的個(gè)數(shù) 初始化發(fā)生在顯示調(diào)用init() 或者第一次getConnection時(shí)
  initial-size: 1
  #獲取連接時(shí)的最大等待時(shí)間 毫秒
  max-wait: 60000
  #最小連接池?cái)?shù)量
  min-idle: 1
  time-between-eviction-runs-millis: 60000
  #鏈接保持空閑而不被驅(qū)逐的最長(zhǎng)時(shí)間
  min-evictable-idle-time-millis: 300000
  #用來檢驗(yàn)連接是否有效的sql mysql為select 1
  # 如果validationQuery為null，testOnBorrow、testOnReturn、testWhileIdle都不會(huì)其作用
  validation-query: select 1
  # 申請(qǐng)連接的時(shí)候檢測(cè)，如果空閑時(shí)間大于timeBetweenEvictionRunsMillis，執(zhí)行validationQuery檢測(cè)連接是否有效
  test-while-idle: true
  # 申請(qǐng)連接時(shí)執(zhí)行validationQuery檢測(cè)連接是否有效，做了這個(gè)配置會(huì)降低性能
  test-on-borrow: false
  # 歸還連接時(shí)執(zhí)行validationQuery檢測(cè)連接是否有效，做了這個(gè)配置會(huì)降低性能
  test-on-return: false
  # 歸還連接時(shí)執(zhí)行validationQuery檢測(cè)連接是否有效，做了這個(gè)配置會(huì)降低性能
  pool-prepared-statements: false
  # 要啟用PSCache，必須配置大于0，當(dāng)大于0時(shí)，poolPreparedStatements自動(dòng)觸發(fā)修改為true
  max-open-prepared-statements: -1


# ====================mybatis==============================
mybatis:
 #配置mybatis的mapper xml文件映射
 mapper-locations: classpath*:mapper/*.xml
 #配置pojo映射
 type-aliases-package: com.example.demo.pojo

#服務(wù)端口
server:
 port: 8080

package com.example.demo.config;
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import javax.sql.DataSource;
//標(biāo)記這是一個(gè)配置類
@Configuration
public class DruidConfig {
 //配置Druid的Bean 讀取yml配置中spring.datasource為前綴的配置
 @ConfigurationProperties(prefix = "spring.datasource")
 @Bean
 public DataSource druid(){
  return new DruidDataSource();
 }
}

package com.example.demo.pojo;
import lombok.Getter;
import lombok.Setter;
import java.io.Serializable;
@Setter
@Getter
public class FtbAdmin implements Serializable {
 private Integer id;
 private String username;
 private String password;
}

package com.example.demo.dao;
import com.example.demo.pojo.FtbAdmin;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
/**
 * @author 11699
 * @date 2020/2/15 - 13:04
 */
@Mapper
public interface FtbAdminMapper {

 public List<FtbAdmin> findAll();
}

<?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.example.demo.dao.FtbAdminMapper" >
 <resultMap id="BaseResultMap" type="com.example.demo.pojo.FtbAdmin" >
 <id column="id" property="id" jdbcType="INTEGER" />
 <result column="username" property="username" jdbcType="VARCHAR" />
 <result column="password" property="password" jdbcType="VARCHAR" />
 </resultMap>
 <select id="findAll" resultMap="BaseResultMap">
 select * from ftb_admin
 </select>
</mapper>

package com.example.demo.service;
import com.example.demo.pojo.FtbAdmin;
import java.util.List;
/**
 * @author 11699
 * @date 2020/2/15 - 13:14
 *
 */
public interface FtbAdminService {
 public List<FtbAdmin> findAll();
}

package com.example.demo.service.impl;

import com.example.demo.dao.FtbAdminMapper;
import com.example.demo.pojo.FtbAdmin;
import com.example.demo.service.FtbAdminService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @author 11699
 * @date 2020/2/15 - 13:16
 *
 * 服務(wù)層實(shí)現(xiàn)，不要忘記打上service注解
 */
@Service
public class FtbAdminServiceImpl implements FtbAdminService {

 //注入mapper
 @Autowired
 private FtbAdminMapper adminMapper;

 @Override
 public List<FtbAdmin> findAll() {

  return adminMapper.findAll();
 }
}

package com.example.demo.controller;

import com.example.demo.pojo.FtbAdmin;
import com.example.demo.service.FtbAdminService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * @author 11699
 * @date 2020/2/15 - 13:29
 * 
 * @RestController:返回整個(gè)controller返回的都是json字符串
 * @RequestMapping("/admin")：請(qǐng)求映射
 */

@RestController
@RequestMapping("/admin")
public class FtbAdminController {
 
 //注入服務(wù)層
 @Autowired
 private FtbAdminService adminService;
 
 //添加映射 無需與方法名一樣
 @RequestMapping("/findAll")
 public List<FtbAdmin> findAll(){
  return adminService.findAll();
 }
}

package com.example.demo;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

//開啟mapper接口掃描，指定掃描基礎(chǔ)包
@MapperScan(basePackages = "com.example.demo.dao")
@SpringBootApplication
public class DemoApplication {

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

}