mybtais-plus

1.需要用的依赖

    <!--数据库连接驱动-->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.49</version>
    </dependency>
    <!--lombok-->
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <optional>true</optional>
    </dependency>
    <!--Druid连接池-->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.12</version>
    </dependency>
    <!--mybatis-plus-->
    <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>3.0.5</version>
    </dependency>

2.快速入门

1.建表语句
DROP TABLE IF EXISTS user;
CREATE TABLE user
(
	id BIGINT(20) NOT NULL COMMENT ‘主键ID‘,
	name VARCHAR(30) NULL DEFAULT NULL COMMENT ‘姓名‘,
	age INT(11) NULL DEFAULT NULL COMMENT ‘年龄‘,
	email VARCHAR(50) NULL DEFAULT NULL COMMENT ‘邮箱‘,
	PRIMARY KEY (id)
);
2.数据语句
DELETE FROM user;

INSERT INTO user (id, name, age, email) VALUES
(1, ‘Jone‘, 18, ‘test1@baomidou.com‘),
(2, ‘Jack‘, 20, ‘test2@baomidou.com‘),
(3, ‘Tom‘, 28, ‘test3@baomidou.com‘),
(4, ‘Sandy‘, 21, ‘test4@baomidou.com‘),
(5, ‘Billie‘, 24, ‘test5@baomidou.com‘);
3.配置完成连接数据库
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=qq2315290571
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis_plus?useUnicode=true&amp&characterEncoding=utf-8
4.然后只需要配置一个pojo实体类和一个mapper接口继成BaseMapper
1.实体类
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
	private Integer id;
	private String name;
	private Integer age;
	private String email;

}
2.mapper接口
@Repository
public interface UserMapper extends BaseMapper<User> {
}
3.最后在启动类扫描一下

mybtais-plus

mybtais-plus

上一篇:kafka简介


下一篇:Git——基础篇