<?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.21.RELEASE</version>
  <relativePath/> <!-- lookup parent from repository -->
 </parent>
 <groupId>com.xiaostudy</groupId>
 <artifactId>demo1</artifactId>
 <version>0.0.1-SNAPSHOT</version>
 <name>demo1</name>
 <description>Demo project for Spring Boot</description>
 <properties>
  <java.version>1.8</java.version>
 </properties>
 <dependencies>
  <!-- spring-boot -->
  <dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-web</artifactId>
  </dependency>
  <dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter</artifactId>
  </dependency>
  <dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-test</artifactId>
   <scope>test</scope>
  </dependency>
  <!--mybatis-plus自動(dòng)的維護(hù)了mybatis以及mybatis-spring的依賴，
  在springboot中這三者不能同時(shí)的出現(xiàn)，避免版本的沖突，表示：跳進(jìn)過這個(gè)坑-->
  <dependency>
   <groupId>com.baomidou</groupId>
   <artifactId>mybatis-plus-boot-starter</artifactId>
   <version>3.1.1</version>
  </dependency>
  <!-- 引入Druid依賴，阿里巴巴所提供的數(shù)據(jù)源 -->
  <dependency>
   <groupId>com.alibaba</groupId>
   <artifactId>druid</artifactId>
   <version>1.0.29</version>
  </dependency>
  <!-- 提供mysql驅(qū)動(dòng) -->
  <dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <version>5.1.38</version>
  </dependency>
 </dependencies>
 <build>
  <plugins>
   <plugin>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-maven-plugin</artifactId>
   </plugin>
  </plugins>
 </build>
</project>

package com.xiaostudy.demo1.entity;
import com.baomidou.mybatisplus.annotation.TableName;
import java.io.Serializable;
@TableName("t_user")
public class User implements Serializable {
 private String id;
 private String userName;
 private String userPassword;
 public String getId() {
  return id;
 }

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

 public String getUserName() {
  return userName;
 }

 public void setUserName(String userName) {
  this.userName = userName;
 }

 public String getUserPassword() {
  return userPassword;
 }

 public void setUserPassword(String userPassword) {
  this.userPassword = userPassword;
 }
 @Override
 public String toString() {
  return "User{" +
    "id='" + id + '\'' +
    ", userName='" + userName + '\'' +
    ", userPassword='" + userPassword + '\'' +
    '}';
 }
}

package com.xiaostudy.demo1.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xiaostudy.demo1.entity.User;
import org.springframework.stereotype.Repository;
/**
 * <p>
 * Mapper接口
 * </p>
 *
 * @author xiaostudy
 * @since 2019-09-15
 */
@Repository
public interface UserDao extends BaseMapper<User> {
}

package com.xiaostudy.demo1.service;
import com.baomidou.mybatisplus.extension.service.IService;
import com.xiaostudy.demo1.entity.User;
public interface UserService extends IService<User> {
}

package com.xiaostudy.demo1.service.impl;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.xiaostudy.demo1.entity.User;
import com.xiaostudy.demo1.mapper.UserDao;
import com.xiaostudy.demo1.service.UserService;
import org.springframework.stereotype.Service;
@Service
public class UserServiceImpl extends ServiceImpl<UserDao, User> implements UserService {
}

package com.xiaostudy.demo1.controller;
import com.xiaostudy.demo1.entity.User;
import com.xiaostudy.demo1.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.Date;
import java.util.List;
@RestController
@RequestMapping("/user")
public class UserController {
 @Autowired
 private UserService userService;
 @RequestMapping("/getAll")
 public String getAll() {
  List<User> list = userService.list();
  System.out.println("list:" + list);
  return list.toString();
 }
 @RequestMapping("/insert")
 public String insert() {
  User user = new User();
  // 不設(shè)置id的話，會(huì)自動(dòng)生成一個(gè)UUID
//  user.setId(new Date().getTime() + "");
  user.setUserName("aaa");
  user.setUserPassword("bbb");
  boolean save = userService.save(user);
  return getAll();
 }
}

