我，【Mybatis-Plus】，一个能强化Mybatis的增强工具包

一、简介

• 介绍

  Mybatis-Plus（简称MP），是一个Mybatis增强包，只做增强不做改变，为简化开发工作、提高生产率而生
  
  官网：https://mp.baomidou.com/

二、集成MP

• 创建测试表

  CREATE DATABASE  mp;
  USE mp;
  
  CREATE TABLE tbl_employee(
  	id INT(11) PRIMARY KEY AUTO_INCREMENT,
  	last_name VARCHAR(50),
  	email VARCHAR(50),
  	gender CHAR(1),
  	age INT
  );
  
  INSERT INTO tbl_employee(last_name,email,gender,age) VALUES('tom','tom@qq.com',1,22);
  INSERT INTO tbl_employee(last_name,email,gender,age) VALUES('jerry','jerry@qq.com',0,25);
  INSERT INTO tbl_employee(last_name,email,gender,age) VALUES('black','black@qq.com',1,30);
  INSERT INTO tbl_employee(last_name,email,gender,age) VALUES('white','white@qq.com',0,35);
  

• 创建JavaBean

  public class Employee{
       
  	private Integer id;
  	private String lastName;
  	private String email;
  	private Integer age;
  	public Integer getId() {
       
          return id;
      }
  
      public void setId(Integer id) {
       
          this.id = id;
      }
  
      public String getLastName() {
       
          return lastName;
      }
  
      public void setLastName(String lastName) {
       
          this.lastName = lastName;
      }
  
      public String getEmail() {
       
          return email;
      }
  
      public void setEmail(String email) {
       
          this.email = email;
      }
  
      public Integer getAge() {
       
          return age;
      }
  
      public void setAge(Integer age) {
       
          this.age = age;
      }
  
      @Override
      public String toString() {
       
          return "Employee{" +
                  "id=" + id +
                  ", lastName='" + lastName + '\'' +
                  ", email='" + email + '\'' +
                  ", age=" + age +
                  '}';
      }
  	
  }
  

• 依赖配置

  • pom.xml配置

      <dependencies>
    <!--        mybatis-plus会自动维护我们的mybatis以及mybatis-spring相关的依赖-->
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus</artifactId>
                <version>2.3</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.9</version>
            </dependency>
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.9</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.37</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>4.3.10.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</artifactId>
                <version>4.3.10.RELEASE</version>
            </dependency>
        </dependencies>
    

  • 加入mybatis全局配置文件

    <?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    
    </configuration>
    

  • 加入db.properties 连接配置信息

    jdbc.driver = com.mysql.jdbc.Driver
    jdbc.url = jdbc:mysql://localhost:3306/mp
    jdbc.username = root
    jdbc.password = 123456
    

  • 加入Spring配置文件

    <?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:p="http://www.springframework.org/schema/p"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:util="http://www.springframework.org/schema/util"
           xmlns:tx="http://www.springframework.org/schema/tx"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.0.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/util
        http: