SpringBoot 零基础入门笔记03(连接池 数据库驱动 mybatis test)

目录结构：

pom.xml

<?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">
    <modelVersion>4.0.0</modelVersion>

    <groupId>cn.itcast.demo</groupId>
    <artifactId>springboot-demo</artifactId>
    <version>1.0.0-SNAPSHOT</version>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.4.RELEASE</version>
    </parent>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <version>2.0.4.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.16</version>
        </dependency>
        <!--编译式依赖-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <!--连接池-->

        <!--数据库驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!--mybatis-->

        <!--通用mapper 以包含mybatis 和连接池jdbc 和驼峰开启-->
        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>2.0.3</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
        </dependency>
        <dependency>
            <groupId>org.junit.jupiter</groupId>
            <artifactId>junit-jupiter-api</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

</project>

application.properties

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/yun6?useUnicode=true&characterEncoding=utf-8&useSSL=false
jdbc.username=root
jdbc.password=123456

application.yaml

#tomcat配置
server:
  port: 80
#  servlet:
#    path: "*.do"
#logger级别控制trace>debug>info>warn>error 默认info
logging:
  level:
    cn.itcast: debug
#数据库配置
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver # com.mysql.cj.jdbc.Driver  #com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/yun6?useUnicode=true&characterEncoding=utf-8&useSSL=false&allowMultiQueries=true&serverTimezone=Hongkong&allowPublicKeyRetrieval=true #jdbc:mysql://127.0.0.1:3306/yun6
    username: root
    password: 123456
    #useUnicode=true&characterEncoding=utf-8&useSSL=false

mybatis:
  #configuration:
#    map-underscore-to-camel-case: true #驼峰命名
  # mapper-locations: mapper/*.xml
  type-aliases-package: cn.itcast.pojo # 别名扫码的包文件

BootDemoApplication类

package cn.itcast;

/*import org.mybatis.spring.annotation.MapperScan;*/
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import tk.mybatis.spring.annotation.MapperScan;
//启动类

@SpringBootApplication
//@MapperScan("cn.itcast.mapper")import org.mybatis.spring.annotation.MapperScan;
@MapperScan("cn.itcast.mapper")
public class BootDemoApplication {
    public static void main(String[] args) {
        SpringApplication.run(BootDemoApplication.class,args);
    }
}

web->HelloController类

package cn.itcast.web;

import cn.itcast.pojo.User;
import cn.itcast.service.UserService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.sql.DataSource;

@Slf4j
@RestController
@RequestMapping("user")
public class HelloController {
    @Autowired
    private DataSource dataSource;

    @Autowired
    private UserService userService;

    @GetMapping("{id}")
    public User hello(@PathVariable("id") Long id) {
        System.out.println("hello method is running");
        log.debug("hello method is running");
        return  userService.queryById(id);
        //return "hello,spring boot !";
    }

}

service.UserService.class

package cn.itcast.service;

import cn.itcast.mapper.UserMapper;
import cn.itcast.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@Service
public class UserService {
    @Autowired
    public UserMapper userMapper;

    public User queryById(Long id){
        return  userMapper.selectByPrimaryKey(id);

    }
    /*事务注解*/
    @Transactional
    public void insertUser(User user){
       userMapper.insert(user);

    }

}

pojo->User.class

package cn.itcast.pojo;


import com.fasterxml.jackson.annotation.JsonProperty;
import lombok.Data;
import tk.mybatis.mapper.annotation.KeySql;

import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.Transient;
import java.util.Date;

/**
 *  lombok
 * @Data :自动提供getter和setter.hashCode, equals toString等方法
 * @Getter:自动提供getter方法
 * @Setter :自动提供setter方法
 * @Slf4j: 自动在bean中提供log变量，其实哟个的是slf4j的日志功能
 *
 */
@Data
@Table(name = "tb_user")
public class User {
    @Id
    @KeySql(useGeneratedKeys = true)
    private  Long id;

    /**
     *  <dependency>
     *             <groupId>tk.mybatis</groupId>
     *             <artifactId>mapper-spring-boot-starter</artifactId>
     *             <version>2.0.3</version>
     *         </dependency>
     *         这个 包会主动开启驼峰命名识别
     * 驼峰命名，userName=user_name,,,但如果是username就无法识别！可以使用 @JsonProperty("user_name")单独加注，，其实没必要，驼峰很香
     */
    private  String userName;

