mybatis plus基础操作

第二章 继承MP

2.1 创建测试表

SET FOREIGN_KEY_CHECKS=0;   -- ---------------------------- -- Table structure for tb_employee -- ---------------------------- DROP TABLE IF EXISTS `tb_employee`; CREATE TABLE `tb_employee` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `last_name` varchar(255) DEFAULT NULL,   `email` varchar(255) DEFAULT NULL,   `gender` varchar(255) DEFAULT NULL,   `age` int(11) DEFAULT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;   -- ---------------------------- -- Records of tb_employee -- ---------------------------- INSERT INTO `tb_employee` VALUES ('1', 'tom', 'tom@atguigu.com', '1', '22'); INSERT INTO `tb_employee` VALUES ('2', 'jerry', 'jerry@atguigu.com', '0', '25'); INSERT INTO `tb_employee` VALUES ('3', 'black', 'black@atguigu.com', '1', '30'); INSERT INTO `tb_employee` VALUES ('4', 'white', 'white@atguigu.com', '0', '35');

2.2 创建javabean

创建普通maven项目。。。该步骤省略

创建javabean Employee

package cn.huangwei.entity; /**  * java bean  *  * `id` int(11) NOT NULL AUTO_INCREMENT,  *   `last_name` varchar(255) DEFAULT NULL,  *   `email` varchar(255) DEFAULT NULL,  *   `gender` varchar(255) DEFAULT NULL,  *   `age` int(11) DEFAULT NULL,  *  *   注意：定义javabean时，成员变量所使用的类型使用包装类型  *   因为每个基本类型都有一个默认值；所以对于一个初始对象来说，明明没有值的也会出现默认值  *   如果设置为包装类，那么只有一个null值。  */ public class Employee {     private Integer id;     private String lastName;     private String email;     private Integer gender;     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 getGender() {         return gender;     }     public void setGender(Integer gender) {         this.gender = gender;     }     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 + '\'' +                 ", gender=" + gender +                 ", age=" + age +                 '}';     } }

2.3 依赖配置

（1）在pom.xml中加入对MP、spring】连接池、mysql驱动等依赖

注意：mybatis和mybatis-spring依赖请勿加入项目配置，以免引起版本冲突，mybatis-plus会帮你自动维护。

<?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.huangwei</groupId>     <artifactId>mp01</artifactId>     <version>1.0-SNAPSHOT</version>     <dependencies>         <!--mp依赖-->         <dependency>             <groupId>com.baomidou</groupId>             <artifactId>mybatis-plus</artifactId>             <version>3.1.0</version>         </dependency>         <!--junit-->         <dependency>             <groupId>junit</groupId>             <artifactId>junit</artifactId>             <version>4.12</version>         </dependency>         <!--log4j-->         <dependency>             <groupId>org.apache.logging.log4j</groupId>             <artifactId>log4j</artifactId>             <version>2.10.0</version>