#數(shù)據(jù)源
spring:
 security:
 basic:
  enabled: false
 datasource:
 url: jdbc:mysql://127.0.0.1:3306/my_test?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false
 username: root
 password: 密碼
 driver-class-name: com.mysql.jdbc.Driver
 druid:
  # 初始化時(shí)建立物理連接的個(gè)數(shù)。初始化發(fā)生在顯示調(diào)用init方法，或者第一次getConnection時(shí)
  initialSize: 1
  # 最小連接池?cái)?shù)量
  minIdle: 1
  # 最大連接池?cái)?shù)量
  maxActive: 10
  # 配置獲取連接等待超時(shí)的時(shí)間
  maxWait: 10000
  # 配置間隔多久才進(jìn)行一次檢測，檢測需要關(guān)閉的空閑連接，單位是毫秒
  timeBetweenEvictionRunsMillis: 60000
  # 配置一個(gè)連接在池中最小生存的時(shí)間，單位是毫秒
  minEvictableIdleTimeMillis: 300000
  # 驗(yàn)證連接有效與否的SQL，不同的數(shù)據(jù)配置不同
  validationQuery: select 1
  # 建議配置為true，不影響性能，并且保證安全性。
  # 申請連接的時(shí)候檢測，如果空閑時(shí)間大于
  # timeBetweenEvictionRunsMillis，
  # 執(zhí)行validationQuery檢測連接是否有效。
  testWhileIdle: true
  # 申請連接時(shí)執(zhí)行validationQuery檢測連接是否有效，做了這個(gè)配置會(huì)降低性能。
  # 這里建議配置為TRUE，防止取到的連接不可用
  testOnBorrow: true
  # 歸還連接時(shí)執(zhí)行validationQuery檢測連接是否有效，做了這個(gè)配置會(huì)降低性能
  testOnReturn: false
  # 是否緩存preparedStatement，也就是PSCache。
  # PSCache對支持游標(biāo)的數(shù)據(jù)庫性能提升巨大，比如說oracle。
  # 在mysql5.5以下的版本中沒有PSCache功能，建議關(guān)閉掉。
  # 作者在5.5版本中使用PSCache，通過監(jiān)控界面發(fā)現(xiàn)PSCache有緩存命中率記錄，
  # 該應(yīng)該是支持PSCache。
  # 打開PSCache，并且指定每個(gè)連接上PSCache的大小
  poolPreparedStatements: true
  maxPoolPreparedStatementPerConnectionSize: 20
  # 屬性類型是字符串，通過別名的方式配置擴(kuò)展插件，
  # 常用的插件有：
  # 監(jiān)控統(tǒng)計(jì)用的filter:stat
  # 日志用的filter:log4j
  # 防御sql注入的filter:wall
  filters: stat

# ====================MybatisPlus====================
mybatis-plus:
 # 如果是放在src/main/java目錄下 classpath:/com/yourpackage/*/mapper/*Mapper.xml
 # 如果是放在resource目錄 classpath:/mapper/*Mapper.xml
 mapper-locations: classpath*:com/frame/**/**.xml,classpath*:mapping/**/**.xml
 #實(shí)體掃描，多個(gè)package用逗號或者分號分隔
 typeAliasesPackage: com.frame.**.entity,com.frame.**.dto
 global-config:
 #刷新mapper 調(diào)試神器
 db-config:
  #主鍵類型 0:"數(shù)據(jù)庫ID自增", 1:"用戶輸入ID",2:"全局唯一ID (數(shù)字類型唯一ID)", 3:"全局唯一ID UUID";
  id-type: UUID
  #字段策略 0:"忽略判斷",1:"非 NULL 判斷"),2:"非空判斷"
  field-strategy: 2
  #駝峰下劃線轉(zhuǎn)換
  column-underline: false
  #數(shù)據(jù)庫大寫下劃線轉(zhuǎn)換
#  capital-mode: true
  #邏輯刪除配置
  logic-delete-value: 1
  logic-not-delete-value: 0
 refresh: true
 configuration:
 #配置返回?cái)?shù)據(jù)庫(column下劃線命名&&返回java實(shí)體是駝峰命名)，自動(dòng)匹配無需as（沒開啟這個(gè)，SQL需要寫as： select user_id as userId）
 map-underscore-to-camel-case: true
 cache-enabled: false
 #配置JdbcTypeForNull, oracle數(shù)據(jù)庫必須配置
 jdbc-type-for-null: 'null'
 log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
 database-id: mysql

server:
 port: 8080

spring:
 profiles:
 include: jdbc