springboot03整合mybatis和druid

springboot整合mybatis和druid数据源

为了练习，整合mybatis既使用了xml配置方式也使用了注解方式。

数据库表

引入依赖

<dependencies>
    <!-- mybatis-spring-boot整合包 -->
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.2.0</version>
    </dependency>

    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
    </dependency>

    <!-- druid -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.21</version>
    </dependency>

    <!-- jdbc相关包 -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </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>
</dependencies>

springboot配置文件

application.yml

配置数据库连接，数据源，别名以及mybatis的mapper.xml文件扫描包

spring:
  datasource:
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/shop
    type: com.alibaba.druid.pool.DruidDataSource
mybatis:
  type-aliases-package: com.hja.entity
  mapper-locations: classpath:mybatis/mapper/*.xml

druid的配置类

package com.hja.config;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;
import java.util.HashMap;

@Configuration
public class DruidConfig {

    //绑定springboot配置文件
    @ConfigurationProperties(prefix = "spring.datasource")
    @Bean
    public DataSource druidDatasource(){
        return new DruidDataSource();
    }

    //后台监控配置
    @Bean
    public ServletRegistrationBean servletRegistrationBean(){
        ServletRegistrationBean<StatViewServlet> bean = new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");//设置后台监控页面路径，到时候输入localhost:8080/druid即可进入监控页面

        HashMap<String ,String> initParamters = new HashMap<>();
        //设置后台监控的用户名密码
        initParamters.put("loginUsername", "admin");
        initParamters.put("loginPassword", "0000");
        initParamters.put("allow", "");

        bean.setInitParameters(initParamters);

        return bean;
    }

}

实体类User

使用lombok插件生成get，set方法，构造函数，toString方法

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.Date;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private String uid;//uuid编号
    private String username;//用户名
    private String password;//密码
    private String name;//真实姓名
    private String email;//邮箱
    private String telephone;//电话
    private Date birthday;//生日
    private String sex;//性别
    private int state;//状态
    private String code;//激活码
}

UserMapper接口

package com.hja.mapper;

import com.hja.entity.User;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectKey;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface UserMapper {
    @Select("select * from user")
    List<User> queryAll();

//    @Select("select * from user where uid = #{uid}")
    User queryById(int uid);


    //@SelectKey生成一个uuid
    @SelectKey(before = true,keyProperty = "uid",keyColumn = "uid",resultType = String.class,statement = "select uuid()")
    @Insert("insert  into user values(#{uid},#{username},#{password},#{name},#{email}," +
            "#{telephone},#{birthday},#{sex},0,#{code})")
    void addUser(User user);
}

UserController

package com.hja.controller;

import com.hja.mapper.UserMapper;
import com.hja.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.Date;
import java.util.List;

//为了省时直接在页面返回字符串
@RestController
public class UserController {

    @Autowired
    UserMapper userMapper;

    //注解方式
    @GetMapping("/queryAll")
    public List<User> queryAll(){
        List<User> list = userMapper.queryAll();
        return list;
    }

    //xml方式
    @GetMapping("/queryById")
    public User queryById(int uid){
        User user = userMapper.queryById(uid);
        return user;
    }

    //注解方式
    @GetMapping("/addUser")
    public void addUser(User user){
        User user1 = new User(null, "hhh", "hhh", "哈哈哈", "hhh@email.com", "12312312312", new Date(), "男", 0, "0");
        userMapper.addUser(user1);
    }
}

UserMapper.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.hja.mapper.UserMapper">
    <select id="queryById" parameterType="int" resultType="User">
        select * from user where uid = #{uid}
    </select>
</mapper>

运行

运行成功，端口号8080.

后台监控页面登录

主页面

queryAll

queryById

传一个数据库中的UID 123456789

addUser

添加成功