    private  String password;

    private  String name;

    private  String age;

    private  Integer sex;

    private Date birthday;

    private  Date created;

    private  Date updated;

    @Transient //(不需要持久化到数据库)
    private  String note;

}

mapper->UserMapper.class

package cn.itcast.mapper;


import cn.itcast.pojo.User;
import tk.mybatis.mapper.common.Mapper;

public interface UserMapper  extends Mapper<User> {

}

interceptor->MyInterceptor.class

package cn.itcast.interceptor;

import lombok.extern.slf4j.Slf4j;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.web.servlet.HandlerInterceptor;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
//@Slf4j
public class MyInterceptor implements HandlerInterceptor {
    private static  final Logger log=  LoggerFactory.getLogger(MyInterceptor.class);
    /**private static  final Logger log=  LoggerFactory.getLogger(MyInterceptor.class);
     *  此方法等价于 @Slf4j
     *
     */
    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        log.debug("preHandle method is running");
        log.error("error");
        log.info("info");
        log.warn("warn");
        log.trace("trace");
        return true;
    }

    @Override
    public void postHandle(HttpServletRequest request, HttpServletResponse response, Object handler, ModelAndView modelAndView) throws Exception {
        log.debug("postHandle method is running");
    }

    @Override
    public void afterCompletion(HttpServletRequest request, HttpServletResponse response, Object handler, Exception ex) throws Exception {
        log.debug("afterCompletion method is running");
    }
}

config->jdbcConfig.class

package cn.itcast.config;

import com.alibaba.druid.pool.DruidAbstractDataSource;
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.context.properties.EnableConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;

import javax.sql.DataSource;

@Configuration
//@PropertySource("classpath:jdbc.properties")
/*启用配置文件*/
//@EnableConfigurationProperties(JdbcProperties.class)
public class JdbcConfig {
  /*  @Value("${jdbc.url}")
    String url;
    @Value("${jdbc.driverClassName}")
    String driverClassName;
    @Value("${jdbc.username}")
    String username;
    @Value("${jdbc.password}")
    String password;*/
 /*   @Autowired
    JdbcProperties jdbcProperties;
    public  JdbcConfig(JdbcProperties jdbcProperties){
        this.jdbcProperties=jdbcProperties;
    }*/


/*   注解方式1： @Bean
    public DataSource dataSource(JdbcProperties prop){
       *//* DruidDataSource dataSource =new DruidDataSource();
        dataSource.setDriverClassName(driverClassName);
        dataSource.setUrl(url);
        dataSource.setUsername(username);
        dataSource.setPassword(password);*//*
        DruidDataSource dataSource =new DruidDataSource();
        dataSource.setDriverClassName(prop.getDriverClassName());
        dataSource.setUrl(prop.getUrl());
        dataSource.setUsername(prop.getUsername());
        dataSource.setPassword(prop.getPassword());

        return  dataSource;
    }*/

    @Bean
    /**
    * springboot 属性注入2
    * 事实上，如果一段属性只有一个Bean需要使用，我们无需将其注入到一个类（jdbcProperties）中,而是直接在需要的地方声明即可
    *
    * */
    //声明要注入的属性前缀，SpringBoot 会自动把相关属性通过set方法注入到DataSource中
    @ConfigurationProperties(prefix = "jdbc")
    public DataSource dataSource() {
        return new DruidDataSource();
    }
}

config->jdbcProperties.class

package cn.itcast.config;

import lombok.Data;
import org.springframework.boot.context.properties.ConfigurationProperties;


@Data//编译时添加get set 方法
/***
 * @ConfigurationProperties 是 Spring Boot 中的标签，
 * 它可以让开发者将整个配置文件，映射到对象中，比@Value 效率更高。
 */
//@ConfigurationProperties(prefix = "jdbc")

public class JdbcProperties {
    private String url;
    private String driverClassName;
    private String username;
    private String password;
}

config->MvcConfig.class

package cn.itcast.config;

import cn.itcast.interceptor.MyInterceptor;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.InterceptorRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
@Configuration
public class MvcConfig implements WebMvcConfigurer {
    @Override
    public void addInterceptors(InterceptorRegistry registry) {
        registry.addInterceptor(new MyInterceptor()).addPathPatterns("/**");
    }
}